Author Topic: BOM Extraction  (Read 3069 times)

0 Members and 1 Guest are viewing this topic.

A_LOTA_NOTA

  • Guest
BOM Extraction
« on: October 08, 2010, 08:05:44 PM »
After a couple of post on the swamp I was about to get the info I needed for lisp that would extract the required info from the attached BOM.  Now I have been asked to get all the lines off the drawings. That doesn't sound real difficult, other than not all the drawings have the same number of lines of text.  So I've attached one of the drawings for suggestions / help. The info needs to be extracted to a comma delimited file. The BOM is always the same size no matter the scale of the drawing. It is always the some distance from the top right corner of the drawing. Thank you
« Last Edit: October 11, 2010, 08:59:41 AM by A_LOTA_NOTA »

Lee Mac

  • Seagull
  • Posts: 12906
  • London, England
Re: BOM Extraction
« Reply #1 on: October 08, 2010, 08:14:01 PM »

CAB

  • Global Moderator
  • Seagull
  • Posts: 10401
Re: BOM Extraction
« Reply #2 on: October 09, 2010, 09:19:20 AM »
You have not explained very clearly the problem you are having.
Are you wanting to get ALL LINES in model space except the border & text table shown in you Sample DWG?
Does the border change size from drawing to drawing?
Are the layer names always the same for the border & table shown?

You can use ssget for model space only and exclude some layer names
or you can use ssget with points to define the area to select.
Note that ssget requires the drawing to be visible on the screen.

The other approach is the iterate through the database looking for LINES that
match you search criteria.
I've reached the age where the happy hour is a nap. (°¿°)
Windows 10 core i7 4790k 4Ghz 32GB GTX 970
Please support this web site.

A_LOTA_NOTA

  • Guest
Re: BOM Extraction
« Reply #3 on: October 09, 2010, 09:43:22 PM »
You have not explained very clearly the problem you are having.
Are you wanting to get ALL LINES in model space except the border & text table shown in you Sample DWG?
Does the border change size from drawing to drawing?
Are the layer names always the same for the border & table shown?

You can use ssget for model space only and exclude some layer names
or you can use ssget with points to define the area to select.
Note that ssget requires the drawing to be visible on the screen.

The other approach is the iterate through the database looking for LINES that
match you search criteria.

Yes, everything is in model space even the border and text. The border changes size with the scale of the drawing but not the BOM. I have not checked the layers but I would have to say yes the are consistant.

A_LOTA_NOTA

  • Guest
Re: BOM Extraction
« Reply #4 on: October 11, 2010, 09:02:30 AM »
The other approach is the iterate through the database looking for LINES that
match you search criteria.

Sorry, what I should have said was lines of text. I'm wanting to extract all the text to a comma delimited file. I've attached an example of the output file.
« Last Edit: October 11, 2010, 09:17:31 AM by A_LOTA_NOTA »

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Re: BOM Extraction
« Reply #5 on: October 11, 2010, 09:09:44 AM »
EATTEXT
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

A_LOTA_NOTA

  • Guest
Re: BOM Extraction
« Reply #6 on: October 11, 2010, 09:20:14 AM »
EATTEXT

I have about 500 drawings I need to get the info off of. The number of lines of text is not consistent from drawing to drawing.

Krushert

  • Seagull
  • Posts: 13679
  • FREE BEER Tomorrow!!
Re: BOM Extraction
« Reply #7 on: October 11, 2010, 10:08:44 AM »
Can I ask what you are using the comma delimited text file for? 
I + XI = X is true ...  ... if you change your perspective.

I no longer CAD or Model, I just hang out here picking up the empties beer cans

Krushert

  • Seagull
  • Posts: 13679
  • FREE BEER Tomorrow!!
Re: BOM Extraction
« Reply #8 on: October 11, 2010, 10:11:14 AM »
EATTEXT

I have about 500 drawings I need to get the info off of. The number of lines of text is not consistent from drawing to drawing.

First of all EATTEXT can processed multiple drawings files at once.  The second .... I will get back to you. 
I + XI = X is true ...  ... if you change your perspective.

I no longer CAD or Model, I just hang out here picking up the empties beer cans

A_LOTA_NOTA

  • Guest
Re: BOM Extraction
« Reply #9 on: October 11, 2010, 10:27:26 AM »
Can I ask what you are using the comma delimited text file for? 

To put the info in a database

A_LOTA_NOTA

  • Guest
Re: BOM Extraction
« Reply #10 on: October 11, 2010, 10:28:25 AM »
I guess I'll have to check EATTEXT out. I have never used it.

A_LOTA_NOTA

  • Guest
Re: BOM Extraction
« Reply #11 on: October 12, 2010, 09:17:07 AM »
I wasn't able to do what I needed with EATTEXT. But I was able to extract the text with lisp. Thanks for all the replies