File upload guide: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 9: | Line 9: | ||
At the moment the system performs four types of error checks: | At the moment the system performs four types of error checks: | ||
<ol> | <ol> | ||
<li>'''Missing_columns''' - mandatory columns | <li>'''Missing_columns''' - checks for mandatory columns missing in the uploaded file.</li> | ||
<li>'''Invalid_datatype''' - cells | <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'''</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>'''Scale/Value_mismatch'''</li> | <li>'''Scale/Value_mismatch''' - checks </li> | ||
</ol> | </ol> | ||
Revision as of 16:02, 4 September 2019
To upload a file, use the "UPLOAD DATA" menu option.
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 exist in database. If not the user should update the appropriate WesSISPedia page.
- Scale/Value_mismatch - checks