Bookmarks - A better Export / Show folder quantity in Status Bar
I did this macro to get my Unsorted Bookmarks out of Firefox (the steps are listed, not the actual macro).
I keep my Bookmarks in a spreadsheet, where I currently have 12 levels of sorting capability.
- * * * * * * * * * * * * * * * * * * * * * * *
As you can see in the Excel screenshot (the top half), sometimes the Titles end up in Column B, instead of Column E.
I think I've seen them in Column A and Column C before, but not recently. I'm watching for that.
In the other two sceenshots, I look at the details between two Bookmarks - one where the Title is in Column E, and the other where the Title is in Column B. They both have a "Description," so that doesn't seem to be what's causing the disparity.
Do you know if there's a way that they could always end up in Col E?
- * * * * * * * * * * * * * * * * * * * * * * *
Other idea: Do you think it could say at the bottom in a Status bar, how many Bookmarks are in a folder (like File Explorer)? That would be useful for when I do a visual check to see that I've got the same number of Bookmarks in my Import, as compared to the Library.
Chosen solution
Sorry, I didn't zoom that first image and see that it was an bookmarks.html file mentioned in the lower section of that Excel window. A small 19" widescreen monitor and 64 yo eyes couldn't read that spreadsheet too well.
Read this answer in context 👍 0All Replies (9)
Images
Wouldn't that be something to discuss in an Excel support forum?
Really doesn't directly involve Firefox support.
I don't think so, because Excel is just opening, or importing, what Firefox has stored.
What would need to be looked at is how Firefox saves the Bookmark info, and if where it saves the web page Title could be standardized.
The web page URLs are always in the same column. How does that take place?
Have you used an SQLite Manager to view the places.sqlite file?
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/
Viewing the "table" structure might be informative. Plus sqlite is a standardized format and has a lot of documentation available online.
https://sqlite.org/
Overall, Mozilla designs file systems to "work", not to be easy for users to tinker with or to extract data from. Quite honestly, you might be better off exporting your bookmarks in HTML format; it's a lot simpler with more uniformity, IMO. I haven't tinkered with sqlite files very much, but found that the bookmarks.html format is very understandable with a limited knowledge of working with HTML code.
Hmm, I have installed the SQLite Manager . . . When I click on places.sqlite, nothing happens:
C: \ Users \ Username \ AppData \ Roaming \ Mozilla \ Firefox \ Profiles \ long string \ places.sqlite
. . . but, that's what I am already doing . . . exporting the bookmarks to html, and then Opening / Importing them to Excel
If I can do something with it as a database, though, yes, that might be more usable, thanks! I'll have to take a look a this.
Modified by sludge7051-x
Chosen Solution
Sorry, I didn't zoom that first image and see that it was an bookmarks.html file mentioned in the lower section of that Excel window. A small 19" widescreen monitor and 64 yo eyes couldn't read that spreadsheet too well.
LOL np
I installed the Add-on, clicked on a copy of places.sqlite, and it doesn't do anything.
I installed this program, did File / Open, and it doesn't do anything: http://sourceforge.net/projects/sqlitebrowser/
She doesn't want to give up her secrets
Ok, I installed SQLite Manager
If you go to Firefox (top left menu) / Web Developer / SQLite Manager . . . Database / Connect Database / D:/temp/places.sqlite (work from a copy)
- - - - - - - - - - - - - - - - - - - -
Tables
moz_bookmarks / Browse & Search tab all the new bookmark Titles are in here at the bottom, but not the URLs
moz_places / Browse & Search tab all the new bookmark Titles and URLs are in here, but not identifiable as the new ones / Unsorted
I don't see how I can get the URLs field to moz_bookmarks, it's not like Access
Would be good if I could just export the whole table, but that doesn't include either the Titles or URLs