Unite was based on BES 4.1 SP2, so I'm not sure if it's going to work on that platform or not.

So Unite is ready for home use?

I can add that the get "more" now works with html emails on 4.5.0.37!
Finally!

Has anybody tried this with Domino? Specifically 6.5.5FP2.

Wooo Hooo!! Did it and it worked like a champ. Thanks jibi!

Just wanted to add this little tidbit.

Updated BES to 4.1.5.24

As I have 200 users, and only one 8310 using OS 4.5, I went to manually make the changes to the database.

I made the changes to the serverconfig table.
When I went to make the changes to the userconfig table, everyone was already set to 1 for RichContentEnabled an also set t 1 for RichContentInlineEnabled.

So, now to watch the impact of this and see if anything slows down...

Spydertech

Has anyone found a way to have it auto-download the images instead of having to select it each time? I've looked in the BES and device, however I could have easily overlooked it.

Go to your Email, then click Options, then Email Settings and at the very bottom under Enable HTML Email is an option that says "Download Images Automatically". Make sure that is set to yes.

I have mine setup that way but still have to manually download the images

I don't see this in my options. I am running OS 4.5.0.18
Seems that everything is working except it won't display images, and i see no place to download them.

Resend your service books using BES manager.

I resent the service books, and still no luck. I have now upgraded to OS 4.5.0.37 , and still no luck.

Can't see the images in emails, and no setting for autodownload, or anything like that.

Any other suggestions?

Are you sure you made the necessary alterations to your BES configuration database?
And you're running SP5 on BES for Exchange (4.1.5), correct?

the fields to enable richcontent are there in Unite. But i have tried many times and cannot get html emails with unite.

hmmm,
can't get it to work. I have SP5 installed on BES but cannot get the SQL scripts to execute. I ran from the commandline on bes and got:

