Skip to main content

The PoolParty Excel Format with SKOS-XL Add-On

Abstract

The PoolParty Excel Format with SKOS-XL Add-On

A short guide on how you can define SKOS-XL relations in an Excel sheet.

SKOS-XL in Excel Sheets

Note

SKOS-XL is an add-on you have to license in addition to your PoolParty bundle. It is available for a PoolParty Advanced or Enterprise Server and for a PoolParty Semantic Integrator.

Since SKOS-XL, the extended SKOS format, has been made available in PoolParty, the PoolParty Excel import allows import of SKOS-XL labels and also all custom attributes and relations of those labels.

The following additional definitions in an Excel sheet become available when you have the SKOS-XL add-on licensed and enabled:

Fixed Area in an Excel Sheet:Sheet column: labelRelation
  • This defines the relation to SKOS-XL label(s). For every defined relation you have to provide a literal form in the respective label@Language column.

  • Allowed values: skosxl:prefLabel, skosxl:altLabel, skosxl:hiddenLabel

  • URI of a custom scheme relation between a SKOS concept and a SKOS-XL label, example: http://my.com/List_of_wine_cocktails

Sheet column: label@Language
  • Defines the literal form of the SKOS-XL label.

  • There has to be one column per language e.g. label@en, label@de

  • The language codes you use inside PoolParty should be compliant to the Oracle Java definition.

Optional Area in an Excel Sheet:Sheet column: skos-xl relations
  • Define relations between SKOS-XL labels.

  • Allowed values: skosxl:labelRelation

Sheet column: <custom attributes>
  • Custom attributes can also be applied to SKOS-XL labels. The same rules as for concepts apply.

Sheet column: <custom relations>
  • Custom attributes can also be applied to SKOS-XL labels. The same rules as for concepts apply.

Sheet column: type
  • Custom classes can also be applied to SKOS-XL labels. The same rules as for concepts apply.

Table 1. Example Excel Sheet with SKOS-XL Relations

<uri>/<notation>/<custom attribute>[optional]

scheme

concept

concept

labelRelation

[optional]

[optional, required for labelRelation]

prefLabel@de

[optional]

hiddenLabel@en[optional]

hiddenLabel@de

[optional]

<customattribute e.g. boolean>[optional]

http://my.com/Cocktails

Cocktails

http://my.com/Aperitif_and_digestif

Apéritif and digestif

http://my.com/Spritz_Veneziano

Spritz Veneziano

http://my.com/Wine_Cocktail

Wine cocktail

http://my.com/Bellini_cocktail

Cocktails mit Wein

Wein-Cocktail

Cocktails with wine

wine cocktail

wein cocktail

http://my.com/List_of_wine_cocktails

Liste der Wein-Cocktails

List of wine cocktails