Hello,
I am trying to export data using business rule. Here is the export rule.
SET DATAEXPORTOPTIONS
{
DataExportLevel ALL;
DataExportDynamicCalc OFF;
DataExportNonExistingBlocks OFF;
DataExportDecimal 4;
DataExportPrecision 16;
DataExportColFormat ON;
DataExportColHeader Period;
DataExportDimHeader ON;
DataExportRelationalFile ON;
DataExportOverwriteFile ON;
DataExportDryRun OFF;
};
FIX("No Account",
"Undefined_Department",
@Relative("TS", 0),
"Undefined_Class",
"Undefined_Location",
"Undefined_Department",
@Relative("TP", 0),
@Relative("TSB", 0),
BegBalance,
"Unit",
"UnitPrice",
"ItemDescription",
"No Year",
"Budget",
"Total Budget",
"Base",
"USD"
)
DATAEXPORT "File" "," "/u03/lcm/nspbcsProjectEstimates.csv" "";
ENDFIX
What I am trying to achieve is to export text values. However, when I try to run this rule, for some reason the text values becomes numbers.
Here's the sample of the export. The ItemDescription is where the text values are.
Can someone please provide me insight as to how the text values can be exported? or if there is something that I need to change on this business rule?
Thanks so much!!