Acoustic Campaign exports the list results to a .CSV file, then adds that file to the FTP account associated with the current session. You can copy the results file to the Stored Files in Acoustic Campaign.
If the database is a Double Opt-in database, Acoustic Campaign exports only confirmed contacts. By default, the database security settings for this operation are disabled for all Double Opt-in databases.
LIST_ID - Unique identifier for the database, query, or contact list Acoustic Campaign is exporting.
EXPORT_TYPE - Specifies the contacts to export. Valid values are: ALL (exports the entire database), OPT_IN (exports only currently opted-in contacts), OPT_OUT (exports only currently opted-out contacts), and UNDELIVERABLE (exports only contacts currently marked as undeliverable).
EXPORT_FORMAT - Specifies the file format for the exported date: CSV (creates a comma-separated values file), TAB (creates a tab-separated values file), or PIPE (creates a pipe-separated values file).
EMAIL - The email address to receive notifications when the job is complete.
FILE_ENCODING - Defines the encoding of the exported filed. Valid values are utf-8 and iso-8859-1. If not specified, Acoustic Campaign uses the organization default encoding.
ADD_TO_STORED_FILES - Writes the output to the Stored Files folder in Acoustic Campaign. If omitted, Acoustic Campaign moves exported files to the download directory of the user's FTP space.
DATE_START - Specifies the beginning boundary of information to export (relative to the last modified date). If time is included, it must be in 24-hour format.
DATE_END - Specifies the ending boundary of information to export (relative to the last modified date). If time is included, it must be in 24-hour format.
USE_CREATED_DATE - If included, the DATE_START and DATE_END range are relative to the contact's create date rather than last modified date. Note: The contact's create date might not be the same as the contact's opted-in date.
INCLUDE_LEAD_SOURCE - If True, includes the Lead Source column in the resulting file. If False, the Lead Source column does not appear. NOTE: This element is used only when not using EXPORT_COLUMNS to export specific database columns.
LIST_DATE_FORMAT - Specifies the date format of the date fields in your exported file if date format differs from "mm/dd/yyyy" (month, day, and year can be in any order you choose). Separators can be up to two characters in length and can consist periods, commas, question marks, spaces, and forward slashes (/).
Valid Month values:
- M (i.e. 1)
- MM (i.e. 01)
- MMM (i.e. Jan)
- MMMM (i.e. January)
Valid Day values:
- d (i.e. 2)
- dd (i.e. 02)
Valid Year values:
- yy (i.e. 99)
- yyyy (1999)
- For date "Jan 2, 1975", your LIST_DATE_FORMAT is "MMM d, yyyy".
- For date "1975/01/02", your LIST_DATE_FORMAT is "yyyy/MM/dd".
INCLUDE_RECIPIENT_ID - Returns Recipient ID in the exported field.
EXPORT_COLUMNS - XML node used to request specific custom database columns to export for each contacts.
COLUMN - A child of EXPORT_COLUMNS used to specify the columns to export. Simply use the name of a column to export it, including custom columns. The following System columns are available: CRM Account ID, CRM Contact Type, CRM Enable Sync, CRM Lead Source, CRM Sync ID, Email, Email Type, Opt-In Date, Opt-In Details, Opt-Out Details, Opted-Out, Opted-Out Date, RECIPIENT_ID, and Last Modified Date.
<Envelope> <Body> <ExportList> <LIST_ID>59294</LIST_ID> <EXPORT_TYPE>ALL</EXPORT_TYPE> <EXPORT_FORMAT>CSV</EXPORT_FORMAT> <ADD_TO_STORED_FILES/> <DATE_START>06/25/2017 01:00:00</DATE_START> <DATE_END>06/28/2017 23:59:59</DATE_END> <EXPORT_COLUMNS> <COLUMN>FIRST_NAME</COLUMN> <COLUMN>INITIAL</COLUMN> <COLUMN>LAST_NAME</COLUMN> </EXPORT_COLUMNS> </ExportList> </Body> </Envelope>
<Envelope> <Body> <RESULT> <SUCCESS>TRUE</SUCCESS> <JOB_ID>135477159</JOB_ID> <FILE_PATH>Primary List - All - u78ar - Jun 19 2022 10-30-01-735 AM.csv</FILE_PATH> </RESULT> </Body> </Envelope>
SUCCESS - True if successful, False if not.
JOB_ID - Identifies the Acoustic Campaign background job created and scheduled for this import.
FILE_PATH - Identifies the file name of the exported file.
The filename format is
<List or query name> - <ExportType> -<alphanumeric string> - <Date>.<File Type>
Primary List - All - u78ar - Jun 19 2022 10-30-01-735 AM.csv
u78ar– is a 5-character alphanumeric random string.
-735– is milliseconds in the date format.
The alphanumeric string and the milliseconds in the date format help prevent issues when there are multiple exports and may share the same filename.