Can Sage NOTE be retrieved 1

[vbdbcoder]

Hi there,

Sage 300 v2023, Module is NOTE. Their SQL tables begins with "KN". I tried to get the contents of the NOTE. It seems that the data is encrypted in the table "KNNTBLOB".

Would anyone confirm if this is the case, and we can't export the NOTE?

Thanks in advance.

 

[DjangMan]

Blob fields are encrypted in the sense that the binary data of the file has been converted into a text equivalent. You'll have to write a utility to query the database and then process the contents of the field. BLOB fields don't work the same way as other SQL fields as you can't just get their "value". You're going to get a stream of bytes and then you save that to a file stream or a memory stream so you can then render the object.

 

[vbdbcoder]

Thanks DjangMan!

I confirmed that the customer is only using text in the NOTE. I could do a CAST to get the text out. I figured I should share it.

SELECT [NOTEUNIQ]
,[PARTNUM]
,[AUDTDATE]
,[AUDTTIME]
,[AUDTUSER]
,[AUDTORG]
,CAST([BLOBDAT] AS VARCHAR(MAX)) TextBLOB
FROM [dbo].[KNNTBLOB]

 

[DjangMan]

Nice!