CAD Forum ► EN ► AutoCAD ► Import CSV with layers error
Display full version of the post: Import CSV with layers error
RobzR0102
21.03.2025, 16:20
I am trying to import an edited CSV file with new layers using the CSVLayers download I found here. It managed to import one layer but I keep getting error after used CSV2LAYERS command, and saying either Y or N to creating new layers or modifying, but it says error, "description was not provided". I only added layer names, changed colour, line type and weight in the same format excel I exported from my drawing and changed nothing else. I have no idea why this is happening and can't find anything online to tell me.
Vladimir Michl
21.03.2025, 16:52
Can you please send me your CSV file and the DWG file you are using? Either attach the ZIP here or send it over e-mail to vladimir.michl (at) arkance.world
RobzR0102
24.03.2025, 10:17
uploads/983456/template_csv.zip
Thanks!
Vladimir Michl
24.03.2025, 11:46
The ZIP file is empty.
RobzR0102
24.03.2025, 12:54
sorry, emailed files
RobzR0102
24.03.2025, 13:49
uploads/983456/template1_csv.zip
Hopefully this works better if email didnt come through.
Vladimir Michl
24.03.2025, 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
24.03.2025, 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
24.03.2025, 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
24.03.2025, 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
24.03.2025, 15:24
I have tried to import your CSV file into your DWG and it has completed successfuly.
RobzR0102
24.03.2025, 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
RobzR0102
24.03.2025, 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
Vladimir Michl
25.03.2025, 07:56
Here is the DWG file and the screen with prompts.uploads/3/TEMPLATE.dwg