Mr. Steve Endow over at Dynamics GP Land managed to unearth my All about the Dexterity OLE Container article in response to a question he fielded from a user who no longer used GP, but wanted to know if they could extract the content embedded in the note files.

In my 2008 article I explained the intrinsic details regarding how OLE notes where created and stored in GP and promised a follow up with a way to automate or access these files externally from GP. During the past two years I have never stopped researching (on and off of course) how these files could possibly be accessed. At the end of the day, it comes down to identifying the actual storage compression algorithm used.

As part of this research, I tested a few tools including Corel's WinZip tool, which is often considered a very good tool for identifying obscure storage compression formats. However, I had no luck with WinZip. I also tried (successfully I may add) creating my own OLE container application, but failed to be able to open the Dexterity OLE Container files created…

Frank has got a very good and informative post on the Ubiquitous GP Note Field.

There are couple of warnings (rather word of caution) given out. One critical point is: Notes can be modified or deleted by any user who has access to the Transaction Window or Inquiry Window where the Note resides. Why would GP allow a Note residing in an Inquiry Window, that…

This came up for me 2x this week alone on 2 different projects. Just about every time you have to insert a record into a GP Table you have to get the next note index. While it's a simple thing, it may not be obvious exactly how to do it.

Run this against your…

Microsoft's David Musgrave takes on OLE attachments and record notes based on a support case he tackled recently. David reviews the process use by Dynamics GP to retrieve the next note index value and how the system associates…

Hi folks


Here is another tip from our tame Dex developer Jon, which I have written up as an article for us mere mortals. The below article should help you if you need to bring back an image from the OLE notes folder in Dynamics GP.

To start with you need to know how OLE notes get their file names. Well the file name is the hexadecimal version of the note index held in the Dynamics GP notes master table (SY03900).

Therefore to reference the file you are going to need to convert decimals to hexidecimals. The below function will allow you to do this.

udfConvertBase10NumberToAnyBase function:

CREATE FUNCTION udfConvertBase10NumberToAnyBase

( @iNumber INT,

@iNewBase INT,

@bitUppercaseOnly BIT = 0,

@bitNoNumbers BIT = 0) --1 to use only alphas

RETURNS VARCHAR(120)

AS

BEGIN

DECLARE @vUppers…

I spent this morning discussing a very interesting customisation with my good friend Mariano Gomez.  We had both seen a newsgroup posting asking if it was possible to add access to the Item Master's record note from the Item Inquiry window using VBA. Mariano had told me that he wanted to see if he could do it and this morning sent me the first version of his code as a package. 

After a long messenger chat and a few ideas from me, he came up with a…

Quite an informative article from David on OLE Attachments and the Record Notes.

If anyone…

“You have too many note windows open. Close a note window”

Mariano in his post about Notes in Microsoft…