Wikibase Export

Choosing the export language

Wiki administrators can configure there to be an option to select the export language at the top of the export page.

The language selection dropdown only shows if there are multiple languages available. If the administrators do not configure any language, the wiki's main language is used.

Example configuration on MediaWiki:WikibaseExportConfig:

{
    "exportLanguages": [
        "en",
        "nl",
        "de"
    ]
}

Selecting entities to export

At the top of the export page, select the entities you wish to export. You can either select a single entity or multiple entities. You can search for entities to include in the export by entering their label or ID in the search box.

As a wiki administrator, you can configure the default entities to be selected via MediaWiki:WikibaseExportConfig. Example:

{
    "defaultSubjects": [
        "Q1",
        "Q2"
    ]
}

You can also limit which entities show up in the search results via subjectFilterPropertyId and subjectFilterPropertyValue. Example:

{
    "subjectFilterPropertyId": "P1",
    "subjectFilterPropertyValue": "Q2"
}

Exporting ungrouped values

Wikibase Export supports filtering and grouping by year. This is however an optional feature. If you do not want all or any of your properties to be grouped by year, use the "Ungrouped values" section. This section only shows if the wiki administrators have configured ungrouped properties.

To export values for only some ungrouped properties, untick the "Values for all properties" checkbox and select the properties you wish to export.

As a wiki administrator, you can configure the list of ungrouped properties via MediaWiki:WikibaseExportConfig. Example:

{
    "ungroupedProperties": [
        "P1",
        "P2"
    ]
}

Grouping values by year

If you want to group values by year, use the "Values grouped by year" section. This section only shows if the wiki administrators have configured grouped properties.

Select the date range you wish to export. You can either select a single year or a range of years. The CSV will have one column per year in the range. Example:

To export values for only some grouped properties, untick the "Values for all properties" checkbox and select the properties you wish to export.

The grouping feature uses qualifiers to determine the year of a statement. To be included in the export, a statement that gets grouped by year needs to have one of these qualifiers:

• Point in time
• Start time
• End time

It is common to combine Start time and End time qualifiers to define a closed range, though leaving the range open is also supported.

As a wiki administrator, you can configure the grouping by year via MediaWiki:WikibaseExportConfig. Example:

{
    "propertiesToGroupByYear": [
        "P3",
        "P4"
    ],
    "startTimePropertyId": "P10",
    "endTimePropertyId": "P11",
    "pointInTimePropertyId": "P12",
    "defaultStartYear": 2019,
    "defaultEndYear": 2023
}

Without propertiesToGroupByYear and either pointInTimePropertyId or both startTimePropertyId and endTimePropertyId, the "Values grouped by year" section will not show.

Choosing column headers

At the bottom of the export page you can choose which column headers to use. The default is to use the property IDs, though you can choose to use property labels instead.