Bookmarks - How to extract them from places.sqlite, and save as a .CSV
I had to update this (below), since this is so great, and no longer works with FF 57.
Previous way (for reference) . . . Bookmarks - Convert from places.sqlite to .xlsx (Excel) - How? | Firefox Support Forum . . . https://support.mozilla.org/en-US/questions/996638
New way:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
DB Browser for SQLite . . . I got the "PortableApp" version . . . http://sqlitebrowser.org/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
View / Preferences / General / Default location - "Remember last location" / Ok
File / Open / C: \ Users\ USER-NAME \ AppData \ Roaming \ Mozilla \ Firefox \ Profiles \ u70715dh.default \ places.sqlite
Later . . . Ctrl+1 . . . or . . . File - and it's at the bottom . . . "Views" / right-click on "output"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Execute SQL tab / put in the code:
SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,"unixepoch","localtime") AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id
. . . and "Execute SQL" - click the "Play" button
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Bottom right square / Save as view "output" / Ok
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Database Structure tab / See "Views" below . . . right-click on "output" / Export as CSV file
[un-check] "Column names in first line," otherwise, you get the SYLK error / Ok
Save "output.csv" to Desktop / Save / Ok . . . then run the Excel Macro on it
Later . . . run this Script from "Views" in the future, also
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
File / Exit / "Do you want to save changes made to the database file?" - Yes
. . . I guess it Saves my Script in Firefox's "places.sqlite"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
所有回复 (6)
I figured out how to do this using SQLite3 and a .BAT file . . . No database viewer is necessary!
I've summarized what to do in a PDF . . . uploaded to my Google Docs . . . Here's the link:
bookmarks-to-CSV.pdf . . . https://drive.google.com/open?id=1xYWPQtijqCzk-1nzTsTb0ZUVKYJNFokR
"Page 1" provides _all_ you need to know, to get your Bookmarks into a .CSV file (When you run the .BAT file, it won't do anything to your actual Bookmarks, it just extracts a copy of them.) Then, the next few pages provide the details of what's going on.
Credit for this SQL query goes to cor-el (please see page 4) . . . thank you!
I have an Excel macro that edits and appends them to another worksheet. Let me get a link to that . . . hang on . . .
So why are you asking this again when you have answers in : https://support.mozilla.org/en-US/questions/1190466
Never make 2 questions , this is the same question, Change/Alter the title of your question to fit.
Easy, get, Avast and it will delete and convert them with out even asking.
I think that other link was preliminary to what I've figured out. I probably should have posted the above there . . . I have since improved on it, and want to share. I have something else to add tomorow or Friday.
Avast does it? How? Do you have a link?
I had to figure out how to do a Custom Ribbon in Excel, which will stay with the worksheet, and make it easy to run the macros.
Instructions for that, along with code for the .BAT files, are in a second pdf - the link is on this page:
Firefox Bookmarks to .xlsm [SOLVED] . . . https://www.mrexcel.com/forum/excel-questions/1040778-firefox-bookmarks-xlsm-solved.html
I put a link to a copy of the xlsm, there, also. Remarks in the VBA explain more of what the macros do.
Since VBA does most of it, I posted it there, in case someone wants to make comments, or has Excel questions.
I always wondered what a good application for Excel macros would be, and found it, working with the Bookmarks.