This tool is alpha. Please report any problems on GitHub issues.

Common Errors

Invalid 'uri' found

This message means you have a problem, usually with a website address in your data.
This error is often caused by the following problems:

What is a URI? Short for “Uniform Resource Identifier” it is a sequence of characters that distinguishes one resource from another. A URL — short for “Uniform Resource Locator” — is a specific type of URI.

When the 360Giving Data Standard requires data to be provided in the format of a URI, this will mean you will very likely be providing a URL — or website address.

Date is not in the correct format

Dates should be in the formats defined by the 360Giving Data Standard.

All Last Modified fields should be in datetime format and all other dates, such as Award Dates and Planned Dates, should be in the YYYY-MM-DD format. However, Award and Planned Dates can also be provided in datetime format.

YYYY-MM-DD format used for full dates

Dates should be in the form YYYY-MM-DD where:

Example: 2022-01-01

Common date errors include

Datetimes format used for Last Modified fields

All Last Modified fields should be in datetime format, which is a very specific form of a date and time that is specified by the 360Giving Data Standard.

A datetime should be in the form of YYYY-MM-DDThh:mm:ss±hh:mm where:

Example: 2022-01-01T12:00:00Z is 12 noon on the 1st January 2022 in UTC time

You can find further guidance here about date and datetime fields in the 360Giving data, as well as formatting tips when publishing using spreadsheets.

(something) is missing but is required

There are 10 core fields that are required in the 360Giving Data Standard.

If any of the following fields are missing, the data is invalid against the schema.

This error message might be triggered because the data is missing or because of a spelling or formatting mistake in the field title. See the full list of field titles for the correct spelling and formatting for the rest of the 360Giving Data Standard.

FieldJSON valueNotesDocumentation
Amount AwardedamountAwardedEvery grant needs to specify the amount of money awarded
Award DateawardDateEvery grant needs to specify the date that it was awarded.Dates
CurrencycurrencyEvery grant needs to specify the currency that the grant was made in.
DescriptiondescriptionEvery grant needs a human readable description.
IdentifieridEvery grant needs a unique identifier so we can tell them apartGrant Identifiers
Funding OrgfundingOrganizationEvery grant needs a funding organisation that makes the award.
Funding Org:IdentifierfundingOrganization/idEvery organisation needs a unique identifier so we can tell them apart..Organisation Identifiers
Funding Org:NamefundingOrganization/nameEvery organisation needs a human readable name.
Recipient OrgrecipientOrganizationEvery grant needs a to specify an organisation to which the grant is awarded.
Recipient Org:IdentifierrecipientOrganization/idEvery organisation a unique identifier so we can tell them apart.Organisation Identifiers
Recipient Org:NamerecipientOrganization/nameEvery organisation needs a human readable name.
TitletitleEvery grant needs a human readable title.

Invalid code found in (something)

In the 360Giving Data Standard, there are three fields that require publishers to use values from a predefined list. When we validate people's data, we check the values of those fields against those lists.

This error tells us that we have found something not on the list for one or more of these fields.

FieldJSON valueDescription
CurrencycurrencyThe currency used in amounts. Use the three-letter currency code from ISO 4217 eg: Use GBP for Pounds Sterling.
Beneficiary, Recipient Org or Funding Org Location:Country CodecountryCodeThe 2-character ISO Country Code of the location of this activity. Taken from ISO-3166-1-alpha-2
From An Open Call?fromOpenCallWas this grant made as the result of an open call for applications? Values must be ‘Yes‘ or ‘No‘

The currency and country code lists are referenced in the 360Giving JSON Schemas and the field descriptions link to the code lists on third-party websites.

Field x is not a string

Data in the 360Giving Data Standard is expected to be provided in a certain format.

Strings are generally text, but can contain other characters such as numbers. Sometimes spreadsheet software can alter the format of data so that it is no longer a string.

To fix these kinds of errors, check the field to make sure you are supplying the data in the form of a string.

If using JSON format: check that the value is not null, and has quotes at the start and end. Escape any quotes in the value with \

Field x is not a number

Data in the 360 Giving Data Standard is expected to be provided in a certain format.

To fix these kinds of errors, check the field to make sure you are supplying the data in the form of a number. Check that the value is not null, and doesn’t contain any characters other than 0-9 and dot (.). Number values should not be in quotes.

x is less than the minimum of 0

A duration value cannot be a minus number. This error can be caused because the duration has been automatically calculated from a Start Date and End Date but these have been accidentally reversed or there is a typo in a date.

To fix these kinds of errors, make sure all Start Dates are before End Dates so the duration can be calculated correctly.

Getting further help

For further information see our guide on using the data quality tool and technical reference for the 360Giving Data Standard.