
How can I organize History?
It seems like I asked this question before, but I can't find it, so forgive me if this is a repeat.
A few weeks ago, I remember visiting a website, but I can't remember it's name, and I did not bookmark it.
Since I do save my History, isn't there some way I can export it, and then delete all the junk third-party ad sites, and consolidate them all by website, so instead of 15,000 entries, I have a few hundred?
Also, is there a way to find out the last time I visited the site?
Is there a way to export history into a structured file?
I tried to do a copy and paste, and every export option seemed to have a problem. When I pasted it into Notepad, only the URL showed up, but not the name of the page, which I need.
When I pasted it into Excel, it was all one cell, with no End-of-Line markers.
When I pasted it into Word, it was all hyperlink text, showing only the name of the website, but not the URL.
I need both, and preferably the last time it was accessed. Is such a thing available?
Thanks in advance.
Modified
Chosen solution
See:
SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_idRead this answer in context 👍 3
All Replies (3)
Chosen Solution
See:
SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id
Thank you. I had a rough start, because I didn't realize I needed to download SQLLite first, but eventually I got it working. Plus, I found out about SQLLite!
Thanks.
You're welcome.