Windows 10 will reach EOS (end of support) on October 14, 2025. For more information, see this article.

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Hierdie gesprek is in die argief. Vra asseblief 'n nuwe vraag as jy hulp nodig het.

How can I organize History?

  • 3 antwoorde
  • 16 hierdie probleem
  • 6 views
  • Laaste antwoord deur cor-el

more options

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.

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.

Gewysig op deur MargaretBartley

Gekose oplossing

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 
Lees dié antwoord in konteks 👍 3

All Replies (3)

more options

Gekose oplossing

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 
more options

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.

more options

You're welcome.