Bug 19347

Summary: Report Generated after download is not comma seperated (CSV)
Product: Koha Reporter: Apurba Jyoti Majumder <apurbajyoti>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: major    
Priority: P5 - low CC: fridolin.somers, jonathan.druart, josef.moravec
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Snapshot of the default output of the downloaded file

Description Apurba Jyoti Majumder 2017-09-20 06:27:30 UTC
Created attachment 67224 [details]
Snapshot of the default output of the downloaded file

The report that is generated after download is not separated by "comma", its "semi colon"

Steps:
1. go to Home › Reports › Guided reports wizard › Saved reports ›
2. Run a report (example: Circulation-All Circ Actions on Date Report)
3. Out put appears on screen
4. Click on download
5. Click on "comma separated text"
6. The report output is downloaded in your computer
7. Go to the "download" folder
8. Open the file in excel or libre office [example: Circulation-All Circ Actions on Date-reportresults.csv]
8. The output is separated row-wise but not column wise and the separator is "semicolon ;" instead of "comma ,"
Comment 1 Josef Moravec 2017-09-20 09:14:25 UTC
(In reply to Apurba Jyoti Majumder from comment #0)
> Created attachment 67224 [details]
> Snapshot of the default output of the downloaded file
> 
> The report that is generated after download is not separated by "comma", its
> "semi colon"
> 
> Steps:
> 1. go to Home › Reports › Guided reports wizard › Saved reports ›
> 2. Run a report (example: Circulation-All Circ Actions on Date Report)
> 3. Out put appears on screen
> 4. Click on download
> 5. Click on "comma separated text"
> 6. The report output is downloaded in your computer
> 7. Go to the "download" folder
> 8. Open the file in excel or libre office [example: Circulation-All Circ
> Actions on Date-reportresults.csv]
> 8. The output is separated row-wise but not column wise and the separator is
> "semicolon ;" instead of "comma ,"

Try to change the system preference "delimiter" to "comma", does it make difference?
Comment 2 Apurba Jyoti Majumder 2017-09-20 11:02:54 UTC
Solved the issue.
Thank you.
But, I think the default "delimiter" should be "comma"
Comment 3 Fridolin Somers 2017-10-10 12:03:41 UTC
I set as resolved.

> But, I think the default "delimiter" should be "comma"
Default values can not satisfy everyone ;)