Import Codesystem - CSV
Aus Termserver-CTS2
(Unterschied zwischen Versionen)
(→Scenarios) |
(→Importing translations) |
||
Zeile 105: | Zeile 105: | ||
= Scenarios = | = Scenarios = | ||
==Importing translations== | ==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. | ||
+ | |||
==Importing metadata== | ==Importing metadata== | ||
==Importing associations (hierarchies)== | ==Importing associations (hierarchies)== |
Version vom 31. Mai 2016, 10:27 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.
Importing metadata
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>