Appended attachments not recognized as Photo or Sketch

210
3
12-13-2020 08:33 PM
MicZatorsky_AEC
Occasional Contributor II

Is is possible to bulk load records with multiple Photos and Sketches into an existing survey such that when the survey is viewed in the Survey123 website or edited in the Survey123 web form in edit mode the photos and sketches show up where expected classified as Photos and Sketches?

Getting the attachments loaded is no problem. Having the Survey123 web apps recognize the attachments as Photos and Sketches is the problem.

I'm using

  • Connect v3.11.123 on Win 10
  • Survey123 v3.11.164 on iOS 13.7
  • ArcGIS Pro 2.5.2 on Win 10


Background

The existing survey has 3 sketch fields and 1 photo field:

MicZatorsky_AEC_0-1607915500231.png

Following the (guessed) photo naming convention in the ATT_NAME field of the in the __ATTACH table,  I have named my attachments using the following the naming convention:

photo-YYYYMMDD-HHMMSS.jpg where photo is the question field name 

And the sketch images have a similar naming convention field name - date - time:

sketch1-YYYYMMDD-HHMMSS.png
sketch2-YYYYMMDD-HHMMSS.png
sketch3-YYYYMMDD-HHMMSS.png

 

Using ArcGIS Pro and the Append tool, maintaining attachments, I have successfully bulk loaded survey records with attributes and all attachments.  The attachments show as expected the AGOL Map and in the Dashboard.

The Survey123 website data tab  does not recognize the attachments as Photos or Sketches though, just as Attachments.

For example, the attachments for a record entered though iOS are correctly classified under the headings "Sketches" and "Photos"

p1.png

 

Similarly, using a URL call to edit the records from a Dashboard, a record loaded via the iOS app displays Sketches and Photos in the web form:

p4.png

But records loaded via Append in Pro have only the attribute data correctly loaded.  The attachments are loaded but they are not recognized as such :

p5.png


Is it possible to bulk load Photos and Sketches such that they are recognized as Photos and Sketches in survey 123?

How does Survey123 know which attachment belongs in each field for a record?  My guess was that it was the ATT_NAME file name prefix being the corresponding field name?  But that's not working or I'm not doing it right (e.g. do timestamps have to match the record's time stamp exactly, those I faked for uniqueness?).

Any suggestions welcome.

Mic

0 Kudos
3 Replies
MicZatorsky_AEC
Occasional Contributor II

This must be a edge case with no response from the community.

Do any of the Survey123 experts have any ideas on how to get attachments recognized as photos or sketches in the Survey123 web apps?

@Philip-Wilson @JamesTedrick @IsmaelChivite @DougBrowning 

0 Kudos
DeniseKelsey
New Contributor II

I have the same exact question. It's disappointing that you haven't received a response given the amount of effort and clarity you put into this post. Did you ever get your problem solved?

Casey

0 Kudos
MicZatorsky_AEC
Occasional Contributor II

No, but I have got a lot of other questions answered, so swings and roundabout :) 

But I think I know what it is -   Attachment keywords.    When you download an FGDB from Enterprise Portal, the attachment keyword is exposed as a column in the attachment table, but this field is not visible in the AGOL attachment  table.

0 Kudos