Select to view content in your preferred language

Survey123 collecting data in unrelated table.

289
1
09-27-2024 07:53 AM
DionysiosKerasidis1
Occasional Contributor

Hi community 

i am having a challenge in the past few days which i cant find a solution. i have read previous post in regards with adding a related table within survey123 but in my case i need and FME workspace to read a spreadsheet saved in shared folder and create two layers.

One called 'Poles' (point feature).

Second is called 'Defect' and its a simple table.

The plan is that this spreadsheet is due to additional records from various sources, its a dynamic dataset and not a static which i could potentialy bring in Arc Pro and establish all the relations.

Not sure which path to follow.

 

The idea is to find on a field map the relevant pole, then open survey123 and work on the table.

 

Any ideas?

0 Kudos
1 Reply
SMauri
by
Frequent Contributor

From what you write the work process is not very clear.
I'll try to give you an idea of ​​a similar workflow.
In the case where I have to process a spreadsheet in a feature class and a related table, I would start by creating the empty structure (fc, table and relationship class) and proceed through the geoprocessing Append appropriately. For me, everything would have to be created through a model created via Model builder and without using Python code.

And why do you necessarily want to go through the use of Field Maps? Even with Survey123 it is easily possible to carry out searches in the map of assets on which to carry out inspections
https://learn.arcgis.com/en/projects/enable-an-inbox-for-a-census-survey/
Survey123 Tricks of the Trade: Repeats 

Hoping it can be of help to you.

Cheers

0 Kudos