Migrating Large Number of Responses Across Survey Projects (Millions) | XM Community
Skip to main content
Question

Migrating Large Number of Responses Across Survey Projects (Millions)

  • June 5, 2023
  • 3 replies
  • 65 views
J
QPN Level 4 ●●●●
Forum|alt.badge.img+7

I am looking to export survey response data from a survey that has over 10 million responses. Exporting out of the data & analysis into a CSV results in a file that is too big to import into the other survey (100MB max). Is there any way to make this process faster other than filtering and splitting the file into 100+ files so that they are under 100 MB? Could an API process make it faster?

3 replies

EmilyErickson
Level 5 ●●●●●
Forum|alt.badge.img+13
  • EmilyErickson
  • Level 5 ●●●●●
  • June 8, 2023

You can create a workflow and select the frequency of when it runs. 

Go to workflows, select “started at a specific time” and input the parameters.

Then, select “extract from survey” and follow the prompts

Then, select “load to survey” and follow the prompts and mapping.

J
QPN Level 4 ●●●●
Forum|alt.badge.img+7
  • jake_dufinetz
  • Author
  • QPN Level 4 ●●●●
  • June 8, 2023

You can create a workflow and select the frequency of when it runs. 

Go to workflows, select “started at a specific time” and input the parameters.

Then, select “extract from survey” and follow the prompts

Then, select “load to survey” and follow the prompts and mapping.

Hi Emily, thanks for responding. Unfortunately, these survey projects are in different licenses/brands so I wouldn’t be able to use the extract/load to survey option I don’t believe.

EmilyErickson
Level 5 ●●●●●
Forum|alt.badge.img+13
  • EmilyErickson
  • Level 5 ●●●●●
  • June 8, 2023

Ahhhh that would be too simple, wouldn’t it?  Then my recommendation would be to follow the first 2 steps and load to an SFTP.  Then create a workflow in the other instance to load the responses from the SFTP (you load a sample file and map it in the prompts).

Terms & ConditionsAccessibility statement