Import Codesystem - CSV

Aus Termserver-CTS2
(Unterschied zwischen Versionen)
Wechseln zu: Navigation, Suche
(→Example)
(→Importing associations (hierarchies))
 
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|Hierarchy_Example.csv]]
  
 
=SOAP Examples=
 
=SOAP Examples=

Aktuelle Version vom 31. Mai 2016, 11:32 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

Hierarchy_Example.csv

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>
Von „http://www.wiki.mi.fh-dortmund.de/cts2/index.php?title=Import_Codesystem_-_CSV“
Meine Werkzeuge
Namensräume
Varianten
Aktionen
Navigation
Werkzeuge