Stats

  • State Not Answered
  • Replies 3
  • Subscribers 44
  • Views 7546
  • Members are here 0
More Content

OrCAD CIP library sharing

abhi08

Hi,

Our organization has setup CIP to use libraries from our internal server. We use CIP to create unique part numbers and maintain that data in our part manager. 

We need support on how we can share the same libraries with a third party. We want to make sure they can use the same libraries from our server and create unique part numbers that will be added to our original list of parts. But, we cannot grant them access to our internal server. Is there a way this could be achieved?

Thanks

  • 0

    The simple approach is your CIS data source can be an XLSx file or MS Access clone of your data.  

    But, you would have to convert the CIP data to xls or Access and create a new DBC file to connect CIS to it.

    I believe anyone can deploy the free-edition MS-SQL and recover a clone of your SQL database from a full backup file. 

    You may have to recreate the user account for CIP_E_CIS_User.

    Avoid the hassle of syncing/merging two CIS data sources back together in the future. 

    My projects tend to have a small number of new IC's/switches/connectors.   We reuse the same passives, diodes, discrete transistors, etc across all projects.  Have them create new ICs and connectors as non-CIS parts.  Add to your CIP and link them to CIS after you bring the project back in house.

  • 0 in reply to RFinley

    thanks for the response!

    how do I do this? "you would have to convert the CIP data to xls or Access and create a new DBC file to connect CIS to it."

  • 0 in reply to abhi08

    This is the process to export xlsx from each component type in CIP to synchronize our cloud PLM (OpenBom)

    >CIS DB Search tab

    Set up a search with Part_Number and "Contains Data"

    Check "Include Additional Fields in Search Results" box  Then you add all the fields you want them to incorporate.  Save it as a search for future.

    Click (Search) button, clickbox Export to Excel.

    This is not much fun.  Especially after doing it about 50 times.

    This gives you individual spreadsheets for each part type which need to be reassembled on the other end in Excel or Access (which I am not familiar with.)   Remember that CIP fields have variances between 12 tables.  There's an admin config that lets you enable/disable.  Be careful if you disable a field you don't use as Capture CIS fails with errors if a field is no longer in the SQL view until the CIS DBC config file is updated.

    I like the idea of cloning the SQL database.

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.