Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #198329

Re: If not "newbie" then ????

Show all headers | View raw

On 08/06/2018 08:19 AM, Richard Owlett wrote:
> On 08/05/2018 10:28 PM, songbird wrote:
>> Richard Owlett wrote:
>>> On 07/21/2018 04:46 PM, cyaiplexys wrote:
>>>>
>>>> Try CherryTree. I use that program for everything. It's cross-platform.
>>>> I download it from the web site instead of using the version in the
>>>> Debian Repo as the latest version fixes some annoying bugs (of which I
>>>> kinda forgot what but would quickly be reminded if I used the repo
>>>> version).
>>>>
>>>> I think that would be useful for categorizing questions and you can 
>>>> even
>>>> search through them. If you want to save to PDF or HTML, it can export
>>>> to those formats as well.
>>>>
>>>> I've used CherryTree for everything from keeping code snippets to
>>>> installation instructions to writing up tutorials (and exporting to 
>>>> HTML).
>>>>
>>>
>>> I've installed CherryTree 0.38.5 from their site.
>>> It can do everything I need *IF* I manually enter all the data.
>>>
>>> I'm trying to import a large set of SeaMonkey bookmarks (a SQLite file).
>>> When using SQLite commands I can create a CSV file with only the
>>> information of interest.
>>>
>>> The CherryTree 0.38.5 manual explicitly states that CSV can be imported.
>>> But there is no menu item in the actual program.
>>>
>>> The CSV has the required information to describe the node/sub-node
>>> structure in explicit detail.
>>>
>>> Suggestions?
>>
>>    learn how to search?
>>
>>    i found this within a few seconds:
>>
>>    
>> http://giuspen.com/cherrytreemanual/Inserting_Objects--From_the_Toolbar--Tables.html 
>>
>>
>>    seems simple enough...
>>
> 
> In this case my search skills were adequate.
> My reading skills however?  <groan> ;{
> 
> I wasn't interested in a "table" per se.
> The CSV file has all the information required for a CherryTree 
> hierarchical file. So I had assumed (wrongly) that there was a CSV to 
> ctb format conversion. Also a closer look demonstrated misunderstanding 
> of how SeaMonkey handles it's data internally and why the JSON file has 
> some features I found annoying. But, along with a hint from an unrelated 
> thread, *MY* problem may be tractable.

My cage has been beneficently rattled ;}
The JSON file exported by SeaMonkey has too much of no interest.
I had given up on working with JSON data directly.
I did a web search for the combination of "sql" and "json".
That led to jq [https://stedolan.github.io/jq/] which led to a slightly 
different search with Synaptic. That led to "SQLite ODBC Driver" 
[http://www.ch-werner.de/sqliteodbc/].

I've not laid out the intermediate steps in detail.
However something like this seems possible:
  1. Export SeaMonkey bookmarks in JSON format.
  2. Clean it with jq.
  3. Use some tool/script to emit CSV.
  4. Edit with spreadsheet of choice, emitting CSV.
  5. Create JSON file acceptable to SeaMonkey.
     [That may require creating dummy data for items disposed of in #2.]

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-07-21 17:50 +0200
  Re: If not "newbie" then ???? Gene Heskett <gheskett@shentel.net> - 2018-07-21 18:30 +0200
    Re: Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-22 00:20 +0200
      Re: If not "newbie" then ???? Gene Heskett <gheskett@shentel.net> - 2018-07-22 03:50 +0200
        Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-22 17:10 +0200
          Re: If not "newbie" then ??? Gene Heskett <gheskett@shentel.net> - 2018-07-22 18:10 +0200
          Re: If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-07-22 21:10 +0200
            Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-26 14:20 +0200
      Re: If not "newbie" then ???? songbird <songbird@anthive.com> - 2018-07-22 15:10 +0200
        Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-22 17:30 +0200
    Re: If not "newbie" then ???? Zenaan Harkness <zenaan@freedbms.net> - 2018-07-22 03:40 +0200
  Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-22 00:10 +0200
    Re: If not "newbie" then ???? Zenaan Harkness <zenaan@freedbms.net> - 2018-07-22 04:10 +0200
    Re: If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-07-22 10:10 +0200
      Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-22 17:20 +0200
        Re: If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-07-24 11:40 +0200
      CherryTree - was [Re: If not "newbie" then ????] Richard Owlett <rowlett@cloud85.net> - 2018-08-04 12:30 +0200
        Re: CherryTree - was [Re: If not "newbie" then ????] Brian <ad44@cityscape.co.uk> - 2018-08-04 12:50 +0200
          Re: CherryTree - was [Re: If not "newbie" then ????] Richard Owlett <rowlett@cloud85.net> - 2018-08-04 13:00 +0200
            Re: CherryTree - was [Re: If not "newbie" then ????] Brian <ad44@cityscape.co.uk> - 2018-08-04 13:10 +0200
    Re: If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-07-22 14:20 +0200
      Re: If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-07-22 15:10 +0200
        Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-22 17:20 +0200
      Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-22 17:20 +0200
    Re: If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-08-05 14:50 +0200
      Re: If not "newbie" then ???? songbird <songbird@anthive.com> - 2018-08-06 05:30 +0200
        Re: If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-08-06 15:30 +0200
          Re: If not "newbie" then ???? Richard Owlett <rowlett@cloud85.net> - 2018-08-06 16:50 +0200
            Searching and organizing emails (Re: If not "newbie" then ????) rhkramer@gmail.com - 2018-08-23 16:40 +0200
              Re: Searching and organizing emails (Re: If not "newbie" then ????) Richard Owlett <rowlett@cloud85.net> - 2018-08-23 18:40 +0200
  Re: If not "newbie" then ???? Eric S Fraga <e.fraga@ucl.ac.uk> - 2018-07-22 12:30 +0200
    Re: If not "newbie" then ???? Tom Browder <tom.browder@gmail.com> - 2018-07-22 12:40 +0200
      Re: If not "newbie" then ???? Eric S Fraga <e.fraga@ucl.ac.uk> - 2018-07-23 10:30 +0200
        Re: If not "newbie" then ???? Erik Christiansen <dvalin@internode.on.net> - 2018-07-23 11:20 +0200
          Re: If not "newbie" then ???? cyaiplexys <cyaiplexys@sitesplace.net> - 2018-07-26 14:30 +0200
  Survival Notes [Was: Re: If not "newbie" then ???? Erik Christiansen <dvalin@internode.on.net> - 2018-07-22 14:20 +0200
    Re: Survival Notes [Was: Re: If not "newbie" then ???? Zenaan Harkness <zenaan@freedbms.net> - 2018-07-22 14:50 +0200

csiph-web