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

You should be able to place cells using the long,lat coordinates fairly easily

1. Under the Utilities tab in the ribbon go to the Geographic group and set the desired geographic coordinate system for your design file.
   
   
2. Many geographic coordinate systems will define a geographic auxiliary coordinate system (ACS) for longitude,latitude input and readout. The ACS dialog can be found under the Drawing Aids ribbon tab
   
   
   
3. Make that geographic ACS your active ACS by double clicking on it.
   
   
4. In your text file change the latitude longitude coordinates so that they read longitude, latitude
   
   
5. Format your coordinates so that they are in this format
   ax=-91d51m40.68s,45d16m49.03s
   
   The ax= keyin places a data point using the the active ACS. In this case it will be geographic, or longitude,latitude.
   
   
6. You can use the dx= keyin to place the text label at an offset from the cell origin
   dx=10,10 would place the text 10 working units to the top and right of the cell origin

You may find that importing your text file into Excel will allow for easier edits. Then just export to .csv. In the .csv replace all of the ax, and dx, with ax= and dx=

I have a different examples using the Excel method outlined here.

https://envisioncad.com/microstation-tip-automate-coordinate-entries/

https://envisioncad.com/microstation-tip-automate-coordinate-entries-part-2/

Your command file would look something like this...

You could set up your spreadsheet something like this...

That's to do both the cell and text label in one command file.

You might find it easier to place the cells using one command file, then place the text labels using the same ax= coordinate in a second command file.

You should be able to place cells using the long,lat coordinates fairly easily

1. Under the Utilities tab in the ribbon go to the Geographic group and set the desired geographic coordinate system for your design file.
   
   
2. Many geographic coordinate systems will define a geographic auxiliary coordinate system (ACS) for longitude,latitude input and readout. The ACS dialog can be found under the Drawing Aids ribbon tab
   
   
   
3. Make that geographic ACS your active ACS by double clicking on it.
   
   
4. In your text file change the latitude longitude coordinates so that they read longitude, latitude
   
   
5. Format your coordinates so that they are in this format
   ax=-91d51m40.68s,45d16m49.03s
   
   The ax= keyin places a data point using the the active ACS. In this case it will be geographic, or longitude,latitude.
   
   
6. You can use the dx= keyin to place the text label at an offset from the cell origin
   dx=10,10 would place the text 10 working units to the top and right of the cell origin

You may find that importing your text file into Excel will allow for easier edits. Then just export to .csv. In the .csv replace all of the ax, and dx, with ax= and dx=

I have a different examples using the Excel method outlined here.

https://envisioncad.com/microstation-tip-automate-coordinate-entries/

https://envisioncad.com/microstation-tip-automate-coordinate-entries-part-2/

Your command file would look something like this...

You could set up your spreadsheet something like this...

That's to do both the cell and text label in one command file.

You might find it easier to place the cells using one command file, then place the text labels using the same ax= coordinate in a second command file.