seiscomp-training/share/doc/seiscomp/html/_sources/apps/scxmldump.rst.txt

.. highlight:: rst

.. _scxmldump:

#########
scxmldump
#########

**Dump database objects to XML files.**


Description
===========

To get event information from the database without using SQL is an important
task for the user. :ref:`scxmldump` queries the database and transforms that
information into XML. The result can be converted into a bulletin with
scbulletin or imported into another database with :ref:`scdb`.

An XSD schema of the XML output can be found under
:file:`$SEISCOMP_ROOT/share/xml/`.

Examples
--------

Export inventory

.. code-block:: sh

   scxmldump -fI -o inventory.xml -d mysql://sysop:sysop@localhost/seiscomp

Export configuration

.. code-block:: sh

   scxmldump -fC -o config.xml -d mysql://sysop:sysop@localhost/seiscomp

Export full event data incl. the relevant journal entries

.. code-block:: sh

   scxmldump -fPAMFJ -E test2012abcd -o test2012abcd.xml \
             -d mysql://sysop:sysop@localhost/seiscomp


Export summary event data

.. code-block:: sh

   scxmldump -fap -E test2012abcd -o test2012abcd.xml \
             -d mysql://sysop:sysop@localhost/seiscomp


Create bulletin

.. code-block:: sh

   scxmldump -fPAMF -E test2012abcd
             -d mysql://sysop:sysop@localhost/seiscomp | \
   scbulletin


Copy event

.. code-block:: sh

   scxmldump -fPAMF -E test2012abcd \
             -d mysql://sysop:sysop@localhost/seiscomp | \
   scdb -i - -d mysql://sysop:sysop@archive-db/seiscomp


Export the entire journal:

.. code-block:: sh

   scxmldump -fJ -o journal.xml \
             -d mysql://sysop:sysop@localhost/seiscomp


.. _scxmldump_configuration:

Module Configuration
====================

| :file:`etc/defaults/global.cfg`
| :file:`etc/defaults/scxmldump.cfg`
| :file:`etc/global.cfg`
| :file:`etc/scxmldump.cfg`
| :file:`~/.seiscomp/global.cfg`
| :file:`~/.seiscomp/scxmldump.cfg`

scxmldump inherits :ref:`global options<global-configuration>`.




Command-Line Options
====================

.. program:: scxmldump

:program:`scxmldump [options]`


Generic
-------

.. option:: -h, --help

   Show help message.

.. option:: -V, --version

   Show version information.

.. option:: --config-file arg

   Use alternative configuration file. When this option is
   used the loading of all stages is disabled. Only the
   given configuration file is parsed and used. To use
   another name for the configuration create a symbolic
   link of the application or copy it. Example:
   scautopick \-> scautopick2.

.. option:: --plugins arg

   Load given plugins.

.. option:: -D, --daemon

   Run as daemon. This means the application will fork itself
   and doesn't need to be started with \&.

.. option:: --auto-shutdown arg

   Enable\/disable self\-shutdown because a master module shutdown.
   This only works when messaging is enabled and the master
   module sends a shutdown message \(enabled with \-\-start\-stop\-msg
   for the master module\).

.. option:: --shutdown-master-module arg

   Set the name of the master\-module used for auto\-shutdown.
   This is the application name of the module actually
   started. If symlinks are used, then it is the name of
   the symlinked application.

.. option:: --shutdown-master-username arg

   Set the name of the master\-username of the messaging
   used for auto\-shutdown. If \"shutdown\-master\-module\" is
   given as well, this parameter is ignored.


Verbosity
---------

.. option:: --verbosity arg

   Verbosity level [0..4]. 0:quiet, 1:error, 2:warning, 3:info,
   4:debug.

.. option:: -v, --v

   Increase verbosity level \(may be repeated, eg. \-vv\).

.. option:: -q, --quiet

   Quiet mode: no logging output.

.. option:: --component arg

   Limit the logging to a certain component. This option can
   be given more than once.

.. option:: -s, --syslog

   Use syslog logging backend. The output usually goes to
   \/var\/lib\/messages.

.. option:: -l, --lockfile arg

   Path to lock file.

.. option:: --console arg

   Send log output to stdout.

.. option:: --debug

   Execute in debug mode.
   Equivalent to \-\-verbosity\=4 \-\-console\=1 .

.. option:: --log-file arg

   Use alternative log file.


Messaging
---------

.. option:: -u, --user arg

   Overrides configuration parameter :confval:`connection.username`.

.. option:: -H, --host arg

   Overrides configuration parameter :confval:`connection.server`.

.. option:: -t, --timeout arg

   Overrides configuration parameter :confval:`connection.timeout`.

.. option:: -g, --primary-group arg

   Overrides configuration parameter :confval:`connection.primaryGroup`.

.. option:: -S, --subscribe-group arg

   A group to subscribe to.
   This option can be given more than once.

.. option:: --content-type arg

   Overrides configuration parameter :confval:`connection.contentType`.

.. option:: --start-stop-msg arg

   Set sending of a start and a stop message.


Database
--------

.. option:: --db-driver-list

   List all supported database drivers.

.. option:: -d, --database arg

   The database connection string, format:
   service:\/\/user:pwd\@host\/database.
   \"service\" is the name of the database driver which
   can be queried with \"\-\-db\-driver\-list\".

.. option:: --config-module arg

   The config module to use.

.. option:: --inventory-db arg

   Load the inventory from the given database or file, format:
   [service:\/\/]location .

.. option:: --config-db arg

   Load the configuration from the given database or file,
   format: [service:\/\/]location .


Dump
----

.. option:: --listen

   Enable server mode which listens to the message server for
   incoming events and dumps each received add\/update.

.. option:: -I, --inventory

   Dump the inventory.

.. option:: --without-station-groups

   Remove all station groups from inventory.

.. option:: --stations sta-list

   If inventory is exported filter the stations to export where
   each item is in format net[.{sta\|\*}].

.. option:: -C, --config

   Dump the configuration database.

.. option:: -J, --journal

   Dump the journal. In combination with \-E only corresponding
   journal entries are included.

.. option:: -R, --routing

   Dump the routing database.

.. option:: -Y, --availability

   Dump data availability information.

.. option:: --with-segments

   Dump individual data segments.

.. option:: -O, --origin ID

   Origin public ID\(s\) to dump. Multiple origins may be specified
   as a comma\-separated list.

.. option:: -E, --event ID

   Event public ID\(s\) to dump. Multiple events may be specified
   as a comma\-separated list.

.. option:: -P, --with-picks

   Dump associated picks along with origins.

.. option:: -A, --with-amplitudes

   Dump associated amplitudes along with magnitudes.

.. option:: -M, --with-magnitudes

   Dump station magnitudes.

.. option:: -F, --with-focal-mechanism

   Dump focal mechanisms of events.

.. option:: -a, --ignore-arrivals

   Do not dump arrivals part of origins.

.. option:: --ignore-magnitudes

   Do not export \(network\) magnitudes of origins. This
   option is most useful in combination with \-O to only
   export the location information.

.. option:: -p, --preferred-only

   When exporting events only the preferred origin, the preferred
   magnitude and the preferred focal mechanism will be dumped.

.. option:: -m, --all-magnitudes

   If only the preferred origin is exported, all magnitudes for
   this origin will be dumped.


Output
------

.. option:: -f, --formatted

   Use formatted XML output. Otherwise all XML is printed
   on one line.

.. option:: -o, --output

   The output file. Default is stdout.

.. option:: --prepend-datasize

   Prepend a line with the length of the XML data.