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

Customer CSV file format

This article specifies the format of a CSV file that is required to import customers with ccimport.

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

active   Whether to set the customer as active. Valid values are true, false, 1, and 0. The default is true. No

rate_plan

rate.plan

The name of the rate plan to associate to the customer

No

account_id

 

The customer's account ID. Use a pipe character (|) to separate account levels. For example, Sales & Marketing|Sales|EMEA.

Yes

alt_account_id

 

An alternate account ID for the customer

No

description

desc

A description or full name for the customer

Yes

flag1

 

Flag 1, a single-character flag you can use for any purpose

No

flag2

 

Flag 2, a single-character flag you can use for any purpose

No

flag3

 

Flag 3, a single-character flag you can use for any purpose

No

flag4

 

Flag 4, a single-character flag you can use for any purpose

No

flag5

 

Flag 5, a single-character flag you can use for any purpose

No

accounting_day

 

The customer's accounting day. Valid values are 1 through 30. The default is 1. No
fiscal_start_month   The default is 1 No

contact_name

 

The name of a contact person for the customer

No

email_address

email

A contact email address for the customer

No

postal_address1

address1

The customer's postal address, line 1

No

postal_address2

address2

The customer's postal address, line 2

No

postal_address3

address3

The customer's postal address, line 3

No

postal_address4

address4

The customer's postal address, line 4

No

postal_address5

address5

The customer's postal address, line 5

No

Sample CSV

The following is a sample CSV file.

active,rate_plan,account_id,description
true,Default,B|Commercial,"Business Banking, Commercial Lending"
true,Default,B|SmallBus,"Business Banking, Small Business Lending"
Last modified

Tags

Classifications

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