On Tue, 2 May 2017 15:09:11 -0700 (PDT) tscv11 <[email protected]> wrote:
> The "import->import any file" method for .db3 files no longer > works for me, and does, in fact create completely empty nodes titled > after the file (@auto nodes). Thus I cannot repeat the process, and I > was hoping someone could figure out how I got that result, if Leo > *doesn't* support .db3 files. And trust me, I have better things to > do than make up stories for Leo developers. I can't repeat it, but it > *did happen* ; ) Yeah, we've all been there :). So the XML file you attached was a .leo outline file (they're XML), with couple of date nodes each with an amount and time node under them. Leo can import XML in a human readable format using the xml_edit.py plugin. It can also import XML as XML, but I wouldn't call that human readable - at least nothing you'd want to interact with. So if you could export the SQLite to XML, you might be able to import that with the xml_edit.py plugin. I'm sure there are SQLite to XML export utilities. You'd want one that names the XML elements after the table and field names. End of the day though a script that imports them would probably give the most useful structure. Cheers -Terry > With sqlite3 files importable as xml (as shown) I knew it would > be relatively > easy to write my plugin, so hopefully you can understand my > disappointment upon finding that the imports no longer worked, and > why I asked for help. > > > Hmm, SQLite files are binary and I don't remember Leo having any > > > support for them, so wouldn't have expected that to do anything > > useful > > - can you verify you can do it repeatably? > > > > Building an outline in Leo based on the content of SQLite file with > > a Python script wouldn't be too hard, but you'd need to know the > > structure of the data in the SQLite file and how you wanted to map > > it to Leo's tree. > > > > Cheers -Terry > > > -- You received this message because you are subscribed to the Google Groups "leo-editor" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/leo-editor. For more options, visit https://groups.google.com/d/optout.
