Import Codesystem - CSV
(→Scenarios) |
(→Importing metadata) |
||
Zeile 117: | Zeile 117: | ||
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). | 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 === | === Example === | ||
− | This example imports 2 | + | This example imports 2 countries with 2 metadata inhabitants and currency. |
<source lang="text"> | <source lang="text"> | ||
− | code;term;metadata_inhabitants | + | code;term;metadata_inhabitants;metadata_currency |
− | DEU;Germany;80.62 millions | + | DEU;Germany;80.62 millions;Euro (EUR) |
− | USA;United States of America;318.9 millions | + | USA;United States of America;318.9 millions;US-Dollar (USD) |
</source> | </source> | ||
Version vom 31. Mai 2016, 11:14 Uhr
Inhaltsverzeichnis |
Usage
Fields have to be seperated by semicolon ";".
Charset has to be "ISO-8859-1".
Filename must have csv extension.
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
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)
Examples
Roles (German) with translation to French
code;term;translation_fr AccIns;Unfallversicherung;Assureur accident Assoc;Gesellschaft;Association Chiro;Chiropraktiker;Chiropraticien Dent;Zahnarzt;Méd. Dentiste DiabAdv;Diabetesberater/in;Conseiller/ère en diabète DoctMed;Humanmediziner;Méd. Humaine Drugg;Drogist;Drogiste DruSto;Drogerie;Droguerie Ergo;Ergotherapeut;Ergothérapeute GrpPra;Gruppenpraxis;Cabinet médical de groupe HeaIns;Krankenversicherung;Assureur maladie HeaProd;Gesundheitsprodukte Herstellung & Handel;Produits de santé (fabrication et commerce) HeaProv;Andere Leistungserbringer;Autre prestataire de soin HeaTec;Gesundheitstechnik Herstellung & Handel;Technique de santé (fabrication et commerce) Hosp;Spital / Klinik;Hôpital/Clinique Indus;Industrie;Industrie IntOrg;Internationale Organisation;Organisation internationale Lab;Institut/Forschungs- und Analysen-Labor;Institut/labo de recherche/analyse Midw;Hebamme;Sage-femme Nurse;Krankenpfleger/in;Infirmier/ère NursHom;Pflegeheim;Home médicalisé NutrAdv;Ernährungsberater/in;Conseiller/ère nutritionniste ONursOrg;Andere Pflegeorganisation;Autre organisme de soins Pharm;Apotheke;Pharmacie Pharmst;Apotheker_in;Pharmacien_ne Physio;Physiotherapeut;Physiothérapeute PrivPra;Privatpraxis;Pratique privée Psycho;Psychologe/Psychotherapeut;Psychologue/Psychothérapeute PubHea;Gesundheitsamt;Autorité sanitaire SerFirm;Dienstleistungsfirma;Société de service SocSec;Sozialversicherung;Assurance sociale SpecPra;Andere Praxis;Autre cabinet SpeeTher;Logopäd/in;Logopédiste Veter;Tierarzt;Méd. Vétérinaire Whole;Grossist;Grossiste
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>