SMS Log Report

[trojanex]

Good morning all,

I am somewhat new to BES and am learning a great deal everyday.

Currently we are logging SMS messages on our BES. I need to give the boss a report on 2 users. Does anyone have a report viewer they use or any other trick to make the SMS log easily sortable and readable?

I have been playing with the file in Excel but am not having all that much luck.

Thanks for the help.

[trojanex]

Yes, we can.

They are in the "logs" folder and show up in a CSV format.

[jackie treehorn]

I'm just throwing this out there can they be converted to pdf format and sent that way?

[dpogi1]

Trojan, not sure if this will help, but here's the process I follow to convert the SMSLog_<DATE>.csv to somethig readable:
1. Open Excel and Get External Data from a Text File (I'm on 2007)
2. Select Delimited, Start at Row 1, File Origin Windows, <NEXT>
3. Delimiter - Comma (nothing else) <NEXT>
4. Keep all at default <FINISH>
5. I usually have it put into a new worksheet.

And that's it. You may have some issues with the "Body" field, as any carriage returns will be read by Excel and completely screw up your formatting. I've tried writing a VBS to remove the CRs, but that didn't work.

My question to follow up is... Has anyone created a macro to automate this process? From say, the log folder for that specific day? I've got a bit of a time crunch today, as I need to provide a report of the last 2 months worth of SMS logs into excel, and sorted by user. Aside from Retain and/or finding a new job, does anyone have any suggestions?

Any help is appreciated greatly!