I have installed SQLite Manager 0.8.1
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/
Go to File Explorer / Show Hidden items (so you can see App Data, nex… (read more)
I have installed SQLite Manager 0.8.1
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/
Go to File Explorer / Show Hidden items (so you can see App Data, next)
Put a copy of places.sqlite in C:\temp (work from a copy)
C: \ Users \ Username \ App Data \ Roaming \ Mozilla \ Firefox \ Profiles \ long string \ places.sqlite
Go to the FF drop down menu in the top left / Web Developer / SQLite Manager
. . . it opens the program in a new window
Within the program, go to:
Database / Connect Database / C:/temp/places.sqlite
- - - - - - - - - - - - - - - - - - - -
You will see many Tables. The two pertinent ones I think are:
moz_bookmarks / Browse & Search tab
all the new bookmark Titles are in here at the bottom, even ones not in the Unsorted folder, but the URLs are not here!
the Titles appear to be added in sequential order, according to the id
moz_places / Browse & Search tab
all the new bookmark Titles, and URLs, are in here, they are not readily identifiable, you have to use Ctrl+F
- - - - - - - - - - - - - - - - - - - -
To export the tables:
right-click on the table / Export Table /
CSV tab / [check] First row contains column names
Comma, Double quotes, Save CSV Export Settings
Ok / Save it to desktop as a CSV
Open the CSV, and then save it as an xlsx
- - - - - - - - - - - - - - - - - - - -
Question: How can I get my Title and URLs?
There are over 17,000 rows in moz_places.
I would be putting all new bookmark in Unsorted though, so the question is, how do you identify them?
This seems possible.
Alternatively, if I could add the URL column to moz_bookmarks, then I could just export that. I would work from a copy . . . but it doesn't look like SQLite Manager will let me do this.
- - - - - - - - - - - - - - - - - - - -
I have also installed: SQLite Database Browser, Version 2.0b1
http://sourceforge.net/projects/sqlitebrowser/
I try to open places.sqlite with it, and nothing happens. Any idea why? Thx.