Bug 19347 - Report Generated after download is not comma seperated (CSV)
Summary: Report Generated after download is not comma seperated (CSV)
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low major (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-09-20 06:27 UTC by Apurba Jyoti Majumder
Modified: 2019-06-27 09:24 UTC (History)
3 users (show)

See Also:
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 (11.55 KB, image/jpeg)
2017-09-20 06:27 UTC, Apurba Jyoti Majumder
Details

Note You need to log in before you can comment on or make changes to this bug.
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 ;)