export cad data to csv format

[Anonymous]

I have an drawing file which contains 3000points , as i want those to be converted in .csv format, plz have a look

https://www.dropbox.com/s/eejp6sg6oizjjju/ROAD%201-2.dwg

[braudpat]

Hello

Welcome to the Autodesk/AutoCAD forums !

If you have standard ACAD points with XYZ coords, you have many solutions

- use the dataextraction ACAD feature, on your points - Command: DATAEXTRACTION

- use a Lisp/VLisp routine like PTEXPORT from Dotsoft.com

( You need a "real" AutoCAD to run a Lisp/VLisp/VBA/ARX/Dotnet routine )

See attachment ...

Good Luck, Bye, Pat

Thanks
Discussion_Admin

[braudpat]

Hello

I have just loaded your DWG and there is NO ACAD Points !!!

So I don't understand what you were asking for ...

Sorry, Bye, Pat

[Patchy · Accepted solution]

Something like this?

[braudpat]

Hello

+1 with Patchy

I believe that you need the extract of the MTEXT which are on the "cordinate" layer !?

Sorry for my first answer but you were speaking about Points, so ...

And I have loaded and viewed your DWG after my answer !

Bye, Pat

[rkmcswain]

---

@braudpat wrote:

- use a Lisp/VLisp routine like PTEXPORT from Dotsoft.com

( You need a "real" AutoCAD to run a Lisp/VLisp/VBA/ARX/Dotnet routine )

See attachment ... 

---

Pat, http://dotsoft.com/freestuff.htm clearly states that you cannot post those routines online. 

[Anonymous]

thanks for ur reply...

Can u explain me the steps which u have used to extract the points

[braudpat]

Hello from France

I will try to explain "How to ..." but I have a french ACAD, so maybe you will have some small differences !

First : layer "cordinate" has to be the CURRENT layer and you will switch off ALL OTHERS layers !

1) DATAEXTRACTION

2) Create a New extraction then Next

3) Give a name to the .DXE file for example : TEST

4) Enable the option "Select entities in the current DWG" and then Select them (All your MTEXT entities that are displayed on your screen) then Next

5) Enable ONLY MTEXT entities then Next

6) Right Click, UnSelect ALL, then Enable ONLY "Index" (to get the MTEXT Value) tehn Next

7) On the Table showed, Right Click on the "Number" column title and say "Mask the column"

Right Click on the "Name" column title and say "Mask the column"

You have to keep the Index column and then Next

8) Enable the option "Output Data to external file" and with the small Icon,

you can choice the file type ...

9) End

You will get a CSV (in RTF format) file but you have to edit it a liitle bit to remove the following text :

\A1;

\P

Good Luck, Bye, Pat

[Anonymous]

can i get screenshot as u have mentioned the process, am confused plz, I need in above mentioned format

https://www.dropbox.com/s/iewel5odnteqixw/cad%20file.png

[Anonymous]

Hi friends

plz see attach document

https://www.dropbox.com/s/tihwm95j75xtm7m/file.doc

Actually i have to make layout map

I need only the coordinates of the blocks which are pink colour i mention in the file 

If i take each block mentioning "id " command noting the value , it takes me lot of time

Is there any way to take those values, plz mention in snapshot it will be much clear

thanks

[braudpat]

Hello from France

OK a new procedure (very similar in fact) ... because NOW we are speaking about Blocks

not about MTexts , not about Points ! 
 
Layers ON : HVM-BLOCK & HVM-BLOCK-DIM - Current Layer : HVM-BLOCK
Block name : HVM-NEW-BLOCK - Attribut Name : 1

I will try to explain "How to ..." but I have a french ACAD, so maybe you will have some small differences !

First : layer "HVM-BLOCK" has to be the CURRENT layer and you will switch off ALL OTHERS layers 

except HVM-BLOCK-DIM !

Layers ON : HVM-BLOCK & HVM-BLOCK-DIM - Current Layer : HVM-BLOCK

1) DATAEXTRACTION

2) Create a New extraction then Next

3) Give a name to the .DXE file for example : TEST

4) Enable the option "Select entities in the current DWG" and then Select them (All your Block entities that are displayed on your screen) then Next

5) Right Click, UnSelect ALL, then Enable ONLY "HVM-NEW-BLOCK" (to get the Info from your blocks) then Next

6) Right Click, UnSelect ALL, then Enable "1" (Your attribute Name/Label of the "HVM-NEW-BLOCK"), X Position/Coord, Y Position/Coord and maybe if you need then : "X Scale" & "Rotation"

and then Next

7) On the Table showed,

- Right Click on the "Number" column title and say "Mask the column"
- Right Click on the "X Scale" column title (if you have it) and say "Mask the column"

if you don't want it (because always the same scale !)

- Idem for the "Rotation" column (if you have it) and finally you are not interested !?
- I think you can keep the others columns ...

Don't hesitate to Click into the column title to sort the Table as you wish ...

and then Next

8) Enable the option "Output Data to external file" and with the small Icon,
you can choice the file type: CSV , XLS , etc

9) End

You will get a CSV or XLS file ...

Are you satisfied ???

Good Luck, Bye, Pat

[Anonymous]

hi...

Got the solution in this format

https://www.dropbox.com/s/88c2eo667zrwwry/file.png

i need in this format if possible 

https://www.dropbox.com/s/iewel5odnteqixw/cad%20file.png

northing easting height

I have 1 more issue that there are many layers in the fiile , is there any option off all the layer at a time except current layer

[braudpat]

Hello from France

Sorry but I spent time to help you and try to understand what you want ...

And you don't say if the results is OK or almost OK ???

I was thinking that you want to extract properties of the famous block  "HVM-NEW-BLOCK" !?

With my explanations on DATAEXTRACTION, you will get all Infos (in CSV or XLS) about this block !

I imagine that my English/US is not enough fluent to understand your needs !

So maybe somebofy else could help you !?

Bye, Pat

[Anonymous]

My apologies..

Iam satisfied with ur answer and got the solution but iam getting trouble at 1 steps that they are many layers in the file nearly 200,am doing it 1 by 1 is there any to do in 1 shot

Actually am new to autocad just beginar

Once again my apology

[sharpl]

Works in 2015, how do I keep the tabs for columns if it was an exploded table by some dummy? Thank you!