Submitted by gregory on 2014/11/30 10:18
I have a table in Microsoft Word, the first column of which is in a hierarchical style:
 
1.       Get Conceprocity working and documented.

·         Catalogue the existing Conceprocity resources, because we need to nuggetise them.

·         Minimally improve Conceprocity and ensure that it works in the TeamKIM.org context.

·         Document how I do this as a basic introduction to Conceprocity use.

·         Ensure that Conceprocity is usable by guest users of the TeamKIM.org infrastructure.

 

1. I cannot find a description of how to Import hierarchical data anywhere in the online manual.

The only reference I can find to this facility is in a forum entry which reports a problem encountered by another InfoQube user which appears never to have been satisfactorily answered. The forum entry is to be found at:

 
 

2. When I try to use the facility, I encounter a dialogue the second part of which makes no sense to me - much as it failed to do to the previous reporter.

 

3. I converted my Word outline in Microsoft Excel such that the first level of indenting was represented by a single tab character char(9), the second by two tab characters.

 

In Word, the data looks something like this:

 



"

Task
Notes
TaskDuration

1.       Get Conceprocity working and documented.

Yada yada.

2,5

·         Catalogue the existing Conceprocity resources, because we need to nuggetise them.

·         Minimally improve Conceprocity and ensure that it works in the TeamKIM.org context.

·         Document how I do this as a basic introduction to Conceprocity use.

·         Ensure that Conceprocity is usable by guest users of the TeamKIM.org infrastructure.

 
 
 "
My hope is that the row labelled with a number will appear as a TLI, and those with dots as SLI.

In the absence of any documentation for import hierarchical data, I had fondly imagined that all that was necessary was to ensure that the tab character ASCII 9 appeared at the start of a string and that this would cause indentation.

The Excel formula which I use to achieve what I take to be the correct tab indentation inserts char(9)&char(9) for a second-level indentation.

 

Please can somebody point me in the right direction?

 

Incidentally, as far as I can ascertain, no Microsoft Office product is capable of saving in OPML format; so that will not help me.

Thank you.

 
 
 
 



 

 

Comments

With a bit of help from Pierre (thanks!), I have moved forward on this question.

I had misunderstood the functionality. What InfoQube can import is a single Excel worksheet in which the first level in the hierarchy – sometimes referred to as the TLI, the top level identifier – is in the first column, and the second level, the SLI, the second level identifier is in the second column. Further levels of hierarchy are represented by further columns. (This precludes importing data into other fields at the same time as importing the hierarchical data, since all the data on the worksheet is imported into a single field in a single grid.)
 
I therefore moved the data from Word to Excel, where I saved the file as type "Text (Tab delimitted)". This is a text-only format with embedded tab characters. Annoyingly, Excel stores a trailing tab character after each field of data, including the last: and InfoQube preserves this.

The first screenshot shows the data in Excel.
 
The second shows the import dialogue.  The first part of this dialogue defaults to adding TLI only; I have instead used the drop-down option "Add all items to grid". (Note, I have not attempted the second part of the dialogue. This appears only to permit the imported items to be added to yes/no fields, for which I have no use at present.)
 
The third screenshot shows the results in the grid to which I imported the data.
 
Mark GREGORY, Redon, France - GMT +1/+2; EST +6

Armando

2015/01/16 11:10

In reply to by gregory

Thanks ! Good to know!
 
-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz