- stonehillcollegeAsked 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?
- serkanAnswered 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.
- stonehillcollegeAnswered on February 15, 2012 at 04:19 PM
Thanks I appreciate that and I understand.
- JotForm SupportMike_TAnswered 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.
- stonehillcollegeAnswered 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.
- fxrAnswered 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?
- stonehillcollegeAnswered 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.
- fxrAnswered 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:
- stonehillcollegeAnswered 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
- stonehillcollegeAnswered on February 17, 2012 at 09:18 AM
I am opening the file with excel after downloading the .csv file
- fxrAnswered 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?
- stonehillcollegeAnswered on February 17, 2012 at 09:24 AM
- stonehillcollegeAnswered on February 17, 2012 at 09:25 AM
Because you can only have 255 characters as far as I know with excel.
- stonehillcollegeAnswered on February 17, 2012 at 09:29 AM
Are you using excel to open up the .csv?
- fxrAnswered 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.
- stonehillcollegeAnswered on February 17, 2012 at 10:45 AM
Thanks so much. I really appreciate your help with this.
- fxrAnswered 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.