From September, Flash will no longer be supported by Chrome. Prepare for the shift towards HTML5 by visiting our Flash to HTML5 help page

Check it out!

XML Requirements

Requirements and specs for XML data source:

Good example of XML structure: http://test.adform.com/banners/mindaugas/xmls/e-shop-xml.xml
This kind of XML structure is very good and it is easy to make a data transformation from it to Adform XML template. Regarding the other requirements and specs please see below:

Collection:

via HTTP or FTP (if FTP - login credentials should be provided)

Format:

  • XML: correct
  • Document needs to have a root node
  • Every node needs to be closed correctly
  • No HTML tags in content recommended (e.g. no <br/> tag like "1st line.<br/> 2nd line.")
  • Encoding should be UTF-8, ISO-8859-1 or Windows-1252: or better always to use UTF-8
  • No XML specific characters in contents "&" or "<" ,else they have to be encoded ( "&amp;" und "&lt;") or in a CDATA tag
  • Product item's unique value should not be longer then 200 symbols (including spaces, commas, etc.)
  • Product item's values should not be empty, at least one character is required for each (can not be only space). 
  • It is recommended, that all external sources (e.g. image url, landing page url, data feed url) use secure protocols (HTTPS), if it is not for a direct campaign. HTTP can be used in direct campaign.

Plus - every product node (instance) must have a unique value, something like id, sku, number or unique string combination.

Following such specs we should get a nicely formed XML source and there shouldn't be any issues to import it to Adform system.

 

Requirements and specs for CSV data source:

Collection:

  • via HTTP or FTP - login credentials should be provided.

CSV structure validation check:

  • first row should be set as column (field) names;
  • fields values should be separated with comma (,) vertical bar (|) , semicolon (;) delimiter or TAB separated;
  • if comma (,) is used as a field values delimiter and there are texts that contain commas then text strings should be added to double or single quotes qualifier, like:
    id111,Product A,"Some text string, another word, test",http://deeeplink.com,price 11eur
  • encoding should be set to UTF-8;
  • every product instance must have a unique value, something like id, sku, number or unique string combination;
  • product item's unique value should not be longer then 200 symbols (including spaces, commas, etc.).
  • Product item's values should not be empty, at least one character is required for each (can not be only space). 
  • It is recommended, that all external sources (e.g. image url, landing page url, data feed url) use secure protocols (HTTPS), if it is not for a direct campaign. HTTP can be used in direct campaign.

Tip: if CSV is formed right after opening it with MS Excel you should see data values nicely filled to columns.

 

CVS source samples:

CSV file with comma delimited fields - http://test.adform.com/banners/mindaugas/csv/comma_delimited.csv:

product_id,product_name,product_category_id,product_deeplink,product_image,product_price
id-1,Head saver,Head holders,http://dcodemo.adform.com/eshop/?product_id=1,http://files.adform.net/Banners/Stream/images/head-saver.jpg,90
id-2,Diet belt,Clothes,http://university.adform.com/eshop/?product_id=2,http://files.adform.net/Banners/Stream/images/diet-belt.jpg,10.50
id-3,Washing boots,Good Ideas,http://university.adform.com/eshop/?product_id=3,http://files.adform.net/Banners/Stream/images/washing-boots.jpg,30.33
id-4,Dream pillow,Head holders,http://university.adform.com/eshop/?product_id=4,http://files.adform.net/Banners/Stream/images/dream-pillow.jpg,150.00
id-5,Time killer,Good Ideas,http://university.adform.com/eshop/?product_id=5,http://files.adform.net/Banners/Stream/images/time-killer.jpg,9.99
id-6,Pimped comb,Good Ideas,http://university.adform.com/eshop/?product_id=6,http://files.adform.net/Banners/Stream/images/pimped-comb.jpg,90.00
id-7,AB Hancer,Good Ideas,http://university.adform.com/eshop/?product_id=7,http://files.adform.net/Banners/Stream/images/ab-hancer.jpg,177.77

CSV file with semicolon delimited fields - http://test.adform.com/banners/mindaugas/csv/semicolon_delimited.csv:

product_id;product_name;product_category_id;product_deeplink;product_image;product_price
id-1;Head saver;Head holders;http://university.adform.com/eshop/?product_id=1;http://files.adform.net/Banners/Stream/images/head-saver.jpg;90
id-2;Diet belt;Clothes;http://university.adform.com/eshop/?product_id=2;http://files.adform.net/Banners/Stream/images/diet-belt.jpg;10.50
id-3;Washing boots;Good Ideas;http://university.adform.com/eshop/?product_id=3;http://files.adform.net/Banners/Stream/images/washing-boots.jpg;30.33
id-4;Dream pillow;Head holders;http://university.adform.com/eshop/?product_id=4;http://files.adform.net/Banners/Stream/images/dream-pillow.jpg;150.00
id-5;Time killer;Good Ideas;http://university.adform.com/eshop/?product_id=5;http://files.adform.net/Banners/Stream/images/time-killer.jpg;9.99

CSV file with comma delimited fields and texts separated commas:
http://test.adform.com/banners/mindaugas/csv/comma_delimited_texts.csv:

product_id,product_name,product_category_id,product_deeplink,product_image,product_price
id-1,"Head saver, product",Head holders,http://university.adform.com/eshop/?product_id=1,http://files.adform.net/Banners/Stream/images/head-saver.jpg,90
id-2,"Diet belt, nice item",Clothes,http://university.adform.com/eshop/?product_id=2,http://files.adform.net/Banners/Stream/images/diet-belt.jpg,10.50
id-3,"Washing boots, good idea",Good Ideas,http://university.adform.com/eshop/?product_id=3,http://files.adform.net/Banners/Stream/images/washing-boots.jpg,30.33
id-4,"Dream pillow,sweet dreams",Head holders,http://university.adform.com/eshop/?product_id=4,http://files.adform.net/Banners/Stream/images/dream-pillow.jpg,150.00
id-5,Time killer,Good Ideas,http://university.adform.com/eshop/?product_id=5,http://files.adform.net/Banners/Stream/images/time-killer.jpg,9.99