Most Common Master Data Upload Errors

TRACT runs two rounds of validation on every file:

Some fields are required for every record. If any mandatory field is left empty, your upload will fail. Always make sure the following are filled in before uploading:
​

• Farm Name (Node Name)
• Country
​
Not mandatory but important:
​
• Node ID — this is a unique identifier for each record in Tract. It is how the system recognises and tracks your data across uploads.
​
Every record must have one, and no two records can share the same Node ID (Node ID).

Every record in TRACT must have a unique Node ID (Node ID). The system checks your file against all previously uploaded records. If the same ID already exists, the upload will fail. Because the Node ID (Node ID) is how TRACT identifies each record, keeping it unique and consistent across uploads is critical.​

• Check your file for rows sharing the same Node ID (Node ID)
• Check if the same ID was used in a previous upload
• Assign a new unique ID to the duplicate
​

Farm names, facility names, and farmer group names must be between 3 and 256 characters and cannot contain the following characters:

/ \ [ ] : ; | = + * ? ! < >

• Remove or replace the forbidden characters
• Letters, numbers, spaces, commas, hyphens, and apostrophes are accepted

Node IDs (Node IDs) must be between 3 and 256 characters and can only contain letters, numbers, and these special characters:

• Period (.)
• Underscore (_)
• Hyphen (-)
• Single space

• Remove all other special characters
• Do not start or end the ID with . _ - or a space
• Replace consecutive characters such as -- or .. with a single character

TRACT considers a record unique based on the combination of Name, Latitude, Longitude, and Country. If two or more rows share identical values across all these fields, the duplicates will be rejected, even if they have different Node IDs (Node IDs).

• Sort your file by name to identify identical rows
• Remove the duplicate, or update one of the rows if it represents a genuinely different location

Country is a mandatory field for all Master Data records. The country name must exactly match the list in the Country_List tab of your template, including spelling and capitalisation.

• Open the Country_List tab and copy the exact spelling
• Make sure no Country cells are left blank
• Avoid abbreviations or alternative names (for example, use Côte d'Ivoire instead of Ivory Coast)

GPS coordinates must fall within valid geographic ranges:

• Latitude between -90 and 90
• Longitude between -180 and 180

Coordinates outside these ranges will be rejected.
​

• Confirm latitude is in the GPSLatitude column and longitude is in the GPSLongitude column
• Check that latitude and longitude have not been swapped
• Use decimal format only (for example, 5.6037 rather than 5°36'N)

After the file check passes, TRACT verifies that your GPS coordinates fall within the borders of the country selected in the Country field.

• Verify the GPS coordinates are correct for that specific location
• Verify the Country field matches where the location is actually located
• Check whether latitude and longitude have been accidentally swapped (see #6)

The Farm Radius (km) and Total Cultivated Area (ha) fields only accept numeric values. Text, units, or symbols will cause the upload to fail.

Enter numbers only. If you do not have the value, leave the cell empty.