Home > Community > Forums > PCB Design > Amazing problem while generating BOM

Email

* Required Fields

Recipients email * (separate multiple addresses with commas)

Your name *

Your email *

Message *

Contact Us

* Required Fields
First Name *

Last Name *

Email *

Company / Institution *

Comments: *

 Amazing problem while generating BOM 

Last post Mon, Apr 15 2013 12:59 AM by sunscocool. 8 replies.
Started by sunscocool 28 Feb 2013 07:46 PM. Topic has 8 replies and 1409 views
Page 1 of 1 (9 items)
Sort Posts:
  • Thu, Feb 28 2013 7:46 PM

    • sunscocool
    • Not Ranked
    • Joined on Tue, Feb 19 2013
    • Posts 6
    • Points 105
    Amazing problem while generating BOM Reply

    I used MySQL as my local compent database.

    Everything goes right until generating BOM.

    A Error occurs as :

    ERROR(ORCIS-6156): Unknown database field type

    I am not sure what's wrong with OrCAD Capture CIS 16.6 has anyone met the same problem? 

    Maybe something worng with my Data type set in Mysql database,but I am not sure. 

    • Post Points: 20
  • Fri, Mar 1 2013 1:36 AM

    • oldmouldy
    • Top 10 Contributor
    • Joined on Tue, Jul 15 2008
    • Woking, Surrey
    • Posts 1,371
    • Points 23,350
    Re: Amazing problem while generating BOM Reply
    Yes, something is likely wrong with your DB field data type, only the ANSI SQL 97 data types are supported, that usually means VARCHAR, Char in Access, for any text fields and FLOAT, Number in Access, for any value fields like pricing. Anything else is unlikely to fly straight.
    • Post Points: 20
  • Fri, Mar 1 2013 1:53 AM

    • sunscocool
    • Not Ranked
    • Joined on Tue, Feb 19 2013
    • Posts 6
    • Points 105
    Re: Amazing problem while generating BOM Reply

    Thank your for reply

    I have find someway to solve this probelm

    I can copy all the properties from Part  Proerty Editor and then paste it to Excel. Then I can Edit Excel file to get BOM.

    Also there is another efficient way to generate BOM from Tools->Bill of materials , It seems do not care what's wrong with Database Type error.I find it is efficient to generate a BOM file with modifing the export file format like :

    In header

    Item\t;Quantity\t;Reference\t;Part\t;Manufacturer_Part_Number\t;PCB Footprint\t;Price

    In property String

    {Item}\t;{Quantity}\t;{Reference}\t;{Value}\t;{Manufacturer_Part_Number}\t;{PCB Footprint}\t;{Price}

    also you can write the format as what you want,and then import to Excel. 

    All roads to Roma.

    Good luck to who may meet the same problem! 

    • Post Points: 20
  • Fri, Mar 1 2013 2:30 AM

    • oldmouldy
    • Top 10 Contributor
    • Joined on Tue, Jul 15 2008
    • Woking, Surrey
    • Posts 1,371
    • Points 23,350
    Re: Amazing problem while generating BOM Reply
    The big "BUT" here is that the Tools>Bill of Materials only reads the Schematic properties, it does not use ANY database properties. IF you have something dynamically updated, like Price, or Lead Time, these are unlikely to be maintained the in the schematic properties but there will likely be maintained in an ERP / MRP database. The CIS reports can make use of the database fields, the Capture BOM cannot. (The Tools>Bill of Materials might fit the purpose in some circumstances though)
    • Post Points: 20
  • Fri, Mar 1 2013 2:51 AM

    • sunscocool
    • Not Ranked
    • Joined on Tue, Feb 19 2013
    • Posts 6
    • Points 105
    Re: Amazing problem while generating BOM Reply

    I tried but it works!

    I tried it just a minute ago in the fllowing steps:

    I changed an Inductor's price in MySQL Database and then I find the inductor in my schematic.

    Right-click the Inductor then select  link database part and then open CIS Explorer

    double-click the selected compent in   CIS Explorer  a update symbal warnning appear , click ok.

    After above steps,I open the inductor's property finding that the price was changed.

    So everything works fine with  Tools>Bill of Materials .

    • Post Points: 20
  • Fri, Mar 1 2013 3:30 AM

    • oldmouldy
    • Top 10 Contributor
    • Joined on Tue, Jul 15 2008
    • Woking, Surrey
    • Posts 1,371
    • Points 23,350
    Re: Amazing problem while generating BOM Reply
    BECAUSE you have Transfer to Schematic set for the database field(s), open the Schematic in 6 months time, run the BOM and get data from 6 months ago, this doesn't happen if the BOM data comes from the Database directly.
    • Post Points: 20
  • Fri, Mar 1 2013 10:38 PM

    • sunscocool
    • Not Ranked
    • Joined on Tue, Feb 19 2013
    • Posts 6
    • Points 105
    Re: Amazing problem while generating BOM Reply

    Maybe thing goes like what you say.

    But I think current solution already meet my requirement,If I met what situation like you said I would like to write a program like python script to handle it.

    • Post Points: 20
  • Mon, Apr 8 2013 5:36 AM

    • Vinayram
    • Not Ranked
    • Joined on Mon, Apr 8 2013
    • Posts 3
    • Points 60
    Re: Amazing problem while generating BOM Reply

    Hi sun,

     

    Can you explain about that how to  connect the MySQL Database to Schematic Database.?

     

    Thanks 

    • Post Points: 20
  • Mon, Apr 15 2013 12:59 AM

    • sunscocool
    • Not Ranked
    • Joined on Tue, Feb 19 2013
    • Posts 6
    • Points 105
    Re: Amazing problem while generating BOM Reply

    I was drove exhausted by my project...

    You may refer to http://www.cadence.com/Community/forums/p/24312/1317256.aspx

    for help.

    In general setup an odbc for your operating system like windows with odbc for MySQL,the next is same to local setup.

    If you failed then try it again and again ,then you'll finally get it. 

    • Post Points: 5
Page 1 of 1 (9 items)
Sort Posts:
Started by sunscocool at 28 Feb 2013 07:46 PM. Topic has 8 replies.