Issue with content display in .csv file

  • Profile Image
    stonehillcollege
    Asked on February 15, 2012 at 10:44 AM

    When submitting a form and then downloading the .csv file the characters are displaying oddly.

    For example quotation marks(") are displaying as “ is there a way to fix that?

  • Profile Image
    serkan
    Answered on February 15, 2012 at 03:17 PM

    Since we are having domain issues. I'll not be able to help you right now. I've tagged this question and get back to you soon.

    Thank you for your patience.

  • Profile Image
    stonehillcollege
    Answered on February 15, 2012 at 04:19 PM

    Thanks I appreciate that and I understand.

  • Profile Image
    Mike_T
    Answered on February 15, 2012 at 04:36 PM

    Thank you very much for your understanding in this matter.

    We will update this thread as soon as we can.

  • Profile Image
    stonehillcollege
    Answered on February 17, 2012 at 08:40 AM

    I was wondering if there is any chance you could respond this morning? I have to meet with a client and this is a great frustration for them.

     

     

  • Profile Image
    fxr
    Answered on February 17, 2012 at 08:53 AM

    The developers are probably sleeping off a heavy few days of work, and unfortunately they will have an even further increased workload to come back to. 

    Its unlikely they are going to get to this issue today. 

    I am sorry about and hopw you can try to understand. 

    --

    We are happy to explore finding workaround though, is there any particular form that you need the CSV export for?

  • Profile Image
    stonehillcollege
    Answered on February 17, 2012 at 09:09 AM

    Well the form is http://www.jotform.net/csv/20332658461 We are supposed to launch this to all faculty this afternoon so that they can get all the information in so that they can send out our faculty focus magazine on time.

  • Profile Image
    fxr
    Answered on February 17, 2012 at 09:15 AM

    I have had a look at the CSV file, and dont see much of an issue with it. 

    It contains 4 submissions? with one from the 2012-02-15 19:49:26, I assume being a test.

    What are you trying to open the file with?

    Do can you provide a screenshot of what you are looking at, please?

    --

    This is what I see when opened in notepad: 

  • Profile Image
    stonehillcollege
    Answered on February 17, 2012 at 09:17 AM

    As you can see this is how it is coming through. I highlighted some examples below.

    “Zen Ethics: Idealized Representations and Historical Stancesâ€; University of Heidelberg; June 18, 2010.

    “Imperialist Zen: Causes and Lingering Issuesâ€; University of Heidelberg; June, 17, 2010.

    “The Religious Approach of Shin’ichi Hisamatsuâ€; Zen Centrum Amsterdam; June 8, 2010.

    “Buddhist Ethics in Light of Imperial-Way Zenâ€; VU University, Amsterdam; June 7, 2010. 

    “Imperial-Way Zen: Continuing Debates about its Causes and the Nature of Bu

  • Profile Image
    stonehillcollege
    Answered on February 17, 2012 at 09:18 AM

    I am opening the file with excel after downloading the .csv file

  • Profile Image
    fxr
    Answered on February 17, 2012 at 09:21 AM

    I dont see this issue on the csv file itself. 

     

    It must be something to do with your import settings into Excel. 

    I will have a look at that, but first I have to ask is there any reason why you are not just generating an Excel report rather than CSV report? 

  • Profile Image
    stonehillcollege
    Answered on February 17, 2012 at 09:24 AM
  • Profile Image
    stonehillcollege
    Answered on February 17, 2012 at 09:25 AM

    Because you can only have 255 characters as far as I know with excel.

  • Profile Image
    stonehillcollege
    Answered on February 17, 2012 at 09:29 AM

    Are you using excel to open up the .csv?

  • Profile Image
    fxr
    Answered on February 17, 2012 at 10:06 AM

    I have done now. 

    Its the character encoding in Excel that is causing this. 

    You need to open the CSV in Excel as UTF-8. 

    It appears the only way you can do this is by importing the CSV as UTF-8. 

    This is very easily done in Open Office. 

    But I cant quite get the right settings in Excel for your file. 

  • Profile Image
    stonehillcollege
    Answered on February 17, 2012 at 10:45 AM

    Thanks so much. I really appreciate your help with this.

  • Profile Image
    fxr
    Answered on February 17, 2012 at 11:11 AM

    I cant for the life of me work out the Excel settings.

    --

    But I have a solution for you. 

    Generate a HTML table report, this will give you a URL much like the CSV one, then import that into Excel. 

     

    I dont know what version of Excel you use, but in Excel 2010, you can import data directly from a URL. 

    Its arguably a more elegant solution than downloading an CSV file, then opening it in Excel. 

    I have tested this and it does work well.