Merge two Skype chat archives

Question

i'm looking to parse the real time rates from this webpage: http://www.truefx.com/ into my java programs, ie, i want the data from the webpage that is refreshed on a second by second basis to be constantly streamed into my program.

I would like to do this using the standard java libraries, if possible. i'm aware of plugins like jsoup and possibly others, but i'd like to not have to download and install the plugins as the computer i'm using's hard drive is based in california and everything but a few core programs, eclipse being on of them, gets deleted every night when the system restarts.

So if anyone knows of a package in the standard eclipse download that can do this, please let me know! thanks

---

ok so i got this working, but it seems very slow. for example the data will change on a second by second basis, and even though i'm refreshing the webpage that i read from on a second by second basis also (i used thread.sleep(1000)), and then get a new instance of the webpage, it only updates once every minute or so. what gives?

here's what my code looks like (i used what you posted above as my url reader) :

 public String getPage(String urlString){
        String result = "";
        //Access the page
        try {
         // Create a URL for the desired page
         URL url = new URL(urlString);
         // Read all the text returned by the server
         BufferedReader in = new BufferedReader(new InputStreamReader(url.openStream()));
         String str;
         while ((str = in.readLine()) != null) {
             // str is one line of text; readLine() strips the newline character(s)
             result += str;
         }
         in.close();             
        } catch (MalformedURLException e) {
        } catch (IOException e) {
        }          
        return result;
    }

    public static void main(String[]args){
        int i =0;
        Reading r = new Reading();

    while(true){
        try{Thread.sleep(1000);}catch(Exception e){}
        String page = new String(r.getPage("http://www.fxstreet.com/rates-charts/forex-rates/"));
        int index = page.indexOf("last_3212166");
        //System.out.println(i+page);
        i++;
        System.out.println(i+"GBP/USD: "+page.substring(index+14,index+20));
    }

Solution 1

How can I merge 2 chat history of this two account into one?

If you're still using Skype 3.x, you can export the history to HTML (HTML files can be merged easily).

If you're using Skype 4.x, here's a tutorial how to Save Skype chat history. The output will be TXT files which you then can merge.

Solution 2

Use this open source tool: http://suurjaak.github.io/Skyperious/

It can compare and merge two main.db files, which contain all messages (among other things).

Solution 3

It is not possible to have chat history merged from multiple Skype installations until they are up and running all the time (in fact Skype syncs them while they are online).

And of course it is almost impossible to keep them always running in daily life.

AFAIK the only automated solution that merges Skype chat history is a Skype plugin G-Recorder which works well for me up to now.

Solution 4

Last I looked Skype used unencrypted SQLite tables for conversation history. Some googling and a tool to merge SQLite tables may be able to help here.

View more solutions

Comments

[Adewale Oluyinka]

Found out that is impossible. I can only export my message to HTML or text. So this answer below is acceptable.

[Corbin]

The standard Java libraries do not have any HTML parsing capabilities. Also, have you looked into this yourself at all? Seems like a quick google could have turned that up. Also, if everything gets deleted nightly, how are you keeping your source code? Edit: Actually, it looks like Java does have some built in stuff: en.wikipedia.org/wiki/Java_API_for_XML_Processing

[russell88]

thanks. i looked into it a bit, but probably could have searched a little harder before asking.

[russell88]

well its not really that things get deleted but more to do with the classpath being reset, or something. i don't fully understand how the system is set up i just know that you can't change the class path permanently.

[Husni]

I just tried skyperios, but after I opened two different skype main.db, the "compare two databases" button is grey out, am I missing something or anyone have a clue?

[Martin Prikryl]

Welcome to SU. Please do not ask questions in answer. Use comment instead (just like this one).

[Admin]

right, you want to get the same chat history on BOTH computers? this is not possible, however, if you're logged on at the same time on both computers with the same account (and only then) you will get the history for any chat on both machines, if you log out/turn off one machine, then only the other machine can keep the history.

[Adewale Oluyinka]

My office PC is using Skype 3.8 and I cannot find a way to export my message to HTML format. Can you show me how?

[Admin]

@hvtuananh - open the chat you want to export and type the following command into the message window: /htmlhistory

[quack quixote]

you've posted the same link in answers to four different questions, three of them today. some users may consider this spam. if you are affiliated with the product, it's best to admit it, and make certain you only post it to questions to which it really applies.

[Zeeshan]

Your software is unable to "sync" chats on multiple installations. It may be sending a copy to your email, but that is not what "sync" means. Even the FAQs say: The chat history will be merged in your email box.

[Hastur]

I had (some time later ;) the same idea about SQLite3. The ones interested in can get some hints from this other answer... and do some gym with no need of 3rd party programs.