Import Codesystem - CSV
(→Example) |
(→Example) |
||
Zeile 140: | Zeile 140: | ||
CAL;California;Kalifornien;0;USA;2;has state;is state of | CAL;California;Kalifornien;0;USA;2;has state;is state of | ||
</source> | </source> | ||
− | [Datei:Hierarchy_Example.csv] | + | [[Datei:Hierarchy_Example.csv]] |
=SOAP Examples= | =SOAP Examples= |
Version vom 31. Mai 2016, 11:27 Uhr
Inhaltsverzeichnis |
Usage
Fields have to be seperated by semicolon ";".
Charset has to be "ISO-8859-1".
Filename must have csv extension.
Please see the scenarios how to import specific information into the Terminology Server.
Fields
Field | Optionality | Datatype | Description |
---|---|---|---|
code | required | String | Concept code, maximum of 100 characters |
term | required | String | Designation |
term_abbrevation | optional | String | Abbrevation of designation, maximum length of 50 characters |
description | optional | String | Additional description |
is_preferred | optional | bool | default: true (1), possible values: 1 or 0 |
is_axis | optional | bool | default: false (0), possible values: 1 or 0 |
is_mainclass | optional | bool | default: false (0), possible values: 1 or 0 |
translation_XY | optional | String | Defines translations for a concept designation. XY has to be replaced with the ISO code for the language, for example: "translation_en" |
metadata_XYZ | optional | String | Defines additional metadata for a concept. XYZ has to be replaced with the name of the metadata, for example: "metadata_meaning" |
relation | optional | String | Code to related concept. |
association_kind | optional | Integer | used if relation is set (1=ontological, 2=taxonomic, 3=cross mapping, 4=link; default: 2) |
association_type | optional | String | used if relation is set, forward name for the relation |
association_type_reverse | optional | String | used if relation is set, reverse name for the relation |
crossmapping_csv_id | optional | long | used if relation should be a cross mapping to another code system with given version id |
Scenarios
In this chapter you find information about different scenarios. You can combine them to import complex structures into the Terminology Server.
Importing translations
If you want to import translations, you will have to add 1 column for each language. You will have to name the column with translation_XY, where XY has to be replaced with the language code, for example: "translation_en" for an English translation. The language code has to exists in the domain 'ISO_639_1_Language_Codes'. You can see all possible values in TermAdmin in the domain section.
Example
This example imports 2 language codes with default language English and a German translation.
code;term;translation_de de;German;Deutsch en;English;Englisch
Importing metadata
Metadata works nearly similar to translations. Each metadata you want to import need 1 column named "metadata_XY", where XY has to be replaced with the name of metadata. In contrast to translations you can define your own metadata text (replace XY with any text).
Example
This example imports 2 countries with 2 metadata inhabitants and currency.
code;term;metadata_inhabitants;metadata_currency DEU;Germany;80.62 millions;Euro (EUR) USA;United States of America;318.9 millions;US-Dollar (USD)
Importing associations (hierarchies)
You can import associations between concepts. Therefore you have to import the parent concept before the child concept (by placing the parent concept above the child concept).
Example
This example imports 2 countries with German translation and 2 states associated with the countries.
code;term;translation_de;is_axis;relation;association_kind;association_type;association_type_reverse DEU;Germany;Deutschland;1;;;; NRW;North Rhine-Westphalia;Nordrhein-Westfalen;0;DEU;2;has state;is state of BAV;Bavaria;Bayern;0;DEU;2;has state;is state of USA;United States of America;Vereinigte Staaten von Amerika;1;;;; TEX;Texas;Texas;0;USA;2;has state;is state of CAL;California;Kalifornien;0;USA;2;has state;is state of
SOAP Examples
Import short file creating a new code system
The following sample imports a new code system with csv content. The user has to be logged in before, to obtain a login token.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adm="http://administration.ws.terminologie.fhdo.de/"> <soapenv:Header/> <soapenv:Body> <adm:ImportCodeSystem> <parameter> <codeSystem> <codeSystemVersions> <name>Test X-Version 1</name> </codeSystemVersions> <name>Test X</name> </codeSystem> <importInfos> <filecontent>aXNfcHJlZmVycmVkO2NvZGU7bWV0YWRhdGFfUHJpbeRyc2NobPxzc2VsbnI7bWV0YWRhdGFfU3Rlcm5zY2hs/HNzZWxucjttZXRhZGF0YV9adXNhdHpzY2hs/HNzZWxucjt0ZXJtO3JlbGF0aW9uO2Nyb3NzbWFwcGluZ19jc3ZfaWQ7YXNzb2NpYXRpb25fa2luZDthc3NvY2lhdGlvbl90eXBlO2Fzc29jaWF0aW9uX3R5cGVfcmV2ZXJzZQ0KMDtJOTc3MzA7OztaMzcuOSE7WndpbGxpbmdlOzsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k5MDAxNjtBMDAuMDs7O0Nob2xlcmEgZHVyY2ggVmlicmlvIGNob2xlcmFlIE86MSwgQmlvdmFyIGNob2xlcmFlO0EwMC4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STMwOTE5O0EwMC4wOzs7S2xhc3Npc2NoZSBDaG9sZXJhO0EwMC4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STkwMDE3O0EwMC4xOzs7Q2hvbGVyYSBkdXJjaCBWaWJyaW8gY2hvbGVyYWUgTzoxLCBCaW92YXIgZWx0b3I7QTAwLjE7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJNjk3NTY7QTAwLjE7OztDaG9sZXJhYXJ0aWdlIER5c2VudGVyaWU7QTAwLjE7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJMzA5MjA7QTAwLjE7OztFbC1Ub3ItQ2hvbGVyYTtBMDAuMTsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k3MDY3MDtBMDAuMTs7O0VsLVRvci1FbnRlcml0aXM7QTAwLjE7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJMTM2MTQ7QTAwLjk7OztDaG9sZXJhO0EwMC45OzE1ODszO2VxdWFscztlcXVhbHMNCjE7STMyNzc2O0EwMC45Ozs7Q2hvbGVyYSBhc2lhdGljYTtBMDAuOTsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k2ODA3MDtBMDAuOTs7O0Nob2xlcmEgZHVyY2ggVmlicmlvIGNob2xlcmFlIE86MTtBMDAuOTsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kzMjc3NztBMDAuOTs7O0Nob2xlcmEgZXBpZGVtaWNhO0EwMC45OzE1ODszO2VxdWFscztlcXVhbHMNCjE7STMyNzc1O0EwMC45Ozs7Q2hvbGVyYSBtYWxpZ25hO0EwMC45OzE1ODszO2VxdWFscztlcXVhbHMNCjE7STY2Mzc3O0EwMS4wOzs7QWJkb21lbnR5cGh1cztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kyMjQ2NTtBMDEuMDs7O0JhdWNodHlwaHVzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STIyNDU3O0EwMS4wOzs7RGFybXR5cGh1cztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k3NTMwMztBMDEuMDs7O0ViZXJ0aC1LcmFua2hlaXQ7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJNzE0MDY7QTAxLjA7OztFbnRlcml0aXNjaGVzIEZpZWJlcjtBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kyMjQ2NjtBMDEuMDs7O0VudGVyb3R5cGh1cztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kyMjQ2NztBMDEuMDs7O0ZlYnJpcyBlbnRlcmljYTtBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kxNzcwNDtBMDEuMDs7O0dhbGxlbmJsYXNlbnR5cGh1cztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k3MTQxNTtBMDEuMDs7O0dhc3Ryb2VudGVyaXRpc2NoZXMgRmllYmVyO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STE3Nzk0O0EwMS4wOzs7R2VoaXJudHlwaHVzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STIxMzEzO0EwMS4wOzs7SGF1dHR5cGh1cztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kyMjQ1NTtBMDEuMDs7O0lsZW90eXBodXM7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJOTQ5ODE7QTAxLjA7OztJbmZla3Rpb24gZHVyY2ggQmFjdGVyaXVtIHR5cGhvc3VtO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STczNjcxO0EwMS4wOzs7SW5mZWt0aW9uIGR1cmNoIEViZXJ0aGVsbGEgdHlwaG9zYTtBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kyMjQ1ODtBMDEuMDs7O0luZmVrdGlvbiBkdXJjaCBTYWxtb25lbGxhIHR5cGhpO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STE4NzIxO0EwMS4wOzs7TGViZXJ0eXBodXM7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJMjEzMTI7QTAxLjA7OztMdW5nZW50eXBodXM7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJOTYyNTE7QTAxLjA7OztMeW1waGFkZW5pdGlzIG1lc2VudGVyaWFsaXMgZHVyY2ggU2FsbW9uZWxsYSB0eXBoaTtBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k2NjUwOTtBMDEuMDs7O1Bvc3R0eXBob2lkZXIgQWJzemVzcztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kyMjQ1NjtBMDEuMDs7O1N0YXR1cyB0eXBob2lkZXM7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJMjI0NjM7QTAxLjA7OztUeXBob2VudGVyaXRpcztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k3MTQ0NztBMDEuMDs7O1R5cGhvZ2FzdHJpc2NoZXMgRmllYmVyO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STIyNDYyO0EwMS4wOzs7VHlwaG9pZGVzIEZpZWJlcjtBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kzMTQxNjtBMDEuMDs7O1R5cGhvbWFuaWU7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJMjI0NjQ7QTAxLjA7OztUeXBob3Blcml0b25pdGlzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STIyNDU0O0EwMS4wOzs7VHlwaHVzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STIyNDYxO0EwMS4wOzs7VHlwaHVzIGFiZG9taW5hbGlzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STczOTI2O0EwMS4wOzs7VHlwaHVzaW5mZWt0aW9uO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STcwNjkwO0EwMS4wOzs7VHlwaPZzZSBFbnRlcml0aXM7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJNzE2Mzg7QTAxLjA7OztUeXBo9nNlIEZpc3RlbDtBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k5NDA2MDtBMDEuMDs7O1R5cGj2c2VzIERhcm11bGt1cztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k4MjE3NTtBMDEuMDs7O1R5cGj2c2VzIHBlcmZvcmllcnRlcyBVbGt1cztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQowO0k3ODM1MDtBMDEuMDs7O0dhc3Ryb2ludGVzdGluYWxlIFBlcmZvcmF0aW9uIGJlaSBUeXBodXM7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJMjEzMDk7QTAxLjArO0cwMSo7O1R5cGh1cy1NZW5pbmdpdGlzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STY5ODEyO0EwMS4wKztJMzkuOCo7O1R5cGh1cy1FbmRva2FyZGl0aXM7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJNzc0MDA7QTAxLjArO0k0MS4wKjs7VHlwaHVzLU15b2thcmRpdGlzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STc4ODQ2O0EwMS4wKztKMTcuMCo7O1BuZXVtb25pZSBiZWkgVHlwaHVzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STk2OTQ0O0EwMS4wKztKMTcuMCo7O1BuZXVtb25pZSBkdXJjaCBTYWxtb25lbGxhIHR5cGhpO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STIxMzExO0EwMS4wKztKMTcuMCo7O1R5cGh1cy1QbmV1bW9uaWU7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0KMTtJOTA0MTc7QTAxLjArO00wMS4zOSo7O0FydGhyaXRpcyBiZWkgVHlwaHVzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STg5MzM5O0EwMS4wKztNMDEuMzkqOztBcnRocml0aXMgYmVpIFR5cGh1cyBhYmRvbWluYWxpcztBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0k4Mjc4NztBMDEuMCs7TTQ5LjI5Kjs7U3BvbmR5bGl0aXMgdHlwaG9zYTtBMDEuMDsxNTg7MztlcXVhbHM7ZXF1YWxzDQoxO0kyMTMxMDtBMDEuMCs7TTYzLjA5Kjs7VHlwaHVzLU15b3NpdGlzO0EwMS4wOzE1ODszO2VxdWFscztlcXVhbHMNCjE7STc3OTQyO0EwMS4wKztNOTAuMjkqOztUeXBo9nNlIE9zdGVvbXllbGl0aXM7QTAxLjA7MTU4OzM7ZXF1YWxzO2VxdWFscw0K</filecontent> <!-- can be imported directly in Soap-UI (context menu) --> <formatId>1</formatId> </importInfos> <loginToken>7dab8ac8-7ac7-43e8-9dc6-334b07290079</loginToken> </parameter> </adm:ImportCodeSystem> </soapenv:Body> </soapenv:Envelope>