Re: Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-10 Thread Ant 

On 10/10/2019 1:26 AM, Daniel wrote:

Richard Owlett wrote on 10/10/2019 1:36 AM:

Is there a SQLite3 application which can:
   1. read SeaMonkey bookmark files
   2. manipulate the data [my bookmarks resemble Topsy - they just grew]
   3. write the files back such that SeaMonkey can use the
  cleaned up data?

I've not had *ANY* contact with any database system for DECADES {i.e. 
dBASEII}. My gut says it should be possible. None of the bookmark 
threads have suggested any feasible way to reorganize my current mess.


My Bookmarks file dates from about Netscape Communicator V 3.0 and, over 
the years, I think I've ending up with three or four copies of my 
Bookmarks with-in the Bookmarks folder, so I had been thinking of doing 
something like 


1.    Export my Bookmarks file as HTML
2.    Save a copy somewhere else!
3.    Open Bookmarks.html in Notepad++ (or similar)
4.    Select a Bookmark.
5.    Do a search for that Bookmark throughout the file and delete the 
duplicates if only one copy is required.

6.    Repeat Steps 4 and 5 for each following bookmark.
7.    Copy (not import into) the finished file back into the Bookmarks 
file somehow.


I realise this would be A LOT OF (highly repetitive) WORK (which someone 
smarter that me could probable script), but would it be a way of 
achieving the slimmed down result??


For me, I would like to keep their histories too.
--
Stupid old body that won't stop leaking, itching, and sneezing!
Note: A fixed width font (Courier, Monospace, etc.) is required to see 
this signature correctly.

   /\___/\ http://aqfl.net & http://antfarm.ma.cx /
  / /\ /\ \ http://antfarm.home.dhs.org
 | |o   o| |   Axe ANT from its address if shown & e-mailing privately.
\ _ /   Please kindly use Ant nickname & URL/link if crediting.
 ( )
___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey

Re: Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-10 Thread Daniel 

Richard Owlett wrote on 10/10/2019 1:36 AM:

Is there a SQLite3 application which can:
   1. read SeaMonkey bookmark files
   2. manipulate the data [my bookmarks resemble Topsy - they just grew]
   3. write the files back such that SeaMonkey can use the
  cleaned up data?

I've not had *ANY* contact with any database system for DECADES {i.e. 
dBASEII}. My gut says it should be possible. None of the bookmark 
threads have suggested any feasible way to reorganize my current mess.


My Bookmarks file dates from about Netscape Communicator V 3.0 and, over 
the years, I think I've ending up with three or four copies of my 
Bookmarks with-in the Bookmarks folder, so I had been thinking of doing 
something like 


1.  Export my Bookmarks file as HTML
2.  Save a copy somewhere else!
3.  Open Bookmarks.html in Notepad++ (or similar)
4.  Select a Bookmark.
5.	Do a search for that Bookmark throughout the file and delete the 
duplicates if only one copy is required.

6.  Repeat Steps 4 and 5 for each following bookmark.
7.	Copy (not import into) the finished file back into the Bookmarks file 
somehow.


I realise this would be A LOT OF (highly repetitive) WORK (which someone 
smarter that me could probable script), but would it be a way of 
achieving the slimmed down result??


--
Daniel

User agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 
SeaMonkey/2.49.5 Build identifier: 20190609032134

___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey

Re: Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-09 Thread EE 

Richard Owlett wrote:

Is there a SQLite3 application which can:
   1. read SeaMonkey bookmark files
   2. manipulate the data [my bookmarks resemble Topsy - they just grew]
   3. write the files back such that SeaMonkey can use the
  cleaned up data?

I've not had *ANY* contact with any database system for DECADES {i.e. 
dBASEII}. My gut says it should be possible. None of the bookmark threads have 
suggested any feasible way to reorganize my current mess.


Are you concerned with favicons taking up too much room, or with bookmarks 
that are no longer valid, or both?  You could back up the bookmarks to an 
external directory (external to the profile), remove them from the browser and 
then restore them.  That should get rid of the favicons.  Getting a handle on 
what they are is easier if you then output them to .html, and then edit that. 
To check the validity, Bookmarks Checker still exists in Classic Add-ons 
Archive, but you need an extension to access it.  The add-on is Classic 
Add-ons Archive, available at Github:

https://github.com/JustOff/ca-archive/releases



___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey

Re: Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-09 Thread Dirk Fieldhouse 

On 09/10/19 19:35, Richard Owlett wrote:

On 10/09/2019 10:03 AM, Dirk Fieldhouse wrote:

On 09/10/19 15:36, Richard Owlett wrote:

Is there a SQLite3 application which can:
   1. read SeaMonkey bookmark files
   2. manipulate the data [my bookmarks resemble Topsy - they just grew]
   3. write the files back such that SeaMonkey can use the
  cleaned up data?
...


Isn't that what the Bookmarks Manager is meant to be?


Chuckle. Some of my bookmarks date back to days of Netscape Navigator 
and when saved as HTML it is ~2MB with >6000 lines. I forget how deeply 
nested some of my references are.


Still, why not just edit the bookmarks in the browser tool (ie 
Bookmarks>Manage Bookmarks...)?  Are you hitting some of the bugs 
introduced by Mozilla vandalism (eg, copying a folder fails)?


If you first create the clean folder structure you want (above or below 
the existing folders), you could then gradually copy bookmarks from the 
old folders, deleting each one once its contained bookmarks and folders 
have been processed. But you won't be able to copy chunks of the tree.


