Required Format for CSV File to Import to the Target Cell Spreadsheet
To successfully import data to the Target Cell Spreadsheet, the comma-separated values (.csv) file that you prepare must match the following format. When you export the contents of the Target Cell Spreadsheet, this is also the format in which data is exported.
*
The file must contain a header row with column names matching the predefined and custom cell attributes.
*
Each row must have the same number of columns as specified in the header row.
*
If there is no data for a given column, it should be left blank.
*
Values of custom attributes will be converted to the appropriate data type. For dates, the date string must be in the user's locale format.
Column Name
Description
Required
Valid Values
CellName
Name of the target cell.
Yes
CellCode
Cell code assigned to this target cell. If empty, Campaign will generate a cell code, otherwise the specified value will be used.
Yes, if this row is marked as IsControl = Yes.
Cell code must match the defined cell code format.
IsControl
Indicates whether the cell in this row is a control cell or a regular target cell.
No
Yes, No
ControlCellCode
The CellCode of a cell that is marked as IsControl = Yes.
No
A valid cell code that exists for a call marked as IsControl = Yes.
AssignedOffers
A semicolon-delimited set of offers, offer lists, or a combination of both.
No
Offers can be specified using offer codes, and offer lists can be specified using offerlist names.The format is: OfferName1[OfferCode1]; OfferName2[OfferCode2]; OfferListName1[]; OfferListName2[], where the offer name is optional, but the offer code is required, and the offer list name is required with empty square brackets.
FlowchartName
Name of the associated flowchart.
No. This column will be populated by Campaign. If specified, it will be ignored. Will be populated for export.
CellCount
The counts for this cell.
No. This column will be populated by Campaign. If specified, it will be ignored. Will be populated for export.
LastRunType
The type of the last flowchart run.
No. This column will be populated by Campaign. If specified, it will be ignored. Will be populated for export.
LastRunTime
The time of the last flowchart run.
No. This column will be populated by Campaign. If specified, it will be ignored. Will be populated for export.
Custom Attr1
Add a column for each custom cell attribute you have defined for which you are importing data.
No
Valid values as required by the custom attribute's data type and user locale/format.
Copyright IBM Corporation 2015. All Rights Reserved.