topic Re: eSearch export to csv format in ArcGIS Viewer for Flex Questions

eSearch export to csv format

JosephAccardi — Sat, 18 Aug 2012 20:05:13 GMT

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.).

Re: eSearch export to csv format

RobertScheitlin__GISP — Sun, 19 Aug 2012 11:22:19 GMT

Joseph,

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

Re: eSearch export to csv format

JosephAccardi — Mon, 20 Aug 2012 13:25:56 GMT

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.

Re: eSearch export to csv format

RobertScheitlin__GISP — Mon, 20 Aug 2012 13:28:22 GMT

Joseph,

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

Re: eSearch export to csv format

JosephAccardi — Mon, 20 Aug 2012 13:31:07 GMT

Sure, no problem Robert.

Re: eSearch export to csv format

RobertScheitlin__GISP — Mon, 20 Aug 2012 14:30:07 GMT

Joseph,

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

Re: eSearch export to csv format

JosephAccardi — Mon, 20 Aug 2012 14:37:17 GMT

See attached txt file. Thanks

Re: eSearch export to csv format

RobertScheitlin__GISP — Mon, 20 Aug 2012 15:11:15 GMT

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?

Re: eSearch export to csv format

JosephAccardi — Mon, 20 Aug 2012 15:38:31 GMT

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...

Re: eSearch export to csv format

JosephAccardi — Tue, 21 Aug 2012 14:55:18 GMT

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

Re: eSearch export to csv format

RobertScheitlin__GISP — Tue, 21 Aug 2012 15:08:55 GMT

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.