Monthly Archives: June 2016

Add Qualtrics Data To PittForm Reporting Database

Data export from Qualtrics

  1. Login to Qualtrics via my.pitt.edu
  2. Select the appropriate Qualtrics survey
    1. There are currently 4 Qualtrics surveys from which to get data
      1. PITT Form class of 2018
      2. PITT Form class of 2019
      3. PITT Form class of 2020
      4. PITT Form class of 2021
  3. Select t “Data and Analysis”
  4. Select “Export & Import”
  5. Select “Export Data”
  6. Select ” Export Data with Legacy format”
  7. Enter start and end dates
    1. Note change to the work spec: Select a date range that goes back three days.  For example, if you are doing the export on Wednesday, select the date range that would be Monday- Wednesday. This helps to insure that all PittForms get counted. On Monday, choose Friday- Monday.
  8. Click for “more options”
  9. Check “use choice text”- This is very important
  10. Check “Compress as .zip”
  11. These steps should be followed for the survey for 2018, 2019, 2020 and 2021

Prepare The data for import

  1. Move the .zip files to your desktop
  2. Double click to unzip each file, or use an unzip app to unzip each file.
  3. These files must be on the desktop

Data inport to Filemaker

  1. Open the Filemaker Databases. There are currently three databases. and do steps 2-5 for each database. Do them in this order:
    1. PittFormReports_2021
    2. PittFormReports v3
    3. PittFormReports
  2. Select the files you are importing from the list presented and add a checkmark in the box. It may already be checked or may need to be checked. Then, click the green “import” button.
  3. You will see two dialogue boxes appear announcing the progress of the import. The first is “Your records have been imported”. The second is “duplicates have been removed.” These happen very quickly for those of the databases.
  4. Click OK for the “duplicates have been removed” dialogue box.
  5. Close the database