Notes in RTC

eagle_eye

In the Classic Client, if I wanted to transfer comments, I would load them into the Comment Line table, but I am now using the RTC and was wondering where the comments are being stored now for the Notes fact box.

I thought I might be clever and check the tables before and after adding some notes to see if any sizes changed, but that was not successful.

Any clues where they are now?

kine

It is same table as links...;-)

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

eagle_eye

Ah hah! Sneaky. Thank you. I see how it works now. Awesome.

psekar

Hi

Note links are stored in table "2000000068 = Record link table" .

But the comments are not stored in the table. It is stored in properitoty format of RTC. Now it can not be seen.

Regards
Sekar

kine

psekar wrote:

Hi

Note links are stored in table "2000000068 = Record link table" .

But the comments are not stored in the table. It is stored in properitoty format of RTC. Now it can not be seen.

Regards
Sekar

It is not true... the comments are stored in the blob type field in this table and the text could be read from there. There is just special character at the begining (length) of the text and the blob is compressed by default. ;-)

psekar

I am not able to see these information in the Record Link table.

Attached is the sceen shot

Ian_Piddington10199

The data is held in the Note field. as this is a BLOB you can't just view it in NAV by zooming or running the table.

if you take a look at
http://midynav.blogspot.com/2009/11/how-to-read-blob-data-and-export-into.html
there is an example of how to export the blob to a text file.

regards

Ian

psekar

Thanks Ian for the details

Alex_L

Hello there,

you mentioned the special character on the beginning of the field:

kine wrote:

psekar wrote:

Hi
It is not true... the comments are stored in the blob type field in this table and the text could be read from there. There is just special character at the begining (length) of the text and the blob is compressed by default. ;-)

It looks quite messy with the "special character" when you print the "Notes" on classic reports:
Like:
ÕAus der Umsatzsteuervoranmeldung
or:
þBemerkungstext

Is there a way to remove the character? I already tried to remove the first 3 characters, but with some "Notes" it was ok and for others it was too much removal.

Furthermore if I stream the "Notes" from the blob it messes up the special german characters. In what format are the notes stored? Does not seem to be ascii or ansi or utf-8 or something else I have Codeunits for conversion.

Any ideas?

Regards

Alex

horinas

When the notes are saved in RTC it is done using a BinaryWriter. This method first writes the length of the string as a UTF-7 encoded unsigned integer.
See http://msdn.microsoft.com/en-us/library/yzxa6408.aspx for more info.

almhansen

If i wanted to bring Notes into the system as part of data migration, how would I do that?

Nightrider

Hi guys,

There's a way to read and write Notes without purchasing, installing or writing any 3rd party app to do it. Here is a How-to on how to automatically write notes for RTC from RTC or Classic:
http://www.sbsintellect.co.za/index.php ... nav-rtc-2/

Please let me know if this works or not.
Vincent Connell