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.
Solved
Missing Rows in CSV Upload
Best answer by sronkowski
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!
+2Been 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!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.