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 > Schema CSV file format

Schema CSV file format

This article specifies the format of a CSV file that is required to import schemas 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

schema_name

schema

Schema name

Yes

schema_desc

desc

Schema description

No

account_required

 

Whether an account is required: 1/0 or true/false

Yes

passthrough

 

Is passthrough? 1/0 or true/false

Yes

field_type

 

Valid values: D(dimension),M(measure)

Yes

field_name

 

Field name

Yes

field_desc

 

Field description

No

field_required

 

Is field required? 1/0 or true/false

Yes

dimension_is_key

is_key

Whether dimension is a key? 1/0 or true/false

No

measure_units

units

Measure units description

No

measure_allocation

allocation

If measure is allocated? 1/0 or true/false

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

Sample CSV

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

schema_name,schema_desc,account_required,passthrough,field_type,field_name,field_desc,field_required,dimension_is_key,measure_units,measure_allocation
Network,Network infrastructure,1,1,d,Name,Name of network,1,1,,
Network,Network infrastructure,1,1,m,Bytes In,Network bytes in,1,,bytes,0
Network,Network infrastructure,1,1,m,Bytes Out,Network bytes out,1,,bytes,0
Network,Network infrastructure,1,1,m,IP Address,IP address,1,,bytes,1
Storage,Storage,1,1,d,Name,Name of storage instance (i.e. volume name),1,0,,
Storage,Storage,1,1,d,Storage Type,Type of storage,1,0,,
Storage,Storage,1,1,d,User,Owner of storage,1,0,,
Storage,Storage,1,1,m,Disk Allocated,Storage disk allocated,1,,GB,1
Storage,Storage,1,1,m,Disk Used,Storage disk used,1,,GB,0
Virtual Machine,Virtual Machines,1,1,d,Host Name,Host name of the virtual machine,0,0,,
Virtual Machine,Virtual Machines,1,1,d,Image Name,Name of the image used to create the virtual machine,0,0,,
Virtual Machine,Virtual Machines,1,1,d,State,Operational state of the virtual machine,0,0,,
Virtual Machine,Virtual Machines,1,1,d,Type,Type of the virtual machine,0,0,,
Virtual Machine,Virtual Machines,1,1,d,User,Owner of the virtual machine,1,1,,
Virtual Machine,Virtual Machines,1,1,d,VM Name,Name of the virtual machine,1,1,,
Virtual Machine,Virtual Machines,1,1,m,bytesIn,Network bytes in,1,,bytes,0
Virtual Machine,Virtual Machines,1,1,m,bytesOut,Network bytes out,1,,bytes,0
Virtual Machine,Virtual Machines,1,1,m,vCPU,Number of CPUs allocated,1,,cpu,1
Virtual Machine,Virtual Machines,1,1,m,vDisk,Disk storage allocated,1,,GB,1
Virtual Machine,Virtual Machines,1,1,m,vMemory,Memory allocated,1,,GB,1
Last modified

Tags

Classifications

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