Exporting Text Messages from a Windows Phone

converting 130876138886889000 from ticks to datetime in powershell >> [datetime] 130876138886889000 << returns 25 September 0415 00:18:08

so the date is off by 1600 years.

Hi

I cannot use powershell inside Excel,can I ?

I just need someway to convert this Epoch time in to normal time.

I searched for answers and I found the formula I have used but still no luck.

I am not sure why the date of off by 1600 years, perhaps its the formula I used.

One of the post used

(F2-6*3600)/86400+25569 which gave me

1514770151574 and using Powershell it returns Tuesday 2 January ,0001 6:04:37 p.m

Take a look at this thread. There is an app for Windows 8.1 pc to export test messages to the PC.

http://answers.microsoft.com/en-us/mobiledevices/forum/mdlumia-mdtips/sms-backup/daabcc3e-696c-4536-b501-b161eb06668a?page=5#LastReply

See page 5 of the thread. this is the PC app

https://www.microsoft.com/en-us/store/apps/windows-phone-message-backup/9nblggh2srtp

Hi,

The apps seems to be good to get your messages and export them as text too.

Although I got the messages ,they cannot be used as evidence as the mobile numbers are not captured.

Its not that I have a pressing need to use the messages as evidence.

I wish to back up all the messages in an excel spreadsheet.

I managed to use an app to export all the text message in an XML file.

Unfortunately the XML file is not giving me the date and time in the correct format.

I thought the time is in Epoch format but it isn't and hence I cannot convert it unless I know what format has been used.

To give an example

130876138886889000 represents 25/9/2015 12:18:08pm

I am trying to find out a formula to convert this number which will help me.

If someone knows of any app to export text messages from a Windows 8.1 mobile and import in Android 5.1 that will be great.

I am even happy if I can keep record of the old messages in an excel sheet in case something crops up later and I need the messages as evidence.

I found the easiest way of exporting messages from Windows Phone and restoring it in on Android.

I have not still tried  the importing part.

Windows Mobile 8.1 gives an App called Transfer my Data.

Using this application one can click on the 3 dots and export the messages on the SD card.

The exported file is in a .vmsg format.

On Android there is application called VMG convertor which will be able to import the text messages.

Before importing it, one needs to add the contacts first which should be easy if you are storing the contacts on the account(live)

This software is free to import only 200 messages.

The cost is only $2 to unlock it and import more.

All the best.

I will let you know how it goes as I have managed to get the .vmsg file and now just need to buy the software.

In case anyone is still interested, the localTimestamp is based on the number of 100 nanosecond increments since 00:00 Jan 1, 1601.

So to convert it to a unix timestamp use the following formula in excel:

=FLOOR( ( LocalTimestamp /10000000) - 11644473600, 1 )

Where 11644473600 is the number of seconds from 00:00 Jan 1 1601 to the unix epoch.

1. Get the old contacts+message backup from the Windows Store
2. Run contacts+message backup (by clicking Open in the Store) and backup SMS/MMS
3. Copy the file (found on SD Card) from WP to Android phone (I used OneDrive)
4. Install VMG Converter from Play store
5. Run VMG Converter, click the Path button, then select Auto
6. It should find all the files you copied and will import all messages if you pay $2 for full version

Thanks a lot. I used the first part of your formula

but I did not use powershell

I instead used this formula to convert your FLOOR formula

=(((A2/60)/60)/24)+DATE(1970,1,1)

That converted it to a date format, then I formatted the text using Format Cells and selected date.

Then it appeared as a normal date.