Help:Preparing Bulk import

From CanonBase

Help index


For large amounts of information, the information can be imported instead of manually imported. This is done by making an excel file with the required information and sending it to the team.

Information in the excel file

The minimum information that the Excel file needs to contain

Top rows:

  • Name of the property
  • Pnumber of the property
  • “Add”, “replace“ or “ignore” (depending on what needs to be done with the information.)
  • Qualifier of property (the P number of the property)

Don’t forget obvious properties like [Field], [type of information], [instance of], [source], [source URL], … These are often the same for the whole series, but are needed for good functioning.

Mark new properties

First columns

  • Unique number (for later reference)
  • Q number in case of existing items (leave empty if new item)
  • Label
  • Description

Cels

In case of values that have a expected value list, use a drop down list

Check the expected input

Avoid text in numerical values

Avoid multiple values in one field.

Adding qualifiers

Add in top row the P-number of the property Add a column with the value that the qualifier is part of. Add the value Example: a historical address has two qualifiers, the first column shows the address, the second shows the starting date and the third on shows the ending date.

Properties with multiple values

Add a line with only the Q-number or label in the first columns Add the next value in the appropriate column.

Adding vs. updating information

Wikidata