Autocad to Excell or Access

[draftingrus]

Hello there

I'm trying to get drawing data extracted into spreadsheet or database form. I have using copy and paste with the "LIST" command, but that requires too much manipulation to get in to a format I can use

The ultimate goal is to find an easiy way to go from Drawing to CNC format; in this case a lathe program. the lathe in question does not recognize the G70 series, so all of the cuts have to be programmed.

So - AutoCad Drawing to Excell or Access format as painless as possible

Draftingrus

 

[MikeHalloran]

I was thinking of constructing toolpaths as polylines, and writing those to a DXF file, then massaging that into a G-code file... but somewhere you need to convert Y dimensions in AutoCAD into diameters as X coordinates in the G-codes. X coordinates in AutoCAD would convert directly to Z dimensions in G code space.

Have you tried any of the cheap/ freeware/ shareware CAD to CNC converters?



Mike Halloran
Pembroke Pines, FL, USA

 

[draftingrus]

The problem of converting y values into xnx x values (and doubled for diameters rather than radius is a snap in excell or access..... getting the information into a format that works easily ..... seems to be the rub.

I haven't tried the converters or AutoCNC - guess I need to continue the quest

Thanks

 

[TCARPENTER1]

Hi Guys,

You might try these guys somewhere in the AutoCAD/Software section of the forums they might be able to help: CNCZone

HTH
Todd

 

[MikeHalloran]

If you save the toolpaths in a DXF file, it should be possible to extract the core of that (the coordinates) and convert them to a .csv file with AWK or another scripting language.


Mike Halloran
Pembroke Pines, FL, USA

 

[draftingrus]

Hey Mike

I don't know if you go to cnczone, but there is a guy that has worked out a vbasic program that works inside of AutoCad converting plines into G-Code. I have not tried it yet.

http://www.cnczone.com/forums/showthread.php?t=8226&page=5

AC2GCv038.zip (228.1 KB, 288 views) is the file

 

[draftingrus]

http://home.comcast.net/~cncwoodwork.../AC2GCv039.zip

This is the direct link for the Autocad subroutine to convert plines into code.

here is a java program that makes the same claim

http://cnccodegen.sourceforge.net

 

[MikeHalloran]

Thanks. I better write that down in case I need it.



Mike Halloran
Pembroke Pines, FL, USA