INFORMATION - Importing AP test results produces an "Input string was not in a correct format" error

Recently customers have been experiencing an "Input string was not in a correct format" error when attempting to import the AP test results. This error occurs when the data is not in the correct format because each entire record is encased in quotes (ex., "123456, Lastname,Firstname,...,2").


When the AP test results are downloaded they need to be converted to a csv file using the Part 1 directions on the AP Central College Board site... from our documentation:


https://support.aeries.com/support/solutions/articles/14000069300-test-specific-information-ap
image


The AP test result data file can be fixed by stripping the quotes using a text editor (not Excel) or a new data file can be downloaded from College Board using ONLY the Part 1 instructions (not the Part 2 or Part 3 instructions).




Login to post a comment