{"id":14330,"date":"2024-10-21T15:03:55","date_gmt":"2024-10-21T20:03:55","guid":{"rendered":"https:\/\/cyflex.com\/?page_id=14330"},"modified":"2026-03-04T08:44:16","modified_gmt":"2026-03-04T13:44:16","slug":"hogger_out","status":"publish","type":"page","link":"https:\/\/cyflex.com\/index.php\/usage-help-manual\/9-data-collection-data-logging\/hogger_out\/","title":{"rendered":"hogger_out"},"content":{"rendered":"
\n

Purpose:<\/h3>\n
\n
\n

Convert the SQLite3 database created by the hogger application into a readable format.
\nThis function is available with CyFlex 7.1 and subsequent releases.<\/p>\n<\/dd>\n<\/dl>\n<\/div>\n

Enter:<\/h3>\n
\n
\n

hogger_out<\/strong> <-s spec_file> | <-i database_file> <-L> options<\/p>\n<\/dd>\n<\/dl>\n

Where:<\/h3>\n
\n
\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

-s spec_file<\/p>\n<\/td>\n

\n

Specify a spec file to read. Required if the spec file includes a database file.
\nIf the spec file does not include a database file, use the -i option.<\/p>\n<\/td>\n<\/tr>\n

\n

-i database_file<\/p>\n<\/td>\n

\n

Specify a database file if not in the spec file. Required if a spec file is not specified.<\/p>\n<\/td>\n<\/tr>\n

\n

-L<\/p>\n<\/td>\n

\n

Specify the CSAR label type. Valid options are:<\/p>\n

    \n
  • csar to use a variable CSAR label without an ECM prefix<\/li>\n
  • prefix to use a variable CSAR label with an ECM prefix<\/li>\n
  • external or ext to use the external CSAR name<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Options<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

-o output_file<\/p>\n<\/td>\n

\n

If not in the spec file, specify an output file to write into. Specify either a fully qualified path or a relative path.<\/p>\n<\/td>\n<\/tr>\n

\n

-d delimiter<\/p>\n<\/td>\n

\n

Specify a custom delimiter to use. This will override the spec file. Use non-white space characters only.<\/p>\n<\/td>\n<\/tr>\n

\n

-e<\/p>\n<\/td>\n

\n

Specify this flag to add an index and exit. This greatly speeds up data retrieval from the database.<\/p>\n<\/td>\n<\/tr>\n

\n

-g<\/p>\n<\/td>\n

\n

Specify this flag to perform debug+query. No output will be produced.<\/p>\n<\/td>\n<\/tr>\n

\n

-n<\/p>\n<\/td>\n

\n

Specify this flag to prevent conversion of units to log units. By default, if the units get converted to log_units which are selected in the hogger application. The variables are stored in the units that they are in when logged, but if hogger also stored log_units than a conversion takes place. This option disables that conversion, and the original units are used in the report.<\/p>\n<\/td>\n<\/tr>\n

\n

-q<\/p>\n<\/td>\n

\n

Specify this flag to query the database and exit. No output will be produced.<\/p>\n<\/td>\n<\/tr>\n

\n

-A<\/p>\n<\/td>\n

\n

Specify this flag to prevent writing of headers when appending to the file.<\/p>\n<\/td>\n<\/tr>\n

\n

-D<\/p>\n<\/td>\n

\n

Specify this flag to display debug information.<\/p>\n<\/td>\n<\/tr>\n

\n

-E<\/p>\n<\/td>\n

\n

Specify this flag to remove the index and exit.<\/p>\n<\/td>\n<\/tr>\n

\n

-H<\/p>\n<\/td>\n

\n

Specify this flag to disable writing of headers.<\/p>\n<\/td>\n<\/tr>\n

\n

-I<\/p>\n<\/td>\n

\n

Specify this flag to add an index to the database. The application will run to completion.
\nThis improves performance on large data sets.<\/p>\n<\/td>\n<\/tr>\n

\n

-R<\/p>\n<\/td>\n

\n

Specify this flag to remove indexes and reclaim disk space when the application is done with the database.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/dd>\n<\/dl>\n

Example:<\/h3>\n
\n
\n

hogger_out<\/strong> -s \/specs\/hogr_out_spec.1 -L csar
\nThe preceding uses specification file \/specs\/hogr_out_spec.1 and a variables CSAR label without an ECM prefix.<\/p>\n

hogger_out<\/strong> -i \/data\/PC_format\/database.db -L prefix
\nThe preceding uses database file \/data\/PC_format\/database.db and a variables CSAR label with an ECM prefix.<\/p>\n<\/dd>\n<\/dl>\n

Notes:<\/h3>\n

See Also:<\/h3>\n

Hyper-Logger User Guide<\/a>, hogger<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Purpose: Convert the SQLite3 database created by the hogger application into a readable format. This function is available with CyFlex 7.1 and subsequent releases. Enter: hogger_out <-s spec_file> | <-i database_file> <-L> options Where: -s spec_file Specify a spec file to read. Required if the spec file includes a database file. If the spec file […]<\/p>\n","protected":false},"author":35,"featured_media":0,"parent":1960,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-14330","page","type-page","status-publish","hentry"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/cyflex.com\/index.php\/wp-json\/wp\/v2\/pages\/14330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cyflex.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cyflex.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cyflex.com\/index.php\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/cyflex.com\/index.php\/wp-json\/wp\/v2\/comments?post=14330"}],"version-history":[{"count":0,"href":"https:\/\/cyflex.com\/index.php\/wp-json\/wp\/v2\/pages\/14330\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/cyflex.com\/index.php\/wp-json\/wp\/v2\/pages\/1960"}],"wp:attachment":[{"href":"https:\/\/cyflex.com\/index.php\/wp-json\/wp\/v2\/media?parent=14330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}