Exporting and Importing corrected data | XM Community
Skip to main content
Solved

Exporting and Importing corrected data

  • July 19, 2019
  • 2 replies
  • 315 views

I have exported survey data and need to make some edits to it in the CSV file, then import the edits. However, I need to retain the Recorded Date, Start Date and End Date. It won't let me import these through the straight import function. (I found a link talking about exporting/importig an example.csv file, but not sure what this is.) I am trying to import a file in the same structure as it is exported. Also, if I import corrected data, will it just overwrite the current file, or will completely new records be created, thus duplicating the file? Thanks!

Best answer by Alok_Painuly

Hi @JMB: You can keep start and end date as is in the import file but not recorded date. Recorded date will automatically is captured when the record is being captured/imported into Qualtrics database. Importing the data is recommended in Legacy Importer. If you are not sure about the variables then you can simply download the Example file. Click Import then Use Legacy Importer and download Example CSV. Keep the start and end date value whatever you want to. Please note that the start and end date must be in mm/dd/yyyy format while importing.

2 replies

Alok_Painuly
Level 2 ●●
Forum|alt.badge.img+4
  • Level 2 ●●
  • 35 replies
  • Answer
  • July 20, 2019
Hi @JMB: You can keep start and end date as is in the import file but not recorded date. Recorded date will automatically is captured when the record is being captured/imported into Qualtrics database. Importing the data is recommended in Legacy Importer. If you are not sure about the variables then you can simply download the Example file. Click Import then Use Legacy Importer and download Example CSV. Keep the start and end date value whatever you want to. Please note that the start and end date must be in mm/dd/yyyy format while importing.

  • Author
  • 2 replies
  • July 22, 2019
Thank you for the help.