1

Export Messages to Excel (xls)

(edited by jhdeguate 25/08/2016 16:16:13)

Topic: Export Messages to Excel (xls)

Hello Gurtam team!

We use a lot the information from "Messages" (for data/performance analazing),  and it will be very useful to be able to have the option to export to Excel (xls).  Hoping you are agree with me!

Best regards,

Jary Hernández
FENIX GPS

2

Export Messages to Excel (xls)

Re: Export Messages to Excel (xls)

100 % agree.

Locating things
3

Export Messages to Excel (xls)

Re: Export Messages to Excel (xls)

jhdeguate and locationGPS, to get Excel files with messages, please use a special report table — Messages Tracing.

Katerina Alexandrova
Product Manager (Hecterra)
Gurtam
4

Export Messages to Excel (xls)

Re: Export Messages to Excel (xls)

Thanks Alek for your response...

Yes, we can use Messages Tracking to get vehicle and sensors information, BUT that is not what I am just looking for as I need to be able to export to "xls" all the information I can get from "Messages" for easy analizing (not for customers, it is for our thecnical/operations department); example:

1. Data messages  (I need this to export to xls)
    1.1 Raw data  (I need this to export to xls)
    1.2 Sensor values  (I need this to export to xls)

2. SMS messages (I don´t use them right now but it would be good to be able to export as well)

3. Sent commands  (I need this to export to xls)

4. Registered events  (I need this to export to xls)

5. Log  (I need this to export to xls)


I  hope now you get my point.
Regards,


Jary Hernandez

5

Export Messages to Excel (xls)

Re: Export Messages to Excel (xls)

jhdeguate,
1. Messages Tracing table as well as standard export of messages
2. SMS Messages table
3. Executed Commands table
4. Events table (incleds registered events)
5. Log table

Please consider these reports and try to find everything needed in them!
If not, come back here and explain your difficulties in more detail.

Katerina Alexandrova
Product Manager (Hecterra)
Gurtam
6

Export Messages to Excel (xls)

Re: Export Messages to Excel (xls)

Hello Alek...

I know the "Export Messages" supported formats are:

1) OziExplorer track(.plt).
2) NMEA messages (.txt).
3) Google Earth (.kml).
4) Wialon messages (.wln).
5) Wialon binary messages (.wlb).

BUT, I need you to add XLS (Excel) as well.

6) XLS

For US it will be very helpfull if you can do it.  Hope you are agree with me.
Best regards,


Jary Hernandez

7

Export Messages to Excel (xls)

Re: Export Messages to Excel (xls)

Alternatively, you can convert .txt into .xls

Katerina Alexandrova
Product Manager (Hecterra)
Gurtam