Forms with Chinese characters - I cannot export the results

  • Profile Image
    yvesfb
    Asked on January 13, 2012 at 04:57 AM

    Hi,

    I made a form for Chinese target audience (http://www.jotform.com/13473650635) and one reply has been posted.

    When I export the form in Excel or CSV, I don't receive all the information, only the heading line (that I can read when transforming the csv in txt files and opening it as a text file) without the raw of data.

    1°) Any idea about the configuration to receive a full Excel file or a full CSV file?

    2°) ANy idea about the coding character set to use (because the Excel and CSV files I can download don't display properly).

    I send you the exported files if needed.

    Best Regards

    yves

  • Profile Image
    fxr
    Answered on January 13, 2012 at 01:29 PM

    Hello yves,

    I have downloaded your submissions and they show fine in MS Excel Viewer. 

    I am not sure of exactly where the setting for this is in Excel, but can you confirm you have the Chinese Simplified Language installed for MS Office?

    This may be a way to do that: 

    You can click Start >Programs>Microsoft Office Tools>Language Settings>Click on Chinese Simplified

    Then Add it

     

    If you are asked about character encoding always select UTF-8.

     

    Can you let me know if any of those 2 suggestions help.


  • Profile Image
    yvesfb
    Answered on January 13, 2012 at 03:16 PM

    Hi,

    thank you for your feedback and support.

    I found the problem: it comes from the Excel version that I am using: EXCEL MAC 2011 (latest update). I tried under the emulated windows environment and Excel 2010 for windows (latest update as well under parallel desktop emulation), then I have the same result as you have. It works fine.

    So the file can not be properly read under Ecxel 2011 for MAC (even after having imported and saved it under windows). I also tried to use the CSV version and import it into excel using all the proposed Chinese encoding by Excel MAC, but it was not succcessful.

    So if I want to work on the data, then I will do it via the windows emulation. I don't know if you may have a possibility to report that to Microsoft, but it would be nicer to use the whole process without being obliged to switch between environments (or then we may simply use Apple's office tools without microsfot office for MAC).

    Remark: I just also open the generated report in excel format with the Apple Numbers application (the calc application of iWorks by Apple), and it works fine in the MAC environment.

    Best Regards

    yves

  • Profile Image
    fxr
    Answered on January 13, 2012 at 03:26 PM

    I did a quick search on this issue of MS Office on MAC and it seems recurring and common problem. 

    Have a read of this -> http://www.yale.edu/chinesemac/pages/applications.html maybe something in there may help. 

    Personally, I prefer Open Office, a free alternative to MS Office as I find niggly little issues like the one you are suffering from less commonplace. 

    best,

  • Profile Image
    yvesfb
    Answered on January 13, 2012 at 03:43 PM

    I agree with you about Open Office. :-)

    and thank you for your link about the Chinese language on MAC and office software packages.

     

    best,