Map pins to nets using CSV

Question

I have a symbol with >300 pins and I want to assign them to nets using a CSV file that was externally generated. The CSV file has this format: 
 ``` PINNAME,NET A1,gnd A2,net1 A3,netB A4,netwhatever ... A435,netfinal ``` 
 I go to `File/Import/Symbol spreadsheet...` and Allegro prompts me to select a component. I click the component and the "Symbol Update from Spreadsheet" window pops up. I configure the fields of this window like this: 
 - File name: /path/to/the/file/with/mappings.csv - File type: CSV - Worksheet: Not applicable - The box below "Worksheet", I have a list with "Pin Name" and "Net Name". - Delimiter: , - Spreadsheet cells have data labels: Uncheck - Spreadsheet has row and column headers: Check - Add/Delete pins based on cell contents: Uncheck - Create new nets defined in spreadsheet: Check - Allow deassignment of pins: Check - Assign cell colors to nets: Uncheck - Rows and columns defined by: Component pin pitch 
 Next I click "Update" and the window closes, no error is shown, but the pins are still connected to the original nets.

Tyler · Accepted Answer

The symbol update with spreadsheet command uses a spreadsheet which represents what is typically known as a ball map, or a bump map. Where each "square" (row + column) in the spreadsheet has all the data that corresponds to a pin at that position in the grid-based pattern of pins in your symbol. That is why you see options like whether the rows and columns have headers. 
 The command you want is File -> Import -> Netlist In Wizard. Which imports a CSV file that has at least the following three columns: 
 
 Reference Designator (tells the system what component, or device, to find the pin on) 
 Pin Number / Pin Name (tells the system what pin on the device in column one to look up) 
 Net Name (tells the system what net to assign to the pin) 
 
 In your example above, you are just missing the RefDes column. If your device has a refdes U1, then every row would have that value in the refdes column. Typically, you import the net assignments for more than one device at a time, otherwise you'll get shorts that need to be resolved in any kind of routed design. The tool does not care if you assign nets to 1 pin of 1 device, all the pins of one device, or all the pin 1s on every device. It is just assigning the nets you give to the pins referenced. 
 Give that command a try after you add the third column and you should be all set!

Stats

Map pins to nets using CSV

Community Guidelines