{"id":387,"date":"2010-09-20T02:10:24","date_gmt":"2010-09-20T01:10:24","guid":{"rendered":"http:\/\/www.penguino.co.uk\/?p=387"},"modified":"2011-06-26T03:16:48","modified_gmt":"2011-06-26T02:16:48","slug":"inq-chat-mini-3g-sms-backup-and-export","status":"publish","type":"post","link":"http:\/\/www.penguino.co.uk\/computing\/inq-chat-mini-3g-sms-backup-and-export","title":{"rendered":"INQ Chat Mini 3G \u2013 SMS Backup and Export"},"content":{"rendered":"\n\n\r\n\n\n\n

\"\"<\/a>I have been a proud owner of an INQ Mini 3G <\/a> phone for about 6 months. It is easily the best small 3G handset that I have ever used. It has social networking features jam-packed inside (Facebook, Twitter, MSN, Yahoo, Bebo, Google, Skype), plus all the standard 3G handset feature such as HSPDA 3G web browsing, camera, MMS, music player,\u00a0HSPDA\u00a0Modem, Bluetooth,\u00a0 etc.. \u00a0To top it all there is free Skype to Skype call without topping up – all that in a handset for \u00a330 in the UK. \u00a0Some might disagree but I cannot praise it enough!<\/p>\n

Being a small handset does have its limitation though. Looking around at the INQ user forum <\/a>I noticed that a few users were experiencing problems where their SMS stores were overloaded. Some users also wish to keep their SMSs<\/a> before deletion but there isn\u2019t an official way. So poking around the INQ\u2019s\u00a0 backup system (INQ PC Suite) I have found a stop-gap solution to export the SMSs from my INQ Mini. I presume that the following method should work for both Chat 3G and Mini 3G.\u00a0 The method is a bit of a hack, please bear with me and\u00a0I hope I can write a PC application to do this in future.<\/p>\n

First, back up your phone like you normally do,\u00a0using the INQ PC Suite\u00a0(obviously making sure that you check the tick box to backup the messages)<\/p>\n

<\/p>\n

\"\"<\/a><\/p>\n

Let PC Suite does its business.\u00a0 What happened is that: inside the default directory where PC Suite is installed, the path: C:\\Program Files\\PC Suite\\userdata<\/strong> will contain a backup file ending with the extension .mbk (for example if I back up my phone today – 19 Sept 2010, a file called 2010919XXXXXXXX.mbk<\/strong> will be created inside the directory C:\\Program Files\\PC Suite\\userdata<\/strong>) where \u00a0XXXXXXXX is the timestamp.)<\/p>\n

\"\"<\/a><\/p>\n

So we will go ahead and let the backup to proceed….<\/p>\n

\"\"<\/a><\/p>\n

If all goes well, your backup will proceed to completion. A backup report will show the location of the .mbk<\/strong> file once again. Make a note of this location. \u00a0\"\"<\/a><\/p>\n

Thanks to the INQ’s software team – this file is actually a Microsoft Access 2003 database format. Before you go ahead and open it – please make a backup copy first<\/span><\/strong><\/span> to prevent accidentally loss of data,\u00a0and then renaming the extension from .mbk<\/strong> to .mdb<\/strong> – MS Access database extension.<\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

You can then open this file with MS Access or import it into MS Excel (via the menu [Data], [Import External Data], [Import Data]). In this database file, there are a few other tables for other items such as your contacts, calendars, etc. But for our SMS purposes, the table you should look out for is the table “Sms_From_NV<\/strong>“. \"\"<\/a><\/p>\n

Voila – it contains all the SMS messages (from the phone\u2019s memory) with the phone numbers which were sent\/received. Note: The field\/column “SMSPosition” contains the value with<\/p>\n

“8” = the SMS is outgoing (Sent box)<\/p>\n

\u201c9″ =\u00a0 the SMS is incoming (Inbox)<\/p>\n

\u201c11\u201d\u00a0 = the SMS is either a Draft or a Template<\/p>\n

\"\"<\/a><\/p>\n

The field\/column “SMSTime” contains the date and time code\u00a0 yyyymmddhhmmss. However, it is in text (memo) format and any prefixing zeros seem to be dropped with a blank space character during the backup.\u00a0 So in order to use this field for sorting purposes one would need to convert it.\u00a0 In Microsoft Access you can write a function using the REPLACE function to replace the space with \u201c0\u201ds. In Excel you can create a new column and use the SUBSTITUE function to substitute the space with \u201c0\u201ds from the original column.<\/p>\n

I hope the above info will help some of you. If I get time, I intend to develop an application which can decode the data format properly, and to export the SMSs as xml\/html\/excel\/csv. If you need any help or have any comments, please feel free to drop me a line.<\/p>\n