Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-03-2019, 01:18 PM
Stjamesg8 Stjamesg8 is offline Need to reverse order of SMS text messages a program has exported to Word Windows Vista Need to reverse order of SMS text messages a program has exported to Word Office 2007
Novice
Need to reverse order of SMS text messages a program has exported to Word
 
Join Date: Feb 2009
Posts: 11
Stjamesg8 is on a distinguished road
Default Need to reverse order of SMS text messages a program has exported to Word

I found a free program that can export/backup text messages from my smartphone, and saves as xml. When I right click on the xml file and select "Open with Microsoft Office Word", it reverses the order of the messages by date, with newest messages at the top. The xml file doesn't include the dates that I can decipher, but that's okay. I just want the messages in order from oldest to newest (top to bottom) so I can at least follow the correct sequence when reading through them. Individual messages are separated by hard breaks. Is there a way I can have Word reverse the order? I'm using Word 2007. I guess this would be the same as reversing a simple list of items?
Reply With Quote
  #2  
Old 11-03-2019, 04:20 PM
Guessed's Avatar
Guessed Guessed is offline Need to reverse order of SMS text messages a program has exported to Word Windows 10 Need to reverse order of SMS text messages a program has exported to Word Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,735
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

Can you open the XML file in Excel instead of Word?

If so, you should be able to re-sort them there and then copy to Word (if that is your preference).
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 11-03-2019, 05:21 PM
Stjamesg8 Stjamesg8 is offline Need to reverse order of SMS text messages a program has exported to Word Windows Vista Need to reverse order of SMS text messages a program has exported to Word Office 2007
Novice
Need to reverse order of SMS text messages a program has exported to Word
 
Join Date: Feb 2009
Posts: 11
Stjamesg8 is on a distinguished road
Default

Thank you for the suggestion. I get the option to open in XML Editor, but the result is no different than clicking directly on the file since the default is to open in XML Editor. Yes, I tried opening the file directly in Excel, but I guess the way the SMS backup program (SyncDroid) creates the XML file really creates a mess in Excel, and several messages are completely X'd out. Strange.

I found a work-around, although a bit time consuming. With all 23 messages in the Word doc, I sequentially numbered the messages, placing the numbers in front of the first word of each message, and used the number Sort option, descending order. But still no dates for each message other than in the form of (eg) 1572810081000. How anyone can get 11/03/19 out of that is beyond me.

Sure glad I'm not working with 100s of messages, but I don't text that much.
Reply With Quote
  #4  
Old 11-03-2019, 05:29 PM
Guessed's Avatar
Guessed Guessed is offline Need to reverse order of SMS text messages a program has exported to Word Windows 10 Need to reverse order of SMS text messages a program has exported to Word Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,735
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

It would be pretty quick to run a macro to work on paragraphs to do the autonumbering, fix the numbers, sort in reverse order and then remove the numbers.

Can you provide a little sample xml file that shows what the message structure is?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 11-03-2019, 05:52 PM
Stjamesg8 Stjamesg8 is offline Need to reverse order of SMS text messages a program has exported to Word Windows Vista Need to reverse order of SMS text messages a program has exported to Word Office 2007
Novice
Need to reverse order of SMS text messages a program has exported to Word
 
Join Date: Feb 2009
Posts: 11
Stjamesg8 is on a distinguished road
Default

Here are three of the messages with content and personal info x'd out. "type1" = person I'm communicating with; "type 2" = myself

<?xml version="1.0" encoding="UTF-8"?>
<SmsRecords><sms><address>xxxxxxxxxxxxxx</address><body>xxxxxxxxxxxxxxxxxxxxxxxxxxxxx</body><date>1572724623592</date><type>2</type></sms><sms><address>xxxxxxxxxxxxxxxxx</address><body>xxxxxxxxxxxxxxxxxxxxxxxxxxxx</body><date>1572723979315</date><type>1</type></sms><sms><address>xxxxxxxxxxxxxxxxxxxxxxxxxx</address><body>xxxxxxxxxxxxxxxxxxxx</body><date>1572722590940</date><type>1</type></sms>
Reply With Quote
  #6  
Old 11-03-2019, 06:47 PM
Guessed's Avatar
Guessed Guessed is offline Need to reverse order of SMS text messages a program has exported to Word Windows 10 Need to reverse order of SMS text messages a program has exported to Word Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,735
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

Presumably the date numbers could be used for sorting even though we can't see what they mean in terms of day/month/year. Surely a bigger number is a later date/time.

When I open the xml in Word, I get a pattern of 6 paragraphs per message. If you convert this to a 6 column table (separated by paragraphs) and then sort on the date column then you should have the means of determining the correct order.

You can probably work out the algorithm for the date by looking at the difference between two messages (date & time) in the SMS and the number difference in the xml. Is the xml number showing number of seconds after a particular date/time? Perhaps it is documented in the software you are using to extract the xml.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 11-03-2019, 07:00 PM
Stjamesg8 Stjamesg8 is offline Need to reverse order of SMS text messages a program has exported to Word Windows Vista Need to reverse order of SMS text messages a program has exported to Word Office 2007
Novice
Need to reverse order of SMS text messages a program has exported to Word
 
Join Date: Feb 2009
Posts: 11
Stjamesg8 is on a distinguished road
Default

Thanks again for taking the time to help. I will check further with the software company and see what they have to say.

I did locate another free program called APower Manager that allows copying SMS messages to the clipboard, which can be pasted into Word, Notepad, etc, and includes not only the date of each message, but time as well. Very clean interface. The big problem is, in a conversation, the program splits up sender/receiver into two separate entities, so there's no way to back up/copy an entire conversation in sequential order of both parties. Very odd.
Reply With Quote
  #8  
Old 11-04-2019, 05:34 AM
Charles Kenyon Charles Kenyon is offline Need to reverse order of SMS text messages a program has exported to Word Windows 10 Need to reverse order of SMS text messages a program has exported to Word Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 7,667
Charles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud of
Default

What is the first program?
Reply With Quote
  #9  
Old 11-04-2019, 07:16 AM
Stjamesg8 Stjamesg8 is offline Need to reverse order of SMS text messages a program has exported to Word Windows Vista Need to reverse order of SMS text messages a program has exported to Word Office 2007
Novice
Need to reverse order of SMS text messages a program has exported to Word
 
Join Date: Feb 2009
Posts: 11
Stjamesg8 is on a distinguished road
Default

I believe it was Android SMS Transfer. I also tried APowersoftManager and Coolmuster Android (trial versions)
Reply With Quote
  #10  
Old 10-15-2021, 03:11 AM
Jakov93 Jakov93 is offline Need to reverse order of SMS text messages a program has exported to Word Windows 10 Need to reverse order of SMS text messages a program has exported to Word Office 2010
Novice
 
Join Date: Jul 2021
Posts: 17
Jakov93 is on a distinguished road
Default

I faced the same problem
after googling, the sorting depends on the application itself
for example,
Super Backup Pro, makes XML and sort messages from newest to oldest.
SMS Backup & Restore, make XML and sort messages from oldest to newest (best choice).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
reverse order of paragraphs, word 2010 moorea21 Word VBA 1 08-02-2018 03:47 AM
open dialog box in Word has folders in reverse alphabetical order Rewster Word 2 02-20-2017 08:06 AM
Need to reverse order of SMS text messages a program has exported to Word Reverse Order for Flashcards? bknollman3 PowerPoint 2 03-23-2013 06:34 AM
wildcards in find & replace to reverse word order jeffk Word 3 11-11-2012 01:47 PM
Reverse order of headings throughout Word my_vine_figtree Word VBA 1 08-17-2010 01:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft