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.xxxxIs 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
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..
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
The Import coordinates tool was useful in importing the text. I did however incorporate a few more steps to get them in the right location
I am working with a geographic coordinate system : NAD83
my coordinates are express as
N51:06:54.4352 W071:45:30.4352 (Degrees,minutes,seconds) which I then convert into -71.7584,51.9151. (degrees) (This is still W° and N°)
If I use the "import coords' tool, it places the point at X= -71.7584 Y=51.9151 this is not the same location as N51:06:54.4352 W071:45:30.4352.
Is there a way to change the 'import coordinate" tool to import using the Geographic coordinate system I am using?
I found this work around
I place all my cells using the key-in @c:\folder location\xx.txt
point acsabsolute -71.7584,51.9151;
this will place my cells (obstacles/objects in the right location)
I then use the "export coordinate" tool with TXYZ
this exports all my cells and coverts the W° N° into the correct X,Y location.
I then edit this exported file in excel and change all the "T" with my text column, I then import this file back into microstation with the TXYZ. Thanks.
one thing that did concern me when exporting, would microstation keep the order in which the obstacles were placed.
It seems it does. Obstacle 1,2,3,4,....when placed is still in the correct order 1,2,3,4,.....when exported, but that is something too keep an eye on and cross check.
Maybe there's a better way to do this? please share, is there a key-in to import text from .txt, .csv.. with the W°, N° coords?
Stephane Grondin said:If I use the "import coords' tool, it places the point at X= -71.7584 Y=51.9151 this is not the same location as N51:06:54.4352 W071:45:30.4352.
I think the import coordinates is expecting meters ... I think we must use long lat as degrees units .. but as Rod suggested the Auxillary coord system can use Lat , long ( x,y) .. but Doesnt the GCS datum when set to long lat say its changing the units from meters...?
I've not struck this before... as usually I have it UCM Eastings and Northings and just use the reproject feature via using it in a ref file to get it to long lat ( and I have seen a noticeable distortion or narrowing as you go further south) ... what GCS datum did you set it to use?
when I started with a new file in meters no datum in meters, then I select GCS as not projected to get the NAD83 in long lat microstation asks me to let it change the units to degrees.( when I later checked the design units they are now in degrees) .. then if the lat long in degrees from xyz tools should work?
Have you any survey data that you can xref to check a coordinate from the xref reprojected into the active long lat file?
I found it easier to set-up a clean file with the LL83 GCS, set the unit format how I liked it and simply use that file for all ins and outs, referencing to and from my project file using Geographic-Reprojected. The only drawback is graphics distort, easily corrected.
Connect r17 10.17.2.61 self-employed-Unpaid Beta tester for Bentley