Getting the right data to ReSci is important to making sure your campaigns function correctly. When import errors occur it's important to not only know what occurred, but understand the severity of the error.
When an import error occurs you'll receive a pair of emails that look something like the emails below:
The first email will contain a summary of all imported files, with the number of valid and invalid rows for each file. (Looking to learn more about dropped records? Click here.)
For a perfect import, the "Invalid" column on the right will be all zeroes.
It's common, however, for human error to result in a few invalid rows. It's time to involve your tech team and ReSci tech support when reported errors number in the hundreds to thousands, or if you're seeing the same error occur repeatedly.
To learn more about the errors, you will need to open the second email, which contains files summarizing the errors. There will be one attached file for each imported file with errors, and each respective attached file will contain one line for each error.
If you have access to the files created and output by your system you can use these files to investigate the lines that are causing errors in your imports. It's often as simple as a missing piece of required data (a user with no email address) or a special character invalidating a piece of the entry (e.g. "90012\" for zip code, instead of "90012")
In the example below a formatting error caused hundreds of errors in the items file, and once it was fixed only the single bad image url remained.
Another example of an alert is from errors in the abandon_checkout file. As a general rule you can ignore errors from the abandoned_checkouts file. Checkouts with missing user record ID or missing email are most likely guest checkouts or had incomplete information when abandoned.
If you're experiencing trouble with your item imports, submit a request to the help desk and we will be glad to assist with the troubleshooting!