Sync attributes with a text file

Hello

I have a lot of drawings containing blocks with attributes.

I would like to find a tool which enables to export attributes to txt/xls file and import them back after modification in Excel.

I have tried with ATTOUT and ATTIN. It works fine but the problem is that I need to export also the positions X, Y of the block. ATTOUT can not do that.

I have tried with ATTEXT and a template, it works fine, but there is no command to import the modified text file.

So I would like to find a simple Autolisp code which enables to export all blocks B01 and their attributes to a text file.

And then update the attributes from the modificated text file.

Any suggestion ?

Thanks for your time.

Welcome to CADTutor!

Have you tried the DataExtraction command?

Hello, thanks for your reply.

I'm working with Autocad R2006. And the dataextraction command is not available in this version.

I'd prefer an autolisp routine that I can adapt to my needs.

Thanks again for your help.

That's too bad.

The only way I can think of for your situation, is for you to create a routine that incorporates a selection set filtering for DXF code (66 . 1), then step through your selection set testing for the HasAttributs property, then step through each attribute in the block, and write the attribute information to your Excel compatible file (i.e., .CSV?).

Good luck!

Yes it is exactly what I want to do.

Yes it is exactly what I want to do.

Okay, sounds good.

I've laid out some of the more critical steps... Write your routine, and post back here if / when you run into a stopping point.

Good luck!