The following TAR ball can be downloaded:

    StationXMLReader.tar

on our anonymous FTP (ncedc.org) in:

    /outgoing/stephane/metadata/HT/

- Prerequisites:

    * HT & IR tables and their associated sequences.
    * SerialNbMap table:
         CREATE TABLE SerialNbMap (
            type         VARCHAR2(1)   NOT NULL,
            id           NUMBER(8)     NOT NULL,
            serial_nb    VARCHAR2(80)  NOT NULL,
            CONSTRAINT   type01    CHECK (type IN ('S','P','I','A'))
         );
    * Cosmos schema.

- Configuration:

    * Update the 'connect.properties' file with the DB credentials.
    * Update the 'CheckHTInfo.sql' script (line 6) with the DB credentials.
    * Update the 'Import_ExtStaXML.csh' script (line 6 - CURRDIR variable)
      with the directory where this script resides.
    * Eventually update the 'Import_ExtStaXML.csh' script (line 15 - JAVA variable)
      with the path where java resides.

- Notes:

    * There is an equipment mapping file 'equip_map.json' to allow eventual remapping of
      equipment names. I do not think that you will need it; therefore just use the
      provided 'equip_map.json' file that specifies empty JSON arrays.
    * To import the metadata, just run:
        Import_ExtStaXML.csh <Extended Station XML File>
      For example:
        Import_ExtStaXML.csh CI_AGO_ext.xml
      It will create a sub-directory 'Net.Sta.YYYYMMDD' that contains the extracted information
      and log files.
    * The script assumes that all the hardware information is contained in the extStaXML file.
      It will not work if only partial information is present in the file. It also assumes that
      the extStaXML file has been generated by SIS or follow the SIS representations.
    * If Cosmos attributes are present in the extStaXML file for given channels, it will populate
      the C_ChannelData accordingly. The other Cosmos tables will first need to be populated manually
      with your equipment information.