PoolParty Excel & CSV Tabular Import & Export - Principles and Use Cases
PoolParty Excel & CSV Tabular Import & Export - Principles and Use Cases
This section provides examples on when and why you should use the tabular import or export feature to your advantage.
The Two Underlying Principles of the PoolParty Export and Import
The PoolParty tabular import and export feature is implemented to make sure that collaboration on PoolParty projects is easier.
Because of a number of collaborators (such as data scientists, knowledge engineers and taxonomists) are going to contribute to a PoolParty project, creating and editing or re-using tabular files can make enriching thesauri for PoolParty more user friendly and effective.
The PoolParty import feature provides two distinct functions that can be easily mistaken for each other, namely:
Import New Data into a Thesaurus Project
Add New Data to Existing Data in Your Thesaurus Project
Their use cases and functionalities overlap, yet there are also subtle differences. In this topic you can find the details about these two principles, their similarities and their differences.
Import New Data Into a Thesaurus Project
On the import level in PoolParty importing new data means one of the following:
Create a new project from scratch.
Add new data, such as concept schemes, top concepts or concepts to a thesaurus that were not there before.
Add New Data to Existing Data in Your Thesaurus
Add to existing data in your thesaurus such as new properties for concepts, labels for existing concepts, custom attributes, custom classes or relations.
At first glance, adding new data (2) is not entirely different from a simple import, because you can also import completely new data (1) at the same time. But in such cases you would also add data to existing concepts, and would check the Enable Update check box. This is called adding data in PoolParty.
Note
The function in PoolParty is called 'add data', because existing concepts and concept schemes can be extended.
PoolParty is not going to update existing data by overwriting existing values!
PoolParty Excel & CSV Tabular Export and Import - Use Cases
PoolParty Excel & CSV Tabular Export and Import - Use Cases
This section contains a short overview of PoolParty's Tabular import and export use cases.
Create a new project and import a whole PoolParty project thesaurus into PoolParty using a tabular format.
Add new concept schemes, top concepts and concepts to an existing thesaurus.
Add concept schemes, top concepts and concepts to a sub-tree of a thesaurus. This way not the whole project is going to be updated but instead, only the concept scheme, for example.
Update existing concepts with SKOS relations.
Add labels in other languages to existing concepts.
Add or edit custom scheme-based relations and attributes to existing concepts.
Export a whole PoolParty project thesaurus for editing or re-import.
Export sub-trees from your thesaurus, such as concept schemes or top concepts for editing and re-use in other projects.
The following section covers the basic actions you need to follow in order to import successfully and learn about the export rules:
Find out what a compliant Excel sheet look like for importing successfully: The PoolParty Excel Format
If you want to import an Excel sheet and thus import new data into PoolParty, find details here: Import Tabular Table, Excel Sheet or CSV File into PoolParty
If you want to add data to your thesaurus (including importing entirely new data, if desired), refer to this topic: Add Data via Excel
Information on what to expect from an export of Excel sheets from PoolParty find here: Export an Excel Sheet from PoolParty