search

Esri / Survey123-tools

Tools for ArcGIS Survey123
Apache License 2.0
42 stars 20 forks source link

how do I write the number of the question into the .xlsx file? #9

Open f2502 opened 2 years ago

f2502 commented 2 years ago

thank you very much for this useful tool. I am conducting a PPGIS survey where subjects are asked to take pictures. However, taking the pictures is not mandatory. How can I change loop that the number of the question is also in the table, so that I can assign the pictures to the questions?

Thank you very much!

Zachary-Sutherby commented 11 months ago

Hello @f2502 I am guessing you are referring to the Export survey data with attachments tool, can you provide more details on what you mean by the "number of the question"? Are you referring to the name of the image question that generated the photo?

In the last line of code in the last code block where the csvwriter is writing a row, that's where it's writing the information about the attachment to the CSV. You can modify this to include additional information to be written into the CSV. You can extract the attribute information of the parent record by modifying the feature_object_ids variable to set return_ids_only to False. With this, though you will need to modify any reference to feature_object_ids to then be feature_object_ids.attributes['objectid'].