Although the files created by SMS Backup & Restore and Call Logs Backup & Restore are XML files, they can be easily viewed in any Web browser (like Internet Explorer or Firefox) and can also be opened in MS Excel.

Before using any of the methods, Make sure that the preferences for “Add XSL Tag” and “Add Readable Date” in the Preferences of the app are checked before taking a backup.

There are multiple ways to view the files:

  • Use a Backup Reader
  • Open it in a Web Browser
  • Open it in MS Excel.

Use a Backup Reader (Only for SMS at this stage)

Matt at XtNetworks is working on a Java based Viewer for the backup files which is probably the easiest way to view the files on a computer. The program now works with displaying threaded conversations on
Windows, OSX, and Linux and it can also export messages to text files. More information is available at his site: http://devadvance.com/sms-backup-reader/

View the backup data using a Web Browser:

To be able to view  the files on a computer, the first thing to do is to make sure that the preferences for “Add XSL Tag” and “Add Readable Date” in the Preferences of the app are checked before taking a backup.

  • Copy the backup file to a folder on the computer.
  • For SMS Backup & Restore:
    • Copy the sms.xsl file to the same folder. (This file can be found in the same folder where the backup file was created by the app).
  • For Call Logs Backup & Restore:
    • Download (right click on the link and select “Save Target As” or “Save Link As” or equivalent on your browser) Calls.xsl (for Call Logs Backup & Restore) file and store it in the same folder as the xml file.
  • Open the xml file in the browser. The browser will now display it in a friendly HTML format.

 

Threaded view for SMS Messages:

BlueChip has put together a nice stylesheet to display the SMS Messages in a threaded view. Currently it only works on Opera and Mozilla Firefox.

  • Make sure that the preferences for “Add XSL Tag” and “Add Readable Date” in the Preferences of the app are checked before taking a backup.
  • Copy the backup file to a folder on the computer.
  • Click here to download the ZIP file containing the scripts and style sheets required.
  • Once downloaded, extract the files from the ZIP file into the same folder as the backup XML file.
  • Open the XML file in the browser. The browser will now display it in a friendly HTML format with a threaded view.
  • You can also change the style/theme by changing the option in the drop down.

View/Edit messages using MS Excel:

MS Excel can also be used to edit these files if you are not comfortable in editing them in a text editor. Here are the steps involved to do that:

  • Open Excel and select File -> Open and then select XML Files (*.xml) in the file type dropdown.
  • Select the backup file from the list.
  • Press Open.
  • Press OK.
  • Press OK.

  • The 4th column will have the date as stored in the file and is not easily readable. The readable date gets added further to the right of the list in the 2nd last column called “readable_date”. The format of this date can be changed when creating the backup by changing the “Readable Date Format” setting.
  • If the backup file does not contain the “readable_date” then it can be calculated…
  • To view the date in a human understandable format, enter the following value in a new column and then copy it to all the rows:
    =([@date]/86400000)+25569
  • Format the new column as a date/time.
  • Done.

If you edit the file in Excel, it may not allow you to Export it back to xml and display this error message:

To be able to export again:

  • Open the Developer Tab in the Ribbon Bar
  • Click on the Source button.
  • Remove the Count Element from the Map.
  • Now Excel should let you Export.