Forum GLPI-Project

morvanbr

Member

From: Brasil

Registered: 2015-05-05

Posts: 43

Website

Wrong Format When Exporting to CSV

Hi. When I take a report, say, Statistics of tickets, and try to export via CSV format, spreadsheets (tested on Calc and Excel) do not appear to handle properly the data. Time Fields, like "Mean Time Solution" exhibit strange numbers. If we try to convert to Serial Date, it renders fixed, although. See bellow:

We need some clue, cause our politics regarding GLPI prohibits messy with code. Any idea will be welcomed.
Obs.: via PDF, of course, all right. GLPI Ver 0.85.5.
Edited: Version of GLPI.

Last edited by morvanbr (2015-11-30 16:43:35)

KKAdmin

Member

From: Germany

Registered: 2010-03-05

Posts: 959

Re: Wrong Format When Exporting to CSV

I have only a solution for your ">" problem.

Read this post
http://forum.glpi-project.org/viewtopic … 51#p218351

---

You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3

morvanbr

Member

From: Brasil

Registered: 2015-05-05

Posts: 43

Website

Re: Wrong Format When Exporting to CSV

I have only a solution for your ">" problem.
Read this post
http://forum.glpi-project.org/viewtopic … 51#p218351

Hi. Thanks. But problem persists, cause we face it regarding numbers. To convert Encode is not a concern, in this case.
We tested against Calc (LibreOffice), once I am L. O. Enthusiast and right about this, for pupils at my organization. Anyway, thanks.