Tuesday, 10 September 2013

Excel-Friendly CSV Files

Xataface has supported CSV export since the beginning, but I have recently been made aware that the CSV files that Xataface produces haven't been "MS Excel" friendly when it comes to UTF-8 special characters.  You may have noticed that if you export a data set as CSV from Xataface where some records include special characters (like é and å), and try to open it with MS Excel, the characters become garbled.  These CSV files work fine with Open Office, Google Docs, and pretty much every other spreadsheet program out there.  It's just that MS Excel doesn't seem to support UTF-8 encoded CSV files.

(Note: You can still import them into Excel using its import features, where you can specify the encoding explicitly, but if you try to simply open the CSV file with Excel, it will assume that the encoding is Mac Roman or Windows 1252 depending on whether you're on Mac or Windows).

Many solutions were tried to try to make these CSV files work nicely with Excel, but it seems that Excel simply can't handle UTF-8!

Today I implemented an experimental feature in Xataface to be able to export data to CSV that Excel can handle.  It works by using UTF-16 encoding instead of UTF-8 as well as some other settings specifically designed to cater to Excel (e.g. tab delimiter instead of commas, and a different mimetype).

You can enable this feature by adding the following to your application's conf.ini file:


[export_csv]
    format=excel

Then you can just use the export CSV action as normal (e.g. from list view click "Export" > "CSV" if using the g2 theme, or click the "Export CSV" icon in the upper right of the list view if using the default theme).

This change is currently in the master repository on GitHub and will be included in the 2.0.3 release.

4 comments:

  1. Replies
    1. GET BACK YOUR EX FAST, SAVE YOUR MARRIAGE FROM DIVORCE AND AMEND YOUR BROKEN RELATIONSHIP WITH THE HELP OF DR GREAT CALL OR WHATSAPP +2348118829899

      Hello everyone i am happy to spread my testimony of a strong spell caster called Dr Great. I'm Kaitlyn Houston and i live in USA, my husband and i had a little fight because of that he wanted to divorce me i was so afraid to lose him because i love him very much so i search online for help and i saw a lot of people's testimonies on how Dr Great help them and came out with positive results like Divorces, Cancers, lotteries, fertilities and others. So i emailed him and told him my problem and he told me what to do and I did it as he instructed, 24 hours later he told me he is done with the spell and my husband will no longer divorce me and when my husband came back from work he told me he won't divorce me anymore he said he didn't know what came over him that he is sorry I was so happy and I thank Dr Great for his help If you need Dr Great help email him at infinitylovespell@gmail.com or infinitylovespell@yahoo.com view his blog http://infinitylovespell1.blogspot.com my page https://kaitlynhouston19.blogspot.com you can also add him on WhatsApp +2348118829899 and he will put an end to your problem 







      GET BACK YOUR EX FAST, SAVE YOUR MARRIAGE FROM DIVORCE AND AMEND YOUR BROKEN RELATIONSHIP WITH THE HELP OF DR GREAT CALL OR WHATSAPP +2348118829899

      Hello everyone i am happy to spread my testimony of a strong spell caster called Dr Great. I'm Kaitlyn Houston and i live in USA, my husband and i had a little fight because of that he wanted to divorce me i was so afraid to lose him because i love him very much so i search online for help and i saw a lot of people's testimonies on how Dr Great help them and came out with positive results like Divorces, Cancers, lotteries, fertilities and others. So i emailed him and told him my problem and he told me what to do and I did it as he instructed, 24 hours later he told me he is done with the spell and my husband will no longer divorce me and when my husband came back from work he told me he won't divorce me anymore he said he didn't know what came over him that he is sorry I was so happy and I thank Dr Great for his help If you need Dr Great help email him at infinitylovespell@gmail.com or infinitylovespell@yahoo.com view his blog http://infinitylovespell1.blogspot.com my page https://kaitlynhouston19.blogspot.com you can also add him on WhatsApp +2348118829899 and he will put an end to your problem 







      GET BACK YOUR EX FAST, SAVE YOUR MARRIAGE FROM DIVORCE AND AMEND YOUR BROKEN RELATIONSHIP WITH THE HELP OF DR GREAT CALL OR WHATSAPP +2348118829899

      Hello everyone i am happy to spread my testimony of a strong spell caster called Dr Great. I'm Kaitlyn Houston and i live in USA, my husband and i had a little fight because of that he wanted to divorce me i was so afraid to lose him because i love him very much so i search online for help and i saw a lot of people's testimonies on how Dr Great help them and came out with positive results like Divorces, Cancers, lotteries, fertilities and others. So i emailed him and told him my problem and he told me what to do and I did it as he instructed, 24 hours later he told me he is done with the spell and my husband will no longer divorce me and when my husband came back from work he told me he won't divorce me anymore he said he didn't know what came over him that he is sorry I was so happy and I thank Dr Great for his help If you need Dr Great help email him at infinitylovespell@gmail.com or infinitylovespell@yahoo.com view his blog http://infinitylovespell1.blogspot.com my page https://kaitlynhouston19.blogspot.com you can also add him on WhatsApp +2348118829899 and he will put an end to your problem 

      Delete
  2. If you want your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (no matter why you broke up) you got to watch this video
    right away...

    (VIDEO) Why your ex will NEVER come back...

    ReplyDelete
  3. Replik Moncler Jacken, das eleganten Stil und modernste Technologie kombiniert, eine Vielzahl von Stilen von günstig moncler kinder weste, der Zeiger bewegt sich zwischen Ihrem exklusiven Geschmacksstil.

    ReplyDelete