CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz] ARKANCE | CONTACT - CZ | SK | EN | DE
Over 1.099.000 registered users (EN+CZ). AutoCAD tips, Inventor tips, Revit tips. Try the new precise Engineering calculator and the updated Barcode generator. New AutoCAD 2026 commands and variables.
RSS channel - CAD tips RSS tips
RSS discussions

Discussion Discussion forum

?
CAD discussions, advices, exchange of experience

CAD Forum - Homepage 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.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic Closedimport layer list from excel file

 Post Reply Post Reply
Author
Macieto View Drop Down
Groupie
Groupie


Joined: 25.Feb.2009
Location: Poland
Using: ACAD MEP
Status: Offline
Points: 23
Direct Link To This Post Topic: import layer list from excel file
    Posted: 14.Dec.2010 at 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-tip7193
But 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

Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

Arkance Systems CZ

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2123
Direct Link To This Post Posted: 14.Dec.2010 at 08:12
There is a simple fix - just update to the latest version of CsvLayers - see Download.
Vladimir Michl (moderator)
ARKANCE - https://arkance.world - Autodesk Platinum Partner
Back to Top
Macieto View Drop Down
Groupie
Groupie


Joined: 25.Feb.2009
Location: Poland
Using: ACAD MEP
Status: Offline
Points: 23
Direct Link To This Post Posted: 14.Dec.2010 at 08:25
Originally posted by Vladimir Michl Vladimir Michl wrote:

There is a simple fix - just update to the latest version of CsvLayers - see Download.


Right now I have downloaded todays version of csvlayers and still there is no possibility to import descriptions of layers
Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

Arkance Systems CZ

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2123
Direct Link To This Post Posted: 14.Dec.2010 at 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.
Vladimir Michl (moderator)
ARKANCE - https://arkance.world - Autodesk Platinum Partner
Back to Top
Macieto View Drop Down
Groupie
Groupie


Joined: 25.Feb.2009
Location: Poland
Using: ACAD MEP
Status: Offline
Points: 23
Direct Link To This Post Posted: 14.Dec.2010 at 09:19
Originally posted by Vladimir Michl Vladimir Michl wrote:

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.


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 see
my hidden line;

Is there any way to det rid of that semicon?
Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

Arkance Systems CZ

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2123
Direct Link To This Post Posted: 14.Dec.2010 at 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?
Vladimir Michl (moderator)
ARKANCE - https://arkance.world - Autodesk Platinum Partner
Back to Top
Macieto View Drop Down
Groupie
Groupie


Joined: 25.Feb.2009
Location: Poland
Using: ACAD MEP
Status: Offline
Points: 23
Direct Link To This Post Posted: 14.Dec.2010 at 10:25
Originally posted by Vladimir Michl Vladimir Michl wrote:

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?

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.

Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

Arkance Systems CZ

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2123
Direct Link To This Post Posted: 14.Dec.2010 at 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
Vladimir Michl (moderator)
ARKANCE - https://arkance.world - Autodesk Platinum Partner
Back to Top
Macieto View Drop Down
Groupie
Groupie


Joined: 25.Feb.2009
Location: Poland
Using: ACAD MEP
Status: Offline
Points: 23
Direct Link To This Post Posted: 14.Dec.2010 at 12:05
Originally posted by Vladimir Michl Vladimir Michl wrote:

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


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
Back to Top

Related CAD tips:


 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,168 seconds.