[CONNECT]
Import Coordinates (Latitude, Longitude) with text Labels

Question

I have a .txt file with -Latitude and Longitude points (degrees. minutes,seconds) -text information associated with those coords ie: (start, wpt1, wpt2, mid point, station1...) 
 I want to place Cells using Latitude and Longitude. I also want the text information displayed next to those waypoints. 
 I figured out how to create a .txt file and use "key-in" to place the Lat and long points in one step. (Deg,Mins,Seconds converted to Deg.xxxx Is there a way to add the text information associated with each of those points/cells. 
 I have been looking in the forum and can only information in regards to "import Coordinates", but that uses XYZ. Using this import places the obstacles in the wrong location 
 ...

Lorys · Answer

The import coordinates tool has TXYZ as well but only one text column so you would need to edit your csv file on the fly to change the T column .. what I do is have my csv in excel ( easier than txt files) as T1 X Y Z T2 T3 T4 T5, and run it then set new active level called T2 text, swap order so T2 is first, then run it again and select all T2 level and shift them all down one text height below T1, then repeat for T3 etc be careful the text import doesnt like many symbols or punctuation symbols .. also I prefer to use left centre text justification seems to work better for the text import ( BTW objects is better word in english than obstacles.) 
 Once you done it a few times it gets easier... then when finished you can select all the text and make it all in one level or leave it for ease of turning on or off.. 
 
 I have in the past found this method best for multi line text by import move method rather than working out the shift in xy 
 Now if you must have it all in one line separated by a comma then try using an odd character or Letter like $ or Q instead so it looks like StartQWPIQWP2Q 
 Then when your done use the find replace Q with space comma .. This works as just one import but you still have to select all the text and shift them off the cells ...( better than calculating the shift as your csv file the same one can be still used to place the cells via xyz just move the T to after the z column 
 Test first with small sample say 5 lines or coordinates. 
 As I said mstn import doesn't like punctuation characters so trial and error for 5 lines first pays off in the end. 
 oh and most important NO headings in your csv (excel) file 
 This topic has been posted before and I think it listed exactly what text etc microstation didn't like... but trial and error for small sample will reveal this..

[CONNECT] Import Coordinates (Latitude, Longitude) with text Labels

Top Replies