Question about Apex Coordinate conversion

[Jack ONeill-FR 0]

Hello guys,

 

I have a little question for you.

I need to convert a x y Coordinate to gps coordinate on tanoa map.

 

I know the technique on the editor, but I need a faster and easier method. You know maybe a tool for that.

 

I need to convert a lot of coordinate.

Thanks you for your help.

[gc8 977]

you are looking for script commands? mapGridPosition should do the trick

[Jack ONeill-FR 0]

18 minutes ago, gc8 said:

you are looking for script commands? mapGridPosition should do the trick

 

I have a database file with the uid reader, Coordinate ect on a Excel file.

 

I need to convert 500 or 1.000 line.

[Grumpy Old Man 3546]

8 hours ago, Jack ONeill-FR said:

 

I have a database file with the uid reader, Coordinate ect on a Excel file.

 

I need to convert 500 or 1.000 line.

What exactly is stopping you?

Where's the problem?

 

Cheers

[Jack ONeill-FR 0]

For exemple i have on my file:

x=3457 y= 1543

 

but i need a gps coordinate 128764

I am looking for example a converter to do it quickly.

 

Sorry I do not know if I'm clear in my explanations

[Greenfist 1863]

Do you really have an excel file with just awkward lines of "x=3457 y= 1543", or is it more like a one column for x  and one for y?
X    |    Y
12  |   23
27  |   34
88  |  812

If that's the case you could copy all of those coordinates to clipboard,  then run the following script in console, and paste the results to a new column in your excel.

_output = "";
{
    _mapGrid = mapGridPosition ((_x splitString toString [9]) apply {parseNumber _x});
    _output = _output + _mapGrid + toString [10]
} foreach (copyFromClipboard splitString toString [10]);
copyToClipboard _output;

 

[Jack ONeill-FR 0]

On 13/12/2017 at 5:06 PM, Greenfist said:

Do you really have an excel file with just awkward lines of "x=3457 y= 1543", or is it more like a one column for x  and one for y?
X    |    Y
12  |   23
27  |   34
88  |  812

If that's the case you could copy all of those coordinates to clipboard,  then run the following script in console, and paste the results to a new column in your excel.

_output = "";
{
    _mapGrid = mapGridPosition ((_x splitString toString [9]) apply {parseNumber _x});
    _output = _output + _mapGrid + toString [10]
} foreach (copyFromClipboard splitString toString [10]);
copyToClipboard _output;

 

Ok i try that.