Missing Rows in CSV Upload

Question

I’m working on uploading state assessment scores to Qualtrics from prior years. There’s about 7 years for the same test with about 3,500 lines for each year.  I’m expecting about 24,500 responses in the imported data file yet it only returns 9,500. I’m using a csv to upload the data, I’m unsure of where to begin troubleshooting.

sronkowski · Accepted Answer

Been a while since I’ve run manual imports, but I know when we send data via the API, things tended to go less-than-perfectly when we tried to upload more than 5000 or so rows at a time; we now submit our data in batches of 5000 rows at a time. Can you try splitting the CSV file into a few smaller ones and uploading that way?Our main student dashboards all have 20,000+ rows of data, so it’s definitely not a question of too many rows in total… just might be too many rows to upload at all once!

aclose · Answer

Thank you for the suggestion! I went ahead and gave this a try and it still came up with the same error where it was omitted rows. I realized that I was not supposed to select a unique ID because if students tested in the following years they would get overridden with each iteration. Seems like such a simple fix.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded