Pesquisar no site de suporte

Evite golpes de suporte. Nunca pedimos que você ligue ou envie uma mensagem de texto para um número de telefone, ou compartilhe informações pessoais. Denuncie atividades suspeitas usando a opção “Denunciar abuso”.

Saiba mais

Esta discussão foi arquivada. Faça uma nova pergunta se precisa de ajuda.

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

  • 6 respostas
  • 1 tem este problema
  • 9 visualizações
  • Última resposta de 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" - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Todas as respostas (6)

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

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

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.

more options

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

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?

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.