Hi All,
I’m testing out the newish workflow task for exporting response data to excel I’ve not found any support page for this yet so maybe it is documented but never the less… I have discovered that there are certain fields you can’t include or at least don’t appear in the drop down list yet when you do a manual export in the D&A section they do appear. This includes:
Recorded Date
NPS_GROUP
any derived fields
TextiQ fields
Is there a way round this?
When I export manually I can see that the above fields have the following extra info:
=Recorded Date:
Recorded Date
RecordedDate
{"ImportId":"recordedDate","timeZone":"Europe/London"}
=NPS:
Q01_NPS_GROUP
NPS Question - Group
{"ImportId":"QID3_NPS_GROUP"}
=An example of a derived field:
Q17_new B32 All meals CSAT
Q17_new B32 All meals CSAT
{"ImportId":"Q17_ne_DERIVEDcbi44xe"}
=An example of a textiq Topic (Textiq from within the survey)
Q04c_R - Topics
Q04c_R - Topics
{"ImportId":"QID9_TEXT_4fa5eba4135d43d890b5e933Topics"}
I have tried a number of different methods to manually configure the piped text in the task setup but so far the answers have been blank.
eg. for Q17_new B32 All meals CSAT
I’ve tried ${e://Field/Q17_ne_DERIVEDcbi44xe}
and also ${e://Field/Q17_new B32 All meals CSAT}
but no luck
Does anyone know how they can include these types of fields into an excel file that autoupdates?
Alternatively, if that’s not possible, I could consider exporting via the export automation setup in the D&A section but I think the file name is not controllable meaning that an new file will be created each time and not overwrite the previous one. This will create problems in updating a master file.
Ultimately, we’re trying to get response data into excel so that we can then use this as a mean to run some reports or do some extra calculations or share data accordingly.
Thanks in advance
Rod Pestell