GPSBabel › GPSBabel - Dev

gps tracker tk 106 pro2

Classic

List

Threaded

5 messages Options

il grilletto

gps tracker tk 106 pro2

the new tracker in object write positions on a micro sd card with a strange format. the old model writed gps position in nmea format. this model write in this format: imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172802,,F,092758.000,A,4529.9463,N,00911.6587,E,0.00,0; do you can help me to undestand how can I transform this in Google format? for exaple .kml? tank you.

Robert Lipe-4

Re: gps tracker tk 106 pro2

Your question is very hard to understand.

Reformatted, I think you're saying that this device writes files with content like this:

imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;

Which sort of looks like NMEA, but isn't. You might be able to get our gpsbabel style definitions to read it as that 4529N/911E pairing is probably an NMEA_LAT/NMEA_LON pair.

If that doesn't play out, you may find it easier to write your own reader/writer in C++ .

If they pushed a firmware update that stopped storing YOUR data in NMEA and instead in this weird format, perhaps there's a setting to change it back. I'd encourage you to see if there is.

RJL

On Thu, May 26, 2016 at 9:48 AM, il grilletto <[hidden email]> wrote:

the new tracker in object write positions on a micro sd card with a strange format. the old model writed gps position in nmea format. this model write in this format: imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172802,,F,092758.000,A,4529.9463,N,00911.6587,E,0.00,0; do you can help me to undestand how can I transform this in Google format? for exaple .kml? tank you.
View this message in context: gps tracker tk 106 pro2
Sent from the GPSBabel - Dev mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
Gpsbabel-code mailing list http://www.gpsbabel.org
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gpsbabel-code

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
Gpsbabel-code mailing list http://www.gpsbabel.org
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gpsbabel-code

Robert Lipe-4

Re: gps tracker tk 106 pro2

If this was captured on the north side of Milan, you may have hit the jackpot.

If your data is in /tmp/xx:

imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;

and we sketch in a style as /tmp/xx.style:

$ cat /tmp/xx.style

FIELD_DELIMITER COMMA

RECORD_DELIMITER NEWLINE

IFIELD IGNORE, "", "%s" # imei:**

IFIELD IGNORE, "", "%s" # tracker

IFIELD GMT_TIME, "", "%y%m%d%H%M%S" # datetime
IFIELD IGNORE, "", "%s" # empty

IFIELD IGNORE, "", "%s" # "F" ?

IFIELD IGNORE, "", "%s" # "0924" ?

IFIELD IGNORE, "", "%s" # "A" ?

IFIELD LAT_NMEA, "", "%s" # "4529..." ?

IFIELD IGNORE, "", "%s" # "N" probably a hemisphere

IFIELD LON_NMEA, "", "%s" # "4529..." ?

IFIELD IGNORE, "", "%s" # "E" probably a hemisphere

It looks like we can basically read it. It highlights that we probably need a hemisphere in our style, but you may be lucky.

$ ./gpsbabel -i xcsv,style=/tmp/xx.style -f /tmp/xx

Wed May 25 12:25:22 2016 45.499105N 9.194312E WPT001/WPT001

Wed May 25 12:25:42 2016 45.499105N 9.194312E WPT002/WPT002

Wed May 25 12:26:02 2016 45.499105N 9.194312E WPT003/WPT003

Wed May 25 12:26:22 2016 45.499105N 9.194312E WPT004/WPT004

Wed May 25 12:26:42 2016 45.499105N 9.194312E WPT005/WPT005

Wed May 25 12:27:02 2016 45.499105N 9.194312E WPT006/WPT006

Wed May 25 12:27:22 2016 45.499105N 9.194312E WPT007/WPT007

Wed May 25 12:27:42 2016 45.499105N 9.194312E WPT008/WPT008

Perhaps you can figure out the other fields, polish this up, then send the results back to us so we can include it for the next user of this device.

RJL

On Thu, May 26, 2016 at 2:44 PM, Robert Lipe <[hidden email]> wrote:

Your question is very hard to understand.

Reformatted, I think you're saying that this device writes files with content like this:

imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;
imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;
imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;
imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;
imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;
imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;
imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;
imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;

Which sort of looks like NMEA, but isn't. You might be able to get our gpsbabel style definitions to read it as that 4529N/911E pairing is probably an NMEA_LAT/NMEA_LON pair.

If that doesn't play out, you may find it easier to write your own reader/writer in C++ .

If they pushed a firmware update that stopped storing YOUR data in NMEA and instead in this weird format, perhaps there's a setting to change it back. I'd encourage you to see if there is.

RJL

