The eccoMAGIC Forums

The eccoMAGIC Forums
http://forums.eccoMAGIC.com/forum/YaBB.pl
Ecco Tutorials, Tips and How-to Guides >> How do I ..... >> ? export tree to excel and repeat parents
http://forums.eccoMAGIC.com/forum/YaBB.pl?num=1210349622

Message started by ykorovin on 05/09/08 at 11:13:42

Title: ? export tree to excel and repeat parents
Post by ykorovin on 05/09/08 at 11:13:42

Does anybody know an easy way how to export outlined tree with folder values
a fv1
b fv2
c fv3

, export to excel like this
a - - fv1
a b - fv2
a b c fv3

this would enable sort in excel, while keeping parent structure.

Thanks!

Title: Re: ? export tree to excel and repeat parents
Post by ykorovin on 05/09/08 at 11:46:02

here is the basic excel converter from tree to table

Title: Re: ? export tree to excel and repeat parents
Post by Admin on 05/10/08 at 13:02:07

An not sure *exactly* the output format you are intending....

can you be more specific on what output file would look like ? (particularly, HOW sub items are outputted in the file)

note: ecco has nice built in export (includes Tables); Slang extension allows copy with fields (loses indent levels);

Title: Re: ? export tree to excel and repeat parents
Post by ykorovin on 05/12/08 at 03:12:10

Thanks for the reply.
Yes i knew the eccoext "copy with columns". After second thought - yes, it appeared to be the answer:

I define the unique key for the every item i need.
I lookup the key value of the top 4 parents by the autorule
++::getpv(fv("key"), il() == X ):[key] != ""
( X = 1,2,3,4 - level of parent - as much as i need)
I prepare the view with columns - key, TLI.key, Parent2.key, Parent3.key, Parent4.key
I copy it with columns, and then resolve keys back to item names by excel VLOOKUP. This helps change item name in ecco, and then dynamically represent the change in report.xls, because key is the constant.