[blincoln]

Hmm.
Could you do me a favour? Download and install OutlookSpy. Have someone send you a test message without anything in it that you'd be uncomfortable letting me see. Open the message in Outlook, then pull up the OutlookSpy IMessage view of it. Use the Save to File function to save it to a text file, then paste the contents into the form on the Contact page of my site (see signature) and send it my way.
We don't have 4.1.4 installed yet, so I can't test it myself to see if they changed the names of the fields or if something else is going on.
Your mod sounds like an interesting idea. The main reason I made the script work the other way is that I would generally be using it to figure out where a message was, without knowing which folder it was in.

[yk101]

B. - I sent you the message as requested. Sorry, it took me a bit of time because I had to actually buy a license for OutlookSpy (since I had a trial already and it has expired some time ago).

[blincoln]

Thanks for the quick response!
Wow, it's licensed now? I must have gotten it just in time before it became shareware. If I'd known, I would have asked you to use MFCMAPI/MAPI Edit instead.
Thanks for sending me the file. I see what appear to be the fields in it that the script is looking for (one of them is the one whose name shows as ????????D, since that's what you get when you take "PR_RIM_MSG_REF_ID" as an ANSI string but read it as if it were a Unicode string and try to display it using a standard font). You won't see the ones that are referred to by their hex ID in a message, those are in the hidden calendar sync folder that the BES sets up.
Do you get any output from the script, or just the error? If you do get some output, does it continue after the error, or does the error cause the entire script to abort?
One last thing - when the script fails, does it give you a line number indicating where the failure occurred?

[yk101]

The script does not fail (On Error Resume Next), but I did the following to see the error:

Function GetMessageFieldValue(objMessage, fieldNameOrNumber)
Dim fieldValue
On Error Resume Next
fieldValue = objMessage.Fields.Item(fieldNameOrNumber).Value
If Err.Number <> 0 Then
'fieldValue = "[NULL]"
fieldValue = Err.number & " :" & Err.Description
Err.Clear
End If
On Error GoTo 0
GetMessageFieldValue = fieldValue
End Function

So, what I get is this:

\Calendar item description [NULL] Updated: In-House Interview: xxxxx xxxx: ID No. 24823, Systems: Sr. W
indows 10/26/2007 5:34:30 PM 11/9/2007 3:45:47 PM -1359394560 -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_
FOUND(8004010F)]] -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]]

[blincoln]

Oh, right. So you get the results, but some of the fields have "[NULL]" in them? If that's all that's happening, that's expected behavior for two reasons:
- The BES tracks the calendar items in a completely different way than messages. I put them in different columns to help make it clear that it's not the same data that's being retrieved for the two item types. So you will get [NULL] in the calendar item fields for lines that belong to messages, and [NULL] in the message fields for lines that belong to calendar items.
- The BES only tags messages that have been synchronized with the BlackBerry. If you have a bunch of stuff in a folder that was too old to sync when you Enterprise Activated your handheld, it won't be tagged, and you will see [NULL]. Annoyingly enough, if you have an existing handheld, then wipe and re-Enterprise Activate it, and have a bunch of older mail that is too old to be synced during the Activation, it will retain its old tags and they will not be updated by the BES. The same applies to folders that are not marked for synchronization with the handheld - none of the messages will be tagged, and you'll see [NULL] for them in the output.
To give you a more concrete example, I developed the script in order to track down the "needle in a haystack" of some messages that were showing up in the BES logs for a particular user when they were moved to another folder (the user had accidentally done a drag and drop between their inbox and somewhere in their enormous Outlook folder structure and didn't know where they had ended up, and didn't remember enough of the specifics to search for them by their contents). I had the RefIDs from the logs, but nothing else. The user had thousands of messages in their mailbox, so going through each one with a tool like MFCMAPI was not practical (although to test my theory before writing the script I had MFCMAPI dump all of the items in the mailbox to text files and used Windows' file search to search for the RefID, which was very, very slow). What the script allowed me to do was dump all of that data in a relatively fast way, import the results into Excel, and sort or search through the data to find what I was looking for. With a mailbox like that one (a user who had been with the company for many years), the vast majority of messages were not tagged and showed as [NULL] in the fields for the BES tracking data. But the newer messages did contain the data I needed, particularly the RefID and FolderID.
So, TLDR: are you seeing data for newer messages in the message-related columns and data for the calendar items in the calendar item columns, or am I misunderstanding what you're describing?

[yk101]

If I would have some Null data I would not worry about it! All of the records I get have Null's in them as in the example above.

The reason I started looking at it is similar to yours, but from somewhat different angle. I have a number of VIP users for whom loosing an appointment is a very costly proposition. I'm monitoring logs (BESAlert and SysLog) and finding messages like:

<N/A> | BlackBerry Messaging Agent BES1 Agent 4 (Application Event Log on SERVER) | 11/12/2007 15:34:15 (AFFF4EDE) -> {abc@123.com} GetRIMCalendar() failed: SUCCESS, EntryId=956413

I'm trying to come up with something that would correlate this EntryId to an outlook entry. This way I can get one of his EA's to check if it actually got to the device.

I ran it through my own Outlook and. while I know all of my messages/appointments went to the device, I do not see any RefId's. I tried talking to RIM support about it, but they are completely lost.

[blincoln]

I'm going to run the script against my mailbox and match it up with what you're seeing. Would you mind posting a couple of the lines of output for what the script reads out of your Calendar and Inbox? The subject and to/from don't matter, so you can censor those out with Xs if you'd like. If they can be the most recent 2-3 things from each of those folders, that would be ideal.

[yk101]

Sorry, those are not the most recent entries, but they are all the same...
Here are my Calendar entries:

\Calendar xxxxxxx [NULL] Updated: Quick chat on PerTrac 11/7/2007 1:45:42 PM 11/7/2007 2:24:18 PM
-2069631360 -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]] -2147221233 : [Collaboration Dat
a Objects - [MAPI_E_NOT_FOUND(8004010F)]]
\Calendar xxxxxxxx [NULL] Systems Dinner / Peter's Send-Off 11/7/2007 4:49:00 PM 11/7/2007 4:49:0
0 PM -2057016320 -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]] -2147221233 : [Collaboration
Data Objects - [MAPI_E_NOT_FOUND(8004010F)]]
\Calendar xxxxxxx [NULL] Systems 11/10 DR meeting all hands 3:00 slot 11/7/2007 6:49:21 PM 11/7/2007 6:49:2
1 PM -1622863232 -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]] -2147221233 : [Collaboration
Data Objects - [MAPI_E_NOT_FOUND(8004010F)]]
\Calendar xxxxxxx [NULL] Systems Group Meeting 11/8/2007 12:24:27 PM 11/8/2007 12:24:27 PM -4053123
83 -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]] -2147221233 : [Collaboration Data Object
s - [MAPI_E_NOT_FOUND(8004010F)]]
\Calendar xxxxxxxx [NULL] Systems Group Meeting 11/8/2007 1:29:28 PM 11/8/2007 1:29:39 PM -8872968
95 -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]] -2147221233 : [Collaboration Data Object
s - [MAPI_E_NOT_FOUND(8004010F)]]
\Calendar xxxxxxxxx [NULL] CMS Performance Testing 11/8/2007 4:58:44 PM 11/8/2007 4:58:44 PM -1834167424
-2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]] -2147221233 : [Collaboration Data Objects - [MAP
I_E_NOT_FOUND(8004010F)]]
\Calendar xxxxxxxx [NULL] Updated: In-House Interview: xxxxxxx: ID No. 24823, Systems: Sr. W
indows 10/26/2007 5:34:30 PM 11/9/2007 3:45:47 PM -1359394560 -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_
FOUND(8004010F)]] -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]]

