Difference between revisions of "File upload guide"
| Line 1: | Line 1: | ||
| − | + | This guide walks you through the process of uploading data to WeSIS. | |
Note that the system accepts only .csv, .xls, .xlsx files. | Note that the system accepts only .csv, .xls, .xlsx files. | ||
| Line 11: | Line 11: | ||
<li>'''Missing_columns''' - checks for mandatory columns missing in the uploaded file.</li> | <li>'''Missing_columns''' - checks for mandatory columns missing in the uploaded file.</li> | ||
<li>'''Invalid_datatype''' - checks whether cells are of type desribed in [[File_formats|File formats section]], i.e. Numeric, String, Binary, Datetime or other. </li> | <li>'''Invalid_datatype''' - checks whether cells are of type desribed in [[File_formats|File formats section]], i.e. Numeric, String, Binary, Datetime or other. </li> | ||
| − | <li>'''Unrecognized_values''' - checks whether the following column values: country, cow_code, technical_indicator_name exist in database. If not the user should update the appropriate WesSISPedia page. </li> | + | <li>'''Unrecognized_values''' - checks whether the following column values: country, cow_code, technical_indicator_name, scale exist in database. If not the user should update the appropriate WesSISPedia page. </li> |
| − | <li>'''Scale/Value_mismatch''' - checks </li> | + | <li>'''Scale/Value_mismatch''' - checks whether the scale documented in WeSISPedia for each technical indicator agrees with the scale of the actual value</li> |
</ol> | </ol> | ||
Revision as of 17:05, 4 September 2019
This guide walks you through the process of uploading data to WeSIS.
Note that the system accepts only .csv, .xls, .xlsx files. Please, ensure that data formatted according to templates described in File formats .
Error logs
At the moment the system performs four types of error checks:
- Missing_columns - checks for mandatory columns missing in the uploaded file.
- Invalid_datatype - checks whether cells are of type desribed in File formats section, i.e. Numeric, String, Binary, Datetime or other.
- Unrecognized_values - checks whether the following column values: country, cow_code, technical_indicator_name, scale exist in database. If not the user should update the appropriate WesSISPedia page.
- Scale/Value_mismatch - checks whether the scale documented in WeSISPedia for each technical indicator agrees with the scale of the actual value
