topic Missing table column in an uploaded data table in ArcGIS Collector Questions

Missing table column in an uploaded data table

StahlyEngineering — Fri, 01 Jul 2016 20:45:12 GMT

When uploading a table as part of a feature service one of the table columns is missing and values are shifted into the wrong column. I am attempting to upload a layer with a related table (1:many relationship, based on this blog: Related Tables – Exploring New Ways to use Collector for ArcGIS | ArcGIS Blog ). The uploaded result is a faulty table and the layer does not display its related content.

The table has the following structure in its correct offline form:

PARCELID LINK DOCUMENT TYPE

9001 >linky name

9002 >linky1 name1

Once uploaded the table looks as such:

PARCELID LINK DOCUMENT TYPE

>linky name

>linky1 name1

Re: Missing table column in an uploaded data table

DanPatterson_Retired — Sat, 02 Jul 2016 19:59:57 GMT

did you link parcel id to parcel id ? or link to link? you didn't specify

Re: Missing table column in an uploaded data table

StahlyEngineering — Tue, 05 Jul 2016 15:48:34 GMT

parcel id to parcel id.

The problem with the table also occurred when I uploaded it to a service without the relate.

Re: Missing table column in an uploaded data table

RandyBurton — Tue, 05 Jul 2016 19:26:57 GMT

Do your field names contain reserved words or spaces? See: FAQ: What characters should not be used in ArcGIS for field names and table names? and FAQ: What are the reserved words for Esri's file geodatabase?

Re: Missing table column in an uploaded data table

StahlyEngineering — Wed, 06 Jul 2016 22:38:34 GMT

Changed "DOCUMNENT TYPE" to "DOCTYPE" just to be sure and the problem persists.

I'm thinking this is a bug with how the publishing process works for standalone data tables.

Re: Missing table column in an uploaded data table

RandyBurton — Thu, 07 Jul 2016 21:09:27 GMT

My next suggestion would be to look at the JSON file and check if the field definitions carried across correctly. For example, is the link field remaining a long/integer or is it becoming text? What type is the doctype field; text or other?

Re: Missing table column in an uploaded data table

StahlyEngineering — Thu, 07 Jul 2016 22:40:40 GMT

The linked field, a string is remaining a string. Opening the JSON file associated with the uploaded file reveals that all the components in the table are alive and healthy.