eSearch export to csv format

JosephAccardi · ‎08-18-2012

Robert, I'm using your eSearch widget which is a great tool. I'm having some issues when I export out tables with cells that have long text strings (300-400 characters). The table that is exported has 5 fields, but whenever I do an export and open the csv file I notice that parts of the text in 3 of the fields are extracted and placed in a 6th field. Have you ever come across this? I can't find any direct correlation (i.e. after commas, after the 255th character, etc.).

RobertScheitlin__GISP · ‎08-21-2012

Joe,

Well that make a lot of scene now... When it come to a CSV fields are separated by a comma and if the text in that field contains a comma than the field value has to be wrapped in double quotes to signify that commas inside the double quotes need to be ignored but the introduction of a double quote inside the text throws all this off.

Be sure to mark your post as answered.

View solution in original post

RobertScheitlin__GISP · ‎08-19-2012

Joseph,

So please attach one of the exports with the issue for me to look at.

JosephAccardi · ‎08-20-2012

Thanks Robert. Like I said, the csv export generated an additional column and populated it with text from 3 other columns. I attached the export called "Selected Records.csv" and the way it should look called "Correct Format.xls". Thanks for your help.

RobertScheitlin__GISP · ‎08-20-2012

Joseph,

I would like to have the csv file that is originally produced.

JosephAccardi · ‎08-20-2012

Sure, no problem Robert.

RobertScheitlin__GISP · ‎08-20-2012

Joseph,

Can you export it out as tab delimited and attach that as well?

JosephAccardi · ‎08-20-2012

See attached txt file. Thanks

RobertScheitlin__GISP · ‎08-20-2012

Joseph,

So the tab delimited looks correct so it has something to do with the CSV format... Which datagrid are you exporting from the fixed or float? Does the data look correct in the datagrid before export?

JosephAccardi · ‎08-20-2012

I'm using the float datagrid. The results in the datagrid table look perfect. I attached the section of my XML code that pertains to the datagrid and a snapshot of what the datagrid looks like before I export it...

JosephAccardi · ‎08-21-2012

Robert, I removed the " character from my cells and replaced it with the word 'inch' and everything works now. Not sure why this was whacking it out, but I'm good on my end. As always thanks for all your help.

Joe