Welcome, Guest. Please Login or Register.
eccoMAGIC Forums
05/04/24 at 15:10:41
Home Help Search Login Register


Pages: 1
Send Topic Print
? export tree to excel and repeat parents (Popularity: 6084 )
cowdad
Contributing  Member
***


I Love Ecco!

Posts: 23
Show the link to this post ? export tree to excel and repeat parents
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!
Back to top
 
 
  IP Logged
cowdad
Contributing  Member
***


I Love Ecco!

Posts: 23
Show the link to this post Re: ? export tree to excel and repeat parents
Reply #1 - 05/09/08 at 11:46:02
 
here is the basic excel converter from tree to table
Back to top
 
  IP Logged
Admin
Administrator
*****


I love Ecco!

Posts: 134
Show the link to this post Re: ? export tree to excel and repeat parents
Reply #2 - 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);  
 
Back to top
 
 

The Administrator.
WWW   IP Logged
cowdad
Contributing  Member
***


I Love Ecco!

Posts: 23
Show the link to this post Re: ? export tree to excel and repeat parents
Reply #3 - 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.
 
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print