Re: A way to create a text field of all the sub-folders that an item is in?

The length of the rule should not be a problem, just checked it with 89 folders (from DK02_010 to DK02_099).
There is no need to break lines. (but the rule should work with line breaks too)

However, rules are very sensitive to errors. If there is any error in it the rule simply does not work (no error message).

In particular, if any of the folders specified in the rule does not exist, the rule will not work.

You can try to put the IFFs part of the rule into  Evaluator to see it it works.

Or you can run a Lua script that will create the rule for you, e.g.:

local a=''
local folders=get_sub_folders('Categories')
for i, v in pairs(folders) do
  fn=get_folder_name(v)
  a=a..'+IFF(['..fn..'],\''..fn..', \',\'\')'
end
a=string.sub(a,2)
local rule='++:!:'..a..':'
set_folder_rule('Categories', rule)

Do not forget to make a copy of your data file before experimenting with rules and scripts.

Best regards,
JS



From: mailto:[email protected] 
Sent: Saturday, January 13, 2018 18:42
To: mailto:[email protected] 
Subject: Re: [eccopro] A way to create a text field of all the sub-folders that an item is in?
  
Thank you, Mr. Smith. Your knowledge, as usual, is exceptional

It works BUT there is a problem with my implementation:

If I add a short command as in the example it works. However, 
I have 36 sub-folders that I wish to poll and extract their names 
to the Category folder. If I add the syntax as a single rule it's 
1301 characters long and Auto assign seems to choke and 
does nothing. Slang's notes in v1.2 Changelog states:

--Auto assign rule edit dialog now can input more than 31 
character. You do not need to break line manually, the EccoPro 
extension will do it for you.

That doesn't seem to work in this instance. But if I manually 
break the lines before each '+' I also get no results when 
running the Check Folder Rules: Here's the full rule:

++:!F:IFF([DK02_010], 'DK02_010, ', '') 
+ IFF([DK02_011], 'DK02_011, ', '') 
+ IFF([DK02_012], 'DK02_012, ', '') 
+ IFF([DK02_013], 'DK02_013, ', '') 
+ IFF([DK02_014], 'DK02_014, ', '') 
+ IFF([DK02_020], 'DK02_020, ', '') 
+ IFF([DK02_030], 'DK02_030, ', '') 
+ IFF([DK02_031], 'DK02_031, ', '') 
+ IFF([DK02_040], 'DK02_040, ', '') 
+ IFF([DK02_041], 'DK02_041, ', '') 
+ IFF([DK02_042], 'DK02_042, ', '') 
+ IFF([DK02_043], 'DK02_043, ', '') 
+ IFF([DK02_044], 'DK02_044, ', '') 
+ IFF([DK02_045], 'DK02_045, ', '') 
+ IFF([DK02_046], 'DK02_046, ', '') 
+ IFF([DK02_050], 'DK02_050, ', '') 
+ IFF([DK02_051], 'DK02_051, ', '') 
+ IFF([DK02_052], 'DK02_052, ', '') 
+ IFF([DK02_053], 'DK02_053, ', '') 
+ IFF([DK02_054], 'DK02_054, ', '') 
+ IFF([DK02_055], 'DK02_055, ', '') 
+ IFF([DK02_056], 'DK02_056, ', '') 
+ IFF([DK02_057], 'DK02_057, ', '') 
+ IFF([DK02_060], 'DK02_060, ', '') 
+ IFF([DK02_070], 'DK02_070, ', '') 
+ IFF([DK02_071], 'DK02_071, ', '') 
+ IFF([DK02_072], 'DK02_072, ', '') 
+ IFF([DK02_073], 'DK02_073, ', '') 
+ IFF([DK02_074], 'DK02_074, ', '') 
+ IFF([DK02_075], 'DK02_075, ', '') 
+ IFF([DK02_076], 'DK02_076, ', '') 
+ IFF([DK03_010], 'DK03_010, ', '') 
+ IFF([DK03_020], 'DK03_020, ', '') 
+ IFF([DK03_030], 'DK03_030, ', '') 
+ IFF([DK03_040], 'DK03_040, ', '') 
+ IFF([DK03_050], 'DK03_050, ', ''):

David

> You could try the following rule in the Categories folder:
> 
> ++:!F:IFF([Name1], 'Name1, ', '') + IFF([Name2], 'Name2, ', '') +
> IFF([Name3], 'Name3, ', ''):
> 
> It´s just a series of IFF operators, one for each of the subfolders you wish
> to track. The outcomes of the IFFs are glued together by + signs.
> Flag ! means to update the result each time there is a change.
> 
> 
> 
> From: mailto:[email protected] 
> Sent: Friday, January 12, 2018 15:59
> To: [email protected] 
> Subject: [eccopro] A way to create a text field of all the sub-folders that an
> item is in?
> 
> Knowledgeable help on this would be much apprciated
> 
> I need to create a text folder/column that concatenates all the 
> sub folders that an item is in. As an example I have something 
> like the following folder structure
> 
> Categories (text)
> Name1 (check mark)
> Name2 (check mark)
> Name3 (check mark)
> 
> So for an item that is in Name1 and Name3 I want the 
> Categories column to show "Name1, Name3". For another item 
> that is in Name2 and Name3 Categories would show "Name2, 
> Name3"
> 
> Is there a rule that would do this? There's no way to use the 
> 'Column Properties/Sub-folders that Contain Item' as the values 
> are not accessible as text.
> 
> Many thanks in advance,
> David
> 
> ---------- AllinOneFilms.com ---------
> 
> 
> 
> 

---------- AllinOneFilms.com ---------