Stats

  • Locked Locked
  • Replies 1
  • Subscribers 164
  • Views 13534
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Import in local CIS database

stetag

Hello,

I have some components library stored on my pc, now I'll import all this symbols in my CIS local database.

Someone can explain me how i can easy import this library?

I tried to import some symbols from ICA and work fine. 

 

Tanks you 

  • oldmouldy

    If you have an OLB file with the required data, open that and Tools>Export Properties, Part Properties, you will get a tab-delimited text, EXP, file of the properties, fix this text data with a text editor to match you requirements and database, remember that the "schematic part" will just be a text field of the name of the symbol, also, with CIS you will be able to cut the number of passive component symbols drastically, compared to a "graphical" library, you will likely need a single resistor, two capacitors, one inductor and so on, since CIS references the symbol and then applies all the properties from the database. Check that you have "at least" the four required properties for any parts added to the database. This SQL will import a "DOS formatted" CSV into a table:

     USE <database>;

    LOAD DATA LOCAL INFILE 'SET_THIS_PATH/Resistor.txt' INTO TABLE Resistor
    FIELDS TERMINATED BY ',' ENCLOSED BY '"'
    LINES TERMINATED BY '\r\n';

    You could tweak that for tab delimited text, or other text formats. There are plenty of MySQL resources that cover this activity. 

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.