Thank you very much for your valuable suggestion! We will solve it as soon as possible!

PCB Industry Information

Group Administrators: 1 | Group Member: 148 | Group Threads: 373

This Group provides continually the latest information on the most recent trends, forecasts and analysis in the printed circuit board space.

Community > Groups > PCB Industry Information > Make Schematic Symbols from CSV Files
Make Schematic Symbols from CSV Files
Reply
Alternate Text 457
Alternate Text 2
Alternate Text 6

MarcBlade

General Process Overview
Select a symbol
Export pins to ms excel spreadsheet
Make pin changes in the spreadsheet
Import pins and generate symbol automatically
  1. To begin, open your library in Library Manager.
  2. Select a symbol which will be used as a template. In this instance the part is a 34 pin connector which exists in the Optimum Library.
  • Right click the symbol and click Edit.
  • The symbol editor will open with the selected symbol displayed. We will export the pins of this symbol to a .csv file, and open it in Microsoft Excel to make changes.
  • From the Symbol Editor, click File > Export Pins
    1. Name the file something relevant, and save it in .csv format.
  • Navigate to the .csv on your hard drive, and open it with Excel.
  • Take note of how the pins are organized in the spreadsheet, and the order in which they are displayed.
  • For this demo we will delete pins 30-34 from the symbol. All desired changes can be made to the symbol in this spreadsheet; including changing numbering, inverting pins, adding new pins, etc. This simply requires deleting the relevant rows from the .csv file.
  • We will also remove the mounting holes from the symbol, again, by simply deleting the rows from the .csv file.
  • Save all changes made to the pinout, and exit Excel.
  • From the Symbol Editor, click File > Generate symbol from pins…
  • Navigate to the edited .csv, and Open.
  • The symbol is automatically generated with the updated input and output pin configuration. Pins 30-34, and the mounting holes, have been removed as desired.
  • Apply any necessary changes to spacing and labeling size, and clean up the symbol as necessary per your company or customer's specifications. Click File > Save As to save the new, edited symbol.
  • 6 likes
    Statement: This post is only the personal view of the author and does not represent the opinions of ALLPCB.com.

    Caesar

    Quite useful and impressive info.Thanks for marvelous posting.

    Dick

    It answered all my puzzles.Very helpful.

    Hot Threads

    New Threads