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.

  • .xls exportation from messages info
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,";"),""))

.xls exportation from messages info

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

  • .xls exportation from messages info
Nishad Hussain Kaippally
Implementation Specialist, Middle East, Gurtam

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