Batch Jobs

ESRI ArcGIS to Oracle Utilities Work and Asset Cloud Service/Oracle Utilities Work and Asset Management

The following batch processes need to be run in sequence to load all data:

Step	Batch Code	Description	Additional Parameters
1	W1GISUPL	GIS File Upload	• fileName: Name of the file or files to be uploaded. For multiple files, the parameter supports the “glob” syntax for using wildcard characters. • filePath: The file path where the output should be placed.
2	W1-CMSYN	Composite Sync Request	• State: PENDING • BO: W1-CompositeSyncReqGISAsset
3	W1-SIOPE	Ongoing Sync Request - Pending	• State: PENDING • BO: W1-OngoingSyncRequestLocation
4	W1-SIOPE	Ongoing Sync Request - Pending	• State: PENDING • BO: W1-OngoingSyncRequestAsset

Oracle Utilities Work and Asset Cloud Service/Oracle Utilities Work and Asset Management to ESRI ArcGIS

The following batch process need to be run to extract asset information to a file:

Step	Batch Code	Description	Additional Parameters
1	W1GISEXT	GIS File Extract	• fileName: Name of the extract file. The file will be replaced if it already exists or created if it does not. The parameter value is defaulted to “WACS_<assetClass>_{BN}_{RN}_{TN}.json” where the variable {BN} is the respective batch number, {RN} is re run number and {TN} is thread number. The <assetClass> variable will be replaced with the GIS asset class value followed by the file number based on the Maximum Records Per File parameter. A separate file for each GIS asset class is created if the <assetClass> variable is provided. • filePath: The file path where the output should be placed. • maxRecordsPerFile: Parameter value is defaulted to 300. • fileFormat: Parameter value is defaulted to JSON.