View Single Post
  #2  
Old 10-17-2005, 12:07 PM
kevina kevina is online now
Registered User
 
Join Date: 03-26-2003
Posts: 825
You can see how the csv "indenting" feature works by exporting some csv data from an Ultra Recall Info Database with this field.

Essentially here is how it works (for import or export): Parent rows will have an IndentLevel value of 0. Obviously each row of data represents a single Info Item. If a row has child children (rows), then they will immediately follow with an incremented indent level (ie. immediate children will have an indent level of 1).

If you are trying to import data from an external relational database, then you would need to export the parent rows, with children rows following immediately after the appropriate parent row with an incremented IndentLevel value.

You'll want to create a csv file something like this (obviously with other attributes and real data!):

IndentLevel, ItemTitle, Url, ItemNotes
0,"Main Parent","http://acme.com/parent1",Notes
1,"First Child","http://acme.com/child","Some other notes"
1,"2nd Child","http://acme.com/child2","Long note"
2,"1st grandchild,"http://acme.com/grandchild1","Other note"
0,"Second Parent","http://acme.parent2",Notes

The one thing that currently can't be done is specify an alternate template for the children Info Items. Is this something of importance for your import?

If so, perhaps the csv import functionality of a future version could also take a TemplateName field that would be used (if found in the Info Database) to override the general template name provided with the import...
Reply With Quote