blocks with multiple attributes import and export

[Anonymous]

So I want to create a simple block ( hatched circle ) with multiple attributes. the block represents an object found in a survey. - x-coordinate - y coordinate - z coordinate - characteristic a - characteristic b - characteristic c I want to be able to import these blocks ( usually about 50-400 objects ) within a drawing based upon X and Y coordinate, but have the Z and characteristics visible within properties. import through .TXT, .CSV or .XLS the objects should also be able to be exported to .TXT, .CSV or .XLS I allready tried to build a block like this and export ( attext) templates files to do so, but without succes. Can someone help me please?

[maratovich]

Give us an example of your file.

[Anonymous]

Will do so as soon as I get to my desktop@work.
Thought of that already, but thanx

[S.Faris]

Use DATAEXTRACTION to export properties of the block to an excel file.

Refer to this : Extracting object coordinates to an external text file in AutoCAD

[Anonymous]

So I want to import blocks in a drawing with attributes taken from an excel. and vice versa ( extract block attributes from a drawing to an excel. )

3 of the attributes are geometry values ( X,Y and Z ) these should be incorporated.

the other 2 values are generated from a third party ( survey software ) and represent max nT and AM2.

in the example attached the X,Y and Z values are manual input. these should come from the insertion point off course.

I use an attext template to extract the X,Y and Z values. but I haven't had any luck yet extracting the MAX. nT and AM2 values.