Dealing with data (Pulldata) on related tables

Siew_WeiGoh2 · ‎11-23-2017

Hi,

I am seeking advice or ideas on how to deal with dataset from asset that has multiple entries under the same field attribute. For example, in one particular bridge, it contains 3 parts in span material and structure. I am not sure what is the best way to display each of these information on Survey123 (prepopulate fields) given that they have the same fieldname. These data would be stored as related tables from the source database.

FIELD_ATTRIBUTE	A1	A2 (start km)	A3 (end km)
STATUS_OF_BRIDGE	INSERVICE - MAINTAINED	169.61	169.742
SPANTYPEMATERIAL	BMS	169.61	169.677
SPANTYPEMATERIAL	STEEL	169.677	169.695
SPANTYPEMATERIAL	BMS	169.695	169.742
SPANTYPESTRUCTURE	ARCH	169.61	169.677
SPANTYPESTRUCTURE	INVERTEDTRUSS	169.677	169.695
SPANTYPESTRUCTURE	ARCH	169.695	169.742

I could rename these fields by adding numbers to the end to make the repeats unique, but that would placed them at separate columns, instead of writing back to the same field attribute/column.

Any suggestions will be appreciated.

Regards

SW

IsmaelChivite · ‎11-24-2017

Hi. It looks like a repeat may be a good way to model this. I am guessing something like this:

type	name	label
select_one status	status_of_bridge	Status of Bridge
begin_repeat	span_types	Span Types
decimal	span_start	Start (Km)
decimal	span_end	End (Km)
select_one material	span_material	Material
select_one structure	span_structure	Structure
end_repeat

All questions above the repeat block will be stored in a feature layer. Questions within the repeat will be stored in a related table called span_types.

If you already have all your bridge data loaded into a feature service, you may want to create a new survey from your feature layer. This will create a new XLSForm for you as described in https://community.esri.com/groups/survey123/blog/2017/09/25/working-with-existing-feature-services-i...

Siew_WeiGoh2 · ‎12-02-2017

Hi Ismael,

Thank you. I have tried to get the repeats stored in a relate table to work but am having major blockage. Mainly because I could not work out how to get the relationship to be based on GlobalID field:

I do not have ArcServer, only ArcDesktop & AGOL. When I create a GUID type field in the Table, it is empty. I have no way of linking the GUID type field to the GlobalID of the primary layer. The only way I know how to populate the table is done externally through using Excel. But this set the field as String rather than GUID type field. Once I import the table back into the GDB, and create a new GUID type field, I am unable to force populate the new GUID field from the corresponding String field. Therefore, the GUID type field remains empty for existing entries.

Will really appreciate any advice and suggestions on how I can establish a working repeat on survey123 given the my difficulties explained above.

Thank you

Siew Wei

JamesTedrick · ‎12-04-2017

Hi SW,

Probably the easiest path is to create the survey with the repeat relationships and then publish the new feature class in ArcGIS Online. That will get you an empty set of tables properly formatted that you can then fill in with existing data. To fill in, you can either edit the feature class in ArcGIS Desktop (ArcGIS Pro is a bit better than ArcMap for this, as it can edit directly, rather than require the local copy download) or download a FGDB export of the Feature Layer, add the data to the FGDB in Desktop, and then republish the FGDB as a new set of feature layers in AGOL (and then modify the survey to use a submission_url setting).

Siew_WeiGoh2 · ‎12-04-2017

Thank you James.

Unfortunately, due to some circumstances, I do not have access to ArcGIS Pro. Therefore, I’m stuck with ArcDesktop.

I proceeded with your suggestion:-

1. created a base Survey using Create Advance from Connect and include two Groups of Repeats (to allow for two tables)

2. Published to AGOL

3. Entered a couple of data to the survey and confirmed data is in both Layer0 and both related tables

4. Download from AGOL to Desktop

5. Manually add a new field and entered a new row to one of the table (defectCapture) AND manually populate the GUID field using ArcDesktop

6. Republished to AGOL with all the downloaded tables and relationship including the GDB ServiceItems

New field and new entry row have been added to the defectCapture table.

7. Repoint the submission_url to this republished feature layer, and republish the form

8. Download/Update the form on Survey123

9. Refresh the Inbox. All was going good until it tried to get information on the GDB_ServiceItems. An hour… it’s still stuck on the GDB_ServiceItems ☹, so i had to terminate the survey.

Perhaps I shouldn’t republish with the GDB_ServiceItems in Step 6?

So I republish again by overwriting the service and this time without including the GDB_ServiceItems table. When I get to Step 9 above and refresh the Inbox, it is now stuck on Getting service information on Span_Types after cycling through Bridge and defectCapture.

I had not touched the Span_Types table so am perplex why the refresh on Inbox on Survey123 is stuck in getting this table's service. I had to kill the Inbox action.

Please can someone advice?

Thank you

SW

JamesTedrick · ‎12-05-2017

Hi SW,

Yes I wouldn't have republished the GDB_ServiceItems table. The usual way I publish is by adding the feature classes and tables in an ArcMap Data Frame and then publishing via ArcMap - this allows me to set the order of the layers and tables.

Siew_WeiGoh2 · ‎12-05-2017

Hi James,

Thanks for that advice. I have also tried republishing via ArcMap without including the GDB_ServiceItems, but upon attempt in refresh the Inbox on the app, it is stuck on the last item to be loaded . It does seem like a loading issue on Inbox?

Perhaps I did something wrong in my set-up/pointers:

The feature service:

I have the submission_url point to:

Would it help if you have access to the feature service that it's linked to? I am happy to share the feature service if you would like to email me your username.

Thanks again

Cheers

SW

CurtisMoore · ‎04-26-2018

Any solution to this? I'm having the same issues as described above. Thanks!

DougBrowning · ‎04-26-2018

When I got this error it was having a photo in a repeat. That meant the form FC was related to the repeat table which had a _ATTACH relate off of that. That makes it 3 levels deep - which will hang your submit.

(For this project I also had a master FC that held the points to visit which are viewed in collector then related to each form FC so that may have been part of it - but removing the photo in a repeat always fixed it.)

Hard to tell without seeing your full GDB.

MeleKoneya1 · ‎02-18-2021

I am wondering if I am missing something in our Survey 123 implementation. We created a point feature class for facilities related to a table that has assets (i.e. rooms) to inspect. From there, there is another related table with the items (i.e. Floors, Ceilings) to review for the asset. Finally there is a table that holds the inspections records for the assets. All of this looks good in the Feature Service, but once it is brought in to ArcGIS Survey 123 Connect, I see our repeats for the related tables as I would expect. However, If I select a facility, I would like to see the assets only for that facility. Is this accomplished by querying the feature layer with JavaScript? We would prefer not to add all the values as choices as we have 40 facilities with various facilities and ideally it would be nice for the data to determine the choices.