Topic: importing csv file issues

[whdjr]

I have an excel file with all my layers setup like I want them.  Now I want to make a template file in Autocad that has my layers already setup properly.  What is the best/easiest way to get my layers into Autocad?

My thoughts were to write layers to a csv file from excel, then read that in lisp to make a list for each layer.  Then use 'mapcar' on each layer to creat and set properties.  My problems arise in the csv file.  lisp reads it differently than I thought it would and I'm not sure how to handle it or if there is an easier way.

All thoughts and suggestions are welcome. 

[It's Alive!]

I have an excel file with all my layers setup like I want them.  Now I want to make a template file in Autocad that has my layers already setup properly.  What is the best/easiest way to get my layers into Autocad?

My thoughts were to write layers to a csv file from excel, then read that in lisp to make a list for each layer.  Then use 'mapcar' on each layer to creat and set properties.  My problems arise in the csv file.  lisp reads it differently than I thought it would and I'm not sure how to handle it or if there is an easier way.

All thoughts and suggestions are welcome. 

I use ADOlisp and access for setting up my layers.

[whdjr]

Well I'm using Excel, cause I don't know Access.  I know ADOLISP says it can connect to excel but I don't know any of the commands cuse it seems like they are all sql statements.

[Keith™]

It depends upon your formatting in the CSV file ...

Put each layer information on a seperate line .. i.e.
Name,color,linetype,lineweight,plot style,plottable

thislayer,green,continuous,0.1,PlotStyle1,yes

Then read each line successively

(setq thisline (read-line file))

break down the line according to commas (or whatever your delimiter is) then pass the vars to the layer creation routine.

[whdjr]

It depends upon your formatting in the CSV file ...

Put each layer information on a seperate line .. i.e.
Name,color,linetype,lineweight,plot style,plottable

thislayer,green,continuous,0.1,PlotStyle1,yes

Then read each line successively

(setq thisline (read-line file))

break down the line according to commas (or whatever your delimiter is) then pass the vars to the layer creation routine.

Yeah that was my thoughts and that is what I was working on doing, I just didn't know if another way existed.

Thanks,

[CAB]

Try this:
http://www.theswamp.org/index.php?topic=10101.0

[CAB]

More resources:
http://forums.augi.com/showthread.php?t=55527

[whdjr]

More resources:
http://forums.augi.com/showthread.php?t=55527

Thanks CAB.  I was able to use this one.