AutoCAD Electrical Forum
Welcome to Autodesk’s AutoCAD Electrical Forums. Share your knowledge, ask questions, and explore popular AutoCAD Electrical topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

I want to store pricing in the default_cat.mdb file

3 REPLIES 3
Reply
Message 1 of 4
jcolacino
548 Views, 3 Replies

I want to store pricing in the default_cat.mdb file

Good Morning, I am trying to export a project BOM to either an Excel Spreadsheet or Access Database so that I can add or modifiy a couple of pricing columns. My hope is to have Cost and Resale information stored in the catalog database so that nexttime, I can simply export the BOM and my last pricing is there. I noticed that there seemed to be USER fields in the default_cat.mdb but when I export the project "componants" to access, they do not show up. I want to keep this as simple and painless as I can...

 

Jim Colacino jcolacino@colacino.com

 

3 REPLIES 3
Message 2 of 4
sonny3g
in reply to: jcolacino

I would not recommend that you do this.  It will make your default catalog .mdb much bigger which will slow down your every day use of AutoCAD.  Especially if you are planning on having the pricing change frequently.  Better to have a seperate spreadsheet or database with the part number and pricing information.  Then create a lisp routine you can run from one of the three post process buttons available in a report to pull that information into the report when building your BOM.  Not painless or quick, but it won't slow down your every day use of ACADE.

Scott G. Sawdy
scott.sawdy@bluecoyotecad.com
Message 3 of 4
testsubject
in reply to: sonny3g

One of the ways to improve the database is to removeall the items that you will not need from the deault database and institute the use of the secondary file for the complete list.

 

I copied the original database and renamed it default_original and set i ti up as my secondary databse. I then removed al lthe components that I will not use from the default database. Lookups are now much faster.



Bob Hanrahan
Ace User since 1998
If this answered your question, please click on "Accept Solution"
Message 4 of 4
sonny3g
in reply to: testsubject

We did that too.  But if we were to start trying to use the default.mdb for pricing, vendors etc, it would become very unwieldy.  As it is, we reduced it from 300+MB down to 96MB.  Sometimes smaller really is better.

 

Scott

Scott G. Sawdy
scott.sawdy@bluecoyotecad.com

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost