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 evensearch 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 toinstallation 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.htmlseems 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.]