Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Each column can be also written with a text qualifier, usually a single or double quote.

 

CSV Sample

...

Samples

Sample 1 displays "idList", "idNL", "Email", "subject", "statusType", "details", "statusChange" ( date ), "sentdate" ( another date ) and four dynamic fileds.

No Format
idList;idNl;email;subject;statusType;details;statusChange;sentDate;campo18FirstName;campo19LastName;campo33CustomerId;campo34TargetId
5;1555;email@sample.au;Subject of your campaign;OPN;http://clickurl.com/;20150513T232106;20150513T112026;John;Smith;34234;08586153085861532
5;1555;email@sample.au;Subject of your campaign;CLK;http://clickurl.com/;20150513T232206;20150513T112210;John;Smith;34234;085861532
5;1550;email-23445@sample.com;Campaign subject;NCO;;20150513T013820;20150508T150226;;;;0158634536
5;1555;email.sample@email.com;Campaign subject;NCO;HB   ;20150513T182035;20150513T112210;;;;001478445;2125401707

 

Sample 2 displays "idList", "idInvio" ( sendId ),"idNL" ( newsletter id ), "Email", "Subject", "statusChange", "sentdate" , "tags" and "FirstName"

No Format
idList;idInvio;idNl;email;subject;statusType;details;statusChange;sentDate;tags;FirstName
1;173;175;john@email.com;;CLK;Unsubscribe;20150521T105739;20150521T105733;Prova_Export;John
1;166;172;john@email.com;Test DynField;SNT;;20150521T105242;20150417T140808;Tag1, Tag2, Tag3;John
1;166;172;john@email.com;Test DynField;OPN;;20150417T141100;20150417T140808;Tag1, Tag2, Tag3;John

 

Sample 3 displays a csv layout inclusive of a single quote text qualifier. Text qualifier is very often used when "useragentdata" is part of the layout, as user agent might display characters that could be misread as separator.

No Format
'idList';'idInvio';'idNl';'email';'subject';'statusType';'details';'statusChange';'sentDate';'ipaddress';'countryname';'region';'city';'useragentdata''1';'14';'6';'demo@mailup.it';'Esempio di messaggio creato con un feed RSS';'OPN';'';'20140905T200936';'20140903T010936';'2.225.83.105';'-';'-';'-';'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20120907 Thunderbird/15.0.1'

Bounce chart

Allowed codes for bounces are listed in the table below

...