This thread was archived. Please ask a new question if you need help.
i want to save the autocomplete history of websites visited
It seems that Firefox has stored some of the websites I've visited according to the spelling of each website. I would like to know if it's possible to save the collection of websites that comprise this "autocomplete function."
All Replies (4)
Open history in the sidebar by hitting CTRL+H, then right click the bookmark and choose "Bookmark this page".
Does pressing Ctrl+H and right clicking the bookmark save all of the "autocomplete function" of all the collections of all the websites and their URLs, I presume, that have been amassed ( without personal deletion by the user, of course)?
In my version of Firefox (3.6.17), right clicking a bookmark and selecting "Bookmark This Page," brings up the New Bookmark window, which I believe is only for one web page.
When I mention "autocomplete function," I'm referring to the websites that appear in a drop-down box when one starts to type in the name of a webpage (e.g., delta.com) in the box just under the Menu Bar in Firefox 3.6.17.
You can use the SQLite Manager extension to create a list of the history and export that list as a CSV file.
- Open Profile Directory -> places.sqlite -> Go
- Hit the Execute SQL tab
- Use a Select like this:
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
If you only want to see typed entries then use this instead:
WHERE moz_places.id = moz_historyvisits.place_id AND typed LIKE '1'
- Click the Action button to Save the results to a CSV file
You can also select some records and use the right-click context menu to copy the selected records as CSV to the clipboard.
You can also create a Temporary view:
- View > Create View : [X ]Temporary Name: Enter a Name for the view
- Use the same Select as above
- View > Export View : Database > Temp
Modified by cor-el