Category:PCB PCB Industry Information

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

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

Thread Reply
Make Schematic Symbols from CSV Files Reply 2017-02-25 17:05:37
476 views
2 comments
6 likes

MarcBlade

Leave A Message

Follow

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

    Leave A Message

    Follow

    Quite useful and impressive info.Thanks for marvelous posting.

    Dick

    Leave A Message

    Follow

    It answered all my puzzles.Very helpful.
    ThreadReply