Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Make CSV exports in UTF-8 readable for Excel #41

Closed
pes-soft opened this issue Aug 24, 2015 · 2 comments
Closed

Make CSV exports in UTF-8 readable for Excel #41

pes-soft opened this issue Aug 24, 2015 · 2 comments
Milestone
0.9.4

Comments

@pes-soft
Copy link

When OpenCATS exports CSV file and content is in UTF-8, special characters are not properly imported to Excel, because Excel cannot identify that CSV file has UTF-8 encoding. By adding UTF-8 BOM to the beginning of the file, Excel will recognize this correctly.

I've been able to test it by adding echo chr(239) . chr(187) . chr(191) after headers within lib/DataGrid.php in function drawCSV.

For backward compatibility, this feature/fix could be also enabled/disabled by configuration variable.
@RussH RussH added this to the Future milestone Sep 4, 2015
@RussH
Copy link
Member

RussH commented Sep 4, 2015

Hi, do you have any recommended code you can contribute to rectify this?

wjcheers added a commit to wjcheers/OpenCATS that referenced this issue Sep 24, 2015
@wjcheers
Make CSV exports in UTF-8 readable for Excel opencats#41
0616b6c 
Insert UTF-8 BOM before CSV files
RussH added a commit that referenced this issue Sep 24, 2015
@RussH
Merge pull request #48 from wjcheers/master
680806d 
[FEATURE] Make CSV exports in UTF-8 readable for Excel #41
@RussH
Copy link
Member

RussH commented Dec 7, 2016

Resolved by commit 41 by @wjcheers

@RussH RussH closed this as completed Dec 7, 2016
@skrchnavy skrchnavy modified the milestones: 0.9.3-next, Future Dec 7, 2016
@RussH RussH mentioned this issue Jun 3, 2019
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
0.9.4
Development

No branches or pull requests
3 participants
@RussH @skrchnavy @pes-soft