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.

12 comments:

  1. Replies
    1. Five weeks ago my boyfriend broke up with me. It all started when i went to summer camp i was trying to contact him but it was not going through. So when I came back from camp I saw him with a young lady kissing in his bed room, I was frustrated and it gave me a sleepless night. I thought he will come back to apologies but he didn't come for almost three week i was really hurt but i thank Dr.Azuka for all he did i met Dr.Azuka during my search at the internet i decided to contact him on his email dr.azukasolutionhome@gmail.com he brought my boyfriend back to me just within 48 hours i am really happy. What’s app contact : +44 7520 636249‬

      Delete
    2. AM SANDRA FROM UNITED KINGDOM, THANKS TO DR ONIHA WHO HELP ME BRING MY HUSBAND BACK, MY HUSBAND LEFT ME WITH THREE KIDS, FOR ANOTHER YOUNG GIRL, FOR OVER TWO YEARS, I TRIED ALL I COULD TO SETTLED OUR DIFFRENCES, BUT IT YIELDED NO RESULT, I WAS THE ONE TAKING CARE OF THE CHILDREN ALONE, UNTIL ONE DAY, I CAME IN CONTACT WITH SOME ARTICLES ONLINE, CONTAINING HOW DR ONIHA HAS HELP SO MANY LOVERS AND FAMILY REUNION AND REUNIT AGAIN, AND I DECIDED TO CONTACT HIM, AND HE CAST HIS SPELL ON MY HUSBAND, WITHIN FIVE DAYS, MY HUSBAND RAN BACK HOME, AND WAS BEGGING ME AND THE KIDS FOR FORGIVENESS, IN CASE YOU ARE PASSING THROUGH SIMILAR PROBLEMS, AND YOU WANTS TO CONTACT DR ONIHA, YOU CAN REACH HIM VIA HIS CONTACT NUMBER, ON CALL OR WHATSAP +2347089275769 OR EMAIL DRONIHASPELL@YAHOO.COM

      Delete
    3. BEST WAY TO GET YOUR EX LOVER BACK REUNITE TOGETHER CONTACT LORD ZULU DIRECTLY ON WHATSAPP +19097814612
      How to get your ex back fast! I was hurt and heart broken when a very big problem occurred in my marriage seven months ago, between me and my husband . so terrible that he took the case to court for a divorce. he said that he never wanted to stay with me again, and that he didn't love me anymore. So he packed out of the house and made me and my children pass through severe pain. I tried all my possible means to get him back, after much begging, but all to no avail. and he confirmed that he had made his decision, and he never wanted to see me again. So one evening, as I was coming back from work, I met an old friend of mine who asked my husband .So I explained everything to him, so he told me that the only way I can get my husband back is to visit a priest, because it has really worked for him too. So I never believed in spells, but I had no other choice, than to follow his advice. Then he gave me the Email address of the priest whom he visited. So the next morning, I sent a letter to the address he gave to me, and the priest assured me that I will get my husband back the next day. What an amazing statement!! I never believed, so he spoke with me, and told me everything that I needed to do. Then the next morning, So surprisingly, my husband who didn't call me for the past 7 months, gave me a call to inform me that he was coming back. So Amazing!! So that was how he came back that same day, with lots of love and joy, and he apologized for his mistake, and for the pain he caused me and my children. Then from that day, our relationship was now stronger than how it was before, by the help of a priest. So, I will advise you out there if you have any problem contact LORD ZULU, I give you 100% guarantee that he will help you.. or WhatsApp him on +1(909)7814612
      call: + 1(213) 538-2469
      EMAIL: Allsupremepowersolutionhome@gmail.com
      WEBSITE; allsupremepowersolutionhom.website2.me


      BEST WAY TO GET YOUR EX LOVER BACK REUNITE TOGETHER CONTACT LORD ZULU DIRECTLY ON WHATSAPP +19097814612
      How to get your ex back fast! I was hurt and heart broken when a very big problem occurred in my marriage seven months ago, between me and my husband . so terrible that he took the case to court for a divorce. he said that he never wanted to stay with me again, and that he didn't love me anymore. So he packed out of the house and made me and my children pass through severe pain. I tried all my possible means to get him back, after much begging, but all to no avail. and he confirmed that he had made his decision, and he never wanted to see me again. So one evening, as I was coming back from work, I met an old friend of mine who asked my husband .So I explained everything to him, so he told me that the only way I can get my husband back is to visit a priest, because it has really worked for him too. So I never believed in spells, but I had no other choice, than to follow his advice. Then he gave me the Email address of the priest whom he visited. So the next morning, I sent a letter to the address he gave to me, and the priest assured me that I will get my husband back the next day. What an amazing statement!! I never believed, so he spoke with me, and told me everything that I needed to do. Then the next morning, So surprisingly, my husband who didn't call me for the past 7 months, gave me a call to inform me that he was coming back. So Amazing!! So that was how he came back that same day, with lots of love and joy, and he apologized for his mistake, and for the pain he caused me and my children. Then from that day, our relationship was now stronger than how it was before, by the help of a priest. So, I will advise you out there if you have any problem contact LORD ZULU, I give you 100% guarantee that he will help you.. or WhatsApp him on +1(909)7814612
      call: + 1(213) 538-2469
      EMAIL: Allsupremepowersolutionhome@gmail.com
      WEBSITE; allsupremepowersolutionhom.website2.me

      Delete
  2. I was searching for help on the internet to get my ex husband back after he divorced me 5 months ago, i came across so many testimonies from different people and they are all talking about this wonderful man called Doctor ODIBOH DADA on how he help them to save their marriage and relationships and i also contact him on his email (odibohsolutionhome@gmail.com) and explain my problem to him and he did a nice job by helping me to get my divorced husband back within 3 days and later on i got pregnant for him, for we have been married for 6 years no pregnancy .. I never believe that such things like this can be possible but now i am a living testimony to it because Doctor ODIBOH DADA actually brought my lover back and also help me got pregnant, If you are having any relationship problems or any problem concerning life itself why not contact Doctor ODIBOH DADA for help via his email: odibohsolutionhome@gmail.com or whatsapp +2347048883838. Then i promise you that after all said and done you will have reasons to celebrate just like me.

    ReplyDelete
  3. I really want to thank Dr Emu for saving my marriage. My wife really treated me badly and left home for almost 3 month this got me sick and confused. Then I told my friend about how my wife has changed towards me then she told me to contact Dr Emu that he will help me bring back my wife and change her back to a good woman. I never believed in all this but I gave it a try. Dr Emu casted a spell of return of love on her, and my wife came back home for forgiveness and today we are happy again. If you are going through any relationship stress or you want back your Ex or Divorce husband you can contact his whatsapp +2347012841542 or email emutemple@gmail.com 

    ReplyDelete

  4. Am here to testify what this great spell caster done for me. i never believe in spell casting, until when i was was tempted to try it. i and my wife have been having a lot of problem living together, she will always not make me happy because she have fallen in love with another man outside our relationship, i tried my best to make sure that my wife leave this woman but the more i talk to her the more she makes me fell sad, so my marriage is now leading to divorce because she no longer gives me attention. so with all this pain and agony, i decided to contact this spell caster to see if things can work out between me and my wife again. this spell caster who was a man told me that my wife is really under a great spell that she have been charm by some magic, so he told me that he was going to make all things normal back. he did the spell on my wife and after 5 days my wife changed completely she even apologize with the way she treated me that she was not her self, i really thank this man his name is Dr ose he have bring back my wife back to me i want you all to contact him who are having any problem related to marriage issue and relationship problem he will solve it for you. his email is oseremenspelltemple@gmail.com he is a man and his great. wish you good time.
    He cast spells for different purposes like
    (1) If you want your ex back.
    (2) if you always have bad dream
    (3) You want to be promoted in your office.
    (4) You want women/men to run after you.
    (5) If you want a child.
    (6) You want to be rich.
    (7) You want to tie your husband/wife to be yours forever.
    (8) If you need financial assistance.
    (9) HIV/AIDS CURE
    (10) is the only answer to that your problem of winning the lottery

    Contact him today on oseremenspelltemple@gmail.com or whatsapp him on +2348136482342

    ReplyDelete
  5. Five weeks ago my boyfriend broke up with me. It all started when i went to summer camp i was trying to contact him but it was not going through. So when I came back from camp I saw him with a young lady kissing in his bed room, I was frustrated and it gave me a sleepless night. I thought he will come back to apologies but he didn't come for almost three week i was really hurt but i thank Dr.Azuka for all he did i met Dr.Azuka during my search at the internet i decided to contact him on his email dr.azukasolutionhome@gmail.com he brought my boyfriend back to me just within 48 hours i am really happy. What’s app contact : +44 7520 636249‬

    ReplyDelete
  6. I was married for 16 years to a loving mother and wife. We had 2 children together who are now 11 & 13. I reconnected with an old girlfriend from college on Facebook and we began an affair and I left my wife. The woman I had an affair with is a wonderful woman and I love her too and our kids had begun accepting the situation and my wife has kind of moved on, but not in love with the man she is seeing. I thought I fell out of love with my wife and I felt terrible about what I did to her - she is a good woman and I don't know what came over me. I decided to try and get her back and I was recommended to Lord Zakuza for help to get reunited with my wife and within 48 hours after I made contact with Lord Zakuza my wife decided to work things out with me and now we are back together with our children living as one happy family. I really don't know the words to use in appreciation of what Lord Zakuza did for me but I will say thank you sir for reuniting I and my family back. For those in trying times with their marriages or relationship can browse through his website via: lordzakuzaspells.com or WhatsApp Lord Zakuza for help or text with this number +1 740 573 9483 or you can send him an email to Lordzakuza7@gmail.com

    ReplyDelete
  7. Good day to you, here is a quick one, just in case you are desperately in need of a trustworthy spell caster to help revive your crumbled relationship. Here is one that is truly versatile, compassionate and reliable when it comes to spell casting.. Doctor Abolo spelling home is the right choice for you. Contact and explain to him and I can assure you that the rest would be complete magic, my love life was on the verge of collapse until I ordered for a love spell while all due procedures were properly followed, I am a living witness that Doctor Abolo spell magic does work that is why i'm using all medium to let the world know of this great witch doctor who brought back peace and unity to my home, Talk to him today and have your emotional setbacks wiped out totally.
    You reach him at these contacts! Abolospell@gmail.com

    ReplyDelete
  8. I was having issues in my marriage because my husband wants a divorce but I was able to get him to cancel the divorce with the help of a spiritual man called PRIEST OSAS and now we are living in peace. If you are facing any kind of problem in life and want a lasting solution, PRIEST OSAS is the right man for the job. I'm a living testimony of his great power. He also prepares herbs for any kind of sickness you know about, he works wonders and miracles, I thank my stars I reached out to him for help
    CONTACT HIM: +14193594367


    I was having issues in my marriage because my husband wants a divorce but I was able to get him to cancel the divorce with the help of a spiritual man called PRIEST OSAS and now we are living in peace. If you are facing any kind of problem in life and want a lasting solution, PRIEST OSAS is the right man for the job. I'm a living testimony of his great power. He also prepares herbs for any kind of sickness you know about, he works wonders and miracles, I thank my stars I reached out to him for help
    CONTACT HIM: +14193594367



    I was having issues in my marriage because my husband wants a divorce but I was able to get him to cancel the divorce with the help of a spiritual man called PRIEST OSAS and now we are living in peace. If you are facing any kind of problem in life and want a lasting solution, PRIEST OSAS is the right man for the job. I'm a living testimony of his great power. He also prepares herbs for any kind of sickness you know about, he works wonders and miracles, I thank my stars I reached out to him for help
    CONTACT HIM: +14193594367

    ReplyDelete
  9. BEST WAY TO GET YOUR EX LOVER BACK REUNITE TOGETHER CONTACT LORD ZULU DIRECTLY ON WHATSAPP +19097814612
    How to get your ex back fast! I was hurt and heart broken when a very big problem occurred in my marriage seven months ago, between me and my husband . so terrible that he took the case to court for a divorce. he said that he never wanted to stay with me again, and that he didn't love me anymore. So he packed out of the house and made me and my children pass through severe pain. I tried all my possible means to get him back, after much begging, but all to no avail. and he confirmed that he had made his decision, and he never wanted to see me again. So one evening, as I was coming back from work, I met an old friend of mine who asked my husband .So I explained everything to him, so he told me that the only way I can get my husband back is to visit a priest, because it has really worked for him too. So I never believed in spells, but I had no other choice, than to follow his advice. Then he gave me the Email address of the priest whom he visited. So the next morning, I sent a letter to the address he gave to me, and the priest assured me that I will get my husband back the next day. What an amazing statement!! I never believed, so he spoke with me, and told me everything that I needed to do. Then the next morning, So surprisingly, my husband who didn't call me for the past 7 months, gave me a call to inform me that he was coming back. So Amazing!! So that was how he came back that same day, with lots of love and joy, and he apologized for his mistake, and for the pain he caused me and my children. Then from that day, our relationship was now stronger than how it was before, by the help of a priest. So, I will advise you out there if you have any problem contact LORD ZULU, I give you 100% guarantee that he will help you.. or WhatsApp him on +1(909)7814612
    call: + 1(213) 538-2469
    EMAIL: Allsupremepowersolutionhome@gmail.com
    WEBSITE; allsupremepowersolutionhom.website2.me

    ReplyDelete