Exporting Ultra Recall database (any experiences, pls?)

Started by karel on 12/4/2018
karel 12/4/2018 12:11 am
Hi,
I would like to transfer my whole database into Ultra Recall (UR) and I would like to stick with it even using virtualization of older versions of Windows in the years to come if necessary.

BUT
in the case something happens and I decide to move my UR database into another software, I worry about my chances of transferring the multi-parent structure of items from the UR database into something else.

That's why I would like to ask whether perhaps somebody here already went thru exporting data from Ultra Recall and could perhaps kindly share experiences either good or bad?

Many thanks in advance!

Karel
Pierre Paul Landry 12/4/2018 1:57 am
karel wrote:
in the case something happens and I decide to move my UR database into another software, I worry about my chances of transferring the multi-parent structure of items from the UR database into something else.
That's why I would like to ask whether perhaps somebody here already went thru exporting data from Ultra Recall and could perhaps kindly share experiences either good or bad?

It has been a while since this was tested (as in many years...), but the process of exporting from URp to InfoQube was pretty smooth (IIRC). Documentation here:
https://infoqubeim.com/drupal5/?q=node/1057

It could be improved if there was a demand for it. I "think" I still have a working copy of URp, and I know that Kyle Alons (URp designer) has a license of InfoQube... he asked for one during the IQ Black Friday license giveaway ! LOL

Pierre
IQ Designer


karel 12/5/2018 12:05 am
Thanks for your reply, Pierre!
How does your import deal with multiparent structure, though? On the bottom of the linked web page you state under "Limitations:" the following: "If an item has more than 1 parent (logical linking in URp terminology), the item will be imported for each parent, so multiple copies will be created. This will be fixed."
I assume you mean that this limitation will be fixed in the future? When and how do you plan to do that if I may ask?

Best regards,
Karel
Pierre Paul Landry 12/5/2018 2:51 am
karel wrote:
I assume you mean that this limitation will be fixed in the future? When and how do you plan to do that if I may ask?

What I recall, is that OML/OPML does not really support multiple parents (vague souvenir however), so URp does what it can, which is to reproduce the item (as a new item) under each parent

What could be done, is some post processing to clean up and restore the multiple parenthood. It should not be too hard, in large part due to another limitation of the URp export: that each item must have unique item text...

If you think that you'd use that feature, I can certainly work on it.

Pierre

22111 12/6/2018 9:10 pm
Hint: UR doesn't have a principal parent, and then secondary parents, but then, the respective table mentions them in a given, chronological order (of time of creation of the parentage, which for the very first parent is identical to the time of creation of the item), so the first occurrence there could be treated as the parentage, further occurrences as links, even in tools without cloning (like RightNote).
karel 12/13/2018 4:25 pm
@22111
That's very interesting.
I have actually learned that although XML export of UR database shows logically linked items multiple times, they all have identical ItemID number. One can use that to identify logically linked items (and their children, although they are not exactly logically linked though in effect they are) easily. That made me feel safe :-)

:)
Karel
Pierre Paul Landry 12/13/2018 8:10 pm
Hi Karel,

If you can supply me with a sample file (multiple parents, attributes to import) I can work on improving the current importer

HTH !

Pierre
22111 12/26/2018 3:14 pm
Thank you, Karel, and please see this thread over there: http://www.donationcoder.com/forum/index.php?topic=46952.0