Wednesday, February 17, 2010

BBM Messenger Log Cleanup Script

As mentioned previously, the CSV files produced by Blackberry Messenger 5.0+ need some cleaning up before they can be properly used. I finally wrote a short script for doing just that.

You can download the VBScript here: This code is released to the public domain.

Once you have the BBM log file on your computer (email it there from your phone, again, see the last post on this subject), just drag and drop it onto this VBS file, and a “clean” version will be produced as a separate file in the same directory. The new file will have human-readable dates and the message will be properly escaped – in short, it will be something you can just open and use in Excel (e.g.).

Change Log

Version 1.1 (Feb 20, 2010)

  • Added GMTOffset constant to allow timestamps to be properly adjusted for time zones.


Denise said...

I get an error when I tried this.

I'm not sure if that link will work. I'm new to googledocs. My apologies.

Can you please help me?

Joel said...

I tried opening that link but it says I do not have access to that file.

Can you explain what you did, and exactly what the error message said?

Gretchen Nobles said...

Hey - Great script! I have a couple of questions. How do I adjust to make the time display in 12 hour format? Also - is there a way to set my time zone? Central Standard

Joel A. said...

If you open the .vbs script file in Notepad, you'll see there is a place to edit the timezone.

The format of the time display actually is in 12hr format in the output csv file, but by default Excel converts it to 24hr format when displaying the time value. You can display it however you want by changing the cell formatting in Excel.