...
The .CSV file must be structured in two sections: header and messages.
Header
The header is made of a fixed number of rows: each one has a specific meaning and is preceded by the symbol "#" (number sign).
...
| Row | Optional | Description | Example |
|---|---|---|---|
| 1 | Y | Indicates the author of the file. It can be an email address or a mobile number with prefix included | name.surname@myprovider.com |
| 2 | Y | Date and time of sending, with format "YYYY-MM-DD HH:MM". If the row is empty or the data indicate a time in the past, MailUp schedules an immediate sending. If the format is incorrect, an import error will occur. This row is used only if the field in row 3 is validated as "I" (i.e. sending) | 2012-03-01 14:30 |
| 3 | N | Action to be performed: Sending or Queueing. Allowed values are "I" for sending (capital "i", from the first letter of the Italian word "invio"), and "A" for queueing (capital"a", from the first letter of the Italian word "accodamento"). Queueing option arranges the sending but does not perform it: you will have to access the MailUp system to schedule it. | I |
| 4 | N | ID of the sender. It can be a valid phone number, or an alphanumeric ID (max 11 characters, with restrictions on allowed characters) | MailUp |
| 5 | Y | ID of the MailUp list. It indicates the "environment", the cost center or the category in which messages and recipients will be inserted (the ID of the list must be indicated, and not its name) | 5 |
| 6 | N | Campaign name. It identifies the different sendings when looking through the statistics. If the row is left empty, messages will be automatically associated to the campaign "Default N", where "N" stands for the ID of the MailUp list | Special offers |
| 7 | N | Non-duplication univocal code (max 10 chars). This row can be used to assign a univocal code to each file. The system will perform the import only if a file containing that specific code has never been imported to that account. According to maximum allowed length, you can freely choose which string to use and the convention according to which each new code is generated. | COD1234567 |
Messages
The .csv file can contain an unlimited number of rows referring to the messages to be sent. Each row must have the following structure:
...
| Note |
|---|
|
Sample files
Queueing only (with non-duplication code)
#
#2012-02-29 09:50
#A
#MailUp
...
0018881234567;hello [#2] your name is [#1] and you live in [#3] [#4];;Patricia;Johnson;Lexington, 1500;NY;0
Immediate sending to a list with default prefix 001 (international prefix is mandatory only when sending abroad)
#
#I
#MailUp
...
+4901512345678; Halo [#2], du heißt [#1];Merkel; Angela;2;Berlin;0
#commentary
Sending scheduled for February 29th, 2012 at 9:50 AM
#
#2012-02-29 09:50
#I
#MailUp
...
+4901512345678; Halo [#2], du heißt [#1];Merkel; Angela;2;Berlin;0
Immediate sending with one placemark only
#
#
#I
#MailUp
#1
#Special offer
...