Autodesk 00128-051462-9340 Preview Guide - Page 42

Object Data Extraction., Data extraction and external data linking

Get Autodesk 00128-051462-9340 - AutoCAD 2008 - PC PDF manuals and user guides
UPC - 606121891987
View all Autodesk 00128-051462-9340 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 42 highlights

AUTOCAD 2008 PREVIEW GUIDE For example, if you use lines and arcs to represent the gas, drainage, and water lines on a subdivision layout, you might want to extract the length property of all the lines and arcs on the Gas, Drainage, and Water layers. Figure 70. Object Data Extraction. Depending on the type of data you extract and how you wish to use it, you may choose to export the data to an Excel spreadsheet for further calculations. You can also link data from an Excel spreadsheet into your data extraction table. For example, your drawing might include blocks that represent various manufactured parts. Using data extraction, you can extract the item number and quantity count from the drawing blocks and then link the corresponding item number, cost and description from an Excel spreadsheet. The process for linking an Excel spreadsheet to extracted data requires you to specify a data link. You can view a list of all the available data links using the External Data Options dialog box. If the list does not yet include an appropriate data link, you can launch the Data Link Manager to create a new one. After selecting a data link, you must specify a data key column from the AutoCAD table that corresponds to a data key column in the external file. In my example, the item number would be the key column. Figure . Data extraction and external data linking. 42

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
AUTOCAD 2008 PREVIEW GUIDE
For example, if you use lines and arcs to represent the gas, drainage, and water lines on a subdivision layout,
you might want to extract the length property of all the lines and arcs on the Gas, Drainage, and Water layers.
Figure 70. Object Data Extraction.
Depending on the type of data you extract and how you wish to use it, you may choose to export the data to an
Excel spreadsheet for further calculations. You can also link data from an Excel spreadsheet into your data
extraction table. For example, your drawing might include blocks that represent various manufactured parts.
Using data extraction, you can extract the item number and quantity count from the drawing blocks and then
link the corresponding item number, cost and description from an Excel spreadsheet. The process for linking an
Excel spreadsheet to extracted data requires you to specify a data link. You can view a list of all the available
data links using the External Data Options dialog box. If the list does not yet include an appropriate data link,
you can launch the Data Link Manager to create a new one. After selecting a data link, you must specify a data
key column from the AutoCAD table that corresponds to a data key column in the external file. In my example,
the item number would be the key column.
Figure . Data extraction and external data linking.
42