Kbase P42072: The Dynamics Export to Excel feature truncates data larger than 320 characters
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/03/2007 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.0A
Dynamics 2.1A
OpenEdge 10.0B
SYMPTOM(s):
Dynamics: New and Old values of Audit details are truncated to 320 characters when exported to Excel.
After changing a record and looking at the Audit Control, if the records are exported to Excel, the 'Value New' and 'Value Old' column values have been truncated to 320 characters.
Dynamics 2.1A03
CAUSE:
Known issue in data.p/tableOut, Dynamics exports hBufferField:STRING-VALUE in order to handle special formats:
field-loop2:
DO iField = 1 TO NUM-ENTRIES(cWantedFieldHandles, CHR(3)):
CREATE ttTable.
ASSIGN hBufferField = WIDGET-HANDLE(ENTRY(iField, cWantedFieldHandles, CHR(3)))
iPosn = LOOKUP(hBufferField:NAME, pcFieldList)
ttTable.iRow = iRowNum
ttTable.iCol = (IF iPosn = 0 THEN iField ELSE iPosn)
ttTable.cCell = TRIM(hBufferField:STRING-VALUE).
END. /* Loop through the buffer fields */
FIX:
The following suggestion has been submitted to development:
In data.p/tableOut, change the above code to:
field-loop2:
DO iField = 1 TO NUM-ENTRIES(cWantedFieldHandles, CHR(3)):
CREATE ttTable.
ASSIGN hBufferField = WIDGET-HANDLE(ENTRY(iField, cWantedFieldHandles, CHR(3)))
iPosn = LOOKUP(hBufferField:NAME, pcFieldList)
ttTable.iRow = iRowNum
ttTable.iCol = (IF iPosn = 0 THEN iField ELSE iPosn).
IF LENGTH(STRING(hBufferField:BUFFER-VALUE)) < 320
THEN ttTable.cCell = TRIM(hBufferField:STRING-VALUE).
ELSE ttTable.cCell = TRIM(STRING(hBufferField:BUFFER-VALUE)).
END. /* Loop through the buffer fields */