AutoCAD Electrical General Discussion

Reply
Contributor
pata825
Posts: 24
Registered: ‎10-18-2010
Message 1 of 10 (1,053 Views)
Accepted Solution

AutoCAD Electrical Custom Attributes not Showing in exported excel.

1053 Views, 9 Replies
06-22-2011 12:28 PM

I have created some custom attributes using the symbol builder. I am able to see the new attribute as well as edit it in the edit component dialog box. I am running into an issue where when I export the information onto an excel spreadsheet the custom attribute is not listed in the columns of the spreadsheet. Has anyone figured out a way around this?

 

Thanks,

 

Pata

*Expert Elite*
rhesusminus
Posts: 899
Registered: ‎09-21-2007
Message 2 of 10 (1,044 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-23-2011 12:20 AM in reply to: pata825

Hello Pata.

 

If you open C:\Program Files\Autodesk\Acade 2012\wd_xls_all_template.xlt in excel, you'll find the templates used for all the export to excel functions.

Just add a new column in the worksheet taht you use, and insert your attribute tag at the first row of this column.

Save, Close and try the export to excel function again.

 

THL


THL
Please select "Accept As Solution" if this post answers your question. Kudos don't hurt either. ;-)
Contributor
pata825
Posts: 24
Registered: ‎10-18-2010
Message 3 of 10 (1,021 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-23-2011 12:21 PM in reply to: pata825

Hey THL,

 

Thanks for the reply, but i'm runnning into some problems getting it to work. First off what type of file are you resaving as? in the column where you want the custom attribute to you just type the tag of the attribute as shown? I've tried to do this and it did not work for me. I am currently running 2011 electrical. I have 2012 is this something that is new?

 

pata

Employee
murnenp
Posts: 523
Registered: ‎08-01-2007
Message 4 of 10 (1,019 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-23-2011 12:43 PM in reply to: pata825

You can use the User-Defined Attributes feature to add these custom fields to the export. I have an explanation of this on the AcadE wiki site -

 

http://204.236.156.205/AutoCAD_Electrical/enu/Community/User_Pages/Pat_Murnen's_AutoCAD_Electrical_p...

 

there are a couple of videos showing the various steps. Also, if you are using the General option on the Export then you will need to add the attribute names/tags to the wd_xls_all_template.xlt template in the column header row of each worksheet.  The default location for the spreadsheet template is C:\Program Files\Autodesk\Acade {version}\Support.

 



Pat Murnen
Principal Content Developer
Information Modeling and Platform Products Group

Autodesk, Inc.

Contributor
pata825
Posts: 24
Registered: ‎10-18-2010
Message 5 of 10 (981 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-30-2011 12:16 PM in reply to: murnenp

@Pat Murnen

 

Can you explain the .wda file for me a little bit. Is it going to be an outside reference in that particular dwg? 

 

Also how were you assigning a value to that attribute?

 

Thanks,

 

Pata

Employee
murnenp
Posts: 523
Registered: ‎08-01-2007
Message 6 of 10 (976 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-30-2011 12:39 PM in reply to: pata825

The .wda file is a text file used by the User-Defined Attributes feature. It can be a default file used for all projects or it can be project specific. It is created when you run the User Defined Attribute tool. I would suggest reading through some of the documentation available on the User-Defined Attributes feature. This feature allows you to add the values from attributes that are not standard AcadE attributes to reports and they are supported in the Export/Import feature.

 

On the wiki you can find the topics at http://wikihelp.autodesk.com/AutoCAD_Electrical/enu/2012/Help/0818-Reports818/0827-Add_repo827

 

The same content is also available in the product Help at Reports > Add report fields with the User Defined Attribute List tool.

 

I am not sure I understand the question about assigning the values to the attribute. Do you mean through the export/import feature or just in general?



Pat Murnen
Principal Content Developer
Information Modeling and Platform Products Group

Autodesk, Inc.

Contributor
pata825
Posts: 24
Registered: ‎10-18-2010
Message 7 of 10 (972 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-30-2011 12:47 PM in reply to: murnenp

In your sample video your user defined attribute (STORES)  has a values in the column...

 

X54S231, X54S294.... ETC.

 

When I created a user defined attribute it made that column, but I could find where that information is put in inside of Electrical....

 

Hope that makes sense.

 

Pat

Employee
murnenp
Posts: 523
Registered: ‎08-01-2007
Message 8 of 10 (968 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-30-2011 12:59 PM in reply to: pata825

From your original post it sounded like you had added the non-standard attributes to the block and you were able to add values to those attributes using the edit dialogs. But that those values were not showing up when you used the export to spreadsheet function. Once you add those non-standard attribute names to the user-defined attributes file then those values that are actually on the attributes (that you added in the edit dialog) should show up in those columns in the spreadsheet. THat is where my values came from in the example, they were actually the attribute values.

 

If there are values on the attributes and they do not show up in the spreadsheet column then something is not set up right.

 

If you can, post a drawing that contains one of the blocks with a non-standard attribute along with the .wda file created using user-defined attributes feature. Maybe I can see what is not correct.

 

One thing to verify - make sure that the field you enter in the user-defined attributes matches the attribute name exactly. I also would recommend using all upper case for both the attribute itself and when you add it in the user-defined attributes.

 

I am just curious - did the video play extremely fast for you? When I played it the speed was too fast and I am thinking something may have gone wrong in the uploading of it. It wasn't originally that fast.



Pat Murnen
Principal Content Developer
Information Modeling and Platform Products Group

Autodesk, Inc.

Contributor
pata825
Posts: 24
Registered: ‎10-18-2010
Message 9 of 10 (965 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-30-2011 01:09 PM in reply to: murnenp

Pat,

 

Your right on your assumptions above. I did realize that the drawing I was in was opened outside of the project file and it didn't work correctly that way. Once I got into the project it worked great.

 

Your videos played just fine for me.

 

Thanks for all your help!

 

Pata

Employee
murnenp
Posts: 523
Registered: ‎08-01-2007
Message 10 of 10 (963 Views)

Re: AutoCAD Electrical Custom Attributes not Showing in exported excel.

06-30-2011 01:13 PM in reply to: pata825

Ok. Glad you figured that out and it is all working fine now.



Pat Murnen
Principal Content Developer
Information Modeling and Platform Products Group

Autodesk, Inc.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Electrical Category!

The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Ask the Community