Difference between revisions of "Help:Preparing Bulk import"

From CanonBase
(Created page with "Help index ------------------- For large amounts of information, the information can be imported instead of manually imported. This is done by making an excel f...")
 
 
Line 36: Line 36:
 
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.
 
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 ===
+
== Properties with multiple values ==
 
Add a line with only the Q-number or label in the first columns
 
Add a line with only the Q-number or label in the first columns
 
Add the next value in the appropriate column.
 
Add the next value in the appropriate column.
  
=== Adding vs. updating information ===
+
==Adding vs. updating information ==
 
 

Latest revision as of 22:41, 31 July 2023

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