AutoCAD Electrical Forum
Welcome to Autodesk’s AutoCAD Electrical Forums. Share your knowledge, ask questions, and explore popular AutoCAD Electrical topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

INPORT/EXPORT FROM SPREADSHEET

6 REPLIES 6
Reply
Message 1 of 7
david_lota
540 Views, 6 Replies

INPORT/EXPORT FROM SPREADSHEET

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:

6 REPLIES 6
Message 2 of 7
david_lota
in reply to: david_lota

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

Message 3 of 7
PatMurnen_Adsk
in reply to: david_lota

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
Product Development – AutoCAD Product Line Group

Autodesk, Inc.

Message 4 of 7
david_lota
in reply to: david_lota

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)

Message 5 of 7
PatMurnen_Adsk
in reply to: david_lota

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
Product Development – AutoCAD Product Line Group

Autodesk, Inc.

Message 6 of 7
david_lota
in reply to: david_lota

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
Message 7 of 7
PatMurnen_Adsk
in reply to: david_lota

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
Product Development – AutoCAD Product Line Group

Autodesk, Inc.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost