Engage Digital | Viewing export files

The format you select for an export will affect the format of the files which are included in the report. This section discusses the file formats and the associated CSV charset (code character set) encoding for each format.

For example, selecting the BI or Excel Window formats produces a UTF-8 compliant CSV file, while the Excel Mac format produces an ISO-8859-15 compliant CSV file. You can check the documentation for the application you use to read CSV files for details on compatible encoding.

The following table shows the encoding by format:

Format	Encoding	Byte-order mark	Strip line breaks	ISO 8601 date & datetime format	CSV column separators
BI	UTF-8	false	false	true	,
Excel Window	UTF-8	true	false	false	en , fr ;
Excel Mac	ISO-8859-15	false	true	false	en , fr ;

Locale

Depending on the locale (language) configured in your user account and the export format, the CSV export displays with a different format or separator. The purpose is to be compatible with the Microsoft Excel expectation that depends on the locale. Note that BI has a specific format for certain columns for easier processing by computers. Otherwise, it falls back to an English language format.

The following table shows the column types that are locale dependent:

Column type / format	BI	Windows EN	Windows FR	Mac EN	Mac FR
Boolean	1 / 0	true / false	vrai / faux	true / false	vrai / faux
Date	2013-09-24	09-24-2013	24/09/2013	09-24-2013	24/09/2013
Datetime	2013-09-24T19:00+00:02	09-24-2013 19:00	24/09/2013 19:00	09-24-2013 19:00	24/09/2013 19:00
Float	12.8	12.8	12,8	12.8	12,8

Column types available in exports

Your exports will contain a variety of data from different data types.

The following table lists all the column types available in exports.

Type	Example	Description
Array	My Facebook Page, My Twitter Page	Represents a collection of elements, such as string or objectId
Boolean	true	A boolean that can have the following values: Excel : ‘true’ / ‘false’ or ‘vrai’ / ‘faux’ BI : 1 / 0
Date	24/09/2013	The Date format changes depending on your language and the format you choose. Excel : fr : "%d/%m/%Y" 24/09/2013 en : "%m-%d-%Y" 09-24-2013 BI : "%Y-%m-%d" 2013-09-24 ISO8601
Datetime	24/09/2013 19:00	Represents an instant in time, typically expressed as a date and time of day. Format changes depending on your language Excel :fr : "%d/%m/%Y %H:%M" 24/09/2013 19:00 en : "%m-%d-%Y %H:%M" 09-24-2013 19:00 BI : "%Y-%m-%d %H:%M%z" 2013-09-24T19:00+00:02
Integer	12	A number that can be written without a fractional or decimal component
ObjectId	523ffffb7aa58d1b6700000f	A unique 12-byte BSON type identifier
String	“my Facebook Post title”
Text	“Hi, I cannot make phone calls using my new SIM card. Can you help me?”
Float	12,5	Represents a number with decimal component.The separator depend on your language: Excel :fr : ,en : . BI : .

Note: Excel has limits for cells and titles. A cell should not exceed 32767 characters and a title 255 characters.

Datetime and time zones

The datetime fields in exports are displayed in the user’s timezone. If the user has no time zone specified in his or her profile, the domain global time zone is used. You can specify a user's timezone by navigating to Users > Agents in the left navigation bar, and editing the Timezone field in the Settings section for the user.

Note : This does not apply for automated exports, which will use BIformat.

Example export file

The following is an example of an export file:

Created_at;source_id;source_type;source_name;content_thread_id;type;id;private_message;created_from;status;ignored_from;categories;intervention_id;creator_id;creator_name;author_id;author_name;body;title;foreign_id;foreign_categories

01/10/2020 08:35;523ffe057aa58d181f0000de;Tapatalk;LesMobiles;524a6db90f4ca18aec00002c;Réponse publique;524a6db90f4ca18aec00002b;Non;synchronizer;Nouveau;"";Commercial Centre de tri;"";"";"";524a6db90f4ca18aec00002a;scarcore;Bonjour

01/10/2020 09:19;523ffe057aa58d181f0000de;Tapatalk;LesMobiles;524a6db90f4ca18aec00002c;Réponse publique;524a77730f4ca1bdba000042;Non;synchronizer;Nouveau;"";Commercial Centre de tri;"";"";"";52413bcd7aa58dcb570000b5;Paglopp;Bonjour Pour la batterie : [url=http://esimport.fr/iphone-4s/257-batterie-iphone-4s-.html]http://esimport.fr/iphone-4s/257-batter ... e-4s-.html[/url] Pour remplacement de la batterie sur un iphone 4S : [url=http://esimport.fr/tuto/tutos-iphone/tutos-iphone4s/iphone-4s-%E2%80%93-demontage-batterie/]http://esimport.fr/tuto/tutos-iphone/tu ... -batterie/[/url];"";872905;iPhone 4/4S