Jump to content

Exporting Drawing Data to Excel


3rdElle

Recommended Posts

Can you take text from a drawing and export it out to excel?

My thoughts are room numbers, employee names, department names, etc.

 

I need an excel spreadsheet showing this information to then upload to my CAFM Aapplication? Can this be done? How? Is there an alternative to obtaining a report from a drawing?

Link to comment
Share on other sites

What criteria defines each sub-set of information? For example, are room numbers, employee, and department names each on a separate layer?

 

What format does your 'CAFM Application' require (if any)? Will something like a .TXT or.CSV be sufficient?

 

Have you looked into the DATAEXTRACTION Command? I don't use this myself, but I know it's useful for others.

Link to comment
Share on other sites

What criteria defines each sub-set of information? For example, are room numbers, employee, and department names each on a separate layer? My workstations are blocks with various attributes. My CAFM application will not identify attriubutes. I need to export each workstation with all of its assigned criteria to a report.

What format does your 'CAFM Application' require (if any)? Will something like a .TXT or.CSV be sufficient? Excel would be ideal, but CSV

Have you looked into the DATAEXTRACTION Command? I don't use this myself, but I know it's useful for others.

Not yet but will explore soon.
Link to comment
Share on other sites

DATAEXTRACTION is the way to go. I use it on drawings with Title Blocks. You can configure it to only use specific attributes, or items. There is a lot of flexibility there.

Link to comment
Share on other sites

DATAEXTRACTION is the way to go. I use it on drawings with Title Blocks. You can configure it to only use specific attributes, or items. There is a lot of flexibility there.

 

............+1

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...