I created a database and a text file that contains the structure of the folder hierarchy that I want to use in the database. Not surprisingly, the file looks like an outline. I want to create the folder hierarchy automatically from the text file.
Any suggestions on how to approach this through a script?
I can reformat the file into anything reasonable, such as csv, tab delimited, etc.
The action DT takes is a bit unexpected, but here is what happens. On importing an OPML file, each outline level in the OPML file that has a child is created as a group and the child is created as a record in that group. To force an outline level to become a group, it has to have a child. The child can have a blank name. So, this structure in an OPML file:
One
–One’s child
----
Two
–Two’s child
----Two’s grandchild
Will result in groups for One, One’s child (because it has a blank child), Two, and Two’s child. Two’s grandchild will appear as a record under Two’s child.
Try to modify your OPML (e.g., by downloading a demo of OmniOutliner and futzing with the file to get it the way you want) then import it.