Here are my Inbox entries:

\Inbox xxxxxxx [NULL] RE: Case C0622653 - [14] Assistance w/ installing and config. of token for the blackberry
11/1/2006 7:01:25 PM 11/1/2006 7:02:29 PM [Not Found] -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(80
04010F)]] -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]]
\Inbox Microsoft Volume Licensing Services [NULL] Action Required: TechNet Software Assurance Benefits{~8107102:1~}
11/1/2006 7:44:26 PM 11/1/2006 7:44:56 PM [Not Found] -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(80
04010F)]] -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]]
\Inbox [NULL] Microsoft Software Assurance Study 11/1/2006 7:43:04 PM 11/1/200
6 7:59:31 PM [Not Found] -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]] -2147221233 : [C
ollaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]]
\Inbox xxxxxxx [NULL] SQLManager.net - do you have any questions about the product? 11/1/2006 8:07:26 PM 11/1/200
6 8:07:48 PM [Not Found] -2147221233 : [Collaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]] -2147221233 : [C
ollaboration Data Objects - [MAPI_E_NOT_FOUND(8004010F)]]

[blincoln]

Okay, so it looks like the calendar part is working, since you're getting the data in that column for the calendar entries. It's just the messages where it's not showing up.
Can you humor me and run an unmodified version of the script again, and post the line that it shows for the test message you exported and emailed me a copy of?

[yk101]

Thanks for looking into it B!

Here is the message using the "original" script.

Folder Sender Recipient Subject Sent Received Calendar RefID(s) PR_RIM_MSG_REF_ID PR_RIM_MSG_FOLDER_ID
\Inbox xxxxxxx, xxxxxxx [NULL] test 11/15/2007 1:19:31 PM 11/15/2007 1:19:32 PM [Not Found] [NULL] [NULL]

As you can see, the fields that I really want are missing (RefID(s), PR_RIM_MSG_REF_ID and PR_RIM_MSG_FOLDER_ID).

[yk101]

Actually, I turned on ANSI to Unicode and got the values for this one:

Folder Sender Recipient Subject Sent Received Calendar RefID(s) PR_RIM_MSG_REF_ID PR_RIM_MSG_FOLDER_ID
\master.nyc xxxxxxx, xxxxxxx [NULL] test 11/15/2007 1:19:31 PM 11/15/2007 1:19:32 PM [Not Found] -1910790235
-20
but it still does not explain why the Calendar does not work... All I'm interested in is matching RefId I get in the BES failure message to the actual entry...

[blincoln]

The Calendar part is working, at least in the example entries you posted earlier. Remember that the Calendar RefIDs get their own column, because they're stored in a different way. So in the examples you posted, the Calendar RefIDs were -2069631360, -2057016320, -1622863232, etc.
Are you viewing the output in Excel (or the OpenOffice equivalent of Excel) or just as a text file in something like Notepad? It makes much more sense if you open it as a tab-delimited text file in a spreadsheet app. That way you can (in your case) sort by the "Calendar RefID(s)" column, delete everything that has "[Not Found]" in that column, and look for the RefID you're after.