If that doesn't work for you, why not export the Bookmarks to JSON 
using Bookmarks Manager>Tools>Backup..., edit the JSON, then Restore 
the modified file?


'Cause I don't know anything about JSON.


Just a JavaScript-syntax interchange format, like a SQL dump; easier to 
deal with than HTML, which of course is another option. I doubt that 
directly editing places.sqlite would be any easier, unless you might 
have some SQL scripts prepared to clean up the bookmark hierarchy (but 
you hadn't "had *ANY* contact with any database system for DECADES"). 
Anyway you can script against JSON with something like jq 
.


Tools>Web Development>Scratchpad will open a JS editor with a 
pretty-printer that you'll likely need to make sense of the JSON.


And this really is a good tool, with pretty-print, syntax highlighting 
and folding.


/df

--
London
UK
___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey

Re: Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-09 Thread Richard Owlett 

On 10/09/2019 10:15 AM, Frank-Rainer Grahl wrote:

SQLiteStudio

https://sqlitestudio.pl/index.rvt


I don't trust that site. It requires both cookies and JavaScript to be 
enabled and then tries to log me into Facebook without asking.


I looked for it in the Debian repository - it's not there.
However I discovered something called sqlitebrowser which is described 
as a "GUI editor for SQLite databases". I'll investigate to see if it 
might be a partial solution.




be careful. Only use it when SeaMonkey is closed

Dirk Fieldhouse wrote:

On 09/10/19 15:36, Richard Owlett wrote:

Is there a SQLite3 application which can:
   1. read SeaMonkey bookmark files
   2. manipulate the data [my bookmarks resemble Topsy - they just grew]
   3. write the files back such that SeaMonkey can use the
  cleaned up data?
...


Isn't that what the Bookmarks Manager is meant to be?

If that doesn't work for you, why not export the Bookmarks to JSON 
using Bookmarks Manager>Tools>Backup..., edit the JSON, then Restore 
the modified file?


Tools>Web Development>Scratchpad will open a JS editor with a 
pretty-printer that you'll likely need to make sense of the JSON.


/df




___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey

Re: Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-09 Thread Richard Owlett 

On 10/09/2019 10:03 AM, Dirk Fieldhouse wrote:

On 09/10/19 15:36, Richard Owlett wrote:

Is there a SQLite3 application which can:
   1. read SeaMonkey bookmark files
   2. manipulate the data [my bookmarks resemble Topsy - they just grew]
   3. write the files back such that SeaMonkey can use the
  cleaned up data?
...


Isn't that what the Bookmarks Manager is meant to be?


Chuckle. Some of my bookmarks date back to days of Netscape Navigator 
and when saved as HTML it is ~2MB with >6000 lines. I forget how deeply 
nested some of my references are.




If that doesn't work for you, why not export the Bookmarks to JSON using 
Bookmarks Manager>Tools>Backup..., edit the JSON, then Restore the 
modified file?


'Cause I don't know anything about JSON.



Tools>Web Development>Scratchpad will open a JS editor with a 
pretty-printer that you'll likely need to make sense of the JSON.


/df




___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey

Re: Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-09 Thread Frank-Rainer Grahl 

SQLiteStudio

https://sqlitestudio.pl/index.rvt

be careful. Only use it when SeaMonkey is closed

Dirk Fieldhouse wrote:

On 09/10/19 15:36, Richard Owlett wrote:

Is there a SQLite3 application which can:
   1. read SeaMonkey bookmark files
   2. manipulate the data [my bookmarks resemble Topsy - they just grew]
   3. write the files back such that SeaMonkey can use the
  cleaned up data?
...


Isn't that what the Bookmarks Manager is meant to be?

If that doesn't work for you, why not export the Bookmarks to JSON using 
Bookmarks Manager>Tools>Backup..., edit the JSON, then Restore the modified file?


Tools>Web Development>Scratchpad will open a JS editor with a pretty-printer 
that you'll likely need to make sense of the JSON.


/df


___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey

Re: Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-09 Thread Dirk Fieldhouse 

On 09/10/19 15:36, Richard Owlett wrote:

Is there a SQLite3 application which can:
   1. read SeaMonkey bookmark files
   2. manipulate the data [my bookmarks resemble Topsy - they just grew]
   3. write the files back such that SeaMonkey can use the
  cleaned up data?
...


Isn't that what the Bookmarks Manager is meant to be?

If that doesn't work for you, why not export the Bookmarks to JSON using 
Bookmarks Manager>Tools>Backup..., edit the JSON, then Restore the 
modified file?


Tools>Web Development>Scratchpad will open a JS editor with a 
pretty-printer that you'll likely need to make sense of the JSON.


/df

--
London
UK
___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey

Is there an SQLite3 app to manipulate SeaMonkey bookmarks

2019-10-09 Thread Richard Owlett 

Is there a SQLite3 application which can:
  1. read SeaMonkey bookmark files
  2. manipulate the data [my bookmarks resemble Topsy - they just grew]
  3. write the files back such that SeaMonkey can use the
 cleaned up data?

I've not had *ANY* contact with any database system for DECADES {i.e. 
dBASEII}. My gut says it should be possible. None of the bookmark 
threads have suggested any feasible way to reorganize my current mess.


___
support-seamonkey mailing list
support-seamonkey@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-seamonkey