Difference between revisions of "File upload guide"

From WeSISpedia
Jump to: navigation, search
Line 5: Line 5:
 
When you’ve decided that your data is finally ready to be uploaded to WeSIS please make sure that you have:
 
When you’ve decided that your data is finally ready to be uploaded to WeSIS please make sure that you have:
 
<ol>
 
<ol>
<li>Created an indicator page on WeSISPedia. You should use the following [[Template:Indicator| template]]. Here is an [[Example:_Example_indicator| example indicator page]]  so you get a better idea. Please make sure that ALL relevant fields in the info box are filled out, since this is important for data validation.
+
<li> '''bold'''Created'''bold''' an indicator page on WeSISPedia. You should use the following [[Template:Indicator| template]]. Here is an [[Example:_Example_indicator| example indicator page]]  so you get a better idea. Please make sure that ALL relevant fields in the info box are filled out, since this is important for data validation.
<li>Added all new indicators to the [[Index_of_all_indicators|Index of all indicators page]] on WeSISPedia.
+
<li> '''bold'''Added'''bold''' all new indicators to the [[Index_of_all_indicators|Index of all indicators page]] on WeSISPedia.
<li>Formatted your files according to the provided templates as described in [[File_formats|File formats]]. Please note that the system accepts .csv,.xls and .xlsx. Though uploading .xls files in not recommended.
+
<li>'''bold'''Formatted'''bold''' your files according to the provided templates as described in [[File_formats|File formats]]. Please note that the system accepts .csv,.xls and .xlsx. Though uploading .xls files in not recommended.
 
</ol>
 
</ol>
  

Revision as of 09:48, 6 September 2019

This guide walks you through the process of uploading data to WeSIS.


Before you start

When you’ve decided that your data is finally ready to be uploaded to WeSIS please make sure that you have:

  1. boldCreatedbold an indicator page on WeSISPedia. You should use the following template. Here is an example indicator page so you get a better idea. Please make sure that ALL relevant fields in the info box are filled out, since this is important for data validation.
  2. boldAddedbold all new indicators to the Index of all indicators page on WeSISPedia.
  3. boldFormattedbold your files according to the provided templates as described in File formats. Please note that the system accepts .csv,.xls and .xlsx. Though uploading .xls files in not recommended.

File overiew

Error logs

At the moment the system performs four types of error checks:

  1. Missing_columns - checks for mandatory columns missing in the uploaded file.
  2. Invalid_datatype - checks whether cells are of type desribed in File formats section, i.e. Numeric, String, Binary, Datetime or other.
  3. 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.
  4. Scale/Value_mismatch - checks whether the scale documented in WeSISPedia for each technical indicator agrees with the scale of the actual value


File preview