topic Re: Export to CSV Attributes Shifted Fields in ArcGIS Viewer for Silverlight Questions

Export to CSV Attributes Shifted Fields

NicholasGross — Wed, 08 May 2013 18:49:45 GMT

[ATTACH=CONFIG]24138[/ATTACH] [ATTACH=CONFIG]24137[/ATTACH]

When using the Export Selection to CSV tool included with the Silverlight Viewer, the resulting data in the CSV file is being shifted into the wrong fields (see screenshots). The 'District Code' field (the field that should contain 'I-2', 'RS-1', etc) is a short integer subtype field, and I'm wondering if that is somehow causing the problem. Also note, 'Zone District' and 'Zone Subdistrict' have default values that are dependent on the subtype field. Has anyone else run into this problem? Am I doing something wrong?

Re: Export to CSV Attributes Shifted Fields

IanPeebles — Mon, 13 May 2013 20:31:31 GMT

I noticed this a few months ago. This is certainly a bug. Based on the tests I have done, NULL values give problems. There is no way we can guarantee not having NULL values. Hopefully this problem is fixed soon.

Re: Export to CSV Attributes Shifted Fields

Anonymous User — Wed, 15 May 2013 18:08:07 GMT

Original User: Bleroux

I too have run into this issue and it is the Null values as Ian has mentioned. I was able to work around this with my data by modifying my SQL that loads my tables to replace Nulls with some other value (0s or N/As).

Re: Export to CSV Attributes Shifted Fields

JosiahThoen — Wed, 15 May 2013 18:59:40 GMT

I went through the code and it appears that when an empty field value is found a comma is appended to the cvs header row instead of the current records row.

Here is the source code: https://bitbucket.org/jdtblt/arcgis-fixedexportselectioncommand
here is the addin: https://bitbucket.org/jdtblt/arcgis-fixedexportselectioncommand/downloads

Add like any other addin:
Tools.xml
add the namespace:

xmlns:FixedExportSelectionCommand="clr-namespace:FixedExportSelectionCommand.AddIns;assembly=FixedExportSelectionCommand.AddIns"

update the tool code:
[HTML]<Tool Label="Export Selection"
          Icon="Images/toolbar/ExportSelectionCommand16.png"
          Description="Export the attributes of selected features to a CSV file">
        <Tool.Class>
          <FixedExportSelectionCommand:ExportSelectionFixedCommand />
        </Tool.Class>
      </Tool>[/HTML]

Application.xml
Add the extension:

<Extension Url="Extensions/FixedExportSelectionCommand.AddIns.xap" />

Re: Export to CSV Attributes Shifted Fields

Anonymous User — Wed, 15 May 2013 19:13:21 GMT

Original User: Bleroux

Josiah- Out of curiosity, where did you get the source code for this? Also doesn't seem like you have anything to download but a readme file. Unless I am doing something worng.

Re: Export to CSV Attributes Shifted Fields

JosiahThoen — Fri, 17 May 2013 13:29:05 GMT

I extracted the dll's from viewer.xap file. Then used reflection to locate the ExportSelectionCommand code. I then created a new project and implement the original ExportSelectionFixedCommand object and overrode the Execute method with the fixed code. And then added the coded value domain lookup.

Re: Export to CSV Attributes Shifted Fields

Anonymous User — Wed, 22 May 2013 18:11:37 GMT

Original User: winsleav

Worked perfectly- thank you. I was trying to find a fix on my own. You just saved me a ton of time.

Re: Export to CSV Attributes Shifted Fields

StevePickens — Wed, 09 Oct 2013 13:58:55 GMT

Downloaded and used the code. Works great. Cannot go back to back exports more if desired. i.e. Select 10 features and export to CSV. Clear Selection and select 10 more features and export to CSV causes "Error saving file". The file gets created but with 0 size and is empty. This does not happen with in the original Export to CSV code. Tried changing selection to different layers between exports and it doesn't fix the issue.

Any ideas?

Steve

Re: Export to CSV Attributes Shifted Fields

Anonymous User — Fri, 11 Oct 2013 18:18:00 GMT

Original User: rzwaap

FYI, this bug is due to be fixed at the upcoming 3.2 release. Sorry for the inconvenience.

Re: Export to CSV Attributes Shifted Fields

RichZwaap — Sat, 07 Dec 2013 00:14:10 GMT

Version 3.2 has been released and includes a fix for this issue. You can download it from the Resource Center.