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 3 > Administering > Managing resources > Resource CSV file format

Resource CSV file format

Format

The first line of the CSV file is a header row that defines the format of the subsequent rows. The following table describes the field names you can use in the header row and their short names that you can use instead. For full field names, you can also use dots (.) instead of underscores (_) in the names. CSV rows beginning with # are treated as comments and ignored by the importer.

 

Field Name

Short Name

Description

Required

resource_id

id

Resource identifier

Yes

description

desc

Resource description

No

effective_date

eff

Effective date (yyyymmdd)

No

tier_name

tier

Name of tier, or empty when tiers do not apply

No

tier_low_range

threshold

Tier low range (lower boundary). Use a value of zero (0) or empty for first tier.

No

rate

rate

Variable rate

No

rate_type

 

Rate type: price or cogs (cost of goods sold). These values can be abbreviated as p or c . The default is price .

No

fixed_charge

fixed

Fixed charge amount

No

flat_fee_flag

flat

Flat fee flag: 1/0 or true/false

No

allocation_flag

alloc

Allocation flag: 1/0 or true/false

No

charge_interval

interval

Interval for allocated resource rate: hourly, daily, weekly, monthly, or yearly.

No

group_title

group

Resource group name

Yes

rate_plan

rate.plan

Rate plan name

No

currency_code

curr

Currency code

No

unit_desc

unit

Units description

No

comments

comment

Comments

No

numeric_type

numtype

Unit numeric type: num or frac

No

rate_decimals

ratedec

Rate decimal positions

No

unit_decimals

unitdec

Unit decimal positions

No

tolerance_low

low

Used by HPE only

No

tolerance_high

high

Used by HPE only

No

conversion_operator

operator

Unit conversion operator: mult or div

No

conversion_operand

operand

Unit conversion factor or divisor

No

hidden_flag

hidden

When true, the resource does not appear in reports although its charges are still applied and stored in the database. The default is false.

No

state_name

state

Resource state

No

resource_type

restype

Resource type: s (standard), d (discount/surcharge), p (passthrough), or b (bundled). The default is s .

No

Sample CSV - basic

The following is a sample CSV file with quotes to protect the data in the fields. Quotes are optional and are only required for fields that contain a comma in the field value.

resource.id,description,rate,group.title,unit.desc
"cpu","CPU Consumption",.005,"mygroup","MHz"
"mem","Memory Allocated",.025,"mygroup","MB"
"memcon","Memory Consumed",.02,"mygroup","MB"
"diskio","Disk IO",.001,"mygroup","kB"
"lanio","LAN IO",.002,"mygroup","kB"
"wanio","WAN IO",.005,"mygroup","kB"
"stor","Storage",.02,"mygroup","GB"

Sample CSV - tiers

When importing, you can specify tiered pricing by including the tier name and threshold fields in the file. Leave these fields empty for resources that do not have tiered pricing. The following is an example of three storage tiers for an alternate rate plan:

id,group,rate.plan,eff,desc,tier,threshold,rate,unit,currency,group,alloc,interval
disk,storage,,,Disk,,,.005,GB day,usd,mygroup,1,daily
disk,storage,partner,,Disk,small,0,.001,GB day,usd,mygroup,1,daily
disk,storage,partner,,Disk,large,20,.002,GB day,usd,mygroup,1,daily
disk,storage,partner,,Disk,huge,500,.003,GB day,usd,mygroup,1,daily
disk,storage,partner,20120201,Disk,small,0,.002,GB day,usd,mygroup,1,daily
disk,storage,partner,20120201,Disk,large,20,.004,GB day,usd,mygroup,1,daily
disk,storage,partner,20120201,Disk,huge,500,.006,GB day,usd,mygroup,1,daily
Last modified

Tags

Classifications

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