Bulk update the crew positions skills and new pay policy
Content was last updated in 06.01.14-00
Revision History
Version No. | Reference No. | Changes |
06.01.14-00 | MAIN-3089 | Support to update the new pay policy to the existing booking lines |
Imagine this scenario, you have a Camera-person working at a project location. A sudden requirement requires him to double-up as a recording assistant for few hours. Now since this additional task wasn't planned in the first place, it needs to be added to the Crew's work itinerary.
And accordingly, his pay-policy gets modified for working some additional hours for the new skill.
You can add/update the crew positions skills along with few other details in bulk so that after the data conversion, the skills and the other details reflects in the R2Labor application.
Pre-requisites
The scripts and batch file is placed in the below path.
R2 installation path> sqls\R3Sqls\DataConversion\Skills_Certificates
Make sure to create one or more crews so that you can update their skills in bulk.
Sample Workflow#1: Add skills and update new pay policy
Open the 'CrewPositionSkills.CSV' file from the specified path.
Provide the details in the respective columns as shown below
Table 1.0: Column details
Column | Data type | Description | Mandatory |
Resource ID | Varchar2(50) | Provide the Resource ID. Duplicate names are not allowed. Character limit is 50 | Yes |
Position ID | Varchar2(50) | Provide the Position ID. | Yes |
Skill Name | Varchar2(50) | Provide the skill name and it should be same as mentioned in skills master. | Yes |
IsPrimary | Number | The accepted values are: 1— True 0 —False If the value is not specified, then it is considered as True (1). | No |
Hourly Cost | Number | Provide the hourly cost. | No |
Price Group ID | Varchar2(50) | Provide the price group id. | Yes |
Figure 1.1: Crew Position Skills CSV
Save the file.
Run the 'Convert8i' batch file. In the batch file provide the following details and then click enter.
convert8i CREATE_SKILL_DETAILS <username>/<password>@<Service Name> <CSV File Name>
Figure 1.2: Batch file
After executing, it states that the rows are successfully loaded indicating that the details are uploaded to application.
Another prompt displays in the batch file to update the new pay policy for the existing booking lines a shown below.
Figure 1.3: Prompt to update new pay policy
Press '1' and hit enter to update the pay policy for existing booking lines. Otherwise key in '0' and hit enter to exit.
Figure 1.4: Update new pay policy to existing booking lines
Once the batch file runs successfully, the new pay policy will be updated for all the existing booking lines for the respective crew position.
Update new pay policy for the existing booking lines
You can also run the batch file separately for updating only pay policy for the existing booking lines alone. The batch file and the script is placed in the below path.
Path: R2 installation path>sqls\R3Sqls\PRGS\Updates\Customer\UBS\PayPolicyUpdate
Pre-requisites:
Ensure that you have updated the hourly cost/grid pricing for the existing booking lines. You can update from the following places.
R2Labor> Crew edit window> Hourly Cost
R2> Maintenance> Grid pricing
Sample Workflow#2: Update new pay policy for the existing booking lines
Run the PayPolicyUpdate batch file.
Enter the Username, Password, Service name and Effective Date details as shown below. Then, click enter.
Figure 2.1: Provide the details
After executing, you will see successful message in the batch file and the new policy get updates for the booking lines whose lines are from/beyond the mentioned effective date.