 |
Consumption Analytics Documentation |
|
Consumption Analytics Documentation |
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 identifier | Yes |
|
|
| Resource description | No |
|
|
| Effective date (yyyymmdd) | No |
|
|
| Name of tier, or empty when tiers do not apply | No |
|
|
| Tier low range (lower boundary). Use a value of zero (0) or empty for first tier. | No |
|
|
| Variable rate | No |
|
|
| Rate type: | No |
|
|
| Fixed charge amount | No |
|
|
| Flat fee flag: 1/0 or true/false | No |
|
|
| Allocation flag: 1/0 or true/false | No |
|
|
| Interval for allocated resource rate: hourly, daily, weekly, monthly, or yearly. | No |
|
|
| Resource group name | Yes |
|
|
| Rate plan name | No |
|
|
| Currency code | No |
|
|
| Units description | No |
|
|
| Comments | No |
|
|
| Unit numeric type: | No |
|
|
| Rate decimal positions | No |
|
|
| Unit decimal positions | No |
|
|
| Used by HPE only | No |
|
|
| Used by HPE only | No |
|
|
| Unit conversion operator: mult or div | No |
|
|
| Unit conversion factor or divisor | No |
|
|
| 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 |
|
|
| Resource state | No |
|
|
| Resource type: | No |
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"
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