/
AQ JSON File Import Error

AQ JSON File Import Error

Problem

Receiving Error message when importing JSON File. Not seeing which item when looking at AQ

Example Errors

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”: “

When using either “item_number”: “ or “Spec”: “ you would use the arrows to cycle through until you find the duplicate, missing AQ Line Number, or Item/Description that was too large.

Solution 3a Example:

Solution 3b & 3c Example

 

Related content

Create Project in TRX with AQ JSON file
Create Project in TRX with AQ JSON file
More like this
Lesson 01: Cleaning AQ FIle
Lesson 01: Cleaning AQ FIle
More like this
AQ Import
AQ Import
More like this
AQ Sync Troubleshooting
AQ Sync Troubleshooting
More like this
Project Import
Project Import
More like this
Lesson 02 Importing AQ File
Lesson 02 Importing AQ File
More like this