Importing recipients into SendSuite Tracking Online
Products affected: SendSuite® Tracking Online
You can import recipients into SendSuite Tracking Online from a list in CSV format manually as needed, or schedule automatic recurring imports. A template is provided to assist you in formatting your list correctly for a successful import.
Select Contacts - Recipients & Senders. The Contacts page is displayed.
Select Import list.
On the Manual Import tab, select the Download File button to download a template that you can fill in with your addresses.
Open the template file SSTOcontacts_en.csv and enter your recipients in the columns provided, according to the Import File Requirements below.
When finished, save and close the file.
Back in SendSuite Tracking Online, on the Manual Import tab, select the Browse button, locate and select your file, and select Open.
Select how to import your recipients:
Replace all current recipients with the recipients in the CSV file.
Update and add to your current recipients
Select Start Import.
The S/FTP server whitelist must allow inbound connections from *.pitneybowes.com.
Automatic imports will replace all current recipients. You cannot undo this action.
To configure automatic importing
Select the gear icon in the upper right.
Select Contacts - Recipients & Senders.
Select Import list.
Select the Automatic Import tab.
(Optional) Select Download Template to download a template that you can fill in with your addresses.
Select the delimiter from the drop-down list. Available delimiters are:
Other (provide the file delimiter in the text box revealed upon selecting this option.)
In the File Access section, complete the following fields:
File path, including file name: Select FTP or SFTP from the menu, then enter the complete server address, including the file name.
SFTP User Name: Enter the username that SendSuite Tracking Online will use to access the server.
SFTP Password: Enter the password for the user account.
(Optional) Click Test Access to confirm that the Pitney Bowes server can access the S/FTP site and locate the file.
In the Import Schedule section, complete the following fields:
Repeats On: Select the days on which SendSuite Tracking Online will import the file.
Time: Select the time at which SendSuite Tracking Online will import the file.
(Optional) Click Import Now to execute a one-time on-demand file import.
Import File Requirements
Include a unique name for each recipient. Duplicates are not permitted.
The first line of the .csv file is reserved for column headings. If the headings are omitted, the first contact will be missed.
The import supports Unicode and ASCII formats.
The columns must be in the same order as the template: First Name,Middle Name,Last Name,Email Address
If Locations are turned on, the field order is: First Name,Middle Name,Last Name,Email Address,Building,Floor,Office
If using your own file instead of the template, a text delimiter must be present to preserve the columns even if there is no data in the column. For example, if there is no middle name or building, the comma-delimited record would look like this: John,,Doe,email@example.com,,4,419
Note: The Middle Name field is present in the template for all countries.