AQ JSON File Import Error

Problem

Example Errors

Open

Open

How-To Find the Issue

Upload the file to https://jsonformatter.org/ and do the following

1. Click on the right section

2. Hit Ctrl+F to bring up the search bar

3. Enter the Line ID given in the message or type in one of the following, depending on your message

   1. Duplicate, Missing, or Value Too large for AQ Line number use “ItemNumber”: “

      1. For missing, searching for “ItemNumber”:”” will pull them up

   2. Value Too Large for Column use “Spec”: “

   3. TRX Item Too Large for Column use “model”: “

   4. AQ Category Too Large for column use “Category”: “

Solution 3a Example:

Solution 3b & 3c Example