Select to view content in your preferred language

CSV Export Issue

2551
3
Jump to solution
04-05-2012 05:07 AM
BrianLeroux
Frequent Contributor
I have a particular layer where there are fileds that may not have a value. Viewing the table for this layer works fine. However, when attempting to export as a CSV the data does not output correctly. If a record has any fields with no value the data for that record is pushed to the columns to the right. For example if I have a table with 2 columns names ObjectID and CustomerNumber and the CustomerNumber is blank in one record, on export the ObjectID for that record would now be placed in the CustomerNumber field and the ObjectID field would be blank.

Is this a known issue and is there any resoulution besides making sure all fields have data?

Thanks!
0 Kudos
1 Solution

Accepted Solutions
KatherineDalton
Esri Regular Contributor
Hi Brian,

Unfortunately it is a bug. The Nimbus number is: NIM069739. At this point no workaround other than your suggestion to make sure every field has data.

Katy
Katy Dalton | Technical Consultant
THE SCIENCE OF WHERE™

View solution in original post

0 Kudos
3 Replies
KatherineDalton
Esri Regular Contributor
Hi Brian,

Unfortunately it is a bug. The Nimbus number is: NIM069739. At this point no workaround other than your suggestion to make sure every field has data.

Katy
Katy Dalton | Technical Consultant
THE SCIENCE OF WHERE™
0 Kudos
BrianLeroux
Frequent Contributor
Hi Brian,

Unfortunately it is a bug. The Nimbus number is: NIM069739. At this point no workaround other than your suggestion to make sure every field has data.

Katy


Oh well. Thanks for the info. Do you know how I would reference the table if I wanted to create my own export function?
0 Kudos
JosiahThoen
Emerging Contributor
I wrote a work around/ patch if interested.  See this thread: http://forums.arcgis.com/threads/84135-Export-to-CSV-Attributes-Shifted-Fields
0 Kudos