Data Import to RMC Data Warehouse platform requires 1 zip file with the following 2 files:
The developers are responsible with the following in order to upload the data and launch the related campaigns:
|
Things to consider while preparing the TXT data file The most important issue while transferring data to the RMC Data Warehouse platform is to prepare a .TXT data file. There are a number of things to consider in order to prevent erroneous upload:
|
You can set the data types of columns. For example, you could use the ‘money’ type for currency data or ‘float’ for decimal data. Other data types are datetime, string(length), integer and combobox.If you don’t specify the data types of the column names, the system will generate all columns as varchar (100).
The max length of string variable is 1024 |
EMAIL|NAME[string(50)]|BIRTH_DATE[datetime]|LOYALTY_POINT[float]|AGE[int]|INCOME_LEVEL[money]|GENDER[combo.string(1)] |
EMAIL|NAME|SURNAME|BIRTH_DATE|SEGMENT|LOYALTY_POINT it@euromsg.com|IT|EuroMessage|2003-01-01|A|09 jason@hotmail.com|Jason|Goodwill|1987-03-02|B|77 hans@yahoo.com|Hans|Muller|1983-08-04|A|63 |
This sample file will create a 6 column table in your RMC Data Warehouse account.
Please note that LOYALTY_POINT column is 2 length integer column and data is prepared accordingly. Please don’t forget that the first row must include column names. |
|
You can add new members or update the user information in the current tables with incremental data upload.
You may use REST or SOAP methods for incremental data upload. |
If base table name is all_member_data.zip, incremental file name should be all_member_data_20141225_inc.zip System can detect the _inc notation and know that it is an incremental upload, it will match the base file name (all_member_data) and set the version name (20141225). Data is always collected in base table therefore while sending email campaign you should only use base file as the target list. |
EMAIL|NAME|SURNAME email1@test.com|name1|surname1 email2@test.com|name2|surname2 email3@test.com|name3|surname3 |
EMAIL|NAME|SURNAME email1@test.com|updated_name1|surname1 (This one updates the first name of the first user) email4@test.com|name4|surname4 (This one inserts a new user to the base table) email5@test.com|name5|surname5 (This one inserts a new user to the base table) |
You can upload your Product Catalog using the Data Warehouse module.
Things to consider while preparing your PRODUCTS table:
|
PRODUCT_ID;PRODUCT_NAME;COLOR;PRODUCT_PRICE;IMG_URL;TARGET_URL 1354ASC;shoe;brown;149.99; http://yourwebsite.com/img/shoe.jpg; http://yourwebsite.com/products/1354ASC 139CSA1;tshirt;blue;23.99; http://yourwebsite.com/img/tshirt.jpg; http://yourwebsite.com/products/139CSA1 1535KCA;bag;black;79.99; http://yourwebsite.com/img/bag.jpg; http://yourwebsite.com/products/1535KCA |
You can upload the promotion codes using the Data Warehouse module.
Things to consider while preparing PROMO_CODES table:
|
CODE;CATEGORY;EXPIRE_DATE;DESCRIPTION DWH012;Anniversary;19.04.2015; 10% discount code for your anniversary. DWH013;Anniversary;19.04.2015; 10% discount code for your anniversary DWH014;Birthday;19.04.2015; 10% discount code for your birthday. DWH015;Anniversary;19.04.2015; 10% discount code for your anniversary. DWH016;Birthday;19.04.2015; 10% discount code for your birthday. |
Parent Topic: Data Warehouse SFTP Integration