GP Dyamics OLE Notes structure question

[fmcmurray]

Hi All

We doing an implementation of GP 10 for a client, the accounting dept. loves the idea of attaching the OLE Notes to the vendor cards and journal entries. The IT dept is questioning the amount of drives space that will be needed per item. Does anyone have a structure or sizing of the OLE Notes?

Thanks

Fred McMurray
AccessTek LLC
GP Warrior

 

[winthropdc]

OLE notes are stored in a folder as defined by the OLEPath setting in the Dex.ini.

There will folder for each company with a OLENotes folder. The OLE objects are stored as files with a name representing the 'Note Index' value as Hexidecimal.

The size of the files will be approximately the same size as the files or objects stored in them.

You would need to look at what the customer wants to store to decide how much space will be needed.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[JohnTcolo]

In practice we are usually talking kb's or mb's for the entire OLE folder and all the OLE objects. Size/space is not a major concern with the size of most hard drives today.

 

[RobertC22]

In nine years of using Great Plains, at one site, the number of files created due to OLE notes is 4,534.
These 4,500 files consumes 8.24Gb space.
Most of these OLE note attachments are Excel spreadsheets.
The largest single file is 55Mb.

In comparison there are 48,433 records in the SY03900 table for text based notes only.
Within the SQL database, this table takes up 51400 KB ( as reported by sp_spaceused ).

------
Robert