Submitted by reesd on 2010/08/24 15:58
Hi Pierre,
(and perhaps Jan since you seem to be using URp import a lot)

I’m trying to figure where we are with import so I can create a mapping for Bonsai and maybe some other XML formats (e.g. FreeMind). I’ve been digging through the threads and playing with imports for a while, would like to get the results summed up and in the doc.

Can you please confirm what should be working for OPML/OML/URp importing? If you do I can update the doc if you like.

Here is my guess based on the threads:

What is working
  • Item hierarchy
  • Item text
  • Embedded RTF text (as IQ HTML)
  • Text and Number attributes - Attribute name must match IQ field name (this means URL works automatically)

What is not working
  • Yes/No attributes
  • Date attributes
  • Images
  • Item notes (Item Text  in URp OML)
  • Linked HTML files

Import Issues
  • Each item must have a distinct item name. Otherwise, all items with the same name will have the RTF content of the last duplicate
  • Bullets are converted to symbol, not to an HTML bulleted list
  • 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.

Planned Improvements
  • Add a field mapping UI (as in 6.20 Text files import (Excel, Access, Outlook, etc.)), but for now IQ field names must match URp attribute names.
 
Links
Thanks,
dave
 

Comments

Anybody could check out these ? I don't use URP neither Bonsai.

Hi Pierre,
 
Any chance we can at least get date and notes import? Those are the two essentials for importing a todo list from any other tool. And the lack of them is the main reasons I still am in Bonsai for my todo stuff (the others are CPU usage and the lack of full-hierarchy
 
I have a sample file with notes and dates here pastie.org/1036900.
 
d
 
PS, The other main reasons are:

Pierre_Admin

2012/03/27 13:36

Permalink

Sure could... in the supplied file, what fields do you want to import ? And to which IQ field do you suggest they be mapped ?
 
(the file is an export of Bonsai I suppose ?)
 
 

reesd

2012/03/27 18:26

Permalink

[quote=Pierre_Admin]
Sure could... in the supplied file, what fields do you want to import ? And to which IQ field do you suggest they be mapped ?
 
(the file is an export of Bonsai I suppose ?)
 
[/quote]
 
The file at pastie.org/1036900 is an example of a simple UltraRecall export. I was trying to start from what you already had working. If you got that working with dates and Item Text then I could write a transform from Bonsai to that format. The important fields are 'Item Text', 'Priority', 'Begin Date', 'Due Date', 'Date Completed'. I also tried bringing them in as strings, but apparently the import doesn't like field names with spaces in them.
 
Alternatively, here is a sample bonsai file gist.github.com/2220870. If you get that working it would be less work for me :). The optimal mappings would be something like this
@priority - Priority
@start-date - TaskStart
@due-date - DueDate (or TaskEnd?)
@completed-date - TaskDone
<item> - Item
<note> - ItemHTML
 
Thanks!
dave

I'll add I'm happy to write scripts that convert to CSV for import if you add a way to indicate nesting.
 
I'm also happy to generate something in the copy/paste XML format you use. Is the copy/paste XML format something provided by the grid, some other tool, or just something you wrote yourself? I'm talking about this....
 
<Root Source="InfoQube" Version="0.9.25" ItemCopyXML="1" XMLCopyVersion="1.00" SourceFile="Z:dgrdatasqlNotesdgrMain.sndb">
    <Items>
        <Item Name="shingle" ID="12588">
            <FID16 ID="16" FieldName="WIKITag">{work-company}</FID16>
            <FID2 ID="2" FieldName="IDItem">12588</FID2>
            <FID219 ID="219" FieldName="Priority">2</FID219>
            <FID221 ID="221" FieldName="BatchArea">work-company</FID221>
            <FID223 ID="223" FieldName="ItemDate">10/27/2011 1:18:06 PM</FID223>
Thanks,
d