1. Hover your cursor over the Maropost logo and click on ‘Email’. On the campaign index page, hover your cursor over ‘Contacts’ and click ‘Tables’.

Screen Shot 2016-04-15 at 10.03.19 AM

2. This will open the tables index page. Hover your cursor over ‘Contacts’ again, and click ‘New Table’. Enter the name for the new table.

Screen Shot 2016-04-15 at 10.04.41 AM

When creating a relational table file, please ensure you follow these three rules:

(i) Column order in file must match the table field.
(ii) Column header must match the name and syntax of table fields.
(iii) Dates in the file must be specific format; yyyy-mm-dd hh:mm (all lowercase).

NOTE: you must only use lowercase letters, numbers, and underscores in the table name. If you include ANY capital letters, spaces, or special characters in the name, you will receive a SQL error. You’ll notice that if you use a capital letter in the table name, you will still be able to create the table, but will receive an error when attempting to load data into it.

Example  My Table << is not allowed
My_Table << is not allowed
my_table << is allowedScreen Shot 2015-09-16 at 9.38.04 PM

4. The first empty space is to name the column (eg. email, ID, gender). Then select the type of data this column will hold. The data types are explained below:

 

· String: This is a sequence of characters, which can either be a constant or a variable. The strength for the datatype is 255. The default value can be left blank.

· Integer: This is for a whole number, which can be positive, negative, or zero. The maximum value for the data type is 11. The default value can be left blank.

· Boolean: This is also known as true or false

· DateTime: This is for data in the date/time format. The default value can be set as null.

· Text: This is for data that is used to put the ‘Text’ entities in the column. The maximum limit for the datatype is 65535 bytes.

· Email: This datatype can only store the email address of the contact. It is the only column in Maropost which can be set as sendable for tables.

5. After selecting the datatype for the column, we can give it a default value. The default value depends upon the datatype selected. The column can also be kept blank.



6. The next step is to enter the ‘Field Length’. Set the maximum value for the column, keeping in mind that there is already a maximum value set for every datatype at the backend which cannot be exceeded.

7. We can set a behaviour for the column created in this table. The options are listed in detail below:

(i) Auto-Increment – Automated process to increase the value for the column.
(ii) Primary Key – Uniquely identifying constraints for each record in the database. It should contain unique values. The primary key cannot contain a null value. A table can only have one primary key.
(iii) Allow Null – If no value needs to be provided. Empty data can be imported if the column has been set as ‘allow null’.
(iv) Sendable – How you set the relationship between the contact in a table and the contact that is in the contact database.