topic Re: cad in geoprocessing service in ArcGIS Enterprise Questions

cad in geoprocessing service

ZachTagar — Thu, 06 Oct 2016 12:51:52 GMT

I want to use the CAD to Geodatabase tool as a service, where a user can upload a dwg file and have it shown on a web map as map service. Trouble is that the dwg file is always a 'constant' parameter as it cannot be passed by the browser. I need the user to pass files they receive as part of their workflow. Any suggestions?

Re: cad in geoprocessing service

JonathanQuinn — Thu, 06 Oct 2016 16:50:47 GMT

What about writing your own script to have the user upload a zip file of the DWG, (input parameter is of File type), the script unzips the zip file, and then processes it?

Re: cad in geoprocessing service

ZachTagar — Tue, 11 Oct 2016 06:10:20 GMT

Thanks. This would add a task to the user which I would ideally like to avoid: they would have to zip the DWG before uploading it to the app. It's a workaround, but it would be great to have a quicker way, from the user's point of view. Any ideas?

Re: cad in geoprocessing service

JonathanQuinn — Tue, 11 Oct 2016 16:31:19 GMT

Good point, Zach. Are you familiar with Python? If so, you can use the Copy_management tool and set the input as a File type. This will set the initial input to the tool as a GPDataFile type, and after enabling uploads on the GP service, will tell the browser that the user can upload a file to that parameter. The file can then be copied to the scratch folder and used as input to the CADToGeodatabase tool. The result requires a resulting map service, as it returns a feature dataset, so you should be good as long as your application can retrieve the resulting map service. You could also loop through the scratch geodatabase and then the feature dataset to find the feature classes if you want to return them individually. I've uploaded a sample for you to take a look at. See if you can grab it from here.

Re: cad in geoprocessing service

ZachTagar — Thu, 17 Nov 2016 11:26:53 GMT

Thank you Jonathan. This is indeed very helpful. I will try this .

Re: cad in geoprocessing service

NagorneacConstantin — Mon, 02 Apr 2018 20:50:18 GMT

Dear Jonathan,

I tried to use your sample to upload CAD file and view it as map service, but when I publish it as Geoprocessing service on portal and try to execute it, it fails with the following arcgis server log:

Invalid return value: c:\arcgisserver\directories\arcgisjobs\stopo\cadtogdb_sample_gpserver\j44e42223599b4b449d24ae23e8abde1f\scratch\scratch.gdb\SDS_ToGDB

Could you please give me some hints why it is not working?

I am using Arcgis Server and Portal 1.5.1

Re: cad in geoprocessing service

JonathanQuinn — Tue, 03 Apr 2018 16:45:08 GMT

Can you run the tool, then using ArcCatalog or ArcMap, take a look in the scratch.gdb and check to see if the output data is in there? It may be failing to create it, but I would expect the GP task to fail if that's the case.

Re: cad in geoprocessing service

NagorneacConstantin — Wed, 04 Apr 2018 15:34:18 GMT

You are right. Script copies the data into scratch folder, but does not export data into scratch.gdb

Anyway, It is a nice start. I will try to replicate this functionality by myself.

Re: cad in geoprocessing service

JonathanQuinn — Wed, 04 Apr 2018 15:54:33 GMT

How are you defining the output paths for data? You can try to use the os module and the scratch GDB environment variable to construct the path for any output data:

outData = os.path.join(arcpy.env.scratchGDB,"outData")

Re: cad in geoprocessing service

NagorneacConstantin — Wed, 04 Apr 2018 20:20:47 GMT

Update: I made a mistake. The script works fine from Arcmap. it writes output to scratch.gdb.

Update 2: I also found out that none of my published models can write into scratchGDB. They are okay if they need to write into scratch folder. I tried "feature class to feature class" and it writes shapefile into scratch folder but refuses to write feature class in scratch GDB.

Update 3: wnen script tries to write into ScratchGDB it gives me the following error:

Error executing tool. Upload_and_Visualize_DWG Job ID: j9605b3b83e15414eaff7f14cd9b81833 : ERROR 000210: Cannot create output c:\arcgisserver\directories\arcgisjobs\stopo\upload_test_2_gpserver\j9605b3b83e15414eaff7f14cd9b81833\scratch\scratch.gdb\A44755_F1_C454_350_Polyline Failed to execute (Feature Class to Feature Class). Failed to execute (Model63). Failed to execute (Upload_and_Visualize_DWG).

So looks like it creates job folder where puts DWG file, then it tries to execute Feature class to feature class and fails to write output into scratch.gdb.

Re: cad in geoprocessing service

MapsGeek — Wed, 01 Jan 2020 01:38:02 GMT

can you please elaborate a little about that error ?
when i run the script from ArcMap it successfully creates a dataset with the features inside the scratch geodatabase, on the published service i get the same error as Nagorneac Constantin‌ when i run from web appbuilder however when i check the job output in the server directories i find that the scratch geodatabase has been created and features inside as well.
this tool here does the same function i or " we " need but i have no clue how to do the same since i have no knowledge in python, i also used you methodology using model builder and it worked but couldn't get the file to be imported dynamically, the service always copied the used CAD file to the server and made it as a constant.

when i run the published service from Arcmap i get an error

these are the parameters i add to the script

this is the current code in the script

import arcpy, os

inFile = arcpy.GetParameterAsText(0)

referenceScale = arcpy.GetParameterAsText(1)

inFileName = os.path.basename(inFile)

outFile = os.path.join(arcpy.env.scratchFolder,inFileName)

arcpy.AddMessage("Copying input data set to the scratch folder...")

arcpy.Copy_management(inFile,outFile)

outGDBPath = arcpy.env.scratchGDB

outDataSetName = "{0}_ToGDB".format(inFileName.rstrip(".dwg"))

sr = arcpy.SpatialReference(102100)

arcpy.AddMessage("Running CAD to GDB tool...")

arcpy.CADToGeodatabase_conversion(outFile,

outGDBPath,

outDataSetName,

referenceScale,

sr)

outData = os.path.join(arcpy.env.scratchGDB,outDataSetName)

arcpy.SetParameter(2,outData)