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.
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.