Community PCB Design Capture CIS Comparing CIS database vs excel sheet and list out missing...

Stats

  • State Not Answered
  • Replies 2
  • Subscribers 23
  • Views 1594
  • Members are here 0
More Content

Comparing CIS database vs excel sheet and list out missing parts

Schulz Jordan

We have a access database with over 4000+ parts. Whenever a new project is started we want to ensure all the libraries are readily available. Currently we manually check part by part in excel sheet vs database. Can I automate process by TCL script where the excel parts will be verified with my database.

  • 0

    Why you are not configuring your excel database directly as your Capture CIS Database through Excel ODBC Drivers?

    Whatever you add/delete in your Excel database will reflect in CIS Database.

  • 0 in reply to Vipulc

    Let me brief the scenario. 

    There is a librarian who creates parts & updates same in database. He regularly checks for obsolete parts & modifies accordingly. We may not always get an update from librarian as update happens now & then.

    Suppose I am building schematics & I have list of components with specific part numbers. I do not know whether the particular part is in database or I should request for it. Now I am manually checking parts by query approach but this is not feasible solution. So what I am looking for is I will have a excel sheet which will have all parts I want in a design & this file I would compare with database. If any parts not found then I will request for part from librarian.

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.