Import Data

• The columns in the dataset must follow this structure: 

  • Metric*, Company*, Year*, Values*, Source*, Unpublished, Comment, Headquarters

*Mandatory fields

• • Add all columns titles to your file. Also, if your file does not contain information on the non-mandatory fields.

• Make sure all Metrics already exist in Wikirate. 

  • If you wish to import in a new metric, make sure that you have created the metric before proceeding to the bulk import.

• Make sure that no special characters are included in your file (no asterisk *, no plus signs +, no slashes \, etc.).

• Split your file into smaller ones containing 50, 100, or 200 data points per file. 

• The file should be in a CSV (comma-separated) format.

• Triple check you are not creating duplicate companies.

  To do this, make sure the companies the data points refer to have been mapped correctly (the company is not an entity with a similar name). 

  • When in doubt: Make sure the names are very similar and that the headquarters match. If the address is available, make sure the address is the same.

• Save your mappings every so often. In this way, you will save your work in case you mistakenly leave the page.
• Keep an eye on import failures. You may need to retry the import again or fix something in your import sheet.