[20000] (06/09 18:24:04.496):{0x11E4} Database name: BESMgmt
[40000] (06/09 18:24:04.496):{0x11E4} Authentication Type: Database Authentication
[40000] (06/09 18:24:04.496):{0x11E4} DBMS Type: SQL
[20000] (06/09 18:24:04.590):{0x11E4} Database connection opened!
[20000] (06/09 18:24:04.590):{0x11E4} Reading input file: EnableRichContent.sql
[40000] (06/09 18:24:04.590):{0x11E4} ----------------------------------------------------------------------------
[40000] (06/09 18:24:04.590):{0x11E4} -- EnableRichContent.sql
[40000] (06/09 18:24:04.590):{0x11E4} --
[40000] (06/09 18:24:04.590):{0x11E4} -- This will turn on the Rich Content options for all
[40000] (06/09 18:24:04.590):{0x11E4} -- BlackBerry Enterprise Servers managed in the target database.
[40000] (06/09 18:24:04.590):{0x11E4} --
[40000] (06/09 18:24:04.590):{0x11E4} -- (C) 2008 Research In Motion Limited.
[40000] (06/09 18:24:04.590):{0x11E4} ----------------------------------------------------------------------------
[40000] (06/09 18:24:04.590):{0x11E4} UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
[40000] (06/09 18:24:04.590):{0x11E4} UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (06/09 18:24:04.590):{0x11E4} UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
[40000] (06/09 18:24:04.590):{0x11E4} UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (06/09 18:24:04.606):{0x11E4} ExecuteStatement: Unable to run the statement:
----------------------------------------------------------------------------
-- EnableRichContent.sql
--
-- This will turn on the Rich Content options for all
-- BlackBerry Enterprise Servers managed in the target database.
--
-- (C) 2008 Research In Motion Limited.
----------------------------------------------------------------------------
UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (06/09 18:24:04.606):{0x11E4} ExecuteStatement: Error: [ADOConnectionItem::ExecuteUpdateSQL(): Could not execute SQL Command "----------------------------------------------------------------------------
-- EnableRichContent.sql
--
-- This will turn on the Rich Content options for all
-- BlackBerry Enterprise Servers managed in the target database.
--
-- (C) 2008 Research In Motion Limited.
----------------------------------------------------------------------------
UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0".]
[10000] (06/09 18:24:04.606):{0x11E4} Problem occured while executing SQL commands.


So I when to the SQL server, which is 2000, selected BESMgmt and I opened the query analyser. I pasted the first line in and it failed as follows :

Server: Msg 512, Level 16, State 1, Procedure ServerConfigSaveCapTrigger, Line 29
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.


Any ideas guys?

thanks
Steve

Manually (and very carefully) make the needed adjustments to the SQL tables.

I agree. Pull up the ServerConfig and UserConfig tables and look at the RichContentEnabled and RichContentInlineEnabled columns.

so generally how many people do u guys have on ur bes server(s) when enabling it?

and it was supposed to impact the exchange server, right? so what perf issues has anyone seen with it both on bes and exchange?

I've also run the script and received the error ending with:
"Problem occured while executing SQL commands."

It seems the sql commands have problems when there is more than one bes server in the domain. I had to manually update the table columns (could also run the script if I selected only one of the rows as part of the logic, e.g., "UPDATE ServerConfig SET RichContentEnabled = 1 where id =4").

But now that I've successfully updated the sql tables, I still cannot get html/rich text to display on my bb. My config:
-BES 4.1.5
-Domino 6.5.6FP2
-BB 8800, OS 4.5.0.42
-Device message options-->Email Settings-->Enable HTML Email: Yes

Any ideas? Has anyone else gotten this working on Domino BES? Thanks!

You have to upgrade Domino.
It wouldn't work with 7.0 either. After an upgrade to 7.0.2 it worked like a charm!

Todd

I've got it on an 18-person test server. I won't put this into production until it's included and supported in SP6.

It's currently enabled for 2 users. We've seen no performance issues based on this relatively small deployment.

BES Version in my Unite ServerConfig Table says 4.1.5.24

will html work on that?

i changed all the richcontent fields to 1

i feel bad for the ones it does not work for, cause alot of times that is me. this time it works perfect for me!! i love it too, this is great, now i cant wait till the bold comes out but in the mean time, i am loving this.

I've tired enabling HTML support on our Domino 6.5.4 server. It's a no go. I guess the minimum Domino server support is 7.0.2 based on this thread. Here's what I got on the log:

BlackBerry Enterprise Server, Version 4.1.5.33
© 1997-2008 Research In Motion Limited
[ENV] Domino Version: 6.5.4.0, HF 0, FP 303431680
[ENV] Rich Content unsupported for current version of Domino

I hope HTML becomes supported with our version of Domino when HTML is officially supported by RIM.

We don't have any plan to upgrade to 7 or 8 anytime soon so HTML might be something we won't see for awhile.

OK - I have 4.5 on my device, and it's correctly showing HTML email delivered via BIS. But I can't get BES to work.

The BES is on SP5, I have the correct columns in the server and user tables, and they are stuffed with ones. I've rebooted the BES and re-sent the BES service books.

But on the handheld, when I receive an HTML email (from the BES account) it's just blank - no text or images, nothing. Yet I can get the plain text version just fine.

Any ideas?

Thanks,

P.

p.s. Quick thought - it couldn't be that this test rig is running against Exchange Server 5.5 could it? Has anyone else got the HTML stuff in SP5 working with Exchange 5.5 ?

Are you using PocketDay??

No. I've not got that much installed on this BlackBerry.

Thanks,

P.

Why does RIM require a BES upgrade to support HTML email, while Empower can do it with code on the handheld only?

Can we just run the script in Query Analyzer?

Thanks! After upgrading Domino on the BES server from 6.5.6 to 7.0.2, I was successful with getting rich text/html email to work.

When BES starts, you should see the following message on the console:
07/02/2008 03:10:35 PM [ENV] Domino Version: 7.0.2.2, HF 0, FP -1528624904
07/02/2008 03:10:35 PM [ENV] Rich Content supported for current version of Domino

Also, our mail servers are still on 6.5.x, but the BES server is on 7.0.2. So you don't necessarily need to upgrade Domino mail servers to get it working. I have found the same behavior with configuring Notes-encrypted mail. Good luck?

Great news! That's nice to know. Thanks for the info!

I have installed and disabled manually by inserting 0 in two columns in UserConfig DB.
After restart it works greate

This didn't work until I installed 4.5.0.37 on my BlackBerry Pearl. My BES is Domino 8.0.1 running BES 4.1.5 (obviously). I'm using MSDE locally without issue.

hey guys how do i turn on this feature only for few users instead of everyone.

deanesn - Welcome to BBF!

Personally, I wouldn't recommend doing this unless you're well versed with SQL and you are also great a documentation and change management ... to keep track of these changes. That said, doing this might break functionality in future versions of BES ...

use the sql commands:

UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0

but qualify them with specific users such as:

UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0 and MailboxSMTPAddr = "hdawg@blackberryforums.com"
UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0 and MailboxSMTPAddr = "hdawg@blackberryforums.com"

or ... you could go into the SQL tables and simply change the values.

None of these options I'd recommend doing though.

...

I'm stuck here trying to get this to work. I've got a BES box with 4.1.5.24 with exchange 03 environment and a SQL 05 DB box. Blackberry deivce is 8310 running 4.5.0.52(75)

The BBupdate through me errors so I opened the DB and modified the dbo.ServerConfig and dbo.UserConfig - RichContent tables and the BESOnlyMessages to ((1)) from ((0)). Restarted the SQL server and the BES server, re-pushed the service books from the BES and I still do not see the enable html or the BESOnly icon.

Any ideas on what's wrong with my setup?

Have you performed hard reset of your BB?

c:\bbdbrichcontent>bbdbpdate.exe -db <besmgmt> -n <localhost> -input enablerichcontent.sql

I get "system cannot find the file specified."
I must be in silly mode this morning. I can't figure it out.... Do I need to extract it somewhere else.

win2003/domino 7.0.3/BES 4.1.5/MSDE db

I do have a Virtual Server setup on this same box, but it's db is named differently and it's not even running at the momemt