A way to move text(objects) to specific coordinates.

[eugen.cobilas]

Hello, I need a help with a solution.I need a way to move a Text from specific coordinates to another known position. I know how to do it manually, but after every recalculation of network this texts require update( ussualy it is 300-500 per network). I have an excel what create me this text tables and i find a way to import them to autocad in one go, but i cant figure it out to have them automatically move to position they need to be.

As far as i see solution, it should be something like

1. First time per project i would need to find position for every table manually

2. I would write down every position where all Table should be

3. If i need to rewrite tables i would delete all old text, keeping their coordinates

4. Somehow make auto cad move newly generated tables from specific point to position where their outdates version were.

I tried to create self-renewing tables linked to excel but my autocad will crash with 300-400 links.

   

[Pointdump]

Hi Eugen,
I'm not understanding what your drawing is.
What do all those numbers represent: Q, L, Dn, Pf?
Where are the coordinates in your spreadsheet?
What do the coordinates represent?
Where are your new coordinates, and how are you planning on moving the leader?

Dave

[eugen.cobilas]

Hi, thanks for replay.
those numbers are values I get from another program for my network.
Pressure, Length of pipe etc, between 2 critical points(this blocks with
numbers). I just need to have this little tables with proper information
near every pipeline. And because we have a lot of recalculation, i find
myself rewriting this tables manually, 300-450 per recalculation.
So if i could generate this tabbles automatically somehwere in my drawning
(i already know how to do this part) i could move them to specific position
where they should be. (In excel every table have its little number 1-131
for example, this is network pipelyne where it should be).
I dont know how to collect information, of their final coordinates, but so
far it is not the main issue.
I just need a way to move them all( 340-350) to their 350-400 specific
coordinates whre they should be.
It is somehow more clear now, or i need to explain it better?

[Washingtonn]

(FYI : I used a lisp file to automatically fill in the block handles as the blocks are inserted in order)

[3wood]

I noticed that some of the data doesn't match.

For example 147 - 146:

Is there any special formula for this change?

[eugen.cobilas]

There is another application that calculates what should be written in the table label. This is the reason I need to find a simpier way to update my autocad tabbles after every recalculation, to not put them manually. 

[eugen.cobilas]

Hi, thank you for responding. I have a feeling that your solution is better than one I had in mind. Tell me please, if I could generate Tabbles with that much data like I have in screenshots I attached and how exactly your method work.

So I would need to have 4 TAGS like (TOP/BOT) with my data? do you use external excel where you put all new data what should be updated in excel.

[Washingtonn · Accepted solution]

Attached is the link to a short video showing a procedure which should satisfy your needs.

I use this to coordinate piping systems using tags (dynamic blocks with attributes) in 2D single-line layouts - reduces the time spent creating and modifying 3D pipe models. In the video, I pasted some of your table information in a text file as attributes instead of calculating.

A dedicated spreadsheet can be used to calculate slopes, pipe lengths, etc... all from block insertion points based on the 2D layout and the handles of the tags.

Text files are referenced by supplying a filename and updated by the spreadsheet calculations.  AutoCAD commands ATTIN and ATTOUT update the tags in the drawing file (this can include moving the tags to the correct 3D elevation).

https://youtu.be/G7KA3OQbEn4

[eugen.cobilas]

Hi, I think your solution is far better idea than I had in mind. I would need some times to understand how it work( because I didnt even know autocad could work in way like this) and adapt to what I need. 

Thank you very much. 

P.S. Seeing how you work in AutoCAD, made me realize how much I dont know this program. I have much to learn forward.

[eugen.cobilas]

Also, can you please, send me your drawning, lisp file, excel and an example of file you used as data(.txt) file. I dont think I could set all of this be myself if i dont have an example of yours