Page 1 of 1

Chore Details

Posted: Thu Oct 19, 2017 2:56 pm
by tomok
Does anyone know where Chore details are stored? I know just about everything else is in a control cube somewhere but I can't find anything chore-related, except for the }Chores dimension. I've never had the need to look that stuff up before and now I've inherited a system full of chores and I'm trying to figure out the scheduling and what not and I don't want to have to turn off the scheduling and click through the buttons one by one to find out the schedule.

Re: Chore Details

Posted: Thu Oct 19, 2017 4:00 pm
by gtonkin
Hi Tom, the schedule details are against a control code if you look in the .cho file-the frequency, hour, minute etc. are in one string-I can try unpack a bit later for you if you don’t find it-on my mobile at the moment

Re: Chore Details

Posted: Thu Oct 19, 2017 4:56 pm
by gtonkin

Code: Select all

C:\TM1 Data\BBPS>type "User Group Extract.cho"
534,10
535,"User Group Extract"
530,20140425023148
537,0
531,001061218
532,1
...
Control code 531 relates to the schedule-format dddhhmmss
in my example, run every 1 day , 6hours, 12 minutes and 18 seconds-(changed the details for purposes of posting otherwise you generally have lots of zeroes for realistic schedules)
Control Code 533 is for Active(1) / Inactive(0)

Re: Chore Details

Posted: Thu Oct 19, 2017 6:10 pm
by tomok
Thanks for the info.

Re: Chore Details

Posted: Thu Oct 19, 2017 6:27 pm
by gtonkin
Pleasure-I guess if you were so inclined, you could build a TI to run through the *.cho and build your own "}Chores" cube with the necessary detail.

Re: Chore Details

Posted: Thu Oct 19, 2017 10:05 pm
by Wim Gielis
gtonkin wrote: Thu Oct 19, 2017 6:27 pm Pleasure-I guess if you were so inclined, you could build a TI to run through the *.cho and build your own "}Chores" cube with the necessary detail.
Guess what...

http://www.tm1forum.com/viewtopic.php?t=13373

Tom, can you run the processes and provide feedback please ? Thanks!

Re: Chore Details

Posted: Fri Oct 20, 2017 12:07 pm
by tomok
Wim Gielis wrote: Thu Oct 19, 2017 10:05 pm
gtonkin wrote: Thu Oct 19, 2017 6:27 pm Pleasure-I guess if you were so inclined, you could build a TI to run through the *.cho and build your own "}Chores" cube with the necessary detail.
Guess what...

http://www.tm1forum.com/viewtopic.php?t=13373

Tom, can you run the processes and provide feedback please ? Thanks!
I'll give it a shot soon. Right now I don't have access to an 10.2.2 FP4 or later environment available to me.

Re: Chore Details

Posted: Wed Oct 25, 2017 4:51 am
by macsir
What I have done in the past is using Perl to extract chore details info from chore files into a summary file. Since Perl is good at regular expression, it is kind of easy to program based on that and in that way, it is not depending on any TM1 version.