WYSIWYG HTML Editor
April 8, 2015 6:48 PM Subscribe
I have thousands of Firefox Bookmarks in hundreds of subdirectories. I need to do a merge-and-purge and reorganization.
Editing the bookmark list within Firefox is limited and clumsy. I can export the list to a JSON file, but that's unreadable. I can also export it to export it to an HTML file, but that's filled with coding.
Is there a JSON file editor? If not, is there an HTML editor that lets me work in a WYIWYG environment, so that I can do standard word processing on it, e.g., moving stuff around and alphabetical sorting without worrying about the HTML coding? I will then import the list back into Firefox.
Is there a JSON file editor? If not, is there an HTML editor that lets me work in a WYIWYG environment, so that I can do standard word processing on it, e.g., moving stuff around and alphabetical sorting without worrying about the HTML coding? I will then import the list back into Firefox.
yaml is even easier and you can convert back and forth.
posted by BungaDunga at 7:25 PM on April 8, 2015
posted by BungaDunga at 7:25 PM on April 8, 2015
I just looked at both the JSON and HTML, and neither of them are friendly to a non-programmer. It looks like the bookmarks are actually stored as a database. Looking into it, that's true, bookmarks are stored as part of the user profile in a sqllite database (which is actually just a single, carefully formatted file). Go here to find your profile folder. According to this answer you are looking for the places.sqllite file. If you want to look at it, you will need some sort of sqlite client tool. The one of the best free sqllite tools is actually a firefox extension called SQLite Manager.
However, I just took a look at my places.sqlite file, and...it is kind of a mess, because it is also where history and other things are stored, and there are 13 different tables. If you have a friend who knows SQL, they might be able to help you out from here and get you something you could play with in Excel, but the import-export is still going to be a pain.
The best option might be to just search for one of the many bookmark management add-ons available for Firefox at https://addons.mozilla.org/en-US/firefox/ and see if there is something there that is better than the default Firefox tools. Using one of those is almost certainly going to be the closest to WYSIWYG in this particular problem space.
posted by rockindata at 7:51 PM on April 8, 2015 [1 favorite]
However, I just took a look at my places.sqlite file, and...it is kind of a mess, because it is also where history and other things are stored, and there are 13 different tables. If you have a friend who knows SQL, they might be able to help you out from here and get you something you could play with in Excel, but the import-export is still going to be a pain.
The best option might be to just search for one of the many bookmark management add-ons available for Firefox at https://addons.mozilla.org/en-US/firefox/ and see if there is something there that is better than the default Firefox tools. Using one of those is almost certainly going to be the closest to WYSIWYG in this particular problem space.
posted by rockindata at 7:51 PM on April 8, 2015 [1 favorite]
Google Docs can import your json bookmarks: https://docs.google.com/document/d/1mYsozv1xquCd4CvT-kgvQlvxroJNTjVECB21lb4p8Vs/edit
posted by mce at 8:11 PM on April 8, 2015
posted by mce at 8:11 PM on April 8, 2015
Check out linkagogo.com.
Lots of great organization tools, and can import your firefox bookmarks, and export to many formats.
posted by Sophont at 11:29 AM on April 9, 2015
Lots of great organization tools, and can import your firefox bookmarks, and export to many formats.
posted by Sophont at 11:29 AM on April 9, 2015
That sounds fiddly, exhausting, and error-prone. Have you considered using an online bookmark manager like Pinboard? I'd miss searching by tag or by text if I went back to Firefox bookmarks. Also now I can access my bookmarks from all the devices and browsers I use.
Pinboard can import Firefox bookmarks, so it would be quick and easy.
posted by Pronoiac at 1:42 PM on April 9, 2015
Pinboard can import Firefox bookmarks, so it would be quick and easy.
posted by Pronoiac at 1:42 PM on April 9, 2015
« Older Examples & name for this category of puzzle? | Has anyone made a hard science fiction video game? Newer »
This thread is closed to new comments.
Json is actually designed to be somewhat human readable, much more so than other file formats.
posted by cgg at 6:56 PM on April 8, 2015 [2 favorites]