Importing Records in qualtrics

Hi, can you tell us more about the process you are doing. What I've done before is creating the survey in qualtrics, create one response, export the response file and then populating that file with historical records. If you are doing so, maybe there is a problem with the delimiter used in the file.

Please check all the OE response, there must an openend response which will be taking additional row. Better you should break your file into multiple batches (15 to 20 batchs, each batch should contain max 20K responses) and add additional column on each file for batch numbers. It will help you to upload and QC your data. you can also identify your errors easily.

Hi @krbhavya Missing column is not an issue. First download the blank data csv file from qualtrics survey and map 5 to 10 responses into it and then check if your Qualtrics is mapping your data into system and uploading the response. If it is doing it that means your OE response are breaking at some point. 

Follow few steps.

1) download a blank CSV file from qualtrics, if you have special characters then download TSV file instead

2) Copy 5 responses into it. That means 3 topline headers + 5 response. Then check each column, as each column should have same number of responses.

3) then proceed for upload the data, if email is not appeating blue then select email dropdown manually

4) even if system is not able to upload these 5 reaponses then check the date formats in your start and end date variable. It should be in same format as you are selecting while upload.

5) if it done then create first batch of 1000 records to run next upload, then 10000 records in each batch.

P.S. there are multiple ways to upload. I'm just sharing my way to upload the response. Try it.

Hi @krbhavya  actually, file format should be .csv (utf-8) comma separated and uploading lakh record is not a problem, but small batches are always easy to find the error. Best practice never create data file by your own. but always export the blank file from survey data and then map your responses under it. I’m glad you have resolved your issue.

All the best brother.