registrant icon indicating copy to clipboard operation
registrant copied to clipboard

How to use with server hosted Database

Open NR-COSR opened this issue 4 years ago • 2 comments

I see that this hasn't been updated in a few years and no new issues have been opened in a while so I assume it's dead. But on the off chance it's not I thought I'd ask for an improvement to the documentation. The documentation indicates that the reporter can be used with a RDBMS enterprise geodatabases but does not provide any example of how to go about doing this. I tried to figure it out by looking at the documentation for arcpy and then looking in the code for when that was used but I couldn't find it. Thanks

NR-COSR avatar May 19 '21 21:05 NR-COSR

Hi! Thanks for posting, it's not dead :) maybe there are no issues because everything just works smoothly? ;)

It's been a while indeed and I don't work in the GIS industry any longer, but from what I remember and what I quickly read in the source code, you just have to provide the path to your .sde connection file stored on disk:

reporter = registrant.Reporter(
    r"C:\DBconnections\Production.sde", r"C:\GIS\ReportFolder"
)

Could you please try that and get back whether this works?

AlexArcPy avatar May 19 '21 21:05 AlexArcPy

Well I'm super happy that you responded so quickly. I went to try that and discovered that my install of ArcGIS desktop 10.6 is super screwy. Which means I can't get both arcpy and registrant to be imported at the same time. Because if I run python from a command line and it successfully installs registrant arcpy isn't working. But if I change my directory to the copy of python installed specifically by the Desktop installer I can't install registrant because it can't connect to the pip server due to an SSL error to get the pre-requisites. So I wanted to let you know that I appreciate your quick response and I hope to try your suggestion soon but at the moment I'm fighting with the python install so I can't try it yet. I know my problem is not with your code so I will try and fix my problem and try your solution then.

NR-COSR avatar May 20 '21 00:05 NR-COSR