Import CSV file into Record Link table blob field for Customer Notes

Business Central/NAV Developers Forum
1

I am trying to import some data into NAV 2009 R2 from CSV to populate the customer notes.

I have a text field of 70 chars which I want to put in the blob field. I have written a dataport .
//Read in Blob Data
“Record Link”.Note.CREATEINSTREAM(StreamInObj);
StreamInObj.READ(Comment);

but I get this error !

The stream cannot find a zero-terminated string.

The string may be invalid, or (variable or requested) size may be too small.

Any help please most appreciated.

2

You need to use READTEXT to read from the Note blob. But if you want to write a note see this link → http://www.dynamics.is/?p=463

Gunnar Gestsson