LOOKING FOR OBJECT DATA AND PROPERTIES EXPORT & IMPORT TO AND FROM CSV (ALL IN ONE)
Hello
Please look at messages #4 & #8 of this Topic :
It could help you !?
Bye, Patrice (The Old French EE Froggy)
If you are happy with my answer please mark "Accept as Solution" and if very happy please give me a Kudos (Felicitations) - Thanks
Patrice BRAUD
Hi @infoNV9S2
The tried and true way to export Object Data (OD) is to use MAPEXPORT to shapefile.......then to import data use MAPIMPORT to import the shapefile.
MAPEXPORT command:
This will allow youto export AutoCAD objects to shapefile format. During the export procedure, the command will allow you create the OD. For example, you can create OD from the entity's Properties (same as the Properties shown in the Properties Palette) or from the attributes of an attributed block. You can select which data you want or don't want included in the OD that you create--you're in control.
Shapefile format is versatile. You may use shapefiles in ESRI GIS programs and AutoCAD. You may even use them in non-GIS programs such as Google Earth Pro.
MAPIMPORT command:
This command will you to add geometry to your drawing, and at the same time, convert FROM shapefile format TO AutoCAD format with the results ending up as plain vanilla AutoCAD entities. You may, or may not, choose to keep the DATA in the shapefile's database file (dbf). Keeping the database is how you create (or re-create) Object Data. You can choose which data to keep, i.e. all the data, only some of the data, or none of the data--you're in control.
You don't need special programs or lisps to perform MapExport and MapImport. The commands are already included in the MAP3D toolset.
You don't need a CSV file to perform MapExport and MapImport. However, if you do need a CSV file then you can easily get one by opening the Table View of the shapefile. Once it's open, you can copy ALL the rows and columns to clipboard then paste it to a spreadsheet. You can save your spreadsheet to .xlsx or .csv format--you're in control.
As an alternative to using shapefile, you may also export/import using the AutoCAD format known as SDF (Spatial Data Format).
Chicagolooper
Hi @infoNV9S2 ,
Once OD and CAD properties are exported into CSV, do you modify these data, and then import back and update objet?
For example, do you want to export X,Y of block to CSV, modifiy these value in CSV and import back to move block to new position?
If you don't modify values in CSV, what is the goal of export/import?
Olivier
Olivier Eckmann
To @O_Eckmann
<<... what is the goal of export/import?>>
Yes, that's the million dollar question. Take the data OUT then put it right back IN.....why not keep the data where it is? Take out then put back in means there's no gain.
Is this like trying to go upstairs by stepping on the down escalator?
Chicagolooper
@infoNV9S2 wrote
<<...we want to modify these data and re-import to our main drawing and update the object...>>
Would it be possible to describe (detailed description) or provide a screenshot of what the data looks like? Is the data points? Or lines? Or polygons? A combination? The 'type' of objects the data is attached to makes a difference, a big difference.
Better yet, upload the actual data itself.
If they are points, it's easy. However, if lines or polygons, then it begins to get complicated.
Chicagolooper
Hi @infoNV9S2 ,
There are some manual operations but you could perhaps use a solution by creating OD Table to receive CAD properties, use my plug-in to copy CAD properties to OD, export OD to TXT, update TXT into Excel, import back OD form TXT, and copy back OD to CAD. Here is a video of process.
Olivier
Olivier Eckmann
