ChrisVG at 22:41, 31 July 2023

2023-07-31T22:41:50Z

ChrisVG: 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..."

2023-07-31T22:41:10Z

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..."

New page

[[Help:Main|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 ===

@@ 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.
-=== Properties with multiple values ===
+== 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 ===
+==Adding vs. updating information ==

Help:Preparing Bulk import - Revision history

ChrisVG at 22:41, 31 July 2023

ChrisVG: 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..."