SMS_Borer - Export SMS data from backup file(.ipd)
Please Login to Remove!
I develop this utility to export sms data from backup file (*.ipd). To some people who have plenty of SMS, they can use it to export SMS data on PC. And then process it using any application you like (For example, MS excel). There is a .ipd sample in zip package for your reference. Any feedback is welcome. Enjoy it.
(1)Running following command and export data to "output.dat". You can open the .dat file using MS Excel and use its text_to_columm function to separate data to several columns.
(2)Format of output file "output.dat"
One line is one SMS. Every Fields are separated by "|"(7CH). For example
1st Field: Seq no
2nd Field: Direction. 1 for receiving, 0 for sending.
3rd Field: UST(GMT +0)
4th Field: For receiving, time stamp with SMS
For sending, UST(GMT+0)
5th Field: Far end mobile number
6th Field: SMS content. Don't support unicode at this version.
Test on Win2K & XP and confirm it pass for following platform
DM Ver: 4.0.0.x, 4.0.1.x, 4.1.0.xxx
BB OS: 4.0.0.x, 4.0.2.x, 4.1.1.xxx, 3.8.0.xxx
I tried it, but it didn't give me anything useful. Not sure how I could use this utility in a beneficial way. If the SMS content field would actually show the text from the message it would be much more useful.
Sure. It's used to export info from SMS backup file. Have you tried the sample ipd in package? is it ok? If yes, you get correct way to use this utility.
If the content of your SMS include unicode (For example, East Asia Character), pls try another unicode version here. It work well with simplied chinese and should be ok for Japanese & Korean.
me again... so i tried the program, and as bradwhiteau says it does not seem to extract all the messages that are stored in the ipd file. I tried IPDEditor too, which displays all messages, but that program does not allow the export of the messages :(...
I'm also trying to convert the file myself, found the documentation of the ipd file (general structure, database block set-up), but from that documentation it is not quiet clear, who to convert the none ascii parts, e.g. the conversion of the timestamp is a ridle to me, how to convert that? Maybe you can point me to another doc.
Hope you'll come back to this forum and see my remark ...
I have a utility for extracting SMS, Contact, E-Mail, Phone Log and Calendar info to a comma separated values file. Its not free, but it is cheap ($10). Its called bbExtractor and comes with a report writer called textifire.
I noticed someone asked for PIN messages. I don't know what that is, but I could add it to the extractor if there is interest.
I can't put a URL in my posts until I've made at least 10 posts, but if you google either 'bbextractor' or 'textifire' the home page will come up.
You can buy the software from the products page, it downloads as a self-extracting zip file. Once you've installed it you just click 'Find Files' to search for ipds then double click the backup file you want to open. Every database in the ipd is listed on the main screen (there's usually about 60 or so). From here you double click the database name you want to open, or click the corresponding speed button on the top row and the contents of the database appear in a spreadsheet-like grid. From here you can export to a csv file or pipe the output to the report writer and reformat it how you wish.
There are some automation features tied to the 'Config' button, such as a default search start directory and automatic database opening that can save some effort if you use the program a lot.
This whole process started for me when my girlfriend gave her blackberry to her nephew and needed to pull her contact and schedule info off her phone and I was shocked to find there was no easy way to do it. I then added email, sms and phone log extractors as well as viewing cabability for all the other databases in the file.
Anyway, I hope you find this utility useful and I am open to suggestions on how to improve it.
Glad you like the software. All the databases stored in the ipd can be viewed in bbExtractor by double clicking the name on the main screen. I haven't found one that contains the outbound SMS files but if it's there I'll find it. I'll keep you posted.
Incoming and outgoing SMS are stored in the same database. Look for field type 0x0B. If the first byte of data for that field is 0x00, the message was sent. If the first byte of data for that field is 0x01, the message was received.
I rolled a Sent/Received flag into my last update of bbExtractor which also fixes the email timestamp issue. If you still need any help with timestamps, just drop the tech support guys a line at textifire.