Navigation :
test ../../../ test data-connectors-overview.html
Data Connectors Overview
test ../../../ test data-connectors-overview/whats-new.html
- What's New
test ../../../ test changelog.html
Release and migration notes
test ../../../ test dee-overview.html
Data Extraction Engine
test ../../../ test dee-overview/configuration.html
-
DEE Configuration
test ../../../ test dee-overview/transactions.html
-
DEE Transactions
test ../../../ test dee-overview/responses.html
-
DEE Responses
test ../../../ test dee-overview/user-guide.html
-
User Guide
test ../../../ test dee-overview/user-guide/dee-orders.html
-- Interacting With the DEE
test ../../../ test dee-overview/user-guide/dee-order-structure.html
--
DEE Order Structure
test ../../../ test dee-overview/user-guide/dee-order-structure/output.html
---
DEE File Output
test ../../../ test dee-overview/user-guide/dee-order-structure/output/extraction-procedures.html
---- DEE Extraction Procedures
test ../../../ test dee-overview/user-guide/dee-order-structure/output/ouput-columns.html
----
DEE Output Columns
test ../../../ test dee-overview/user-guide/dee-order-structure/queries.html
---
DEE Queries
test ../../../ test dee-overview/user-guide/requests.html
--
DEE Requests
test ../../../ test dee-overview/user-guide/responses.html
--
DEE Responses
test ../../../ test dee-overview/design-and-customizations.html
-
DEE Extensions
test ../../../ test dlc-overview.html
Data Load Controller
DEE File Output
The transformNAToEmpty
property only applies to non-measure output columns, for example level output columns. To format N/A measure output columns see DEE Measure Output Column .
JSON Structure
"output" : {
"@type" : "fileOutput" ,
"locale" : ,
"tailoredColumnsHeader" : ["Header 1" , "Header 2" , ... ],
"hasColumnNamesHeader" : true ,
"surroundWrittenDataWithQuotes" ,
"transformNAToEmpty" : false ,
"measureValueIfNull" : "" ,
"filenameRoot" : "whatever_you_want" ,
"csvSeparator" : "," ,
"maxRowsPerFile" : 1000000 ,
"maxRawDataSizePerFile" : 10737
"compressionType" : "NONE" ,
"keepOutputFileIfFailure" : true ,
"columns" : [
...
],
"extractionProcedure" : {
...
}
}
Property Details
Property
Values
Default Value
locale
String
Locale.getDefault()
tailoredColumnsHeader
List of String
hasColumnNamesHeader
Boolean
True
surroundWrittenDataWithQuotes
Boolean
False
transformNAToEmpty
Boolean
False
measureValueIfNull
String
Empty String
filenameRoot
String
File Name
csvSeparator
String
“,”
maxRowsPerFile
Integer
1,000,000
maxRawDataSizePerFile
Long
1 GiB
compressionType
CompressionType: “NONE”, “ZIP”, “GZIP”
ZIP
keepOutputFileIfFailure
Boolean
True
columns
List of DEE Output Columns
extractionProcedure
Optional extractionProcedure
Compression Types