Ce site disposera de fonctionnalités limitées pendant que nous effectuons des opérations de maintenance en vue de vous proposer un meilleur service. Si un article ne règle pas votre problème et que vous souhaitez poser une question, notre communauté d’assistance est prête à vous répondre via @FirefoxSupport sur Twitter, et /r/firefox sur Reddit.

Avatar for Username

Rechercher dans l’assistance

Évitez les escroqueries à l’assistance. Nous ne vous demanderons jamais d’appeler ou d’envoyer un SMS à un numéro de téléphone ou de partager des informations personnelles. Veuillez signaler toute activité suspecte en utilisant l’option « Signaler un abus ».

En savoir plus

Ce sujet de discussion a été archivé. Veuillez poser une nouvelle question si vous avez besoin d’aide.

Bookmarks - How to extract them from places.sqlite, and save as a .CSV

  • 6 réponses
  • 1 a ce problème
  • 1 vue
  • Dernière réponse par sludge7051-x

sludge7051-x
sludge7051-x
more options

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"

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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" - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Toutes les réponses (6)

sludge7051-x
sludge7051-x Auteur de la question
more options

It ran this together.

The code is supposed to be two rows, with no row in between:

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

sludge7051-x
sludge7051-x Auteur de la question
more options

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 . . .

Shadow110
Shadow110
more options

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.

Shadow110
Shadow110
more options

Easy, get, Avast and it will delete and convert them with out even asking.

sludge7051-x
sludge7051-x Auteur de la question
more options

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?

sludge7051-x
sludge7051-x Auteur de la question
more options

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.