This may seem like a silly question, but how do you get it to work? I replaced the pur_pbom.lsp from base ACADE with this one, and it didn't work. Obviously I am missing something. What is it that I am missing, if I may be so inquisitive?
Ok, heres another question I have. Because of the large number of some items (fuse blocks, relays, etc), my tallied format report shows lots of blank real estate. I also like to show the TAGS for the assemblers, it makes it easier for them for labeling and such. My question is: is there a way to have the TAGS word wrap in a fixed column width, rather than be in a long, wierd looking column?
So: like this (FU1234,FU1235,FU1236, etc) vs (FU1234
I don't know about word wrapping the TAG IDs but to answer your other question, in the Report Generator Dialog Box, click on User Post and then check the "Supress ITEM number repeats" checkbox.
That should get rid of the extra ITEM numbers and the spaces left behind.
This is merely an observation, I don't want to incur the wraith of any one on here but...
Its a purchasing BOM...
They need MFG, QTY, Catalog number, and Description... unless your purchaser is CAD Savvy (unlikely) they won't care about the item number... That's more for the Shop, and that BOM should be different anyway.
Besides the shop like their TAGS over item numbers, then they can highlight when they place that component in (usually on a print out of the Schematics for our electrician friends anyway).
In the case of Electrical / Mechanical installations, they may want items numbers, but if that's the case you need to use something like the vault to generate an item master from the inventor (or 3d cad) Project, and the ACADE Project.
That or merge the two excel files and pray that you don't have overlap!
(unfortunately right now Cable and Harness doesn't let us join the electrical components to the 3D world preventing overlap)
My point is, I'm not sure this yields any benefit, it you want one all encompassing BOM I would use a Panel BOM, and export to Excel... and data link it in if you really want it on the drawing.
if you pass the BOM out to excel you can clean it up quickly, unless you used 3 item number for the same part, it groups the item numbers in the right order. Simply delete the excess item numbers.
I would keep the BOM separate from the drawings anyway, as BOM's change quite often when parts are ordered from different suppliers (I have had some bad experiences ordering long lead time items) and you don't want the Revs on your drawing set...only on the BOM.
I understand that every client is different, but everyone's purchasing department is the same, they care about the price and supplier. Item numbers don't help either.
I apologize in advance if I upset any one that is dead set on placing the BOM on the drawing, I just want to point out that there are other options that might be better suited for your workflow.
No problem. My skin is pretty thick…
There is a real use for creating BOMs that will reside in the drawing. For the panels I build, I use the ITEM number balloons for everything. Having a BOM that is ITEM number sorted is key to finding which parts that are on there. I don't care what the TAGs are at this point. With the Tallied List, even though I don't select the TAGs I still have "Placeholders" in the list for these TAGs. This presents itself as blank lines when you have more than 6 TAGs with the same Item number. You will have a bunch of blank lines. Because of this, the BOM is much longer than it needs to be. Hence the writing of the .lsp program.
I still provide a list to purchasing but it is an all encompassing BOM to capture the items in the schematic that are not on the Panel.
Glad to hear that I did not offend you.
I know why it's leaving the spaces, the program sticks a comma as a place holder which takes up the space.
In your lisp routine you might want to have it remove trailing comma's. (or just remove any commas)
I also tried sticking an exported excel file through the "Spreadsheet to Table" command but it rips the descriptions apart so that wouldn't help. ( I thought I'd explore that route before suggesting it).
I hope this helps,
I think I misread that forum String... LOL.
The other guys were just having problems implementing your fix.
I looked at the time stamp of the original post it was from last year.
To answer Doug's question, yes you can adjust the width when placing the table.
Select "Define widths" then select "Define" and set the Column size it will auto Wrap the text for you.
I have included a picture so you can see what to toggle and the dialog box that pops up.
I hope this helps,
Yes. The lisp file will remove the extra blank rows that are created when there are a lot of TAG values per ITEM. It is tied to USER Post 3. To get rid of the TAGs, I just removed the column from the report.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.
|AutoCAD Land Desktop|
|AutoCAD Plant 3D|
|AutoCAD Raster Design|
|AutoCAD Structural Detailing|
|Ecotect Analysis - Desktop Tools|
|Green Building Studio - Web-Based Service|
|Robot Structural Analysis|