Xibo

Statistics export

Asked by Danilo Majhenič

1. what is shown in the statistics?
I am asking that, cause i get only a third of plays i guessed it should be.

2. the other thing is, could the *.csv files be made with semicolon instead of comma, so excel would open them without a dialog in which you select that the delimiter is comma? in the form now (with comma) as delimiter....
/later after googling.
There could be some text to make people aware of the problem. there seems to be much confusion what is the standard of formating csv (because there is none), and how excel understands csvs. Cause it depends on the particular installation of windows and the regional settings. there is also a setting for what is a list separator, and in some regions the default is semicolon in some is comma.
if the csv is not properly understand and puts all the data in the first column, then the most userfriendly solution sounds to be to select the column and go to Data > Text to column, and set the delimiter in the gui that is apearing after that.

so i would like to have an answer to 1. and for the 2. I am suggesting to make a help message in the manual/statistics page.

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Alex Harrington
Solved:
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

> 1. what is shown in the statistics?
> I am asking that, cause i get only a third of plays i guessed it should be.

You get one log for each media item and each layout that plays. If the
records aren't there, it can be that your clients are unable to upload
them to the server - in which case they will drop them to a file on the
client.

> 2. the other thing is, could the *.csv files be made with semicolon instead of comma, so excel would open them without a dialog in which you select that the delimiter is comma? in the form now (with comma) as delimiter....
> /later after googling.
> There could be some text to make people aware of the problem. there seems to be much confusion what is the standard of formating csv (because there is none), and how excel understands csvs. Cause it depends on the particular installation of windows and the regional settings. there is also a setting for what is a list separator, and in some regions the default is semicolon in some is comma.
> if the csv is not properly understand and puts all the data in the first column, then the most userfriendly solution sounds to be to select the column and go to Data > Text to column, and set the delimiter in the gui that is apearing after that.

CSV stands for "comma separated variable" - which means that it's fields
separated by a comma. Putting a semicolon might be great for Excel but
who knows what it would break for other people. It's just not an option
I'm afraid.

> so i would like to have an answer to 1. and for the 2. I am suggesting to make a help message in the manual/statistics page.

The manual is in the wiki - you're free to add a section if you feel
that CSV needs explanation.

Alex

Revision history for this message
Danilo Majhenič (danilo-majhenic) said : 		#2

1. Is it localy written only after the moment it realy plays, or is it somehow looking on the schedule and prepares the files before?
if it is unable to upload (from a previously thread i see that it is upload in chunks, when enough data is gathered) and it drops it localy. Does it attempt to re-upload a failed upload?

2. i am aware of that, thats why i was also googling, cause the xibo produced csv looked totaly fine for me. from my point the problem is on MS side. again :>

Revision history for this message
Best Alex Harrington (alexharrington) said : 		#3

> 1. Is it localy written only after the moment it realy plays, or is it somehow looking on the schedule and prepares the files before?
> if it is unable to upload (from a previously thread i see that it is upload in chunks, when enough data is gathered) and it drops it localy. Does it attempt to re-upload a failed upload?

It stores the stats records in memory. When there is sufficient
collected, it uploads them.

If it fails to upload a number of times (I think three but I could be
wrong), it flushes to disk. That file is never read back in and sent.

Alex

Revision history for this message
Danilo Majhenič (danilo-majhenic) said : 		#4

If it is never re-uploaded, then that would be the missing point. Some of our clients are on wifi...
tnx

Revision history for this message
Danilo Majhenič (danilo-majhenic) said : 		#5

Thanks Alex Harrington, that solved my question.