Field Service

Get Involved. Join the Conversation.

Topic

    Sachin Rathod
    Any tool or utility to configure 40k+ resources and work...Answered
    Topic posted December 4, 2016 by Sachin RathodBlue Ribbon: 750+ Points 
    240 Views, 9 Comments
    Title:
    Any tool or utility to configure 40k+ resources and work zones
    Content:

    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

     

     

     

    Version:
    16.8

    Best Comment

    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

    Comment

     

    • 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

    • Jeffry Husman

      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

       

    • Graham Sawell
      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

    • Hardik Gupta

      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

    • Claus Lemke

      Hi,

      using  Postman collection runner, you can easily develop an upload script as postman supports the use of .csv files.

      Claus

    • Jeffry Husman

      Thank you both Hardik and Claus. Sorry for the late response. I see that in 17.2 there is new functionality to import workzones.

    • Hardik Gupta

      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

    • Jeffry Husman

      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

    • Hardik Gupta

      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