Does anyone know how to read the compressed richtext fields from the BCM 2010 database using SQL from Excel? I managed to retrieve user defined binary fields from the database, but can't seem to find any way to decompress the note fields from various forms, which appear to all be stored as...
I cam answer my own question. In BCM 2010 the fields are in a table called 'User Fields'. And they are still in binary format. See notes elsewhere here in the forum on how to read the binary format (search for "user defined field".)
In OL BCM 2007 it seems user defined fields were displayed in the IMAP views (based on a comment in this forum) , but they don't seem to be there any longer. I have added user defined fields to the BCM 2010 Project form and they work fine, but I can't find their content anywhere in MSSMLBIZ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.