CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.
Please abide by the
rules of this forum.
This is a peer-to-peer forum. The forum doesn't replace the official direct technical support provided by ARKANCE for its customers.
How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
| Author |
 Topic Search  Topic Options
|
Vladimir Michl 
Senior Member
Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2196
|
 Topic: Import CSV with layers error
Posted: 25.Mar.2025 at 07:56 |
Here is the DWG file and the screen with prompts.
|
|
|
 |
RobzR0102
Newbie
Joined: 21.Mar.2025
Location: United Kingdom
Using: AutoCAD LT 2024
Status: Offline
Points: 9
|
Posted: 24.Mar.2025 at 15:42 |
Can you send me the dwg file with the layers imported please :) Im not sure what else to do to fix this.
Thanks
|
|
RobzR0102
Newbie
Joined: 21.Mar.2025
Location: United Kingdom
Using: AutoCAD LT 2024
Status: Offline
Points: 9
|
Posted: 24.Mar.2025 at 15:31 |
I checked region in control panel and it is set to comma.
Is it a setting on my excel/PC that is the issue if you can import it? I can try import it on another PC
|
|
Vladimir Michl
Senior Member
Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2196
|
Posted: 24.Mar.2025 at 15:24 |
|
I have tried to import your CSV file into your DWG and it has completed successfuly.
|
|
|
|
RobzR0102
Newbie
Joined: 21.Mar.2025
Location: United Kingdom
Using: AutoCAD LT 2024
Status: Offline
Points: 9
|
Posted: 24.Mar.2025 at 15:22 |
Thanks for explaining. I tried redownloading and with the "," LISP command but didn't help, and I assume changing the delimiter is the ";" in the top 3 lines of csv file, I tried that too and still same error.
When I changed delimiter to ";" it "imported 0 files" which at least isn't an error. Not that it helps me :(
|
|
Vladimir Michl
Senior Member
Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2196
|
Posted: 24.Mar.2025 at 14:46 |
I see. Please load the new version from Download - it will show what delimiter it expects in the CSV2layer command (it is aligning the delimiter to your Windows settings to keep it compatible with Excel). If it is not "," - you can either change it by pasting the above LISP command into your AutoCAD command line, or you can change the delimiter you are using in the CSV file.
|
|
|
|
RobzR0102
Newbie
Joined: 21.Mar.2025
Location: United Kingdom
Using: AutoCAD LT 2024
Status: Offline
Points: 9
|
Posted: 24.Mar.2025 at 14:33 |
No it should be English. I know nothing about code or scripts so I am not sure what LISP is and how to change the delimiter.
|
|
Vladimir Michl
Senior Member
Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2196
|
Posted: 24.Mar.2025 at 14:08 |
Do you use German version of Windows? Your list delimiter is probably set to ";", not to ",". Try to use this LISP command before you import the CSV file:
(setq _CSVdelimiter ",")
|
|
|
|
RobzR0102
Newbie
Joined: 21.Mar.2025
Location: United Kingdom
Using: AutoCAD LT 2024
Status: Offline
Points: 9
|
Posted: 24.Mar.2025 at 13:49 |
uploads/983456/template1_csv.zip
Hopefully this works better if email didnt come through.
|
|
RobzR0102
Newbie
Joined: 21.Mar.2025
Location: United Kingdom
Using: AutoCAD LT 2024
Status: Offline
Points: 9
|
Posted: 24.Mar.2025 at 12:54 |
|
sorry, emailed files
|
|
![CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]](/common/arkance_186.png "CAD Forum - ARKANCE Community - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]")
Discussion forum
Import CSV with layers error
Tweet
