topic More records ArcGIS.com than in original .csv file after upload and geocoding in ArcGIS Online Questions

More records ArcGIS.com than in original .csv file after upload and geocoding

JasonMenard — Thu, 30 Jun 2016 20:39:31 GMT

When we upload a 30-row .csv file to ArcGIS.com to create a hosted feature layer, and then geocode the addresses therein, what happens is that the file will apear correctly in ArcGIS.com, but the 30 records will suddenly become 369 records. Each site is repeated about 11 times. We did not experience this behavior before the June update. What could be happening? The "offending" .csv is attached. It does work if you leave off the Description column, but that sort of defeats the purpose. Running it up as a tab-delimited yields the same issue. Thanks for any ideas.

Re: More records ArcGIS.com than in original .csv file after upload and geocoding

KellyGerrow — Fri, 08 Jul 2016 00:17:33 GMT

Hi Jason,

Can you log this issue with technical support?

-Kelly

Re: More records ArcGIS.com than in original .csv file after upload and geocoding

JasonMenard — Fri, 08 Jul 2016 00:34:46 GMT

Hi Kelly, I did yesterday. Case #01800873. Thanks. -jason

Jason Menard, Ph.D | Geospatial Instructional Technologist

St Olaf College | Information Technology

464 Rølvaag Memorial Library

1510 St Olaf Avenue

Northfield, Minnesota 55057

jcm@stolaf.edu + 507-786-3731 (office) + http://wp.stolaf.edu/it/

*Please consider your environmental responsibility before printing this

email.*

Re: More records ArcGIS.com than in original .csv file after upload and geocoding

BruceGodfrey — Tue, 25 Oct 2016 19:24:23 GMT

I was wondering if you resolved this issue. I am having similar issues. Thanks, -Bruce

Re: More records ArcGIS.com than in original .csv file after upload and geocoding

KellyGerrow — Tue, 25 Oct 2016 20:36:46 GMT

Hi Bruce,

Jason ran into an issue with how his table was structured. you can read more about the specific bug at this link:

BUG-000097921: In ArcGIS Online, publishing a CSV file as a feature..

The particular issue was related to how the spreadsheet was structured. When creating a service out of a csv file, ArcGIS online determines the field length based on the first 10 records. Some entries exceeded the initial field length further down in the csv, causing the duplication. This bug is being worked on by the team.

If this sounds similar to your data, try adding the longest values as the first records in your spreadsheet. If it seems unrelated, contact support so that they can help look at your data.

-Kelly

Re: More records ArcGIS.com than in original .csv file after upload and geocoding

BruceGodfrey — Tue, 25 Oct 2016 22:42:22 GMT

I was able to resolve my issue based on the information you provided. Thank you. Hopefully the bug will be resolved in the not too distant future.

-Bruce