Validate metadata#
To validate your Excel metadata file, upload it at https://fairds.fairbydesign.nl/validate. The system checks the file for any inconsistencies.
Validation report#
During validation, the metadata file is checked structural and semantic inconsistencies. After validation, a report summarizing the validation process is displayed.
Such a summary can look like this:
Analysing investigation information
Analysing study information
Analyzing observation unit sheet
Finished processing Sample - miscellaneous natural sheet
Processing Assay - Illumina sheet
Finished parsing Assay - Illumina sheet
Processing Assay - Amplicon demultiplexed sheet
Finished parsing Assay - Amplicon demultiplexed sheet
Found Lat long values to convert to the GeoSPARQL format.
Validating RDF file
RDF file passed validation
Validation successful, user not logged in.
Result file not uploaded to the data storage facility
Validation appeared to be successful.
Validation errors#
However if the validation was unsuccessful you will see a summary of the validation process and an error message.
Such a summary can look like this:
=================================================================
Your dataset did not pass the validation...
When it is unclear please provide the following message to your data steward
Analysing investigation information
Analysing study information
Analyzing observation unit sheet
The value "malee" of "sex" in the "ObservationUnit" sheet does not match the pattern of (female|hermaphrodite|male|neuter|not applicable|not collected|not provided|other|restricted access) regex (female|hermaphrodite|male|neuter|not applicable|not collected|not provided|other|restricted access) such as in ex.getTerm()ample "female"
Please validate your mappings in the excel file
=================================================================
Please check the error message carefully and see if you can identify the problem yourself. In this case The value "malee" of "sex" in the "ObservationUnit" sheet does not match the pattern of (female|hermaphrodite|male|neuter|not applicable|not collected|not provided|other|restricted access), which means that the value malee is not a valid value for the sex column in the ObservationUnit sheet.
To correct this you can change the value to one of the valid values, in this case to male. If the issue remains unclear, contact us and include the error message. When no new errors are found your metadata file will pass the validation.
Download RDF#
When validation succeeds, the Excel file is converted to an RDF file. This RDF file can be downloaded by clicking on the Download RDF button. RDF files can be saved in a Triple Stores, where they can be used to query the data and to integrate with other applications.