I have a *.csv file complete with point refernces, easting, northing and height. I'm trying to find a way that I can import the points so that I can snap to them and also include the point reference beside the inserted point. Currently running CAD LT 2011. Any help would be great.
Cheers
Andy
Start reading thru these and understand Cocantenation:
Post back if you get stuck with specific issues.
The attached file is a Cocantenation example.
Please mark any response as "Accept as Solution" if it answers your question.
_____________________________________________________________
Regards, Charles Shade
CSHADEDESIGN | AUTOCAD LT | LT-KB | DYNAMIC BLOCKS
Please mark Accept as Solution if your question is answered. Kudos gladly accepted. ⇘
I'd read through some of the ways of importing the multitude of points I have - and had already completed the Cocantenation example. The sticking point is assigning the point I.D from the *.csv file to the corresponding point in the *.dwg
If your "points" are really attributed blocks then the solution is a bit different. Is this the case?
Dave.
I thought that too but the points will come in as single entities and not Blocks.
The OP would then need to either convert these to a Block and assign a Location Field to each which I think is much more than they wish to do.
Though I believe this to be the solution. I do not know of any entitiy that you can just create and have it report where and what it is without additional work.
The OP could Copy/Paste from Excel into a MTEXT entity.
Please mark any response as "Accept as Solution" if it answers your question.
_____________________________________________________________
Regards, Charles Shade
CSHADEDESIGN | AUTOCAD LT | LT-KB | DYNAMIC BLOCKS
Please mark Accept as Solution if your question is answered. Kudos gladly accepted. ⇘
Here I come to save the day!
A script will do what you want. I just created the following script very quickly
POINT 10,10,10 TEXT 10,10,10 2.5 0 10,10,10
I'll break it down for you
POINT 10,10,10 creates a point at location 10,10,10
TEXT 10,10,10 chooses the co-ordinate to put the text.
2.5 is the text height
0 is the text rotation
10,10,10 is the text to put at that location
so for all your points you would change it to
POINT your points TEXT your points 2.5 0 your points
Remember to put a hard return after the last your points and you can do it all in one script file
Howard Walker
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
So...
If there are 25 points the OP would need 25 Scripts?
Or would need to enter the info 75 times?
Regards, Charles Shade
CSHADEDESIGN | AUTOCAD LT | LT-KB | DYNAMIC BLOCKS
Please mark Accept as Solution if your question is answered. Kudos gladly accepted. ⇘
He needs to open up his csv in excel and then put the following into a cell to the right of the first set of numbers
=CONCATENATE("point ",A2," text ",a2," 2.5 0 ",a2)
and that will make the script line. Then he just copy and pastes down the page, and it will do all the work.
Copy and paste the results into a text file.
If he thinks it's too much work. Post the csv file on here and when I have a spare 2 mins. I'll do it.
Howard Walker
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Ahhh... did not think about addding the Text Command to the string.
Brilliant!
Regards, Charles Shade
CSHADEDESIGN | AUTOCAD LT | LT-KB | DYNAMIC BLOCKS
Please mark Accept as Solution if your question is answered. Kudos gladly accepted. ⇘
In the past when I've done this I've copied the final concatenated text out of the spreadsheet and pasted it at the AutoCAD command line. As long as the command entries are correct that works too.
Dave.