Submitted by comvox on 2022/02/16 21:36

I would like to import some Treepad files (.jht) into InfoQube; does anyone know a convenient way to do this?

I have tried to convert Treepad files to CSV and then import to IQ. I have also tried converting the treeoad files to OPML via a trial version of Ultra Recall Pro. But either way, I have trouble importing the resulting files into IQ.

One of the problems is that the Treepad files have two fields, essentially the title field and the article or document field. I want the title field to go to IQ's item field, and the article to go to IQ's document pane.  But despite a number of attempts,  I can't figure out a way to import the articles into the document pane. When importing from a CSV file I can get the articles imported into the ItemHTMLText field, but not into the document pane.

Even if I could get things into the document pane, I would still have the problem that the program tp2csv.exe, which converts Treepad files to CSV, strips out anything indicating a hard return or other formatting. So the resulting document panes would require too much work to put into proper shape. Does anyone know a program for converting from Treepad to CSV that doesn't strip the formatting codes?

I also have a problem when trying to import OPML files. Here too, I can't figure out how to get anything into the document pane. This may be because I have more trouble understanding the OPML import. I don't understand what the setting for "Add all items to fields:" means.

With regard to CSV files, I also have the problem that the conversion program I use puts the title field into different fields depending on whether it is an item or subitem or a subsubitem, etc. This is a problem when trying to import into IQ. One way is to make the CSV file "flat", so to speak, so that all subitems are items. I might be able to do this with a few regex search and replace operations on the CSV file.  But is there something I can put in each line of the CSV file that represents a subitem that would result in it being a subitem when it is imported into IQ?

Comments

Hi,

If you can provide a sample file (in jht) and the equivalent CSV and OPML, I should be able to come up with an importer (or fine tune an existing one)

p.s. to get info into the Doc pane, use the HTML field

 

I have made some progress on this. I am able to get Treepad files converted to OPML. The OPML works when imported back into certain outliners, and the resulting notes included paragraphing. When, via two easy "find and replace" operations, I change the fields in the OPML to "item" and "ItemHTML", as you suggested, the file can be imported properly into InfoQube, except for one thing. The paragraphing gets lost -- what I presume are hard returns in the OPML file get lost or converted to spaces or something. This makes the notes hard to use.

The other formatting (boldface, italics,  table format, etc.)  gets lost too, but that, I presume, is inevitable in OPML, since OPML files are plain-text.  So I see that this formatting is already lost in the OPML file itself. However, it should hopefully be possible to preserve the paragraphing when importing the OPML into IQ.

I have attached an OPML file which gives a proper result  when (with changed field names) it is imported into another outliner, but loses paragraphing when imported into IQ. The file extension was changed from opml to txt in order to allow it to be uploaded.

Got it thanks !

The expected field for the rich text is _note which presumably you changed to ItemHTML

In v120Pre17, I added support for other field names (HTML and ItemHTML)

p.s. no need to do any search and replace, IQ should import the file fine... no ?

When I generate the OPML from the other outliner, the fields are "text" and "description". If i import this file into IQ, it does get the items, but there is nothing in the document panes. If I change the second field, "description",  to "HTML", it doesn't put anything into the document panes either. If I change "description" to "ItemHTML",  it gets everything but without paragraphing.

So far, it does look like I don't have to "find and replace" the first field, "text", but I do have to change the second field "description", and changing to HTML wouldn't work. Nor note, nor _note.

If necessary, I can redo my tests of exporting and importing more carefully and keep better notes about what happens. I get frustrated doing one test after another of the fields, and I may do them too fast. There are a couple of other options, that I think have turned out to be irrelevant, but I felt it necessary to check them at first.

I realized you note said HTML not ItemHTML, but I couldn't find HTML listed as a field in IQ, so that's why I thought what was meant was ItemHTML.  And then ItemHTML seemed to work except for paragraphing, and HTML doesn't work at all as the second field in the OPML file..

Thanks for the rapid response. However, when I use _note as the second field in the OPML file, it leaves the document panes blank after import. I am using v120Pre16.

 

Oops. No, it worked with _note! Thank you very much!

It's very good to see the continued work on OPML import in v120Pre17!

As of now, I have v120Pre16. I find importing into IQ the OPML files created by MyInfo works (but these are plain-text files).  This is very helpful.

Meanwhile, there is also the question of OPML export from IQ.
"File > Items in XML format"
gives the error message "Not yet implemented. Copy items in a grid in XML format and paste into Notepad."
So far, I haven't been able to do that properly.

I am interested in this mainly to be able to use IQ-derived files in Android. For example, With IQ  -> OPML, one might be able to do something like use OPML files from IQ directly in  Android Outliner (or some other suitable Android app), and hopefully vice versa too, using Android Outliner OPML to import into IQ.

In this way, I could hopefully get a connection (at least for plain-text files, maybe for formatted ones) between IQ and Android devices. It may be connection that is a bit clunky, but it would still be quite useful.

How do I ?