Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Source Metadata and Data extraction

...

Command

...

  • Performs a full extraction (metadata + data) for the given source and year/scenario slice.

  • Important: The command removes all existing data and metadata from fact database and imports data only for the years and scenarios specified in the arguments

Command

full-extract

Parameters

  • source: name of source for which metadata should be extracted

Example

.\
  • years: years for which data extraction is executed

  • scenarios: scenarios for which data extraction is executed

Example

.\CXO.Adapter.LongviewTidemark.Cli.exe metadata-extract source:longview-close

Command

data-extract

Parameters

  • source: name of source for which metadata should be extracted

  • years: years for which data extraction is executed

  • periods: periods for which data extraction is executed (this is an optional parameter)

  • scenarios: scenarios for which data extraction is executed

Example

years:17,18 periods:Jan,Feb scenarios:Actual

  • Performs a metadata extraction for the given source.

  • Important: The command removes all existing metadata from fact database and re-imports it again.

Command

metadata-extract

Parameters

  • source: name of source for which metadata should be extracted

Example

.\CXO.Adapter.LongviewTidemark.Cli.exe metadata-extract source:longview-close

  • Performs a data extraction for the given source and year/period/scenario slice.

  • Important: The command removes all existing data from fact database and imports data only for the years, periods and scenarios specified in the arguments

Command

data-extract

Parameters

  • source: name of source for which metadata should be extracted

  • years: years for which data extraction is executed

  • periods: periods for which data extraction is executed (this is an optional parameter)

  • scenarios: scenarios for which data extraction is executed

Example

.\CXO.Adapter.LongviewTidemark.Cli.exe metadata-extract source:longview-close years:17,18 periods:Jan,Feb scenarios:Actual

  • IMPORTANT:

    • If the scenarios contain empty space in their member name they need to be put in double quotes. Ex. .\CXO.Adapter.LongviewTidemark.Cli.exe metadata-extract source:longview-close years:17,18 periods:Jan,Feb scenarios:

...

  • IMPORTANT: If the scenarios contain empty space in their name they need to be put in double quotes. Ex
    • "Scenarios 001","Scenarios 002","Scenarios 003"

    • Metadata members should be split by commas and should not contain empty space between the comma and the member name