Вы не вошли. Пожалуйста, войдите или зарегистрируйтесь.
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
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.
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,";"),""))
You should also check out our new message filtration feature which might help solve your problem.