Imports, Start/End Date, Recorded Date | Experience Community
Skip to main content
Solved

Imports, Start/End Date, Recorded Date

  • Aug 19, 2018 6:22 PM UTC
  • 7 replies
  • 1590 views

Martin_O
Level 2 ●●
Forum|alt.badge.img+11
When I do an import it will never let me import Start/End Date and Recorded Date. I have to Ignore the Column to get the import to work. Does anybody have a fix for this or is that a mandatory setting?

Best answer by PeeyushBansal

Whenever you import data in legacy always download example csv file.these few system variables like responseid, date variables are always there you can't delete these and import. Download example csv in legacy and fill your data and than upload.
View original

7 replies

PeeyushBansal
Level 7 ●●●●●●●
Forum|alt.badge.img+53
  • Level 7 ●●●●●●●
  • Answer
  • Aug 20, 2018 1:37 AM UTC
Whenever you import data in legacy always download example csv file.these few system variables like responseid, date variables are always there you can't delete these and import. Download example csv in legacy and fill your data and than upload.

Martin_O
Level 2 ●●
Forum|alt.badge.img+11
  • Author
  • Level 2 ●●
  • Aug 20, 2018 1:38 AM UTC
Thank you sir!

  • Aug 15, 2019 6:17 AM UTC
What is difference between "end date" and "recorded date"? I understand that "end date" is the date when respondent submitted the survey, while "recorded date" is from system. I'm wonder why some end date is difference from recorded date by 7 days. Please help.

Bhushan
QPN Level 2 ●●
Forum|alt.badge.img+1
  • QPN Level 2 ●●
  • Aug 16, 2019 2:29 PM UTC
Hi @Tick, Here is link to know more about the data set. Recorded date = This column indicates when a survey was recorded in Qualtrics. For users taking surveys online, this date and time will be very similar to End Date. However, for responses that are imported, or uploaded from the Offline App, Recorded Date will often differ from End Date, reflecting when you manually uploaded the results, not when the survey taker finished.

JenCX
Level 5 ●●●●●
Forum|alt.badge.img+11
  • Level 5 ●●●●●
  • Aug 16, 2019 2:53 PM UTC
> @Bhushan said: > Hi @Tick, > > Here is link to know more about the data set. > > Recorded date = This column indicates when a survey was recorded in Qualtrics. For users taking surveys online, this date and time will be very similar to End Date. However, for responses that are imported, or uploaded from the Offline App, Recorded Date will often differ from End Date, reflecting when you manually uploaded the results, not when the survey taker finished. In addition to this, if you have incomplete responses set to record after a set time instead of delete, the recorded date will be the date they switched over to recorded responses from incomplete responses.

  • Aug 19, 2019 1:07 AM UTC
Hi @Bhushan, Thank you for your explanation, it's very useful. Thanks again.

  • Aug 19, 2019 1:11 AM UTC
Hi @JenCX Thank you so much.