On Thu, May 26, 2016 at 9:48 AM, il grilletto <[hidden email]> wrote:
the new tracker in object write positions on a micro sd card with a strange format. the old model writed gps position in nmea format. this model write in this format: imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172802,,F,092758.000,A,4529.9463,N,00911.6587,E,0.00,0; do you can help me to undestand how can I transform this in Google format? for exaple .kml? tank you.
View this message in context: gps tracker tk 106 pro2
Sent from the GPSBabel - Dev mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
Gpsbabel-code mailing list http://www.gpsbabel.org
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gpsbabel-code

il grilletto

Re: gps tracker tk 106 pro2

Robert, thanks for your analysis.
I think we are not much far from the solution.
I asked to the Chinese assistance of the new tracker tk 106 pro2 to change the output text file in nmea format or give me the sms format to change the output format from the actual to the old.
But I don't know if they will do.

For your information I am in north Milan.

I send you:

the old text file of the tracker (150906.txt) in nmea format;
the .kml file produced from 150909.txt with gpsbabel;
the new .txt file (160525_1.txt) in the weird format;
a snapshot from the chinese web site http://www.gpstrackerxy.com/ where you can charge Directly 160525_1.txt and obtain all the positions;
my elaboration of the new txt file in excel (160525.xlsm)

From the first sheet of 160525.xlsm I think it is possible to have a file nmea good for gpsbabel for the translate in .kml or to have directly the translation in gpsbabel of 160525_1.txt.

The only thing I've done in .txt file is that I cancelled my imei.

Tell me what do you think about.

Thank you very much.
Best wishes
Paolo D'Andria

Il 26/05/2016 21:58, Robert Lipe ha scritto:

If this was captured on the north side of Milan, you may have hit the jackpot.

If your data is in /tmp/xx:

imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;

and we sketch in a style as /tmp/xx.style:

$ cat /tmp/xx.style

FIELD_DELIMITER COMMA

RECORD_DELIMITER NEWLINE

IFIELD IGNORE, "", "%s" # imei:**

IFIELD IGNORE, "", "%s" # tracker

IFIELD GMT_TIME, "", "%y%m%d%H%M%S" # datetime
IFIELD IGNORE, "", "%s" # empty

IFIELD IGNORE, "", "%s" # "F" ?

IFIELD IGNORE, "", "%s" # "0924" ?

IFIELD IGNORE, "", "%s" # "A" ?

IFIELD LAT_NMEA, "", "%s" # "4529..." ?

IFIELD IGNORE, "", "%s" # "N" probably a hemisphere

IFIELD LON_NMEA, "", "%s" # "4529..." ?

IFIELD IGNORE, "", "%s" # "E" probably a hemisphere

It looks like we can basically read it. It highlights that we probably need a hemisphere in our style, but you may be lucky.

$ ./gpsbabel -i xcsv,style=/tmp/xx.style -f /tmp/xx

Wed May 25 12:25:22 2016 45.499105N 9.194312E WPT001/WPT001

Wed May 25 12:25:42 2016 45.499105N 9.194312E WPT002/WPT002

Wed May 25 12:26:02 2016 45.499105N 9.194312E WPT003/WPT003

Wed May 25 12:26:22 2016 45.499105N 9.194312E WPT004/WPT004

Wed May 25 12:26:42 2016 45.499105N 9.194312E WPT005/WPT005

Wed May 25 12:27:02 2016 45.499105N 9.194312E WPT006/WPT006

Wed May 25 12:27:22 2016 45.499105N 9.194312E WPT007/WPT007

Wed May 25 12:27:42 2016 45.499105N 9.194312E WPT008/WPT008

Perhaps you can figure out the other fields, polish this up, then send the results back to us so we can include it for the next user of this device.

RJL

On Thu, May 26, 2016 at 2:44 PM, Robert Lipe <[hidden email]> wrote:

Your question is very hard to understand.

Reformatted, I think you're saying that this device writes files with content like this:

imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;

imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;

Which sort of looks like NMEA, but isn't. You might be able to get our gpsbabel style definitions to read it as that 4529N/911E pairing is probably an NMEA_LAT/NMEA_LON pair.

If that doesn't play out, you may find it easier to write your own reader/writer in C++ .

If they pushed a firmware update that stopped storing YOUR data in NMEA and instead in this weird format, perhaps there's a setting to change it back. I'd encourage you to see if there is.

RJL

On Thu, May 26, 2016 at 9:48 AM, il grilletto <[hidden email]> wrote:

