UBports Robot Logo UBports Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    SMS thread printout howto?

    Scheduled Pinned Locked Moved Unsolved Support
    4 Posts 4 Posters 342 Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
      Reply
      • Reply as topic
      Log in to reply
      This topic has been deleted. Only users with topic management privileges can see it.
      • U Offline
        uwahl
        last edited by

        Hello folks,
        could anyone please suggest me a way how to do a printout of an SMS thread? Using history.sqlite database of messaging app and some Linux program...
        Thank you for thinking about!

        lduboeufL 1 Reply Last reply Reply Quote 0
        • lduboeufL Offline
          lduboeuf @uwahl
          last edited by lduboeuf

          @uwahl said in SMS thread printout howto?:

          Hello folks,
          could anyone please suggest me a way how to do a printout of an SMS thread? Using history.sqlite database of messaging app and some Linux program...
          Thank you for thinking about!

          i'm afk, so will be short sorry
          Database for sms is stored in ~/.local/share/history-service/history.sqlite
          As the name suggest it is a sqlite database so you can copy it to your computer and use a sqlite browser.
          There is a Thread table iirc where you can play with.
          Admitting you know some SQL.

          There is a CLI tool also on UT so you can just do sqlite [thedbabsolutepath] "SELECT * FROM threads;"

          A 1 Reply Last reply Reply Quote 0
          • M Offline
            Mirslow
            last edited by

            I just wanted to ask if anyone’s tried using Teleports or File Manager to grab the SMS database directly and format it outside the phone? I’ve been looking into exporting conversations too, and I’m curious if newer scripts or tools have come up lately that make this easier, without needing to mess too much with command line stuff.

            1 Reply Last reply Reply Quote 0
            • A Offline
              ancientsounds @lduboeuf
              last edited by

              @lduboeuf
              Should be sqlite3, not sqlite
              (on this version, anyway)

              1 Reply Last reply Reply Quote 0
              • First post
                Last post