Skip to main content
Solved

1. How do I export, to an excel template, data from a Survey123 form that has related tables? 2. Rather than overwriting the excel file, how can a create a new excel file from the Parent record, while integrating in the Survey123 related tables

  • April 12, 2023
  • 3 replies
  • 247 views
E

I have a Survey123 form, that needs to be exported to a specific excel template file. The Survey123 form has 1 layer (parent record), and two related tables associated with that single record. The final format for the excel template would need to be 1 file per record, with two sheets (from the two related tables). Prior to exporting out to the template files, I would need to filter the data down by a site name

 

For instance, a site (that I have filtered down to) may have 4 records taken on it, so I would need to create 4 separate excel files, based on a Plot ID field. Each on of these excel files would then have 2 sheets based on the related tables of the record.

 

Open to suggestions and comments. Thank you!

Best answer by engelm1324

What I ended up doing was having a series of attribute managers that ultimately went to 1 excel document. I was able to use the fanout method based on a certain attribute to create the additional excel spreadsheets. Here is my solution to my question. This may need some clean up, but for now it is getting me what I need.

 

Solution

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

wisegis
Contributor
Forum|alt.badge.img+17
  • wisegisContributor
  • Contributor
  • 58 replies
  • April 14, 2023

I just looked at my Survey123 export I created a while back, and it is bananas. To keep this answer simple, the trick to what you are trying to do is all at the Writer. I created an attribute during the process and called Excel_Tab_Name. They made it something really hard and I did a calculated field in the AttributeManager for that.

 

In the General section at the top of your writer, you will assign the field for the tabs. I had to create a row_id to ensure all the Survey123 data went into the correct place for each spreadsheet. The writer's field was the actual columns in each tab (A, B,& D).

 

Hope that helped.

Clay Wise
E
  • engelm1324
  • Author
  • 2 replies
  • April 14, 2023

Thanks! I will give this a shot.

E
  • engelm1324
  • Author
  • 2 replies
  • Best Answer
  • April 17, 2023

What I ended up doing was having a series of attribute managers that ultimately went to 1 excel document. I was able to use the fanout method based on a certain attribute to create the additional excel spreadsheets. Here is my solution to my question. This may need some clean up, but for now it is getting me what I need.

 

Solution

Community Stats

32,064
Posts
121,729
Replies
39,690
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.