Home > Cloud Cruiser 4 > Administering > CCIMPORT and CCEXPORT reference > Service CSV file format

Service CSV file format

This article specifies the format of a CSV file that is required to import services with ccimport and written by ccexport.

Format

The first line of the file is a header row that defines the format of the subsequent rows. The following table describes the valid field names for the header row, some of which also have short names that you can use instead. In the full field names, you can substitute dots (.) for underscores (_).

CSV rows beginning with a pound sign (#) are treated as comments and ignored by the importer.

Handling special characters

 

Field Name

Short Name

Description

Required

service_name

service

Service name

Yes

service_desc

desc

Service description

No

measurement_type

(none)

Valid values: M (metered), A (allocated), D (distinct)

Default value:  M

Yes

group_name

group

Service group name

Yes

active_flag

active

Active flag: 1/0 or true/false

No

proration_type

proration

Valid values: N ​(none), P (partial), F (full)

Default value: F

Yes

charge_interval

interval

Valid values: 0 (daily), 1 (hourly), 2 (monthly), 3 (weekly), 4 (yearly)

Default value: 2

Yes

unit_decimals

unit_dec

Unit decimal positions

No

unit_desc

unit

Unit description

Yes

tag_name tag.name Name of the tag No
tag_value tag.value Value of the named tag No

schema_name

schema

Schema name

Yes

measure_name

measure

Measure name

Yes

measure_quantity_operator quantity_operator

Operator specifying exact quantity value or range of values.

Valid values:

  • * any quantity
  • exact quantity (= measure_quantity)
  • ​range (measure_quanity < n < measure_quantity_high)
  • range (measure_quanity < n <= measure_quantity_high)
  • range (measure_quanity <= n < measure_quantity_high)​
  • range (measure_quanity <= n <= measure_quantity_high)​​
Yes

measure_quantity

quantity

Quantity of the measure in the service or lower bound quantity if specifying a range

Yes

measure_quantity_high quantity_high Upper bound of the measure quantity in the service No

conversion_operator

operator

Unit conversion operator.

Valid values: * (multi), / (div), null

Default value: null

No

conversion_operand

operand

Unit conversion factor or divisor

No

dimension_filter_type filter_type Name of a dimension to use as a service filter No
dimension_filter_value filter_value Value of the named dimension to use as a service filter No

Sample CSV

The following is a sample CSV file. Quotes are required only for fields that contain a comma in their value.

service_name,service_desc,measurement_type,group_name,active_flag,proration_type,charge_interval,unit_decimals,unit_desc,tag_name,tag_value,schema_name,measure_name,measure_quantity_operator,measure_quantity,measure_quantity_high,conversion_operator,conversion_operand,dimension_filter_type,dimension_filter_value
A1 VM (Non-Windows) - US West,Compute,allocated,APC,1,full,daily,4,Compute Hours,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,A1 VM (Non-Windows) - US West
A1 VM (Windows) - US East,Compute,allocated,APC,1,full,daily,4,Compute Hours,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,A1 VM (Windows) - US East
A1 VM (Windows) - US South Central,Compute,allocated,APC,1,full,daily,4,Compute Hours,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,A1 VM (Windows) - US South Central
A1 VM (Windows) - US West,Compute,allocated,APC,1,full,daily,4,Compute Hours,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,A1 VM (Windows) - US West
BASIC.A1 VM (Non-Windows) - US West,Compute,allocated,APC,1,full,daily,4,Compute Hours,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,BASIC.A1 VM (Non-Windows) - US West
BASIC.A1 VM (Windows) - US South Central,Compute,allocated,APC,1,full,daily,4,Compute Hours,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,BASIC.A1 VM (Windows) - US South Central
BASIC.A1 VM (Windows) - US West,Compute,allocated,APC,1,full,daily,4,Compute Hours,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,BASIC.A1 VM (Windows) - US West
Developer API Management Units,,allocated,APC,1,full,daily,4,Developer API Management Units,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,Developer API Management Units
Geo Redundant Storage Standard IO - Page Blob/Disk,Storage,allocated,APC,1,full,daily,4,Standard IO - Page Blob/Disk (GB,,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,Geo Redundant Storage Standard IO - Page Blob/Disk
SQL Azure Database Web Edition,Database,allocated,APC,1,full,daily,4,Database (db/month),,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,SQL Azure Database Web Edition
Storage Transactions,Storage,allocated,APC,1,full,daily,4,"Storage Transactions (in 10,000s",,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,Storage Transactions
Windows Azure Data Transfer Egress Zone 1,Compute,allocated,APC,1,full,daily,4,Data Transfer Out (GB),,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,Windows Azure Data Transfer Egress Zone 1
Windows Azure Data Transfer Ingress NA/EMEA,Compute,allocated,APC,1,full,daily,4,Data Transfer In (GB),,,APC,ResourceQtyConsumed,*,1,,none,,ComputedServiceName,Windows Azure Data Transfer Ingress NA/EMEA
Last modified

Tags

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP