AutoCAD Electrical General Discussion

AutoCAD Electrical General Discussion

Reply
Contributor
david_vji
Posts: 25
Registered: ‎06-28-2011
Message 1 of 7 (298 Views)

INPORT/EXPORT FROM SPREADSHEET

298 Views, 6 Replies
03-14-2012 09:21 AM

I am having problems inporting from spredshhet.

When inporting form spreadsheet

all my drawing get dumpt out of my project file.

 

 

my comand line reads:

Drawing Update from spreadsheet
 Checking files for any marked in-use/read-only . . .
_.REDRAW
Command:
Error: bad argument type: stringp 0.0_.UNDO Current settings: Auto = On,
Control = All, Combine = Yes, Layer = Yes
Enter the number of operations to undo or [Auto/Control/BEgin/End/Mark/Back]
<1>: _END
Command:

Contributor
david_vji
Posts: 25
Registered: ‎06-28-2011
Message 2 of 7 (246 Views)

Re: INPORT/EXPORT FROM SPREADSHEET

02-18-2013 05:50 AM in reply to: david_vji

I´am having this probleam a agin. is there anbody out there?? (who knows what is happaning)

Employee
murnenp
Posts: 566
Registered: ‎08-01-2007
Message 3 of 7 (217 Views)

Re: INPORT/EXPORT FROM SPREADSHEET

02-22-2013 09:24 AM in reply to: david_vji

Can you supply some more information about what is happening -

 

What version of AcadE?

Does the export work without any issues?

Are you making edits in the spreadsheet before you import? If so, what type of edits?

Does it work on some drawings and not others?

 

If you are editing the spreadsheet it may be something with the type of edits you are making. Some things should not be changed such as the object's handle. Maybe if you can upload the spreadsheet that is exported before you make any changes and then a copy of it after your changes that cause the import to fail I can see what the issue is.

 

 



Pat Murnen
Principal Content Developer
Information Modeling and Platform Products Group

Autodesk, Inc.

Contributor
david_vji
Posts: 25
Registered: ‎06-28-2011
Message 4 of 7 (215 Views)

Re: INPORT/EXPORT FROM SPREADSHEET

02-22-2013 09:32 AM in reply to: david_vji

I´am using ACE 2013

 

Export works fine (Exporting Drawing settings)

I´am changing setting (sheet number, description text  section and subsetion)

when I import the spreadsheet agin all the drawings in the project file are dumpt from the projet.

 

I´am not changing the drawing location (the last colum in the spreadsheet)

Employee
murnenp
Posts: 566
Registered: ‎08-01-2007
Message 5 of 7 (212 Views)

Re: INPORT/EXPORT FROM SPREADSHEET

02-22-2013 09:51 AM in reply to: david_vji

I wasn't able to reproduce this at my end. It might be something specific in the spreadsheet. Can you upload the edited spreadsheet so I can take a look at it? Also, can you make a copy of the project's .wdp file right before you run the export and then a copy of the .wdp file right after the import and upload those? 

 

It also would help to diagnose if you could turn on the command trace and upload the log file from that. 

Follow these steps (where upper case are commands to type at the command line)-

 

1. LOGFILEON

2. AEONLISPDEBUG

3. Run the export, edit file in Excel, run import.

4. AEOFFLISPDEBUG

5. LOGFILENAME (Make note of name and folder)

6. LOGFILEOFF

 

Post the file from step #5.



Pat Murnen
Principal Content Developer
Information Modeling and Platform Products Group

Autodesk, Inc.

Contributor
david_vji
Posts: 25
Registered: ‎06-28-2011
Message 6 of 7 (210 Views)

Re: INPORT/EXPORT FROM SPREADSHEET

02-22-2013 10:02 AM in reply to: david_vji
Helo Here is a log file [cid:image001.jpg@01CE1126.67140DC0]Me? kve?ju Dav?? P?tur Stef?nsson Verkfr??istofa J?hanns Indri?asonar ehf. S??um?la 1 108 Reykjav?k S: 560 5417 GSM: 661 2774 ?essi t?lvup?stur ?samt vi?hengjum er eing?ngu ?tla?ur ?eim sem hann er st?la?ur ? og g?ti innihaldi? tr?na?aruppl?singar. Sj? http://vji.is/tolvupostsamskipti.html This e-mail and its attachments are intended for the named addressee only and may contain confidential and privileged information. Further info http://vji.is/tolvupostsamskipti.html
Employee
murnenp
Posts: 566
Registered: ‎08-01-2007
Message 7 of 7 (207 Views)

Re: INPORT/EXPORT FROM SPREADSHEET

02-22-2013 11:28 AM in reply to: david_vji

Looks like something went wrong in the upload. Can you send me the .log file and the edited spreadsheet directly at pat.murnen@autodesk.com ?

 

Regards,

Pat



Pat Murnen
Principal Content Developer
Information Modeling and Platform Products Group

Autodesk, Inc.

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.