About the audit data feature
Use the Audit Data button to check your data format. Fix any flagged issues to ensure a smooth import. Running this audit helps you spot and correct problems early, preventing import issues.
- Locate the Button:Head over to theTR_Setuptab and find theAudit Databutton.
- Run the Audit:SelectAudit Datato check your data. This will help you spot and fix any issues before you try to import.
- Check for Yellow Flags:If any data is flagged in yellow, it means there are problems:
- Missing Data:Required fields without data will be highlighted.
- Type/Length Issues:If the data type or length doesn’t match the requirements, it’ll be marked in yellow.
- Review Errors:Errors will be detailed on theTR_Setuptab under the columns titled Sheet, Column, Cell, and Error.
- Fix the Issues:Go to the specific cells and correct the errors. Missing data will be in cells like A4, A5, and A7. Other errors will be in yellow-shaded cells.
- Understand the Errors:For a complete list of possible errors, check out theTR_General_Stringstab underStrTbl_Errors.
By following these steps, you can ensure your data is properly formatted and ready for import.