![]() |
Consumption Analytics Documentation |
This article specifies the format of a CSV file that is required to import customers with ccimport.
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.
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 | |
|
| The name of the rate plan to associate to the customer | No |
|
| The customer's account ID. Use a pipe character ( | Yes |
|
| An alternate account ID for the customer | No |
|
| A description or full name for the customer | Yes |
|
| Flag 1, a single-character flag you can use for any purpose | No |
|
| Flag 2, a single-character flag you can use for any purpose | No |
|
| Flag 3, a single-character flag you can use for any purpose | No |
|
| Flag 4, a single-character flag you can use for any purpose | No |
|
| 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 | |
|
| The name of a contact person for the customer | No |
|
| A contact email address for the customer | No |
|
| The customer's postal address, line 1 | No |
|
| The customer's postal address, line 2 | No |
|
| The customer's postal address, line 3 | No |
|
| The customer's postal address, line 4 | No |
|
| The customer's postal address, line 5 | No |
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"