As per my other thread (I seem to have posted it in the wrong autocad section).
I'm trying to display the XYZ information for multiple points using a process that doesn't take me all year.
You'll see below is the survey that I am trying to annotate. The file is a .dxf from my Leica totalstation. The file in question is attached to the thread.
What I'm trying to achieve is this... I processed the information below by ID'ing a single point and then copying the values from the command bar, then finally pasting the values into text attached at an offset to the point. Very time consuming.
What can I do to make this easier? In a perfect world I would like to highlight all the points and wave the magic wand and see all the points labled up with XYZ!
HELP.
Kind regards,
Ben.
Solved! Go to Solution.
Solved by steven-g. Go to Solution.
Sorry, but I wasn't sure if you meant that there is or isn't an automated tool?
I can't really afford to buy another autocad package so I'm really hoping this could be done somehow...
I can import my survey as a .CSV file rather than .DXF if that would help me? The whole purpose is to visualise my survey points and overlay the layer onto a drawing from my architect.
If the data is in csv format your easiest solution would be to use excel to help draw the data in Autocad, without knowing the full story I would suggest using the data in excel to create a script that will place blocks in your drawing that have attributes for the X,Y & Z values. If you need points in there for any further work then you will have to decide if the points are included inside the block or inserted separately. Can you post a csv file, it will be better to explain using actual data that you have. You could get the points out to excel but thats a bit more complicated than bringing them in, as LT doesn'y have the data extract option.
If it's a one off situation then just placing an attributed block on each point would be the most sensible us eof your time.
That sounds great, sounds to me like you're onto something here!
I've attached a .csv along with a .txt and the latest .dxf for you to mess about with. Happy to compensate you for your trouble if you can come up with something handy?
Looking forward to seeing what you come up with!
Ben.
I opened the csv file in excel and added 2 blank lines at the start of the list, you can see what has been added to column B, it's just a simple formula to create a string that inserts a block at the right scale and then repeats the insert command. The last cell has the last 2 spaces missing from the end of the formula !! The attached drawing has a copy of the block used it needs to be in the drawing for the script to work. In excel just select all the cells colored yellow and press Ctrl+C to copy the cells to the clipboard. Then in Autocad you need to click into the command line to make it active and then just press Ctrl+V to paste the clipboard contents to the command line. That's it.
Probably automating the task using excel macros is possible.
The easiest (but not fastest) solution is - a block with preset attributes, just paste it with NODE osnap on each point
Steven-G you are a LEGEND!!!
You've made it so easy for me! I can't thanks you enough. Well impressed.
Just on the off chance this isn't too taxing, is there a way of editing the attributes of all the points and texts once i've inserted them? Changeing the text height, colour, offset and I wonder, to say ENZ rather than XYZ?
Here's a screen grab of your hard work already put into action on a pile survey. Loveing it!
When altering attributes you usually have to use the ATTSYNC command afterwards and follow the command prompts. It does very occasionally throw up errors but that is rare (just be aware it can happen so check things afterwards) And yes you can alter the labels, open the block in the block editor and double click on the attributes, you can changes the letters in the default box (the first 2 characters - don't delete the grey characters at the right, they are field values that read the coordinates). I would save a copy of the block somewhere in another drawing first just in case.
I seem to be a little lost following you on this one...
I dont quite understand what I'm actually trying to do with attsync? I don't understand what it is asking by block level? Either way, it eventually tells me it is complete, but I don't understand what is complete? Nothing changes so far as I can tell... As for the block editor, I think I need to go back to school ha! I haven't a clue how to do what I want....
I did however edit the source block to look how I would like, however after I add in the excel bits they take on the original look? Properly confused. ha.
Feel free to tell me to jump off a cliff and give up if I'm a no hoper.
Just in case you're sitting there banging your head on the desk, I have just seen your post, and I'm taking a look to see what the problem might be. I finished work a couple of hours ago so only just checked back in. Don't worry we'll get it sorted, can you post a drawing with the altered block just so I can see what is going on there in the drawing
OK do you remember when I said problems with attsync are rare, well today is your lucky day. It looks like it isn't enough to just change the default value of the attribute you need to change the tag name as well.
OK so a bit better explanation on my part.
Open the block with the block editor and double click on one of the attributes (start with "X") that should open the "Edit Attribution Definiton" dialogue box, you should make the changes there, it only needs you to change the letter X to E in both the Tag and Default boxes, and click ok then select the Y attribute and change Y to N. After doing that exit the block editor saving any changes. Back in the drawing start the attsync command and at the first prompt choose select, then click on any of the blocks to select one, and then choose yes to finish the command. That should do it, you may need to do a regen as well.
Thats the basics of it. Are you wanting to alter anything else as well, you mention about adding in some excel bits ? If you want to alter the text style it might be better doing that in the "Format - Text Style" dialogue the style I used is called 1:1. I had used a scale in the insert script of 0.01 and you can adjust the size of the block in the properties toolpalette by selecting all the blocks and changing the scale. Or open the block editor and just change the text style to something else, by selecting the 3 attributes and make the change again in the properties toolpalette. There are other ways of making the changes as well. See if you can get the blocks to update correctly first when you alter the letters. And if you have ANY problems or further questions then I'll be happy to answer, It could be tommorrow though (I'm in Europe so it's getting close to bedtime).
I hope this helps get the problem sorted.
Firstly, sorry it's taken me so long to reply!
However, as you can see....
It worked!
The only thing i'm having a small problem with is editing the text, which is weird seeing as it's something I generally find super easy. Specifically what I'm trying to achieve is removing the dark grey backing to the text, but really for my own knowledge I'm aiming to learn how to edit the text style too...
I've tried....
Unfortunetly I'm still the weakest link here haha.
SO nearly there though. SO very nearly there.
Thanks a million for all the effort you've put in mate!!
That background is because that part of the text is actually a field (it's a sort of visual warning/reminder that a field is present), it can be turned off with the variable fielddisplay=0. I should add that the background is only visible in the drawing, it doesn't show up when you plot a drawing. Other than that you where in the right place for altering the text style.
HOW DO YOU KNOW SO MUCH!?
That worked a treat, though you probably already know that seeing as you are magic.
What is your line of work if you don't mind me asking?
I've been using Autocad for a while ! and I like figuring out how to do things quicker, which means I am always looking at different things. I work in a joiners shop, drawing office, mostly cabinet work and doorsets.
I find the best way to learn, is doing stuff like this, answering questions that are just a bit off the track from you're normal daily work, it's a great way to pick up tricks and look at things from another point of view.
Can't find what you're looking for? Ask the community or share your knowledge.