the new tracker in object write positions on a micro sd card with a strange format. the old model writed gps position in nmea format. this model write in this format: imei:**********78143,tracker,160525172522,,F,092517.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172542,,F,092538.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172602,,F,092558.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172622,,F,092618.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172642,,F,092638.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172702,,F,092658.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172722,,F,092718.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172742,,F,092738.000,A,4529.9463,N,00911.6587,E,0.00,0;imei:**********78143,tracker,160525172802,,F,092758.000,A,4529.9463,N,00911.6587,E,0.00,0; do you can help me to undestand how can I transform this in Google format? for exaple .kml? tank you.

View this message in context: gps tracker tk 106 pro2
Sent from the GPSBabel - Dev mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
Gpsbabel-code mailing list http://www.gpsbabel.org
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gpsbabel-code

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Gpsbabel-code mailing list http://www.gpsbabel.org
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gpsbabel-code

150906.txt (71K) Download Attachment

150906.kml (521K) Download Attachment

160525_1.txt (123K) Download Attachment

160525_1.xlsm (160K) Download Attachment

il grilletto

bingo!!!! Re: gps tracker tk 106 pro2

In reply to this post by Robert Lipe-4

After two days of night work I translated the new strange of gps tracker tk 106 pro2 file in NMEA format!! I'am very happy!!! with gspbabel I translate in .kml and it work's very well in Google map.
All this with an excel.. the more difficult work as been to structurate the Nmea checksum..

this was the starting .txt file (a part)

imei:**********************,tracker,160531073937,,F,053937.000,A,4529.9981,N,00911.6669,E,0.00,0;imei:**********************,tracker,160531073957,,F,053955.000,A,4529.9981,N,00911.6669,E,0.00,0;imei:**********************,tracker,160531074017,,F,054014.000,A,4529.9981,N,00911.6669,E,0.00,0;imei:**********************,tracker,160531074037,,F,054034.000,A,4529.9981,N,00911.6669,E,0.00,0;imei:**********************,tracker,160531074057,,F,054054.000,A,4529.9981,N,00911.6669,E,0.00,0;imei:**********************,tracker,160531074117,,F,054113.000,A,4529.9981,N,00911.6669,E,0.00,0;imei:**********************,tracker,160531074137,,F,054133.000,A,4529.9981,N,00911.6669,E,0.00,0;imei:**********************,tracker,160531074157,,F,054153.000,A,4529.9981,N,00911.6669,E,0.00,0;imei:**********************,tracker,160531074217,,F,054213.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074237,,F,054233.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074257,,F,054254.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074317,,F,054313.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074337,,F,054333.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074357,,F,054353.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074417,,F,054413.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074437,,F,054432.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074457,,F,054453.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074517,,F,054513.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074537,,F,054533.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074557,,F,054553.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074617,,F,054613.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074637,,F,054633.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074657,,F,054652.000,A,4529.9888,N,00911.6640,E,0.00,0;imei:**********************,tracker,160531074717,,F,054713.000,A,4529.9888,N,00911.6640,E,0.00,0;

and this the new (a part):

$GPRMC,053937.000,A,4529.9981,N,00911.6669,E,0.00,0,310516,,,A*4E
$GPRMC,053955.000,A,4529.9981,N,00911.6669,E,0.00,0,310516,,,A*4A
$GPRMC,054014.000,A,4529.9981,N,00911.6669,E,0.00,0,310516,,,A*41
$GPRMC,054034.000,A,4529.9981,N,00911.6669,E,0.00,0,310516,,,A*43
$GPRMC,054054.000,A,4529.9981,N,00911.6669,E,0.00,0,310516,,,A*45
$GPRMC,054113.000,A,4529.9981,N,00911.6669,E,0.00,0,310516,,,A*47
$GPRMC,054133.000,A,4529.9981,N,00911.6669,E,0.00,0,310516,,,A*45
$GPRMC,054153.000,A,4529.9981,N,00911.6669,E,0.00,0,310516,,,A*43
$GPRMC,054213.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*47
$GPRMC,054233.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*45
$GPRMC,054254.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*44
$GPRMC,054313.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*46
$GPRMC,054333.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*44
$GPRMC,054353.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*42
$GPRMC,054413.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*41
$GPRMC,054432.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*42
$GPRMC,054453.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*45
$GPRMC,054513.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*40
$GPRMC,054533.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*42
$GPRMC,054553.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*44
$GPRMC,054613.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*43
$GPRMC,054633.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*41
$GPRMC,054652.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*46
$GPRMC,054713.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*42
$GPRMC,054733.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*40
$GPRMC,054753.000,A,4529.9888,N,00911.6640,E,0.00,0,310516,,,A*46

Thank's for the help and my excel is disposable on request, also if it as many parts of manual activity. in the next day I'll search to arrange it.

by
Paolo