Display full version of the post: import layer list from excel file

Macieto
14.12.2010, 07:48
HI,I want to import layer list form excel file and I found a beautiful tool for that:http://www.cadforum.cz/cadforum_en/how-to-create-dwg-layers-from-a-list-in-csv-excel-tip7193But this tool does not do one thing - tool doesnt import descriptions of layers. Does anybody know a tool that will import all data for layer properties manager? (name, on/off, freeze/thaw, lock, color, linetype, lineweight, plot, description)Description is most important for me.Thanks

Vladimir Michl
14.12.2010, 08:12
There is a simple fix - just update to the latest version of CsvLayers - see Download.

Macieto
14.12.2010, 08:25

[QUOTE=Vladimir Michl]There is a simple fix - just update to the latest version of CsvLayers - see Download.[/QUOTE]Right now I have downloaded todays version of csvlayers and still there is no possibility to import descriptions of layers

Vladimir Michl
14.12.2010, 08:52
The older version may be still stored in your browser cache. Try the direct link http://www.cadstudio.cz/dl/csvlayers.zip and make sure the VLX filedate is 14.12.2010.

Macieto
14.12.2010, 09:19

[QUOTE=Vladimir Michl]The older version may be still stored in your browser cache. Try the direct link http://www.cadstudio.cz/dl/csvlayers.zip and make sure the VLX filedate is 14.12.2010.[/QUOTE]You were right Vladimir!Now I am able to import descriptions too but there is one more problem because in layer properties manager at the end of the description semicon occures.So if the description in CSV file is my hidden line than in layer properties manager You will seemy hidden line;Is there any way to det rid of that semicon?

Vladimir Michl
14.12.2010, 09:59
That's strange - the layer description is just read from the CSV file, no other modifications are done to it. Are you sure your line in the CSV file does not end with the semicolon?

Macieto
14.12.2010, 10:25

[QUOTE=Vladimir Michl]That's strange - the layer description is just read from the CSV file, no other modifications are done to it. Are you sure your line in the CSV file does not end with the semicolon?
[/QUOTE]Vladimir after I deleted that 3first lines of example in CSV file it seems to be ok - there is no possibility to have lineweight bigger than 1mm but i can live with that.

Vladimir Michl
14.12.2010, 11:46
Can you post the contents of your CSV file? Both cases seem to work fine here:
1) lines starting with ";" are simply ignored
2) any AutoCAD lineweight can be applied - replace 25 in the sample by 200 and you will get a 2.0mm thick line

Macieto
14.12.2010, 12:05

[QUOTE=Vladimir Michl]Can you post the contents of your CSV file? Both cases seem to work fine here:
1) lines starting with ";" are simply ignored
2) any AutoCAD lineweight can be applied - replace 25 in the sample by 200 and you will get a 2.0mm thick line[/QUOTE]I was about to paste my CSV code when I found the mistake.1) i was using not standard lineweights (fe. 250)2) i was using linetypes that hasnt been loaded in my ACAD (fe. "GAS")Now after reading what ACAD has written in "commandline" after "csvlayers" command I corrected  my CSV file and everything seems to be OK. It would be much better if ACAD would send some kind of "alert dialog box" saying that sth is wrong, but on the other hand I should always read ACAD respons in "commandline" :-)thanx