Cloud Cruiser became HPE Consumption Analytics on Nov. 1st. You'll still see the old name in places while we update this site.

 

 

Consumption Analytics Documentation

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

Rate Plan CSV file format

This article specifies the format of a CSV file that is required to import rate plans with ccimport and written by ccexport. Each row represents one rate for a given service in a given effective date range of a given rate plan. Therefore, a service with tiered rates requires multiple rows, one for each tier.

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

rate_plan_name

plan

The rate plan that the rate belongs to. The default is Default.

No

rate_plan_desc

plan_desc

The description for the rate plan.

If more than one row for a rate plan contains a value for this field, the last one is used.

No

service_name

service

The service that the rate applies to.

No

service_rate_desc svc.rate.desc

The description of the service when charged under the rate plan. This text appears in place of the service name on standard reports when the Allow unique service descriptions for customers option is enabled in Administration > Configuration > General > System.

When the option is disabled, this field is ignored by ccimport and ccexport.

No
svc_rate_tag_name rate.tag.name A rate plan field passed as metadata to the HPE Consumption Analytics Portal database. No
svc_rate_tag_value rate.tag.value The value for a svc_rate_tag_name field. No

effective_date

date

The first date of the effective date range for the rate, in the format of yyyymmdd

No

end_date end The ending date for the effective date range of the rate plan, in the format yyyymmdd. No

rate_type

model

Type for rate. Valid values are B (basic), T (sticky tiers), H (final or high tiers), P (passthrough), and S (state). The default is B.

No

rate_decimals

rate_dec

The precision for the rate in decimal places. The default is 4.

No

min_commitment_value min.value The amount of a service customers are obligated to purchase regardless of their actual usage of that service No
min_commitment_interval min.interval Defines how often the min_commit_value obligation is applied (Daily, Hourly, or Monthly) No

minimum_units

min_units

The minimum service quantity to charge, if rate_type is B

No

state_name

state

The name of the state that the rate applies to, if rate_type is S

Yes

state_desc

state.desc

The description of the state that the rate applies to, if rate_type is S

No

tier_name

tier

The name of the tier that the rate applies to, if rate_type is T or H

No

tier_low_range

low

The lowest service quantity of the tier that the rate applies to, if rate_type is T or H

No

tier_target_account_field

tier_target

The account level at which service quantities are aggregated for tier calculation, if rate_type is T or H.

If more than one row for a service contains a value for this field, the last one is used.

No

currency_code currency Three-letter currency code for the rate. For example, usd or yen. No
fixed_charge_amount fixed

The fixed (one-time) rate for the service.

If more than one row for a service contains a value for this field, the last one is used.

No
rate unit.price The variable (per-unit) rate for the service or tier No

Sample CSV

The following is a sample CSV file.

rate_plan_name,rate_plan_desc,service_name,service_rate_desc,effective_date,end_date,rate_type,rate_decimals,min_commitment_value,min_commitment_interval,state_name,state_desc,tier_name,tier_low_range,tier_target_account_field,fixed_charge_amount,rate
Default,Default rate plan for all services,systemcenter.PerNICBytesSentPerSecond,,20000101,29991231,basic,4,,daily,,,,,,,0
Default,Default rate plan for all services,EU-EBS:SnapshotUsage,,20000101,29991231,passthrough,4,,daily,,,,,,,
Default,Default rate plan for all services,systemcenter.PerNICBytesReceivedPerSecond,,20000101,29991231,basic,4,,daily,,,,,,,0
Default,Default rate plan for all services,EU-ElasticIP:IdleAddress,,20000101,29991231,passthrough,4,,daily,,,,,,,
Default,Default rate plan for all services,sqlservers.DatabaseCount,,20000101,29991231,basic,4,,daily,,,,,,,0.75
Default,Default rate plan for all services,EUC1-CW:Requests,,20000101,29991231,passthrough,4,,daily,,,,,,,
Default,Default rate plan for all services,LoadBalancerUsage,,20000101,29991231,passthrough,4,,daily,,,,,,,
Default,Default rate plan for all services,mysqlservers.DatabaseCount,,20000101,29991231,basic,4,,daily,,,,,,,0.5
Default,Default rate plan for all services,OpenWorkflowDays,,20000101,29991231,passthrough,4,,daily,,,,,,,
Last modified

Tags

Classifications

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