0

Currently when using the CSV Buffer to import, values with more than 250 charcters get cut:


if Length > 250 then

  Length := 250;

Rec.Value := String.Substring(CurrentIndex, Length);


This should be changed to handle the values the same way they are handled in the Excel Buffer by writing and reading to or from a blob field.


write:

"Cell Value as Text" := CopyStr(Value, 1, MaxStrLen("Cell Value as Text"));

if StrLen(Value) <= MaxStrLen("Cell Value as Text") then

  exit; // No need to store anything in the blob

"Cell Value as Blob".CreateOutStream(OutStream, TEXTENCODING::Windows);

OutStream.Write(Value);


read:

if ExcelBuffer."Cell Value as Blob".HasValue() then begin

  ExcelBuffer.CalcFields("Cell Value as Blob");

  ExcelBuffer."Cell Value as Blob".CreateInStream(RecInStream, TextEncoding::Windows);

  RecInStream.ReadText(CellTextValue);

end;


Category: Development
STATUS DETAILS
New