Export to CSV files

Basics

The plug-in for exporting CSV files exports a network to a collection of CSV files, one file per node / link type, one file for network, one file for scenario. Time series and array values will each have its own file also.

Basic usage:

ExportCSV.py [-h] [-t NETWORK] [-z TIMEZONE]

Options

Option Short Parameter Description
--help -h   show help message and exit.
--network_id -t NETWORK Specify the file containing network information. If no file is specified, a new network will be created using default values.
--scenario_id -s SCENARIO The scenario to be exported. If not specified all the scenarios in the network will be exported.
--output_folder -o OUTPUT The folder where the exported network is to be put. Defaults to Desktop.
--timezone -z TIMEZONE Specify a timezone as a string following the Area/Loctation pattern (e.g. Europe/London). This timezone will be used for all timeseries data that is exported. If you don’t specify a timezone, it defaults to UTC.
--server-url -u SERVER-URL Url of the server the plugin will connect to. Defaults to localhost.
--session-id -c SESSION-ID Session ID used by the callig software. If left empty, the plugin will attempt to log in itself.

File structure

For nodes, the following is an example of what will be exported:

Name , x, y, attribute_1, attribute_2, ..., attribute_n, description
Units,  ,  ,           m,    m^3 s^-1, ...,           -,
node1, 2, 1,         4.0,      3421.9, ...,  Crop: corn, Irrigation node 1
node2, 2, 3,         2.4,       988.4, ...,  Crop: rice, Irrigation node 2

For links, the following will be and example of what will be exported:

Name ,       from,       to, attribute_1, ..., attribute_n, description
Units,           ,         ,           m, ...,    m^2 s^-1,
link1,      node1,    node2,         453, ...,        0.34, Water transfer

The following network file will be exported:

ID, Name , attribute_1, ..., Description 1 , My first network, test , , A network create from CSV files

Note

Add any other information here...

API docs

A Hydra plug-in for exporting a hydra network to CSV files.

class ExportCSV.ExportCSV(url=None, session_id=None)
export(network_id, scenario_id, output_folder)

Export a network (and possibly a scenario) to a folder. If the scenario and output folders are not specified, all the scenarios will be exported and the output location will be the desktop.

export_network(network, scenario)

Write the output files based on the given network and scenario.

export_resourcegroupitems(scenario, group_map, node_map, link_map)

Export the members of a group in a given scenario.

export_resourcegroups(scenario, resourcegroups, node_map, link_map)

Export resource groups into two files. 1:groups.csv defining the group name, description and any attributes. 2:group_members.csv defining the contents of each group for this scenario

export_rules(scenario, node_map, link_map, group_map)

Export rules, which are chunks of text associated with resources and a scenario. :param scenario object to retrive the ID :param node map to get the name of a node from its id :param link map to get the name of a link from its id :param group map to get the name of a group from its id.

get_attr_unit(scenario, attr_id, attr_name=None)

Returns the unit of a given resource attribute within a scenario

get_attr_value(scenario, resource_attr, attr_name, resource_name)

Returns the value of a given resource attribute within a scenario