Categories
Uncategorized

Set Up Pitt Form DB for New Year

Look for three part names in 2022 and check Import All script

Clone previous year

change Table name.  Class of XXXX to the correct name both :All and :Blank

Delete all records in tables:

  • Qualtrics Export
  • ImportLog
  • Report

Create a record in the ImportLog table and set the time completed to some timestamp before any entries were added to Qualtrics

add the Quialtrics survey ID to Import Records script, line 24

Leave a Reply