Member List Upload
Widget Connector width 960 url https://www.youtube.com/watch?v=tVRYTZCzE20 height 540
Data Import to RMC Data Warehouse platform requires 1 zip file with the following 2 files:
//Status subtle true colour Red title txt
: text file containing dataStatus subtle true colour Red title csv Status colour Green title mandatory
: xml file containing campaign definitionsStatus subtle true colour Red title xml Status colour Yellow title optıonal
The developers are responsible with the following in order to upload the data and launch the related campaigns:
- Select data from the database and prepare the text file using the data.
The extension of the text file must be .txt or .csv - If it exists, prepare the XML file that contains the campaign definitions.
- Zip these two files into a single Zip file and name it.
- Send it via SFTP to the RMC Data Warehouse SFTP site sftp://file.euromsg.com using the SFTP Username & Password provided by the RMC Security Team.
Note |
---|
|
Panel |
---|
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:
|
Data types of Columns
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).
Warning |
---|
The max length of string variable is 1024 |
Code Block | ||||
---|---|---|---|---|
| ||||
EMAIL|NAME[string(50)]|BIRTH_DATE[datetime]|LOYALTY_POINT[float]|AGE[int]|INCOME_LEVEL[money]|GENDER[combo.string(1)] |
Code Block | ||||
---|---|---|---|---|
| ||||
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.
Warning |
---|
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. |
Tip | ||
---|---|---|
| ||
|
Incremental Data Upload
You can add new members or update the user information in the current tables with incremental data upload.
Note |
---|
You may use REST or SOAP methods for incremental data upload. |
Tip | ||
---|---|---|
| ||
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. |
Code Block | ||||
---|---|---|---|---|
| ||||
EMAIL|NAME|SURNAME email1@test.com|name1|surname1 email2@test.com|name2|surname2 email3@test.com|name3|surname3 |
Code Block | ||||
---|---|---|---|---|
| ||||
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) |
Uploading your Product Catalog
You can upload your Product Catalog using the Data Warehouse module.
Panel |
---|
Things to consider while preparing your PRODUCTS table:
|
Code Block | ||||
---|---|---|---|---|
| ||||
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 |
Uploading Promotion Codes
You can upload the promotion codes using the Data Warehouse module.
Panel |
---|
Things to consider while preparing PROMO_CODES table:
|
Code Block | ||||
---|---|---|---|---|
| ||||
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