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.