Import and export format for TCS® data
To import data into a target cell spreadsheet (TCS®), the comma-separated values (.CSV) file that you prepare must match the required format. When you export the contents of a TCS®, this is also the format in which data is exported.
*
The file must contain a header row with column names that match 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, leave it 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 generates a cell code, otherwise the specified value is used.
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 where IsControl = Yes.
Only if IsControl = Yes
A valid cell code that exists for a cell marked IsControl = Yes.
AssignedOffers
A semicolon-delimited set of offers, offer lists, or a combination of both.
No
Offers can be specified using offer codes. 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*
CellCount
The counts for this cell.
No*
LastRunType
The type of the last flowchart run.
No*
LastRunTime
The time of the last flowchart run.
No*
Custom Attr1
Add a column for each custom cell attribute that you defined for which you are importing data.
No
Valid values as required by the custom attribute's data type and user locale/format.
*This column is populated by Campaign. If specified, it is ignored. It is populated for export.
Copyright IBM Corporation 2015. All Rights Reserved.