Home

Mikado Tool User Manual

1. Corresponding value 7 in the common vocabulary list 30 wale tania 351 decked gas semiha a L match filer ure to sed Mer Det os ns mich Cancel Figure 10 Mapping window for paramaters It is possible to set a filter in order to find a specific value in a vocabulary list To do so see 7 2 6 2 2 2 Automatic mapping MIKADO VI 5 includes also a functionality to download automatically existing mappings between different vocabulary lists The available mappings are provided by the BODC Vocabulary Server Mappings Index C970 http seadatanet maris2 nl v vocab search asp name C970 9620 Vocab ulary Server Mappings Index amp 1 C970 In the available mappings the SeaDataNet vocabulary lists are mapped with other vocabulary lists using only the exact and narrow matches defined by BODC as follows e If MIKADO finds an exact match for a local value in the Seadatanet vocabulary selected list it maps the local value with this exact match e If MIKADO does not find an exact match but finds a narrow match it maps the local value with the narrow match e If MIKADO finds neither exact match nor narrow match it does not map the local value and then ask the user to define manually the mapping e Ifa local value can be mapped with several SDN values MIKADO does not map it and ask the user to define manually the mapping To use this functionality follow the different step
2. General information Geographical area Datathemes Reference Coordinator Partners Collate centre Organisation name LABORATORY of PHYSICAL OCEANOGRAPHY LPO UMR 6523 CNRS IFREM ILABORATORY OF OCEANOGRAPHY of VILLEFRANCHE LOV Figure 57 EDMERP Partners window sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual sg General information Geographical area Data themes Reference Coordinator Partners Collate centre Collate centre Organisation name Contact information Phone Fax Address Delivery point City Postal code Country Email Website Role SDNident Organisation name Administrative area IFREMER IDM SISMER B SDN EDMO 486 Figure 58 EDMERP Collate centre window Once all the Information related to the EDMERP has been fulfilled the xml file will be created by selecting Save as in the Manual main menu The created XML file has a xml extension 8 2 Open an existing XML file It is possible to open an existing XML file using MIKADO To so select Open in the Manual main menu and choose EDMED CSR CDI or EDMERP Then select the XML file to open Mikado V1 5 Manual Automatic Options New EDMED Download CSR Save CDI Save as EDMERP Figure 59 Open an XML file with MIKADO sdn Mikado User Manu
3. MAPPING INTERNATIONAL BOTTOM TRAWL SURVEY IBTS FRANCE 44444 4 44 8 tf C CU Keyword INTERNATIONAL BOTTOM TRAWL SURVEY PIRATA acronym PIRATA organisation LABORATOR 22 9598 JADE INDIGO SINODE acronym WOCE CONFLUENCE acronym organisation LABOR SUZAN acronym SUZAN organisation MUSEUM NAT COASTAL ENVIRONMENT HEALTH AND SAFETY acro STARMER acronym STARMER organisation CNRS PREVIMER COASTAL OBSERVATIONS AND FORECASTS EQUAMARGE acronym EQUAMARGE organisation U ODP FRANCE acronym ODP FRANCE organisation U ECOMARGE acronym ECOMARGE organisation UN MEDITERRANEAN TARGETED PROJECT MTP II MATER Molecular ecology of the photosynthetic procaryote proc INTERNAT YOUNG FISH SURVEY FRANCE o MEDITERRANEAN INTERNATIONAL TRAWL SURVEY MEDI TRADITIONAL FISHERIES acronym PAME organisation ELOISE METRO MED FRANCE acronym organisation HALIEUTIC RESOURCES ASSESSMENT WEST EUROPE MONITORING AND ASSESSMENT OF COASTAL WATERS 9598 INTERNATIONAL BOTTOM TRAWL SURVEY IBTS FRANC em Ok Cancel Figure 94 Complete the mapping All the XML files extension xml will be then created in the chosen directory sdn_Mikado_User_Manual_V1 26 01 2009
4. Dataset Data holding centre Data contact Identification When where What Reference Get data Completed by Description Period Start date End date Revision date 2007 yyyy 2008 ddimmm yyy hh imm ss 24 hr 25 01 2007 15 05 00 Figure 17 Specific formats sdn Mikado User Manual V1 26 01 2009 Am E SeaDataNet Eu ru MIKADO V1 5 user manual 7 3 2 2 MIKADO automatic The dates must be extracted from the database or Excel file at ISO 19115 format yyyy mm ddThh mm ss time is not mandatory 7 8 8 Tooltips MIKADO provides two kinds of tooltips e Title tool tip which indicates the XML field associated with the selected title and its definition e Field tool tip which gives supplementary information in order to help to fulfill the field To access tool tips put the mouse cursor over an item title or empty field without clicking it and a small box will appear with supplementary information regarding the chosen item Dataset Data holding centre Data contact Point of contact holding Organisation name __ _ _ IdPoC Organisation managing the dataset 29 Widen Organisation T Contact information Address Website Role Figure 18 Title tool tip sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Dataset Data centre Data contact Point
5. Check All query SELECT ORDER BY Automatic CDI N projets seadatanet logiciels Wikado test_mikado_v1_vt V 1 5 automatique query to char cam cam datdeb YYYY MM DD res res_volk 1024 res res obs _ fic fic_ficnom res res_cres _ plp plp_posetal _ to_char plp PLP_DATE YY YYMMDDHH24MISS YYYY MM DD T fmt fic cam res plp ndres res cres ficfic cres and res res cfmt fmt fmt cfmt and plp PLP_TYP J ITABz F and plp PLP_NO res res cres and plp plp_poseta substr INSTR F 1 0 1 INSTRCS 1 2 INSTRCS 1 1 1 and plp PLP DATE to date substr f INSTRCS 1 2 1 YYYYMMDDHH24MIS5 Figure 64 Save the configuration file EB Mikado V1 5 Manual Options New Conn ries Automatic EDMED N YprojetsWeadatanetMogicielsWMikadoMest mikado v1 vtW1 5YautomatiqueWqu SE Open gt Save ueries Saveas late Centre Generate gt easuring area typ Mapping gt itum of coordinate Exit ataset name var05 Dataset id 5 var06 Revision date data 08 Abstract dataset 5 var09 Data Holding Centre 3 vart1 Intrument 3 var12 Platform 3 vart5 Cruise name 5 var16 Cruise short name D var Cruise start date 3 var18 Station name 7 var19 Station short name 3 var20 Station start date var21 Sampling interval 3 var22 Temporal resolution 5 var
6. SeaDataNet MIKADO V1 5 user manual Start date 21 01 2008 15 00 00 ddimm yyyy hh mm ss 24 hr 25 01 2007 15 05 00 End date 21 01 2008 18 00 00 dd immiyyyy hh mm ss 24 hr 25 02 2007 12 00 00 Sampling interval Name az SDNident uomName Figure 44 CDI When window Identification Where to find the data Cruise Station Parameters SDNIdent Temperature ofthe water column SDN P021 26 TEMP Salinity ofthe water column SDN P021 26 PSAL Dissolved oxygen parameters the w SDN P021 26 DOXY Figure 45 CDI What window sdn Mikado User Manual V1 26 01 2009 Identification Where When What How Who Where to find the data Cruise Station Others Instrument CTD profilers Keyword CTD profilers 22 SDNident SDN L05 4 130 Platform class za Keyword research vessel 22 SDNident SDN L061 6 31 Figure 46 CDI How window Identification Where When What How Who Where to find the data Cruise Station Others Point of contact holding centre Organisation name IFREMER IDM SISMER 22 SONident Organisation name SDN EDMO 486 Contact information Phone Fax Address Delivery point City Administrative area Postal code Country Email Website Organisation name dk IFREMER HMMN DEPARTEMENT HALIEUTIQUE DE MANCHE MER DU NORD Originator centre LA Figure 47 CDI
7. sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 7 Common functionalities 7 1 Tables 7 1 1 Free text table The following figure shows examples of free text tables that you will find in the MIKADO Manual interface Geographic coverage bounding box Westlongitude Eastlongitude Southlatitude North latitude Geographic coverage textual description Free text describing the geographic coverage Figure 15 Free text table 7 1 1 1 Add a row To add information in a free text table click on the button row will be added to the table The new row appears in blue Geographic coverage bounding box West longitude East longitude South latitude North latitude To complete the added row double click on the row or on the field you want to complete The field to complete appears in white Geographic coverage bounding box West longitude East longitude South latitude Morth latitude 502 sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual x 29 Important To validate your update do not forget to press on Return The updated field appears in blue Geographic coverage bounding box West langitude East lonaditude South latitude Morth latitude Fa 50 2 Z 1 1 2 Delete a row To delete a row m a table select the row to delete by clicking on it and
8. D partement Informatique et Donn es Marines Tosello V Fichaut M Harscoat V Larour M Maudire G 26 01 2009 sdn Mikado User Manual V1 Version 1 1 2 3 SeaDataNet THIMI PSP MIKADO V1 5 user manual SeaDataNet MIKADO V1 5 user manual SeaDataNet MIKADO V1 5 user manual O IFREMER Tous droits r serv s La loi du 11 mars 1957 interdit les copies ou reproductions destin es une utilisation collective Toute repr sentation ou reproduction int grale ou partielle faite par quelque proc d que ce soit machine lectronique m canique photocopier enregistrer ou tout autre sans le consentement de l auteur ou de ses ayants cause est illicite et constitue une contrefa on sanctionn e par les articles 425 et suivants du Code P nal O IFREMER All rights reserved No part of this work covered by the copyrights herein may be reproduced or copied in any form or by any means electronic graphic or mechanical including photocopying recording taping or information and retrieval systems without written permission sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual SeaDataNet Titre MIKADO V1 5 user manual Titre traduit R f rence sdn Mikado User Manual V1 nombre de pages 81 Date 26 01 2009 bibliographie Oui Non Version 1 1 2 illustration s Oui Non langue du rapport Diffusion libre restreinte
9. Vertical datum Datum identifier Code SDNIdent Code Water depth Figure 9 Select the corresponding value in the list It is possible to set a filter in order to find a specific value in a vocabulary list To do so see 7 2 6 2 2 Automatic generation Incremental Mapping 6 2 2 1 Manual mapping MIKADO V1 allows you to create an incremental local mapping between the information of your database and the common vocabularies This mapping 15 done during the XML generation Each time that MIKADO does not recognized a value entrykey or entryterm which should come from the common vocabulary it asks the user for mapping e MIKADO manages a demand driven continuous incremental extension of a local mapping mapping of the local database to the common vocabulary In the mapping window you will find in a red field at the top of the window the value to map with the common vocabulary list Select the corresponding value in the list and click on OK button at the bottom of the window sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Value to map 1507 amemonelers MS L AH TO atone alor pice ape cr center w LARD acf caries amp LAE 13 balances WAP rogi apis LAEZ3 bench ee g 151 Pb berthos s 358 detecta 111 cami an 85 ceririfuges LAE codon reed ed x 3
10. Fieure 78 Query frame SELECT FROM WHERE ORDER BY frames The query frame can be divided into 4 sub frames SELECT FROM WHERE ORDER BY The free text frames FROM WHERE ORDER BY can be completed directly by typing in them The SELECT frame works as in a free text table see 7 1 1 The expandable tree on the left part of the interface makes it possible to explore the different variables by expending the tree In order to navigate in this tree you have to click on the names of the nodes After clicking the corresponding query appears in the right part of the interface in the Query frame And these queries can be checked using the query checking frame sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Requests Requests o Main Query 7 Main Query o 7 Single subqueries h Edmed identifier EJ Multiple subqueries 9 7 Single subqueries 5 01 Collate Centre h 02 Dataset name var03 Dataset id 5 04 Revision date 5 06 Summary 5 varl Purpose 5 Data holding centre h Point of contact 3 var1 Point of contact Instituti 5 varlB Time period 5 var 17 Begin year 5 vari End year 5 var24 Data website o Multiple subqueries Figure 79 Expandable tree MIKADO distinguishes different kinds of queries o the main query It is the query which identifies all EDMED CSR CDI or EDMERP entries that must
11. 3 MIKADO will open the downloaded EDMED entry in its EDMED manual interface It is now possible to update it and save 1t see 8 1 1 before sending it again to the EDMED central catalogue sdn Mikado User Manual V1 26 01 2009 Mikado V1 5 Download EDMED from BODC Manual Automatic Options Dataset Data holding centre Data contact SeaDataNet MIKADO V1 5 user manual What Reference Get data Completed by Identification Dataset id 0007001 EDMED identifier Dataset name BIMORC System of Indust he Central system will recognise whether new contributions are UPDATES of existing records e ID must be a UNIQUE LOCAL identifier The LOCAL ID is vital for the updating process 50 1 OR really new records Figure 63 Downloaded EDMED entry sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual 9 Automatic generation of EDMED CSR CDI and EDMERP XML files 9 1 General principle Instead of manually typing information using the forms provided by the tool in order to describe EDMED CSR CDI or EDMERP the Mikado software is also able to generate these descriptions automatically if elementary information are catalogued in a relational database which can be queried with SOL language through a JDBC driver Java Data Base Connectivity JDBC drivers are available for most popular relational database management system ORACLE Microso
12. D var06 Revision date data 5 Abstract dataset var09 Data Holding Centre var11 intrument D var 12 Platform 7 var15 Cruise name 3 var16 Cruise short name 5 var17 Cruise start date Y var18 Station name var19 Station short name 3 var20 Station start date D var21 Sampling interval i Check All lI query SELECT var sql Faro collate centre X FROM WHERE ORDER BY Test check 3 If needed add another variable by clicking on the 7 button Connection Queries Requests la Main Query 3 Cdi identifier Single subqueries var01 Collate Centre var02 Measuring area D var03 Datum of coordinate 5 var04 Dataset name 7 var05 Dataset id 7 var06 Revision date dat 7 var08 Abstract dataset 7 var09 Data Holding Centre var11 Intrument 7 var 12 Platform 7 var15 Cruise name 7 vart6 Cruise short name D var17 Cruise start date C var18 Station name 7 var19 Station short name 7 var20 Station start date 7 var21 Sampling interval 4 gt Check All query SELECT va sql collate centre XJ FROM WHERE ORDER BY Test lal check 4 Choose the second variable in the list then press OK and complete the SELECT clause for this variable and so on as many time as you need to add variable in the que
13. Exit MIKADO Figure 65 Automatic menu 9 2 1 Create a new configuration To create a new configuration connection to the database queries select New in the Automatic main menu and choose EDMED CSR CDI or EDMERP There are 2 tabs which enable to input information about e Connection to the database e Queries Ifremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Connection Queries Database Preset Driver class name Mysal Crece JDBC connect url Access Uan Ms Server PostgreSql Passwd T Sybase Other Test check Figure 66 New configuration 9 2 1 1 Define the JDBC connection parameter 1 Choose the database management system by clicking on the corresponding button Connection Queries Preset Database Oracle Driver class Access Excel JDBC connect url User Ms Server PostgreSql Passwd Sybase Other Test check Figure 67 Connection interface Select the database management system 2 Complete or replace the pre filled JDBC connect url field URL of database user name and password 1f required by your database Please do not modify the driver class name field If you have chosen the Other button to define an
14. FARA FRANCE f acronym organisation IFREMER SEISMIC MULTITRACE IFREMER acronym organisa MARGES acronym organisation IFREMER GM LITHOSPHERE acronym LITHOSPHERE organisati MEDRIFF acronym MEDRIFF organisation IFREMEI FLUID MINERAL amp BIOLOGICAL INTERACTION EXTREM INTERNATIONAL OCEANOGRAPHIC DATA AND INFORM MEDAR MEDATLAS acronym MEDAR MEDATLAS OCEANOGRAPHIC CRUISES CATALOGUE gt lt bj match filter use to set filter and lt return gt next match AL Samrat The EDMERP respectively EDMO list will be shortened and will contain only the projects respectively organizations of the selected country After that it 15 possible to match an other filter to find a specific value in the EDMERP or EDMO lists see 7 2 1 sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 7 3 Common screen characteristics for MIKADO manual input 7 8 1 Mandatory fields In the different interfaces the mandatory fields are highlighted with a red star Dataset Data holding centre Data contact Dataset id Dataset name Identification When Where what Reference Get data Completed by EDMED identifier Figure 16 Mandatory fields highlighted with a red star 7 8 2 Specific formats 7 3 2 1 MIKADO manual Specific formats like date are given as comment on the windows when necessary
15. IFREMER has designed the MIKADO tool for the generation of XML files that are entries for the following directories e the Marine Environmental Datasets EDMED e the Cruise Summary Reports CSR the Common Data Index to individual datasets CDI In the framework of the European program SeaDataNet IFREMER proposed to upgrade this tool to support new functionalities and to include the European Directory of Marine Environmental Research Projects EDMERP and the European Directory of the Ocean Observing System EDIOS in a later version VI is compliant with the SeaDataNet V1 XML schemas and uses the SeaDataNet web services for standards and common vocabularies The XML schemas used by MIKADO for EDMED CSR CDI and EDMERP are available on the SeaDataNet BSCW workspace at the following address login password required https www ifremer fr bscw bscw cgi 0 67755 SeaDataNet SDN Technical Task Team ISO Application of ISO 19115 within SeaDataNet V1 sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 2 Technical characteristics e Written in Java Language Version gt 1 5 e Available under multiple environments Microsoft Windows 2000 XP VISTA APPLE Unix Solaris e Linux Use of the SeaDataNet common vocabularies web services to update lists of values of the SeaDataNet common vocabularies need network connections in order to have up to dat
16. Who window sdn Mikado User Manual V1 SeaDataNet MIKADO V1 5 user Manual 26 01 2009 SeaDataNet MIKADO V1 5 user Manual Where to find the data Cruise Station Others Distributor Organisation name IFREMER IDM SISMER g SDNident Organisation name SDN EDMO 486 Collate centre Organisation name IFREMER IDM SISMER SDNident Organisation name 486 Distribution website Database Reference CTDF02 function code Value Dataset Access Restriction Access constraints SDNIdent access constraints unrestricted SDN L081 1 UN t Figure 48 CDI Where to find data window SDN V1 Mikado V1 5 Manual New CDI Manual Automatic Options Identification Where When T What Who Where to find the data Cruise Station Others Distributor Organisation name SONident Organisation name Collate centre Organisation name SDNIdent Organisation Distribution website Database Reference function Function code value Dataset Access Restriction Access constraints SDNident access constraints Figure 49 CDI Where to find data window ECOOP VI sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Identification Where When What Ho
17. gt Mapping gt Download from BODC C16 SeaDataNet Sea Areas Exit Import from a previous version of MIKADO C174 SeaDataNet Cruise Summary Report ship metadata Edit C320 International Standards Organisation countries C371 Ten degree Marsden Squares C381 Ports Gazetteer ICES ROSCOP DATA TYPES L021 SeaDataNet Geospatial Feature Types L031 SeaDataNet Measurement Periodicity Classes L05 SeaDataNet device categories L061 SeaDataNet Platform Classes L081 SeaDataNet Data Access Restriction Policies L101 SeaDataNet geographic co ordinate reference frames L111 Height and Depth Vertical Co ordinate Reference Datums L181 ROSCOP sample quantification units L231 SeaDataNet metadata entities L241 SeaDataNet data transport formats P021 BODC Parameter Discovery Vocabulary P081 SeaDataNet Parameter Disciplines 2 Select the vocabulary list you want to map automatically with an other one For example select the P021 list BODC Parameter Discovery Vocabulary sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual Mikado V1 5 Manual Automatic Options 2 New Save Generate gt Mapping gt Download from BODC C16 SeaDataNet Sea Areas Exit Import from a previous version of MIKADO C174 SeaDataNet Cruise Summary Report ship metadata Save as Ll C320 International Standards Organisation co
18. use the Options main menu and select On or Off in the Vocabulary Update sub menu sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 18 Mikado V1 5 Sec Manual Automatic Figure 5 Enable disable the automatic check of vocabularies After clicking on On radiobutton it Is not necessary to restart MIKADO MIKADO checks directly the version of the vocabulary lists and uploads locally the latest version of each list Check versionfor C7 vocabulary list Fieure 6 Download of the controlled vocabularies If there are any network problems MIKADO detects them and does not check the versions of controlled vocabularies You will have an error message but it will be possible to work off line sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual mikado xml 15019115Exception X SOAP error for SDN C 16 2 counts of InaccessibleWSDL Exception mikado xml 1 019115Exception Vocabulary update error for SDN EDMO SOAP error for SDN EDMO Failed to access the WSDL at http seadatanet maris2 nl ws ws_edmo asmx WSDL It failed with seadatanet maris2 nl Figure 7 SOAP errors 6 2 Use of the controlled vocabularies 6 2 1 Manual input The lists of values used by MIKADO Manual version are the SeaDataNet common vocabularies For each field associated with a list of values you have to choose the correct value
19. Cancel Figure 90 Select the configuration file If there is incoherence between the selected catalogue and the file opened for example the user has click on open CDI and then has selected an XML file related to EDMED the following message will appear mikado xml 15019115Exception Choose the correct menu to open your configuration file Automatic Open EDMED Automatic Generate EDMED Figure 91 Error message Wrong selected menu sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual MIKADO checks if all the mandatory variables had been filled in in the configuration file If a mandatory variable 15 missing MIKADO asks the user to complete it in the configuration file After that the user has to save the updated configuration file by selecting Save in the Automatic Menu and has to run again the generation by selecting Generate in the Automatic Menu Connection Queries Requests Main Query 5 Cdi identifier Single subqueries var01 Collate Centre var02 Measuring area type D var03 Datum of coordinate syste 3 var04 Dataset name 5 var05 Dataset id 5 var06 Revision date da 5 var08 Abstract dataset 5 var09 Data Holding Ce 3 var11 Intrument 3 var12 Platform 3 vart5 Cruise name 5 var16 Cruise short name 3 var17 Cruise start date 3 var18 Station name 3 var18 Station short name 3 var20 Station start date 3 var21 Sam
20. XML file with MIKADO 8 1 1 Manual EDMED input There are 3 main tabs for the EDMED information Dataset Data holding centre and Data contact The first tab gives the dataset description Figure 22 to Figure 28 and 1s divided into 7 tabs which enable to enter information about e Identification of the dataset which is very important The ID must be a UNIQUE LOCAL identifier Because the LOCAL ID is vital for the updating process it is through this LOCAL_ID than the central system will be able to recognise whether new contributions are updates of existing records or really new records e When and where the dataset was collected e What are the data in the dataset data themes parameters instruments summary related project References on the data set bibliography web site Where and how to get the dataset e Responsible of the dataset description sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Dataset Data holding centre Data contact Identification When Where What Reference Get data Completed by Dataset id TEST01 EDMED identifier Dataset name Jeu donn es TEST e ID must be a UNIQUE LOCAL identifier The LOCAL ID is vital for the updating process so the Central system will recognise whether new contributions are UPDATES of existing record OR really new records Figure 22 Dataset information window Identi
21. btest820 Access Excel kaa user Ms Server PostgreSql LJ xd Passwd 0000000 Sybase Other Test check JDBC driver loaded Connected to database Figure 75 Successful connection to the database Green message Connection Queries Database Preset 1 Driver class joracle jdhc driver OracleDriver L _______ y AEN WIRT AI JDBC connect url jidbc oracle hin josephine 1521 btest92 Access Excel user Ms Server PostgreSql Passwd 0000009 Sybase Other Test Check Unable to connect to database JDBC connect url jdbc oracle thin 8josephine 1521 btest92 User serveur java sql SQ LException Io exception Connection refused DESCRIPTION TMP VSNNUM 153093888 ERR 12505 ERROR STACK ERROR CODE 12505 4 Figure 76 Unable to connect the database Red message 9 2 1 2 Define the queries The MIKADO interface for writing queries is divided into 3 parts Anexpandable tree frame for query writing frame for query checking sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual SeaDataNet 68 C are kemi bra 2 Query writin 1 Expandable tree 4 2 Query checking Check Figure 77 Oueries interface query SELECT FROM Free text WHERE Free text ORDER BY Free text
22. click on the button The row will be deleted 7 1 1 3 Update row a field To update row field double click on it The selected row field will appear in white Update it Important To validate your update do not forget to press on Return The updated field appears in blue 7 1 2 Common vocabularies content table The following figure shows you examples of tables containing values from a vocabulary list Projets 1 SDNIdent F3IET j de X 7 1 2 1 row several rows add information in this kind of tables click on the 7 button A window which allows you to select a value in a vocabulary list opens e Ifyou want to add only one value into the table select the value and click on the Ok button sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual e Ifyou want to add several values into the table select the value and click on the Add button and do it again to the last value After selecting the last value click on the Ok button Keyword SeaDataNet Pan European Infrastructure fd Process Oriented Biochemical Studies of The Centr SDMdent SON EOMERP 9632 Monitouring of Basic Pelagic Ecosystem Parameters j Quantification of the Recent Ctenophore invader Beri Application of fishery vessel monitoring VMS and di Will the new invader Ctenophore Beroe ovata contra Bioindicators for Assessment of the Black
23. f INSTR DDHH24MISS var21 Sampling interval var22 Temporal resolution var28 Start date dataset v 4 l Check All Figure 85 Save As the configuration file Steps 1 and 2 9 2 3 Open an existing configuration It is possible to open an existing configuration file using MIKADO To do so select Open in the Automatic main menu and choose EDMED CSR CDI or EDMERP Next select the configuration file to open Mikado V1 5 Manual Automatic Options Save Save as Generate Mapping gt Fieure 66 Open a configuration file with MIKADO sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 78 Connection Queries Database Open configuration Driver class name JDBC connect url Look In query M a a i Excel 3 100778_K048_20060202135200 xml 4 CDI oracle res1 PostgreSql 100778 K049 20060202171200 xml C CDI oracle res1 Other 3 100778 KO29 20060131131900 xml 3 CDI oracle res1 Test D 100778 KO30 20060131162600 xml 3 CDI transsizenu check 3 CDI_13012009 xml CSR_13012009 3 CDI oracle res100778 xml 3 CSR oracle NE ICDI oracle res1 00778 Files of Type xmi X Open configuration Cancel Figur
24. holding centre defined in the previous window able to deal with requests concerning the data sets held by the centre sdn Mikado User Manual V1 26 01 2009 Dataset Data holding centre Data contact SeaDataNet MIKADO V1 5 user Manual Point of contact data contact Individual name Me Organisation name REMER IDM SISMER A 2 SDNident Organisation SON EDMO 486 Person title Contact information Phone 33 0 2 98 22 49 16 Fax 33 0 2 98 22 46 44 Address Delivery point Centre IFREMER de Brest BP 70 City PLOUZANE Administrative area Postal code 29280 Country France Email sismer ifremer fr Website http Awww ifre mer fr sismer Role Figure 30 Data Contact information window Here the phone and fax which are related to the organisation name retrieved from EDMO catalogue may be modified to be related to the identified person point of contact for the dataset Once all the information related to the EDMED dataset has been fulfilled the xml file will be created by selecting Save as in the Manual main menu The created XML file has a extension 8 1 2 Manual CSR input There are 5 main input tabs for the CSR information which are directly inspired by the original ROSCOP form e Identification of the cruise which is very important and the ID must be a UNIQUE LOCAL identif
25. interdite Pr par par Tosello V Fichaut M Harscoat V Larour M Maudire G V rifi par sdn_Mikado_User_Manual_V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Commentaires sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual History Version Date Status Comments j 12 06 2008 Creation from MIKADO VO manual 11 03 07 2008 Update MIKADO V1 4 1 1 ae 0 2008 ki sss Update of 7 3 2 date format difference between MIKADO manual and automatlic kamus Creation of 4 Installation of MIKADO download run shortcut Creation of 5 Main menu of MIKADO Creation of 6 2 2 2 Automatic mapping using webservices Update of 7 1 2 1 Add several values in a common vocabulary table Creation of 7 2 2 Find EDMERP or EDMO values of a particular country Update of 8 1 2 5 Map to select the Marsden squares Update of 8 1 3 CDI for ECOOP Creation of 8 3 Download EDMED entry form BODC Update of 9 2 1 1 Sybase database connection sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 6 Content 1 INTRODUCTION 8 2 TECHNICAL CHARACTERISTICS 9 3 REQUIREMENTS 10 4 INSTALLATION 11 41 DOWNLOAD MIKADO SOFTWARE 11 4 2 RUN MIKADO SOFTWARE 11 4 3 FOR WINDOWS CREATE AN MIKADO SHORTCUT ON YOUR DESKTOP 11 5 MAIN MENU OF MIKADO 14 51 MANUAL MENU 14 5 2 AUTOMATIC MENU 14 5 3 OPTION
26. map with the Marsden squares Clicking on one or several MARSDEN square s and clicking on Ok button add its their value s in the Geographic coverage table r Kpss r L i L l mama EIE TT wasa canal aul ETE TE Ee eee eee Marsden Square SOMCITI 374 BONCYT137 F HI 1 avr West longitude Esstiongeade Sout imode Norm aiie X MELLEL B Track chart Fike naga P File Figure 41 Geographical area Marsden Squares sdn_Mikado_User_Manual_V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual ag Once all the information related to the CSR has been fulfilled the xml file will be created by selecting Save as in the Manual main menu The created XML file has an xml extension 8 1 3 Manual CDI input There are 9 tabs for the CDI information Figure 42 to Figure 51 corresponding to the following basic questions defined in the CDI documentation e Identification of the CDI record which is very important The ID must be a UNIQUE LOCAL identifier Because the LOCAL ID is vital for the updating process it is through this LOCAL ID than the central system will be able to recognise whether new contributions are updates of existing records or really new records Where When What How Who Where to find the data Dataset information Cruise Station Othe
27. of contact holding centre Organisation name EN gt SDNident Organisation name name ofthe responsible organization Contact information Phone Address la Delivery Administrative Postal code Country Website Figure 19 Field tool tip sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 8 Manual entries of EDMED CSR CDI and EDMERP descriptions The manual version of the software 15 well adapted 1f there 15 a small amount of EDMED CSR CDI or EDMERP entries The input screens have been updated to be compliant with the new XML schemas and the lists of values used by MIKADO Manual are the SeaDataNet common vocabularies see 6 Mikado V1 5 Manual New EDMED Manual Automatic Options New 0 Data contact Open Download gt ng centre Save as Exit Address Website Role Figure 20 Manual menu 8 1 Create a new XML file To create a new XML file select New in the Manual main menu and choose EDMED CSR CDI or EDMERP sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Mikado V1 5 Manual New EDMED Manual Automatic Options New gt EDMED ct is CSR centre Data conta Download gt CDI ng centre av EDMERP t Organisation name E ct information Address Website Figure 21 Create a new
28. 021 mapped to P041 BODC Parameter Discovery Vocabulary mapped to Global Change Master Directory Science Keywords P021 mapped to P051 BODC Parameter Discovery Vocabulary mapped to International Standards Organisation ISO 19115 Topic Categories P021 mapped to P091 BODC Parameter Discovery Vocabulary mapped to MEDATLAS Parameter Usage Vocabulary P021 mapped to P092 BODC Parameter Discovery Vocabulary mapped to MEDATLAS Parameter Usage Vocabulary deprecated terms P021 mapped to P031 BODC Parameter Discovery Vocabulary mapped to SeaDataNet Agreed Parameter Groups _ Delete previous mapping s for this list Download mapping lt 4 Tick the check box if you want to delete the previous mappings manual or automatic of the selected list fremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Mikado V1 5 Manual Automatic Options 2 Mapping download for P021 BODC Parameter Discovery Vocabulary P021 mapped to P022 BODC Parameter Discovery Vocabulary mapped to BODC Parameter Discovery Vocabulary deprecates Download mapping Important The manual and automatic mappings are saved in the same file If you choose to delete the previous mappings you can loose a previous manual mapping and you will have to make it again if you
29. 28 Start date dataset iva Check All query SELECT FROM var sql Cantante vari to_char cam cam_datdeb YYYY MM DD4 var38 res es volk 1024 var08 resres obs 04 fic fic_ficnom var05 res res_cres _ plp plp_posetal _ to_char plp PLP_DATE YY YYMMDDHH24MISS na _Lto_charires res_datdeb YYYY MM DD T II fic cam res plp ndres res_cres ficfic_cres and res res_cfmt fmtfmt_cfmt and plp PLP_TYP AB F and plp PLP_NO res res cres and plp plp_poseta substr S INSTR 1 0 1 INSTRCS 1 2 INSTRCS 1 1 1 and plp PLP_DATE to date substr f INSTRCS 1 2 15 Y MMDDHH24MISS fremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual Mikado V1 5 Automatic EDMED N projets seadatanet logiciels Mikado test_mikado_v1_vt V1 5 automatique qu Sel Manual Automatic Options Co Save E 3 CDI oracle res100778 xml EDMED oracle CTI CDI oracle res104853 CTDF02 xml 3 EDMERP oracle M 3 CDI oracle res104853 CTDF02 sansstationnicruise xml D CDI oracle res107680 xml Mall char plp PLP DATE YY 3 CSR oracle NEOMARGES2006 xml D EDMED oracle CTDF02 xml MM DD2 T File Name CDI oracle res1 00778 xrnl PS fmtfmt cfmt and plp PLP and plp plp poseta substr
30. MIKADO Figure 2 First screen of the Mikado tool 5 1 Manual menu The first Manual menu Figure 2 enables you to run the manual way of MIKADO which allows to input manually the relevant information for all the fields in order to generate XML files for one directory 5 2 Automatic menu The second Automatic menu Figure 2 enables you to run the automatic way of MIKADO which allows to generate these descriptions automatically 1f information 1s catalogued In a relational database 5 3 Options menu The Options menu Figure 3 allows you o To enable the automatic check and download of the controlled vocabularies see 6 Ifremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual o select the data centre type SDN Vl is the type for the SeaDataNet partners ECOOP VI is the type for the ECOOP European Coastal sea Operational observing and Forecasting system partners Those two data centre types in MIKADO need to be identified in the CDI input for ECOOP partners the URL distribution website 1s free whereas for the SDN partners the URL distribution website is fixed see 8 1 3 Mikado V1 5 Manual Automatic Options Vocabulary Update Data centre type gt Figure 3 Options menu 5 4 2 menu The menu Figure 4 provides you information about the MIKADO tool Version and Date sdn Mikado User Ma
31. Net Sea Areas C174 SeaDataNet Cruise Summary Report ship metadata C320 International Standards Organisation countries C371 Ten degree Marsden Squares C381 Ports Gazetteer C77 ICES ROSCOP DATA TYPES j E I EDMERP European Directory of Marine Environmental Research Projects EDMO European Directory of Marine Organisations 1021 SeaDataNet Geospatial Feature Types L031 SeaDataNet Measurement Periodicity Classes L05 SeaDataNet device categories L061 SeaDataNet Platform Classes L081 SeaDataNet Data Access Restriction Policies L101 SeaDataNet geographic co ordinate reference frames L111 Height and Depth Vertical Co ordinate Reference Datums L181 ROSCOP sample quantification units L231 SeaDataNet metadata entities L241 SeaDataNet data transport formats P021 BODC Parameter Discovery Vocabulary P081 SeaDataNet Parameter Disciplines Figure 11 Edit local mapping For each vocabulary list you can access the mapping table and you can update it sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 06 modify the first column of the table local value by double clicking on the field you want to update delete a row by selecting the row and by clicking on the button delete all the rows by clicking on the button Important Do not forget to press on Return when you update a field i
32. S MENU 14 5 4 MENU 15 6 CONTROLLED VOCABULARIES 17 6 1 CHECK AND IMPORT THE CONTROLLED VOCABULARIES 17 6 2 USE OF THE CONTROLLED VOCABULARIES 19 6 2 1 MANUAL INPUT 19 6 2 2 AUTOMATIC GENERATION INCREMENTAL MAPPING 20 7 COMMON FUNCTIONALITIES 28 7 1 TABLES 28 7 1 1 FREE TEXT TABLE 28 7 1 2 COMMON VOCABULARIES CONTENT TABLE 29 7 2 VOCABULARY LIST 31 7 2 1 FIND A SPECIFIC VALUE INA VOCABULARY LIST 31 7 2 2 FIND EDMERP oR EDMO VALUES FOR A PARTICULAR COUNTRY 32 7 3 COMMON SCREEN CHARACTERISTICS FOR MIKADO MANUAL INPUT 33 7 3 1 MANDATORY FIELDS 33 fremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 7 7 3 2 SPECIFIC FORMATS 33 7 3 3 TOOLTIPS 34 8 MANUAL ENTRIES OF EDMED CSR CDI AND EDMERP DESCRIPTIONS 36 8 1 CREATE A NEW XML FILE 36 8 1 1 MANUAL EDMED INPUT 37 8 1 2 MANUAL CSR INPUT 42 8 1 3 MANUAL CDI INPUT 49 8 1 4 MANUAL EDMERP INPUT 54 8 2 OPEN AN EXISTING XML FILE 58 8 3 DOWNLOAD EDMED ENTRIES FROM BODC 59 9 AUTOMATIC GENERATION OF EDMED CSR CDI AND EDMERP XML FILES 62 9 1 GENERAL PRINCIPLE 62 9 2 CONFIGURATION OF THE TOOL 63 9 2 1 CREATE A NEW CONFIGURATION 63 9 2 2 SAVETHE CONFIGURATION FILE 76 9 2 3 OPEN AN EXISTING CONFIGURATION 77 9 3 RUN THE AUTOMATIC GENERATION 78 sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 8 1 Introduction In the framework of the European program SEA SEARCH
33. Sea Ecos Monitoring of anchovy and sprat nutritional condition The Marine Research Programme HAV90 acronym Monitoring and managing of European seagrass beds Consequences of weather and climate changes for m Dissolved organic matter DOM in coastal ecosystem Microbiological element cycling in coastal environmer Sustainable exploitation of Blue Mussels in Denmark Stand dynamics of eelgrass Zostera marina and its Alien matter and metals organisation f 4 The Ecology of marine plankton systems acronym Structure and functioning of marine pelagic systems Geomicrobiology of oceanic oxygen deficiency zones Effects of nutrient release from Mediterranean fish fai Improving status of coastal lagoon Tryggelev Nor Dert The marine carbon cycle from North to South along th Identification and quantification of factors influencing SeaDataNet Pan European Infrastructure for Ocean LL SEADATANET The selected value s will appear in the table Projects SONIdent E3IE Pan European Infrastru SOM EOMERP 8532 7 1 2 2 Delete a row To delete a row in a table select the row to delete by clicking on it and click on the button The row will be deleted 7 1 2 3 Update a row To update a row in a table select the row to update by clicking on it and click on the button A window which allows you to select a value in a vocabulary lis
34. aNet MIKADO V1 5 user manual For Sybase database connection the part charset of the JDBC connect URL is optional and allows to choose the right set of characters Ex jdbc sybase Tds wallis 7545 quadrige charset iso 1 Connection Queries Select Access File Database Driver class Lookin C test_mikado_v1_ i Oracle JDBC connect t C3v14 i Excel se Eiv1 5 r PostgreSql Passwd Other File Name Files of Type mdb t Cancel Figure 73 Access and Excel select the database file Database Driver class name sun jdbc adbce lIdbeodbcDriver JDBC connect url ste autormt example databasetaccessicdi training course 2 mdb User Passwd fo Figure 74 Pre filled connection parameters for Access and Excel 3 Check the database connection using the Check button If MIKADO cannot connect to the database check connection parameters user and password For Microsoft Access and Excel check ODBC parameters too Refer to your database and JDBC driver documentation sdn_Mikado_User_Manual_ V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Connection Queries Database Preset Driver class name oracle jdbc driver OracleDriver MEN ka C JDBC connect url jjdbc oracle thin cojosephine 1521
35. ables to input the information about several type of measurements Measurement Geographical area General information Mooring Identification Datatype Reference date Individual name Description Unit Number di Description de number of sta 22 ICTD stati 2006 01 25 titi Current m 2006 01 25 Mr Boo description number of 5 22 description number of de 2 Samples information Thermisto 2006 01 25 Miss Beee Figure 39 Measurement information window 8 1 2 5 Geographical area information The Geographical area window enables to input information about the geographical area of the cruise 26 01 2009 sdn Mikado User Manual V1 SeaDataNet MIKADO V1 5 user manual Identification General information i Geographical area Sea areas Sea area SDNident E Geographic coverage textual description x Free text describing the geographic coverage Geographic coverage Marsden square SDNident Geographic coverage bounding box West longitude East longitude South latitude North latitude LI Track chart File name I eei File type zJ Figure 40 Geographical area window If a track chart 15 available for the cruise browse to select the file name File description must be track chart File type can be GML GIF PNG JPEG or PDF In Geographic coverage frame the button opens a
36. al V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Free text describing the geographic coverage 3015 SWEREF99 18 45 Code World Geodetic System 19 3016 SWEREF99 20 15 3017 SWEREF99 21 45 3018 SWEREF99 23 15 3006 SWEREF99 TM 4616 Selvagem Grande 2943 Selvagem Grande UTM zone 28N 4299 TM65 29902 TM65 Irish Grid 4300 TM75 29903 TM75 Irish Grid 4304 Voirol 1875 4811 Voirol 1875 Paris 30491 Voirol 1875 Nord Algerie ancienne 30492 Voirol 1875 Sud Algerie ancienne 4671 Voirol 1879 4821 Voirol 1879 Paris 30493 Voirol 1879 Nord Algerie ancienne 130494 Voirol 1879 Sud Algerie ancienne 4979 World Geodetic System 1984 3D 4322 World Geodetic Sustem 72 _ SDNident Code S08 1101 2 4979 7 2 2 Find EDMERP or EDMO values for a particular country MIKADO allows to find the EDMERP or EDMO values for a particular country in the EDMERP or EDMO lists To do so select the country in the dropdown list as shown in the following figure Country France 7636 MYTIMED Study of seasonal and interanual variation of The Impact of Appendicularia in European Marine Eco SEISMIC MULTITRACE INSU organisation SOFIA acronym SOFIA organisation CETP Centr FASE SEDIMANCHE acronym organisation IFREM EXTRAPLAC acronym EXTRAPLAC organisation
37. al V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Mikado V1 5 Manual Automatic Options 2 Open m conf dist languages 1515 mapping c sql File Name Files of Type xml m Open Figure 60 Select the XML file to open Update your information using the MIKADO interface and save your modifications by selecting Save or Save as in the Manual main menu 8 3 Download EDMED entries from BODC MIKADO V1 5 includes a functionality to download EDMED entries from the EDMED central catalogue managed by BODC This functionality allows you to download one of your EDMED entries and to update it before sending it again to the EDMED central catalogue To download an EDMED entry l Select Download gt EDMED from BODC in the Manual main menu sdn_Mikado_User_Manual_ V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Figure 61 Download EDMED from BODC 2 Fill in the Dataset id and the Collate centre fields for the EDMED entry you want to download and click on Download button BEES Collate centre Organisation name a National Oceanographic Data Committee NODC Dent Organisation name SDN EDMO 575 Contact inforiTYtien Phone Fax Address Delivery point City Administrative area Postal code Country Email Website Figure 62 Select the EDMED entry to download
38. be exported This request must return only one column which is the identifier primary key of each entry and that will be used for sub queries The returned identifiers could be numerical or textual o the single subqueries These queries return only one row for one identifier returned 1n the main query o the multiple subqueries These queries return 1 to n rows for one identifier returned In the main query The character indicates the identifier of the entry as it as been returned by the main query One identifier symbol must be used in each sub query WHERE condition to identify the entry within the list It will be automatically replaced by the current identifier in the list If identifiers are non numerical must be enclosed by quotes Select station name from mikafdo station where station id or if non numerical For all these queries the SQL syntax for Oracle Excel MySQL and SQL variables must be adapted to your own data base 9 2 1 2 1 Main query fremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 1 Click on the main variable in the expandable tree 2 Fulfil the main query in the query frame 3 Check the query using the check button see 9 2 1 3 Connection Queries Requests query C Main Cdi identifier SELECT var sql station_id o 7 Singles p e C Multiples fixed FROM mikado cruise mikado datas
39. d date dataset gt var30 Minimum depth of ins SERE 5 l sql var31 Maximum depth of ins var34 Vertical datum lvar25 var35 Water depth i var36 Distributor var39 Data size var40 Data website var41 Database reference FROM itiple subqueries L var07 Originators dataset WHERE ODDDDDODDI Z 9 C var 10 Parameters DOG var13 Projects var 14 Access Restriction 24 West longitude var25 East longitude var26 South latitude var27 North latitude L ORDER BY Test var37 Format name i var38 Format version v 4 10200200 check Check All 2 Complete the corresponding SELECT FROM WHERE ORDER BY clauses for this variable and associated variables in the query frame Don t forget that one identifier symbol must be used in each sub query WHERE condition to identify the entry within the list It will be automatically replaced by the current identifier in the list sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual var28 Start date dataset query Y var29 End date dataset 7 var30 Minimum depth of ins SELECT var v sql var27 ar31 Maximum depth of ing FRS sm jj Ter AA jog dig var26 south latitude var34 Vertical datum var25 L L var35 Water depth var24 west longitude var36 Distributor 5 var39 Data size D var40 Data websi
40. datam dias aj ide mido id nud cnd 2 t D vacio wamum seem etu vasmum seem ef y vaca cal dium Dy caca depth cara Dazin ase rennes Clon dates kd mido cue crie id nietas 2 LEG 1 Meable te query Figure 83 Wrong query Red message sdn Mikado User Manual V1 26 01 2009 9 2 2 Save the configuration file SeaDataNet MIKADO V1 5 user manual Once the connection parameters and the queries have been fulfilled and checked you can save the configuration file by selecting Save or Save as in the Automatic menu The configuration file has an xml extension F3 Mikado V1 5 Manual Automatic Options 5 New Conn ries Save Save as ueries dlate Centre Generate gt easuring area type Mapping gt atum of coordinate Exit ataset name var05 Dataset id 5 var06 Revision date datas 5 var08 Abstract dataset 5 var09 Data Holding Centre 3 var11 Intrument 5 var12 Platform 5 var15 Cruise name 5 var16 Cruise short name 3 var17 Cruise start date 5 var18 Station name 3 var19 Station short name 3 var20 Station start date 3 var21 Sampling interval 3 var22 Temporal resolution 7 var28 Start date dataset __ gt
41. e lists of values But Mikado works offline once the list are up to date sdn Mikado User Manual V1 26 01 2009 fU T ae lt o SeaDataNet MIKADO V1 5 user Manual 3 Requirements gt Make sure that the java version on your computer is gt 1 6 gt To know if Java is available on your computer in the right version follow these steps Open Start menu then Execute On the displayed window enter cmd then click on OK button Enter java version gt Check if command has been executed J fnot download the last java version at http java com en download index jsp Else check the version displayed The version should be greater than or equal to 1 6 ocv C WINDOWS system3 cmd exe Microsoft Windows version 5 1 2686 Copyright 1985 2661 Microsoft Corp java version java version 1 6 8 45 TETTE EAE UP SE Runtime Environment build 1 6 0 05 0132 HotSpot TMi Client UM Chuild 18 8 519 mixed mode sharing Figure 1 Check Java version installed on your computer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 4 Installation 4 1 Download MIKADO software The last version of MIKADO is available and downloadable on the SeaDataNet website http www seadatanet org services software _1 mikado To install MIKADO you have to download the MIKADO zip file
42. e 87 Select the configuration file to open If there 1s an incoherence between the selected catalogue and the file opened for example the user has click on open CDI and then has selected an XML file related to EDMED the following message will appear mikado xml 15019115Exception Choose the correct menu to open your configuration file Automatic Open EDMED Automatic Generate EDMED Figure 66 Error message Wrong selected menu 9 3 Run the automatic generation The second step in MIKADO Automatic version 15 the XML generation The tool must have been configured before generating the XML files see 9 2 1 Select Generate in the Automatic Menu 2 Select the catalogue you want to generate EDMED CSR CDI or EDMERP sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual Mikado V1 5 Manual Options 2 New Save Save as Generate gt EDMED Ap Mapping gt CSR j Exit CDI 4 EDMERP f ff N MIKADO Figure 89 Automatic generation of XML files 3 Select the configuration file Mikado V1 5 Manual Automatic Options 2 Open configuration m STE Y EDMED oracle CTI 3 CDI oracle res104853 CTDF02 xml 3 EDMERP oracle M D CDI oracle res104853 CTDF02 sansstationnicruise xml D CSR_oracle_NEOMARGES2006 xml D EDMED oracle CTDF02 xml File Name CDI oracle rest 00778 xml Open configuration
43. e projects related to the cruise e the ship ship name and ship type research opportunity naval survey vessel e the parameters measured during the cruise and the instruments used for these measurements e the responsible party person s in charge of the scientific work chief scientist and laboratory responsible for coordinating the scientific planning of the cruise e the information about the collate centre sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual dentification Generalinformation Mooring Measurement Geographical area Objectives and brief of cruise Parameters Responsible party Collate center Revision date 21 05 2007 dd mmiyyyy 25 01 2007 Period Start date 21 01 2006 ddimmiyyyy 25 02 2007 End date 25 02 2006 ddimmiyyyy 25 02 2007 Country of departure Port of departure e Keyword France Keyword Boulogne 22 SDNident SDN C320 1 FR SDNident SDN C381 8 BSH25 Country of return Port of return Keyword France Keyword St Nazaire 22 SDNident SDN C320 1 FR SDNident SDN C381 8 BSH4218 Dataset Access Restriction Access constraints SDNIdent access constraints SDN L081 1 UN Lx e Pa Figure 32 General information window Cruise Identification General information Mooring Measurement Geographical area Cruise Objectives and brief of cruise Ship Responsible party C
44. ery To do so click on the var column an arrow will appear allowing you to sort the variables by clicking on it sdn_Mikado_User_Manual_V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Connection Queries 7 Requests query o Y Main GJ Query 3 Cdi identifier SELECT sql 9 Single subqueries Bi name var01 Collate Centre var02 Measuring area type D var03 Datum of coordinate 3 var04 Dataset name D var05 Dataset id var06 Revision date datas FROM mikado dataset 3 var08 Abstract dataset var09 Data Holding Centre WHERE di idenlifer vart 1 Intrument x var 12 Platform vari 5 Cruise name var15 Cruise short name ar17 Cruise start date ORDER BY DDDDDDU yar21 Sampling interval check Check All 6 Check the query using the checking frame see 9 2 1 3 9 2 1 2 3 Multiple subqueries the XML variables are listed 1n the expendable tree The mandatory ones are written in bold characters they must be fulfilled null values are not allowed for mandatory variables The number of multiple queries and the list of variables per queries are pre defined Once a variable has been fulfilled it 1s highlighted in green in the expandable tree To fulfil a multiple query l Select the first variable in the expandable tree to fulfil the corresponding multiple query Connection Queries var28 Start date dataset x query var 29 En
45. et mikado station WHERE rnikado station dataset id mikado dataset dataset id and mikado_ dataset cruise id mikado _ cruise cruise id and mikado cruise cruise name CITHER 2 LEG 1 ORDER BY Test 418 ET Figure 80 Main query 9 2 1 2 2 Single subqueries All the XML variables are listed in the expendable tree The mandatory ones are written in bold characters they must be fulfilled null values are not allowed for mandatory variables One to n single subqueries can be written each of which can contain as many variables as necessary Once a variable has been fulfilled it is highlighted in green in the expandable tree To create a single query l Select the first variable in the expandable tree to create a new query keke to ari pcd ji 4 wall ena war t7 NUIT CS il ee neum wan OP Dual ed Select an Opin was laser Alu ae wan OB Aet act dad aet k var F3 ier E aria timi TE ET Lhit AB 2 Complete the corresponding SELECT for this variable in the query frame sdn Mikado User Manual V1 26 01 2009 1 Connection Queries SeaDataNet MIKADO V1 5 user manual Requests C Main Query 7 Cdi identifier 73 Single subqueries 5 varo Collate Centre var02 Measuring area typ var03 Datum of coordinate 5 var04 Dataset name 5 var05 Dataset id
46. fication The identification of the dataset is the unique LOCAL dataset ID and the dataset name Both fields are mandatory Dataset Data holding centre Data contact Identification When Where What Reference Get data Completed by Description Description du jeu de donr Period Start date 1991 2007 End date yyyy 2008 Revision date 21 05 2008 00 00 00 hh mm ss 24 hr 25 01 2007 15 05 00 Figure 23 Dataset information When sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Geographic coverage textual description Free text describing the geographic coverage World wide gt age Sea areas Sea area SDNident X North Atlantic Ocean SDN C16 1 23 South Atlantic Ocean DN C16 1 32 North Pacific Ocean DN C16 1 57 South Paci SDN C16 1 61 Parameters SDNIdent Temperature ofthe water column SDN P021 26 TEMP of the water column SDN P021 26 PSAL SDN P021 26 GWDR SDN P021 26 WVST Instruments SDNIdent CTD profilers SDN L05 4 130 sealevelrecorders SDN L05 4 111 SDN L05 4 110 satellite tracking system SDN L05 4 121 Abstract Abstractofthedataset __ Purpose 1 Figure 25 Dataset information window What fremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 40 Dataset Da
47. for the EDMERP information which enable to input information about e General information Geographical area Data themes Reference Coordinator Partners Collate Centre 7 General information Geographical area Data themes Reference Coordinator Partners Collate centre EDMERP identifier TEST Revision date 21 05 2008 00 00 hh mm ss 24 hr 25 01 2007 15 05 00 Project name PROJECT TEST Project reference reference project TEST Project acronym ACRONYM TEST Associated programme Title Programme id Revision date ddimmyyyy 25 01 2007 Abstract Abstract of TEST 22 Period Start date 01 01 2007 00 00 00 ddimmiyyyy hh mm ss 24 hr 25 01 2007 15 05 00 End date 31 11 2 2009 00 00 00 dd mm yyyy hh mm ss 24 hr 25 02 2007 12 00 00 Project website Figure 52 EDMERP General information window General information Geographical area Datathemes Reference Coordinator Partners Collate centre Sea areas Sea area SDNIdent Indian Ocean SDN C16 1 45 Geographic coverage textual description Free text describing the geographic coverage description ofthe geographic coverage Figure 53 EDMERP Geographical area window sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Ge
48. ft Access Microsoft Excel Microsoft SQLServer MySQL POSTGRES Sybase Please refer to the web site http developers sun com product jdbc drivers for more information If the driver you want to use is not released in MIKADO you can download it from ad hoc websites and copy it in the dist lib MIKADO directory CSR XML files MIKADO Automatic forSeaDataN Java code gt E ERP DI JDBC Java DataBase Connectivity _____ EXCEL File DATABASE Web services C Native Drivers Bridge Drivers ommon E using Microsoft ODBC i ACCESS EXCEL SQL SERVER vocabularies OS GES SQLServer Other Drivers Downloaded from ad hoc Websites Copied in the dist lib MIKADO directory Figure 64 MIKADO Automatic way The different steps of MIKADO automatic version are Configuration of the tool o Definition of the connection parameters to access the local database fremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual o Definition of the queries to retrieve the information in the local database Saving of the configuration and the queries Generation of the XML files 9 2 Configuration of the tool MIKADO VI provides a help for JDBC connection connection checking and SQL query writing query checking Mikado V1 5 BE Automatic Options New gt EDMED Open CSR Generate Mapping
49. ier Because the LOCAL ID is vital for the updating process it is through this LOCAL ID than the central system will be able to recognise whether new contributions are updates of existing records or really new records General information about the cruise Information about the moorings Information about the measurements done during the cruise Information about the geographical areas of the cruise 8 1 2 1 Identification of the cruise The identification of the cruise is the unique LOCAL cruise ID and the cruise name Both fields are mandatory sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual as identification General information Mooring Measurement Geographical area Cruise id FI352006223310 CSR identifier Cruise name CRUISE TEST The ID must be a UNIQUE LOCAL identifier The LOCAL_ID is vital for the updating process so the Central system will recognise whether new contributions are UPDATES of existing records OR really new records Figure 31 Unique identification of a cruise 8 1 2 2 General information about the cruise This window is divided into 6 tabs Figure 32 to Figure 37 which enable to input information about e the cruise identification begin and end dates ports of departure end return e the objectives of the cruise purpose and nature of the cruise as to provide the context in which the data were collected and th
50. in Query 5 Cai identifier SELECT var sql 3 m 9 Single subqueries var01 collate center A var01 Collate Centre VADAT dataset name pa X KI Di a FROM WHERE ORDER BY Test r E check 5 Fulfil the FROM WHERE and ORDER BY clauses of the query Connection Queries 3 Requests C Main Query 5 Cdi identifier cJ Single subqueries 5 var01 Collate Centre D var02 Measuring area type D var03 Datum of coordinate 7 var04 Dataset name F D var05 Dataset id 3 var06 Revision date datas D var08 Abstract dataset 5 var09 Data Holding Centre 3 var11 Intrument 5 var12 Platform D var15 Cruise name varl 6 Cruise short name r var17 Cruise start date var18 Station short name h L 7 vari 8 Station name var20 Station start date var21 Sampling interval L Check r1 L Dl query SELECT var ________ sql m ry 01 collate_centre wards dataset l E FROM mikado dataset WHERE identifierz ORDER BY Test check amg Don t forget that one identifier symbol must be used in each sub query WHERE condition to identify the entry within the list It will be automatically replaced by the current identifier in the list It is possible to sort the different variables of a particular qu
51. in the corresponding common vocabulary list To do so click on the icon on the right of the field Wiese Van Wal Where la final Ea dala Crue Sato Olei dpi Dos Weal Earl Der unte T Hom lbh x ar eg Aids Types Dr dE Er lx Figure 8 Em ield Click on the icon to fulfill it A new window opens allowing you to select a value in a list Select the corresponding value and click on the OK button on the bottom of the window sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual V Mikado V1 5 Manual New CDI 3015 SWEREF99 18 45 Manual Automatic Options 7 3016 SWEREF99 20 15 3017 SWEREF99 21 45 3018 SWEREF99 23 15 3006 SWEREF99 TM Geographic coverage bounding box 4616 Selvagem Grande West longitude East longitude South latitude 2943 Selvagem Grande UTM zone 28N 4299 TM65 29902 TM65 trish Grid 4300 TM75 29903 TM75 Irish Grid Datum of coordinate system d 4304 Voirol 1875 4811 Voltol 1875 Paris 30491 Voirol 1875 Nord Algerie ancienne SOMident Code SDN L101 2 4979 30492 Voirol 1875 Sud Algerie ancienne 4671 Voirol 1879 4821 Voirol 1879 Paris 30493 Voirol 1879 Nord Algerie 0 d Alaerie a Identification Where When What How Who Whe Vertical element Minimum instrument depth Maximum instrument depth Unit of measure
52. n the mapping table Once the mapping table 1s updated you have to save it by clicking on the button Mikado V1 5 BR SIE Manual Automatic Options 2 Mapping SDN C381 Ports Gazetteer Mapping for C381 list Delete 1 row all rows 9095 SON Value Edit and modify Figure 12 Update local mapping C381 list 6 2 2 4 Import the mapping For each release of MIKADO the local mapping cannot be delivered with the software because it Is a local mapping depending on each local database So it 1s possible to import the mapping already done with a previous release of MIKADO To do so select Mapping Import from a previous version of MIKADO 1n the Automatic main menu sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual Mikado V1 5 Automatic Options New Save Save as Generate gt Figure 13 Import local mapping This opens a window where you have to browse your directories to tell MIKADO where the path of the previous installation of MIKADO was m Import Mapping choose previous installation directory of Mikado soft Lookin mikado V1 4 1 File Name N projetsiseadatanellogicielsiMikadoimikado_ 1 41 Figure 14 Select the path of the previous installation of MIKADO Then click on Import mapping button and you will get all the mapping to your local database that you have already done
53. neral information Geographical area Data themes y Reference Coordinator Partners Collate centre Data Themes SDNIdent Cross discipline SDN P081 3 DS06 Figure 54 EDMERP Data themes window mm MM PUY OUL General information Geographical area Datathemes Reference Coordinator Partners Collate centre Titie Publication date Author Editor pa Figure 55 EDMERP Reference window sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual General information Geographical area Data themes Reference Coordinator Partners Collate centre Project coordinator Individual name MAILLARD Catherine Organisation name IFREMER IDM SISMER P3 SONIdent Organisation name SDN EDMO 486 Contact information Phone 33 0 2 98 22 4916 Fax 33 0 2 98 22 46 44 Address Delivery point Centre IFREMER de Brest BP 70 City IPLOUZANE Administrative area Postal code 29280 Country France Email sismer ifremer fr Website http ifremer frisismer Figure 56 EDMERP Coordinator window Here the phone fax and email which are related to the organisation name retrieved from EDMO catalogue may be modified to be related to the identified person the project coordinator
54. nual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual MIKADO Figure 4 About Mikado menu sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 6 Controlled vocabularies 6 1 Check and import the controlled vocabularies MIKADO includes functionality to import the controlled vocabularies EDMERP and EDMO lists for CDI EDMED CSR and EDMERP When MIKADO starts it checks automatically the version of the vocabulary lists and uploads locally the latest version of each list The SeaDataNet controlled vocabularies used by MIKADO are available at the following address http seadatanet maris2 nl v_bodc_vocab welcome aspx MIKADO uses the following lists 174 320 371 381 eaDataNet device categories 021 eaDataNet Geospatial Feature Types 031 eaDataNet Measurement Periodicity Classes 061 eaDataNet Platform Classes 081 eaDataNet Data Access Restriction Policies 101 eaDataNet geographic co ordinate reference frames 111 eight and Depth Vertical Co ordinate Reference Datum 181 OSCOP sample quantification units eaDataNet metadata entities 241 eaDataNet data transport formats 021 ODC Parameter Discovery Vocabulary 081 eaDataNet Parameter Disciplines uropean marine organisations uropean marine projects O m r r r r r I I I J Uo It 15 possible to enable disable the automatic check of the lists and to work offline To so
55. ollate center Objectives purpose of the cruise Objectives ofthe crusies Projects SDNIdent ACOUSTICS FISHERIES SDN EDMERP 9573 Figure 33 General information window Objectives and brief of Cruise sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Identification Mooring Measurement Geographical area Cruise Objectives and brief of cruise Parameters Responsible party Collate center Ship name Keyword Atalante SDNident SDN C174 10 35A3 Platform class dessen B Keyword research vessel 22 SDNident SDN L061 6 31 Figure 34 General information window Ship Identification Generalinformation Mooring Measurement Geographical area Cruise Objectives and brief of cruise Ship Parameters Responsible party Collate center Parameters SDNident Temperature of the water column SDN P021 26 TEMP Salinity ofthe water column SDN P021 26 PSAL Turbulence in the water column SDN P021 26 EPSI Instruments SDNIdent CTD profilers SDN L05 4 130 active fluorometers SDN L05 4 353 Figure 35 General information window Parameters sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Identification Generalinformation Mooring Measurement Geographical area Cruise Objectives and brief of cruise Parameters Res
56. other database management system you will have to fufill the JDBC connect url field and also the driver class name field to connect to your database make sure that the driver file 15 saved in the dist lib MIKADO directory sdn Mikado User Manual V1 26 01 2009 SeaDataNet m E MIKADO V1 5 user manual Database Driver class name IrommysgljdbcDrver vegl jdbe Driver JDBC connect idbc mysqli nocalhostdatapase User Passwd 1 Figure 68 Pre filled connection parameters MySQL Database Driver class name loracle jdbc driver GracleDriver JDBC connect url idhc oracl ethinsererportinstance User Passwd Figure 69 Pre filled connection parameters for Oracle Database Driver class name Itom microsoft jdbc sqlserver SQLServerDriver JDBC connect url ame instancenamese partHumberpraperty v User Passwd Figure 70 Pre filled connection parameters for SOLServer Database Driver class name org postgresql Driver JDBC connect url idbc postqresaql serverinstance User ly Passwd J Figure 71 Pre filled connection parameters for PostereSOL Database Driver class name Irom sybase jdbc3 jdbc EybDriver JDBC connect url idbc svbase Tds serverpoartlinstance charset User Passwd Figure 72 Pre filled connection parameters for Sybase fremer sdn Mikado User Manual V1 26 01 2009 SeaDat
57. pling interval 4 gt Check All query SELECT var sql char res res datfin HH24 MI SS res res cbase cam cam crnom cam cam crno char cam cam datdeb nY MM DD resres volk 1024 Missing mandatory information Create a new Query for var05 No cancel and plp PLP TYPTA oseta substr i INSTRCS 4 Select the directory in which you want to create the export XML files Mikado V1 5 Set Manual Automatic Options Export directory m SISTI test File Name eadatanetilogiciels Mikadottest_mikado_v1_ 1 5iautomatiqueloutput Export Cancel Figure 92 Choose the output directory 5 Control the XML generation SQL error XML error A progress bar and a percentage indicate the progress of the generation and a Cancel button allows to cancel the generation sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual SeaDataNet CDI Automatic id 1100778 KO30 20060131162600 count 40 114 Figure 93 XML generation Ongoing work 6 During the generation complete the mapping 1f necessary see 6 2 2 for more details Mikado V1 5 Automatic Generate CDI N projets seadatanet logiciels Mikado test_mikado_v1_vt V1 5 automatigq MES Manual Automatic Options KS
58. ponsible party Collate center Individual name Organisation name toto LABORATORY of OCEANOGRAPHY and CLI Chief scientist LABORATORY of OCEANOGRAPHY and CLI Organisation name LABORATORY of OCEANOGRAPHY and CLIMATE LOCEAN Originator centre Figure 36 General information window Responsible par Identification General information Mooring Measurement Geographical area Collate center Collate center Parameters Cruise Objectives and brief of cruise Responsible party Collate centre Organisation name IFREMER IDM SISMER SDNident Organisation name SDN EDMO 486 Contact information Phone Fax Address Delivery point City Administrative area Postal code Country Email Website Role Figure 57 General information window Collate centre 8 1 2 3 Moorings information Information about moorings are not mandatory the window enables to input the information about several moorings sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Identification General information Mooring Measurement Geographical area Data type Reference date Individual name Current m 2006 01 25 Mr Booo Moorings information Figure 36 Mooring information window 8 1 2 4 Measurements information Information about measurements are not mandatory the window en
59. r relevant information The content of the Where to find the data tab will depend on the selected options In Data centre type in the Options main menu e If the selected data centre type is SDN VI the URL distribution website will be fixed and the user could not change it see Figure 48 e If the selected data centre type is ECOOP VI the URL distribution website will be free see Figure 49 sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Where to find the data Cruise Station Dataset id 1234 CDI identifier Dataset name IDATASET 1234 e ID must be a UNIQUE LOCAL identifier The LOCAL ID is vital for the updating process so the Central system will recognise whether new contributions are UPDATES of existing record OR really new records Figure 42 CDI Identification window Identification i Where to find the data Cruise Station Others Geographic coverage bounding box West longitude East longitude South latitude North latitude 25 45 Datum of coordinate system Measuring Area Type Code i fp E object type code value point 22 SDNident Code Vertical element Minimum instrument depth 0 Maximum instrument depth 3000 Unit of measure Name Vertical datum Datum identifier D Code French Naval Chart Datum 22 SDNident Code ISDN L111 3 D07 Water depth 9999 Figure 43 CDI Where window sdn Mikado User Manual V1 26 01 2009
60. ram Type a for this shortcut MIKADO Click Finish to create the shortcut sdn_Mikado_User_Manual_V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Lg 4 The MIKADO shortcut will appear on your desktop 5 You can associate the MIKADO Icon with the Mikado shortcut To do so right click on the Mikado shortcut and select Properties Click on the Change icon button in the MIKADO Shortcut Properties window General Shottcfs Compatibility r3 Shortcut to MIKADO Target type Application Target location vbuzzer Target C softwerenikado_1 5 bat Start in C softwarenikado_V 1 5 Shortcut key None Run Normal window Comment J 6 Click on the Browse button and select the Mikado ico file provided in the MIKADO directory And click on OK button Change Change kon Look l or icons in thas Look in thes C rhkado Vi Dre mo ect an icon From tha lat bekar an icon From the lat beoe Jes 55 3 gt 5 x OW 7 The MIKADO icon will appear on your desktop sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 5 Main menu of MIKADO When you run MIKADO tool you can access four different menus Manual menu Automatic menu Options menu 9 menu Mikado V1 5 Manual Automatic Options W
61. ry Requests La E Main Query M 5 Cdi identifier Single subqueries var01 Collate Centre D var02 Measuring area type var03 Datum of coordinate D var04 Dataset name var05 Dataset id 3 var06 Revision date datas 5 var08 Abstract dataset 5 var09 Data Holding Centre Y vart t Intrument 5 var12 Platform 7 vart5 Cruise name D var16 Cruise short name var Cruise start date 3 var1 Station name 7 var19 Station short name 3 var20 Station start date D var21 Sampling interval 1 H Check All n Choose var query SELECT ar02 Measuring area type ar03 Datum of coordinate system ar06 Revision date dataset 08 Abstract dataset ar09 Data Holding Centre FROM ar16 Cruise short name WHERE ar17 Cruise start date ORDER BY Test f l check sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Connection Queries xs 3 var02 Measuring area type 3 var03 Datum of coordinate 5 var04 Dataset name 5 var05 Dataset id var06 Revision date datas 7 var08 Abstract dataset D var09 Data Holding Centre 3 11 Intrurnent var12 Platform 3 var15 Cruise name Y var16 Cruise short name vari Cruise start date 7 varig Station name D var19 Station short name 7 var20 Station start date 3 var21 Sampling interval Check All A Requests query Gj Ma
62. s l Select Mapping gt Download from BODC in the Automatic main menu The available vocabulary lists appear in a dropdown list sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual LS Mikado V1 5 MIE Manual Options 2 New gt Save Save as Generate gt Mapping gt Download from BODC gt C16 SeaDataNet Sea Areas Exit Import from a previous version of MIKADO C174 SeaDataNet Cruise Summary Report ship metadata Edit C320 International Standards Organisation countries C371 Ten degree Marsden Squares C381 Ports Gazetteer C77 ICES ROSCOP DATA TYPES 1021 SeaDataNet Geospatial Feature Types L031 SeaDataNet Measurement Periodicity Classes L05 SeaDataNet device categories L061 SeaDataNet Platform Classes L081 SeaDataNet Data Access Restriction Policies L101 SeaDataNet geographic co ordinate reference frames L111 Height and Depth Vertical Co ordinate Reference Datums L181 ROSCOP sample quantification units L231 SeaDataNet metadata entities 1241 SeaDataNet data transport formats P021 BODC Parameter Discovery Vocabulary P081 SeaDataNet Parameter Disciplines MIKADO checks the available mappings If no mapping exist for a list the vocabulary list will appear painted with grey in the dropdown list and the user can not select it Mikado V1 5 BUE Manual Options 2 New gt Save Save as Generate
63. t opens Select the value and click on the OK button sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual 7 2 Vocabulary list 7 2 1 Find a specific value in a vocabulary list If you want to find a specific value in a vocabulary list it 15 possible to match a filter Select the list by clicking on any value Use to set filter For example if you want to find World Geodetic System 1984 in the L101 vocabulary list type 1984 The used filter appears in green at the left bottom of the window Press Return to go to the next match B Free text describing the geographic coverage 4901 ATF Paris 2 Code 27500 ATF Paris Nord de Guerre 4191 Albanian 1987 2462 Albanian 1987 Gauss Kruger zone 4 4289 Amersfoort 28992 Amersfoort RD New 7415 Amersfoort RD New NAP 28991 Amersfoort RD Old 4183 Azores Central 1948 2189 Azores Central 1948 UTM zone 26N 4665 Azores Central 1995 3063 Azores Central 1995 UTM zone 26N 4184 Azores Oriental 1940 2190 Azores Oriental 1940 UTM zone 26N 4664 Azores Oriental 1995 3062 Azores Oriental 1995 UTM zone 26N 4215 Belge 1950 4809 Belge 1950 Brussels 21500 Belge 1950 Brussels Belge Lambert 5 4313 Belge 1972 em Belge 1972 Belae pri 12 ns C match filter use to set filter and return for next match Ok yo ee SDNident Code sdn Mikado User Manu
64. ta holding centre Data contact Identification When Where What Reference Get data Completed by Title Publication date Author Editor cis Figure 26 Dataset information window Reference Dataset Data holding centre Data contact Identification When Where What Reference Get data Completed by Originator centre j Dataset Access Restriction Access constraints unrestricted SDN L081 1 UN Distribution website Figure 27 Dataset information window Get data sdn Mikado User Manual V1 26 01 2009 SeaDataNet Am s E MIKADO V1 5 user manual Dataset Data holding centre Data contact identification When Where What Reference Get data Completed by Collate centre Organisation name IFREMER IDM SISMER SDNident Organisation name SDN EDMO 486 Contact information Address Website Role Figure 28 Dataset information window Completed by The second tab describes the data holding centre Data holding centre Data contact Point of contact holding centre Organisation name IFREMER IDM SISMER P2 SDNident Organisation name SDN EDMO 486 Contact information Address Website Role Figure 29 Data Holding centre information window The last tab identifies the contact point within the data
65. te 3 var41 Database reference FROM nikado station C Multiple subqueries D var07 Originators dataset WHERE var 10 Parameters 3 vari 3 Projects var 14 Access Restriction var24 West longitude 7 var25 East longitude ORDER BY 7 26 South latitude a var27 North latitude 3 var37 Format name where cdi identiferz Test var38 Format version iv T HT check 3 Check All E If your database does not contain information for some non mandatory variables let them empty in the SELECT clause 3 Check the query using the checking frame see 9 2 1 3 4 Fulfil another multiple query by clicking on an empty variable 9 2 1 3 Queries checking MIKADO allows to check e Each query one by one To do so use the Check button in the query checking frame e All queries at the same time To do so use the Check All button above the expandable tree All queries will be checked one after one Use this button before generating the XML files The results of the query checking appear in the query checking frame A green message informs that the query 15 correct an orange message 15 a warning to tell the user that a reference to the IDs returned by the main query is missing and a red message informs that the query is wrong and gives information about the error sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual c ghe
66. to unzip it and to copy the MIKADO directory on your computer To uninstall MIKADO you have just to delete the MIKADO directory 4 2 Run MIKADO software To run MIKADO e under Windows double click on the mikado bat file in the MIKADO directory e under Solaris run the mikado csh file in the MIKADO directory In order to access MIKADO more easily under Windows you can create a shortcut on your desktop see 4 3 4 3 For Windows Create an MIKADO shortcut on your desktop The quickest method to access MIKADO is to create a shortcut on your desktop To do so proceed as follow l Right click on your desktop and select New and the Shortcut options This window opens Ifremer sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual Create Shortcut This wizard helps you to create shortcuts to local or network programs Files Folders computers or Internet Type the location of the item Click Next to continue 2 Select the Mikado bat file in the MIKADO directory by clicking on the Browse button Click on the Next button Create Shortcut This wizard helps you to create shortcuts to local or network programs files Folders computers or Internet addresses Type the location of the item Csofteverewnikado v1 Simikado bat Click Next to continue 3 Select a title for this shortcut MIKADO for example Click on the Finish button Select a Title for the Prog
67. untries C371 Ten degree Marsden Squares C381 Ports Gazetteer C77 ICES ROSCOP DATA TYPES L021 SeaDataNet Geospatial Feature Types L031 SeaDataNet Measurement Periodicity Classes L05 SeaDataNet device categories L061 SeaDataNet Platform Classes L081 SeaDataNet Data Access Restriction Policies L 101 SeaDataNet geographic co ordinate reference frames L111 Height and Depth Vertical Co ordinate Reference Datums 1 181 ROSCOP sample quantification units L231 SeaDataNet metadata entities L241 SeaDataNet data transport formats P021 BODC Parameter Discovery Vocabulary P081 SeaDataNet Parameter Disciplines 3 Select the mapping to upload in MIKADO For example select the mapping between the P021 list and the P091 list if P021 corresponds to your local data LS Mikado V1 5 Manual Automatic Options Mapping download for P021 BODC Parameter Discovery Vocabulary P021 mapped to P022 BODC Parameter Discovery Vocabulary mapped to BODC Parameter Discovery Vocabulary deprecates P021 mapped to P022 BODC Parameter Discovery Vocabulary mapped to BODC Parameter Discovery Vocabulary deprecates P021 mapped to P011 BODC Parameter Discovery Vocabulary mapped to BODC Parameter Usage Vocabulary P021 mapped to P071 BODC Parameter Discovery Vocabulary mapped to Climate and Forecast Standard Names P021 mapped to P072 BODC Parameter Discovery Vocabulary mapped to Climate and Forecast deprecated Standard Names P
68. w Who Where to find the data Cruise Station Others Cruise information Cruise name kruuise TEST Cruise id FI352006223310 Start date of cruise 20 01 2006 dd mmAyyy 25 01 2007 Date type thesaurus name Station information Station name Station id Start date of station dd mm yyyy hh mm 24 1 25 0 1 2007 15 05 Date type thesaurus Figure 50 Cruise Station window for the CDI In the Cruise Station tab at least cruise information or station information is mandatory The 3 fields for cruise or for station are mandatory Identification Where to find the data Cruise Station Projects SDNIdent NATIONAL PROGRAMME OF COASTA SDN EDMERP 9569 X PA Data size 11234 Name SDNIdent formatName Version x MEDATLAS ASCII SDN L241 1 MEDATLAS 12 0 Data format p 2 Revision date Revision date 21 106 2008 00 00 00 ddimmiyyyy hh mm ss 24 hr 25 01 2007 15 05 00 Date type thesaurus name Figure 51 Others window for the CDI Once all the information related to the CDI has been fulfilled the xml file will be created by selecting Save as in the Manual main menu The created XML file has a xml extension 8 1 4 Manual EDMERP input sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user manual There are 7 tabs Figure 52 to Figure 58
69. want to use it later So be careful using the check box 5 Click on the Download mapping button A progress bar indicates the upload progress Mikado V1 5 Manual New CSR Manual Automatic Options Mapping download for P021 BODC Parameter Discovery Vocabulary P021 mapped to P091 BODC Parameter Discovery Vocabulary mapped to MEDATLAS Parameter Usage Vocabulary Delete previous mapping s for this list Download mapping 6 It 1s possible to edit and to check the uploaded mapping by selecting Mapping Edit in the Automatic main menu sdn Mikado User Manual V1 26 01 2009 SeaDataNet MIKADO V1 5 user Manual LS Mikado V1 5 Manual Automatic Options Mapping SDN P021 BODC Parameter Discovery Vocabulary Local value SDN value 6 2 2 3 Edit the mapping To edit the incremental mapping select Mapping gt Edit in the Automatic main menu and choose a vocabulary list The different vocabulary lists appear In a dropdown list If the mapping does not exist the vocabulary list appears painted with grey in the dropdown list and the user can not select it Mikado V1 5 Sees Manual Options New gt Open gt Save Save as Generate ET Mapping Download from BODC Exit Import from a previous version of MIKADO nm X M C16 SeaData

Mikado Tool User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents