No, Emma, but I just tried a few things.
It looks to be done by OK Code - examples
So, go to CJ02 and to the project definition, as before, then go to the status and highlight the ones you want to automate, click F1 on it
I did that for RELEASE and see this - the OK Code is STFR for release
Repeat for all the statuses you want to automate, making note of the OK Code or Function as it's called above.
I would then use a different made up field for the input in Excel - use a dropdown so it's clear on what they can pick
Release
Technically complete
Locked
....
Record one - then you have the script that does it. Then, copy the OK code line and use IF logic in Expert Mode, like
If column C = "Release' use ok code STFR
Something like this - and note you can use IF - THEN - ELSE if you want, as well
Add as many IF statements as you need for all the statuses you want to automate setting.
HTH
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------
Original Message:
Sent: 04-13-2021 19:48
From: Emma Norihiro
Subject: Need Script to Mass Change Project User Status
Hi Sigrid,
By chance do you have any tips on a script for changing the Project System Status?
Thank you,
Emma Norihiro
Enterprise Financial Solutions | emma.norihiro@warnerbros.com
Original Message:
Sent: 4/12/2021 11:56:00 AM
From: s kok
Subject: RE: Need Script to Mass Change Project User Status
HI Emma
I just tried this in CJ20, and it worked. I used standard recording mode, but it was non-batch with controls.
1. Go to your project header
2. Click Edit - Status - Set Status
3. Click on the filter button
4. then enter either the number or code and click the green checkbox
5. You may also have to click thru a message pop-up.
6. Then save
BTW it works fine in CJ02, as well.
Hope that helps,
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle NA
Original Message:
Sent: 04-09-2021 13:27
From: emma norihiro
Subject: Need Script to Mass Change Project User Status
Hi Winshuttle Open Forum Community Members,
Does anyone have a Winshuttle script that will allow me to mass change the project User Status field?
I have tried unsuccessfully to create a CJ02 script so I am now reaching out to all of you wonderful developers.
I appreciate if you could forward me a working script.
Thank you,
Emma Norihiro
Enterprise Financial Solutions | emma.norihiro@warnerbros.com
