1

.xls exportation from messages info

Topic: .xls exportation from messages info

Hello,
When can we have exportation to .xls / .csv from messages info about rawdata?
It is quite complicated to see errors there even having good screen size.
I remember it was posted some time ago but I do not understand why it was not interesting.
Maybe we test wrong way?
thanks

Locating things
2

.xls exportation from messages info

Re: .xls exportation from messages info

Hello, locationGPS
Did you try to open .wln files with Excel?
.csv and .wln files have the similar structure. Choose semicolon as a separator and get the result like on the attached screenshot.

Tatsiana Kots
Ex-Business Analyst, Gurtam
3

.xls exportation from messages info

(edited by kaippally 21/06/2017 13:18:46)

Re: .xls exportation from messages info

Currently messages can only be exported as .wln, wlb, .txt, .log

However if you export as .wln the data appears in the following format

REG;1498025011;55.36581;25.2344533;0;97;ALT:21.6,hdop:0.6;in1:0,,SATS:17,io_caused:7;avl_driver:"0";;;

Once you  copy this into your spreadsheet you will be able to split them by semicolon  using the following formula 
In google spreadsheet you would do the following

=ARRAYFORMULA(if(A:A<>"",split(A:A,";"),""))

https://forum.gurtam.com/misc.php?action=pun_attachment&amp;item=6048&amp;download=0

You should also check out our new message filtration feature which might help solve your problem.

Nishad Hussain Kaippally
Implementation Specialist, Middle East, Gurtam

"Computer science is no more about computers than astronomy is about telescopes."