Can a text file created through 'Database Output' meet the following requirements?
* Each column is to be Delimited using comma(,) * String column has to be written with double quotation (" ") * Math Numeric column has to be written without having double quotation as a column delimiter
Solution
No. The text file created through database output (not Table Conversion) cannot have mixed data format.
The Database Output method in Report Design Aid (From Section menu ->Database Output) does not support multiple formats where String columns are delimited with double quotation marks (" ") and Math Numeric columns without the double quotation marks.
Currently Database Output supports,
Operations
Insert only
Update
Insert or Update
Delete
Type
Comma delimited file
Fixed length record file
Output format
Numbers
String
Date
Comma Delimited file
32 digit numbers
Same size with defined DD size
JDE Date Format
Fixed length record file
32 digit numbers
Same size with defined DD size
JDE Date Format
Example
Output from Database output option (without converting numeric into String): 000000000000000044465.5900000000 (Does not meet requirement as zeroes '0' are padded in front of math numeric value.
Output from Database output (after converting data into String): "44465.59" (Does not meet requirement as it is quoted with " (double quotation))
Output from Table Conversion (in setting output format, number): 44465.59 (meets requirement) based on Data Dictionary (DD) definition
NOTE:
The file created through Type 'Comma Delimited file' added " (double quotation) to indicate beginning of string and end of string
Each column is delimited using a comma
This output can be useful in converting output to Excel File like *.csv file output in report
The file created through Type 'Fixed length record file' does not indicate the start of string and end of string
There is no delimiter between columns
The above requirements can be accomplished by using the Table Conversion Tool in EnterpriseOne. The Data format (e.g. String, Number, Date, etc.) can be specified for each column.
Create Table Conversion Report
Define as follows for the output file (User Defined Format - type)
Format Type: Delimited - characters such as commas or tabs separate each column
Set Column Delimiter: Comma (,) or define Other if needed
Textual Qualifier: Select "Double Quotation". This will quality for String output value
In your defining output column set type Number (you can choose String, Number and Date)
Note: Through the use of Event Rules, additional logic can be implemented, if needed, to manipulate the data and the data format when creating the text file using the EnterpriseOne Table Conversion tool.