Data Extraction, automated furniture count and cost

[Jeanette_A]

I've created a data extraction set showing various furniture and furniture count. 

Is there a way of setting up a cost for each piece of furniture, it'll in turn get multiplied with how many items there are in the drawing, and then a total cost at the bottom of the data extraction set? Or do I have to link Excel spreadsheets with AutoCAD data and import the spreadsheet into the drawing? 

I'm working on a very large project and would need an automated feature for this. 

Thanks 🙂

[Anonymous]

Hello Jeanette,

Whatch this video. I'm sure there is another video example that shows how to put prices in the desktops.

https://www.youtube.com/watch?v=sBcrtsGlxxU

Regards

[Jeanette_A]

Hi Luis,

Thanks for the link. 

I'm already using ODBC to show employees etc. 

I'm after the specifics of how to add the cost of furniture as per link below. But unsure how I can achieve this. 

https://blogs.autodesk.com/autocad/data-extraction-exploring-features-benefits-autocad/

I found this post https://forums.autodesk.com/t5/autocad-forum/data-extraction-quot-data-column-in-the-external-data-d... but I can't make it work... 

[CodeDing]

@Jeanette_A ,

Is the external data that you're trying to link a database, or an Excel spreadsheet?

When linking, it MUST contain a column (with unique names) of items that matches an existing column of names in your existing data. 

E.G...

DWG Data:

- Name

- Quantity

- Color

External Data:

- Name (unique values)

- Item Cost

... in this case the Names column will contain the same values, and the "Names" column in the External data must only contain unique values (no duplicates).

Is this the case for you or no?

Best,

~DD

[maratovich]

I assume that you have a very large product range.
To do this, create a database.
Get blocks with attributes.
Check the attributes in the database.
Get price for these attributes.
Sort by parameters.
Insert a table into the drawing.
Why the price of the drawing? Providing and editing the price in the drawing is not correct.
For all this, you need a big program. There is a similar, but there is no English.

[Anonymous]

Hi Jeanette,

I found the video that I have mentioned before.

https://www.youtube.com/watch?v=hlN-7SfMRGo

I hope it helps you

Regards.