File Export Types

The following are the available file formats and types to export from the TMMData platform. 

PIPE Delineated

field|"field 2"
val1|"value 2"
vala|"Value B"

CSV Delineated

field,"field 2"
val1,"value 2"
vala,"Value B"

JSON Formatted

{"columns":[{"name":"field"},{"name":"field 2"}],"row":[{"cell":["val1","value 2"]},{"cell":["vala","Value B"]}]}

Semicolon Delineated

field;"field 2"
val1;"value 2"
vala;"Value B"

TAB Delineated

field field 2
val1 value 2
vala Value B

**Note: This format is specifically built for Adobe Sitecatalyst SAINT uploads.  If delivering this file (beyond direct file download), it will deliver this file with the .tab extension and then a complementary 0 byte file withe the same file name and the extension .fin. 

TXT Tab Delineated

field field 2
val1 value 2
vala Value B

XLS Formatted

Standard Microsoft Excel format for 2007 and back.  The data will be within the first and only "Worksheet".

XLSX Formatted

Newer Microsoft Excel format for 2008 and forward.  The data will be within the first and only "Worksheet".

XML Formatted

<?xml version="1.0" encoding="UTF-8"?>
<source>
<name>Data</name>
<columns>
<name>field</name>
<name>field 2</name>
</columns>
<row>
<cell><![CDATA[val1]]></cell>
<cell><![CDATA[value 2]]></cell>
</row>
<row>
<cell><![CDATA[vala]]></cell>
<cell><![CDATA[Value B]]></cell>
</row>
</source>

TDE Tableau Encoded

Standard Tableau Encoded format for Tableau Server or Deskop Versions.

See the full information here.