Bulk Modification of Library Cells using Visual Basic

Document created by scott_williams on Dec 3, 2010Last modified by scott_williams on May 2, 2017
Version 14Show Document
  • View in full screen mode

Author : Scott Williams

 

Platform/Format: Windows, Visual Studio 2015

 

Use case description:

This was developed to clean up cells after translation from other tools.  It is a good example of using Visual Basic to modify cells in bulk from outside the Cell Editor.

Visual Basic, unlike VB Script, has strong variable typing, auto-completion, and an Object Browser that help the programmer better understand the code and choose available objects and methods.

 

The program is menu-driven and pops up the standard disclaimer before continuing.

 

The program reads a layer mapping instruction file to delete user layers, move user layers to different user layer names, or move user layers to "intelligent" layers.  An example mapping file is included with the code.  I support several data types currently.  The program can easily be modified to support additional data types if you download the source code.  If you have no need to modify the source, download just the executable.

 

The layer mapping file format is as follows:from user layer,to layer,side,display condition

 

to layer = user layer name,DELETE,ASSEMBLY,ETCH,PLACE OBSTRUCT,PLACEMENT OUTLINE,RULE AREA,SILKSCREEN,SOLDER MASK,SOLDER PASTE,ROUTE OBSTRUCT,TEST POINT OBSTRUCT, INSERTION OUTLINE

side = user,top,bottom,mount,opposite

display condition = top_only,bottom_only,any_mount

 

Examples:

 

CLEAR_SILK_TOP,Clear Silk Top,user,top_only

PASTE_TEXT_TOP,Solder Paste,top,any_mount

LAYER_NOT_NEEDED,delete,delete,delete

 

The program is compatible with the stated version and all prior versions.  In other words, it is backward-compatible but not forward-compatible.

Outcomes