OkMap forum
OkMap forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 OkMap Forum - English
 Use of the software
 Batch coordinates conversations
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Victor

Russia
2 Posts

Posted - 07/02/2017 :  15:20:46  Show Profile  Reply with Quote
Hi everybody.
I have Excel file with coordinates , save it to csv file.
And next I do not know what input format for coordinate to use.
Excel file has coordinate format Deg Min Secs.
For example(39°18'40.5756", 102°17'30.4656").
Can anybody help me? Example of excel file.
Can I use another column with Excel file , like place , name etc ?

okmap

Italy
2355 Posts

Posted - 07/02/2017 :  18:28:32  Show Profile  Visit okmap's Homepage  Reply with Quote
Use different columns for degrees, minutes and seconds without special characters (first longitude then latitude); example:
102;17;30.4656;39;18;40.5756
Select "Degrees, minutes, decimal seconds" option.
Other columns will be ignored; you can paste them after conversion.
Go to Top of Page

Victor

Russia
2 Posts

Posted - 07/02/2017 :  19:34:42  Show Profile  Reply with Quote
Ok,Gian.
Thanks a lot. I'll try to do so.
Go to Top of Page

LinwoodK

USA
1 Posts

Posted - 25/09/2018 :  12:48:50  Show Profile  Reply with Quote
Hi Gian Paulo, what do you mean exactly by "you can paste them after conversion?" Just copy and paste?
Go to Top of Page

okmap

Italy
2355 Posts

Posted - 25/09/2018 :  14:14:45  Show Profile  Visit okmap's Homepage  Reply with Quote
I don't remember the context of discussion.
However every time you use in OkMap a coordinates box, you can copy the coordinates (and then paste in another coordinates box) using the context manu available in itself.
The coordinates box is a panel where you can choose the format of the coordinates (it has several tabs on the top).
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
OkMap forum © 2018 OkMap Go To Top Of Page
Powered By: Snitz Forums 2000 Version 3.4.07