[$100] Fix script to import job from RCRM

[maxceem]

Some time ago we've implemented a script to import data from RCRM to TaaS API https://github.com/topcoder-platform/taas-apis/tree/dev/scripts/recruit-crm-job-import via this task #101.

Since that we've done various updates to the Job and ResourceBookings models.

We have to update the script to it can work with updated models correctly.

At the moment it returns errors like these:

➜  taas-apis node scripts/recruit-crm-job-import ./scripts/recruit-crm-job-import/example_data1.csv
DEBUG: processing line #1 - {"directProjectId":"18001","projectId":"(dynamic load)","externalId":"59411222","title":"No role","startDate":"09/01/2021","endDate":"09/15/2021","numPositions":"7","userHandle":"nkumar2","jobid":"(dynamic load)","customerRate":"100","memberRate":"50","_lnum":1}
DEBUG: userHandle: nkumar2 userId: 4b00d029-c87b-47b2-bfe2-0ab80d8b5774
ERROR: #1 - Error: cannot POST /v5/resourceBookings (400)
DEBUG: processed line #1
DEBUG: processing line #2 - {"directProjectId":"18001","projectId":"(dynamic load)","externalId":"59411222","title":"Custom Role","startDate":"08/01/2021","endDate":"08/30/2021","numPositions":"1","userHandle":"GunaK-TopCoder","jobid":"(dynamic load)","customerRate":"200","memberRate":"100","_lnum":2}
DEBUG: userHandle: GunaK-TopCoder userId: 2bba34d5-20e4-46d6-bfc1-05736b17afbb
ERROR: #2 - Error: cannot POST /v5/resourceBookings (400)
DEBUG: processed line #2
INFO: === summary ===
INFO: total: 2
INFO: success: 0
INFO: failure: 2
INFO: skips: 0
INFO: jobs created: 0
INFO: resource bookings created: 0
INFO: jobs already exist: 0
INFO: resource bookings already exist: 0
INFO: === summary ===
INFO: done!

[maxceem]

@eisbilir @xxcxy @cagdas001 this is open to pick up.

It's quite urgent, please, only pick it up only if you can complete it during 12 hours. Please, comment here so everyone else knows that you are working on this task.

Thanks.

[maxceem]

@eisbilir @xxcxy @cagdas001 there are also other issues which could be picked up https://github.com/topcoder-platform/taas-apis/issues?q=is%3Aopen+is%3Aissue+label%3ACF+milestone%3A%22UAT+Feedback+for+TaaS+Admin+App%22

[maxceem]

Challenge https://www.topcoder.com/challenges/14d1c446-351a-40c4-9dbb-3a71c75ee390 has been created for this ticket.

This is an automated message for maxceem via Topcoder X

[maxceem]

Challenge https://www.topcoder.com/challenges/14d1c446-351a-40c4-9dbb-3a71c75ee390 has been assigned to eisbilir.

This is an automated message for maxceem via Topcoder X

[maxceem]

There appeared to be issue with updating ES during running this script:

JobProcessorService processUpdate ERROR : id: 302e218c-7242-407a-9d55-7def72ef2cfe "job" not found
ResourceBookingProcessorService processUpdate ERROR : id: 74e14ce7-51b3-49bb-8493-e92a5d84d923 "resource_booking" not found

Ideally, we have to update ES processor to use retry logic for job-update and resourceBooking-update, like we did for workPeirod-create. But to speed up the things we would go with workarounds:

1. if we create a Job with numPostition == 1 we would create it directly with assgigned status, so the event doesn't trigger update
2. can update the script to directly create RB in the correct status to avoid the immediate update

Thanks, @eisbilir for finding out about these issues. The payment for this task is increased for tackling down these issues and updating the script.

[eisbilir]

#432