For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hi All,
Is there any tool/utility to configure 40k+ resources and work zones?
Creating manual is almost impossible and also migrating from non-prod to prod is there any better option?
Regards,
Sachin Rathod
Hi Sachin,
You can use the Resource Management API for this purpose.
You can create a custom program that will call the required methods. Like for adding or updating resource it is insert resource and update resource and for workzones it will set_resources_zone.
Below is the wsdl link for the SOAP API:
https://api.etadirect.com/soap/resource-management/v3/?wsdl
You can also use REST API: https://docs.oracle.com/cloud/latest/fieldservicecs_gs/CXFSC/api-Core-Resources.html
For migration from one environment to another you can raise a SR requesting for a clone.
Regards,
Hardik Gupta
Hi Hardik,
Thanks for providing this answer.
Could you please provide steps by steps/walk through if I need to import 1,000 workzones into core manage? I have a look at the REST API documentation that you have mentioned earlier about how to get work zones for a resource by submitting a GET request on the REST resource. But it doesn't explain to me on how to import the Workzone itself?
Is there any tools available? Our client wants to configure up to 1,000 Work Zones within the Workzone dictionary based on Australia Bureau of Statistics Postcode and locality. I have the raw data but was wondering if there is any smart way to import it to OFSC Core Manage.
Thanks
Jeffry Husman said:Hi Hardik,
Thanks for providing this answer.
Could you please provide steps by steps/walk through if I need to import 1,000 workzones into core manage? I have a look at the REST API documentation that you have mentioned earlier about how to get work zones for a resource by submitting a GET request on the REST resource. But it doesn't explain to me on how to import the Workzone itself?
Is there any tools available? Our client wants to configure up to 1,000 Work Zones within the Workzone dictionary based on Australia Bureau of Statistics Postcode and locality. I have the raw data but was wondering if there is any smart way to import it to OFSC Core Manage.
Thanks
View original
Hey Jeff,
Hope you're well. (I'm assuming you're the same Jeff who was on the OFSC Melbourne Bootcamp I trained last year?)
Good question, there's been a bunch of new metadata endpoints added to the REST API in the latest release, one of which is specifically for this job: http://docs.oracle.com/cloud/latest/fieldservicecs_gs/CXFSC/op-rest-ofscMetadata-v1-workZones-post.html
I've managed to hack together some ways of batch uploading to OFSC in the past using SOAP and REST, feel free to drop me an email if you get stuck. There are lots of different ways to go about it from coding something yourself through to using ETL tools, but there's no standard Oracle offering for data upload (yet). I've heard it's on the roadmap, but I'm not certain.
Cheers,
Graham
Hi Jeff,
I hope Graham was able to solve the query. The REST API http://docs.oracle.com/cloud/latest/fieldservicecs_gs/CXFSC/op-rest-ofscMetadata-v1-workZones-post.html is the best way to go forward. You can write a script that can read the workzones from a file and create the workzones. If you need help in making one you can let me know.
Regards,
Hardik Gupta
Hi,
using Postman collection runner, you can easily develop an upload script as postman supports the use of .csv files.
Claus
Thank you both Hardik and Claus. Sorry for the late response. I see that in 17.2 there is new functionality to import workzones.
Hi Jeffry,
Yes 17.2 has importing work zones using REST API. I have tried it and I was successful in importing work zones. If you are facing issues somewhere you can let me know.
Regards,
Hardik Gupta
Hi Hardik,
Can you please provide steps required to import the workzones in 17.2 using the available import function? I've tried with creating one import file in Excel and save as xml file and import it from OFSC core manage UI but it is not successful.
Is there any mandatory steps require?
Thanks
Jeff
Hi Jeff,
You need to write a script that will call the REST API for Workzones.
You cannot directly import it in OFSC. Your program will read the excel and then call the API for the load.
Link for the API: https://docs.oracle.com/cloud/latest/fieldservicecs_gs/CXFSC/op-rest-ofscMetadata-v1-workZones-post.html
Regards,
Hardik Gupta
Hi Sachin,
You can use the Resource Management API for this purpose.
You can create a custom program that will call the required methods. Like for adding or updating resource it is insert resource and update resource and for workzones it will set_resources_zone.
Below is the wsdl link for the SOAP API:
https://api.etadirect.com/soap/resource-management/v3/?wsdl
You can also use REST API: https://docs.oracle.com/cloud/latest/fieldservicecs_gs/CXFSC/api-Core-Resources.html
For migration from one environment to another you can raise a SR requesting for a clone.
Regards,
Hardik Gupta