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.

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

Export encoding #24

Closed
tibee opened this issue Apr 25, 2014 · 2 comments
Closed

Export encoding #24

tibee opened this issue Apr 25, 2014 · 2 comments
Labels

Comments

@tibee
Copy link
Contributor

tibee commented Apr 25, 2014

It would be nice to support character encoding of the exported files.
For example. due to Excel's limitation, if I have accented characters in my utf-8 encoded darabase, like 'árvíztűrő tükörfúrógép', I need to convert it to iso-8859-2, to appear in Excel correctly. When opening utf-8 file, the accented characters break.

It occurs as CSV and as Excel too, so I would need to configure it to convert the rows to iso-8859-2 before export.

@kartik-v
Copy link
Owner

@tibee could you submit a PR for this?

@monghuz
Copy link
Contributor

monghuz commented Jul 10, 2014

@tibee:
I use the following steps to get the correct encodeing.

  1. Export grid as CSV
  2. Open an empty sheet in excel
  3. On the Data tab, in the Get External Data group, click From Text.
  4. Choose the exported *.csvfile
  5. Select Tabbed and choose _60051 Uniform (UTF-8)_ encodeing on the opening window
  6. After next select coma as delimiter
  7. Finish
  8. Enjoy the well formated characters 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants