Latest Contributions by xavierlhomme

‎10-01-2024

Hello In a geoprocessing toolbox, I want to select an attribute containing a JSON, with the following code sql = f"select jbdata from {table_jsonbdata}" tmp = egdb_conn.execute(sql) but I obtain this error fail Exception : ArcSDESQLExecute: StreamBindOutputColumn Erreur ArcSDE -65 Invalid pointer argument to function Exception : File "C:\Users\User01\Desktop\GestionDeProjet\Script-BDD\uploadBackpack.py", line 781, in main tmp = egdb_conn.execute(sql) I tried with JSONB : it failed I tried with TEXT : it failed I tried with VARCHAR : it failed I tried with VARCHAR(2048) : it works How should I store my json in the postgresql table in order to be able to selectit in a geoprocessing script ? best regards

‎06-24-2024

Hello I will try to clarify my issue. I need to insert in a Table, a new record. I'm using a Geodatabase on SQL Server. I wrote a GeoProcessing in Python to do that. In the first version I used arcpy.da.InsertCursor def insertCalcul(calculObject:dict): id_calcul = 0 calculFields = [ "Titre_Calcul", "Description", "installation", "Origine_X", "Origine_Y", "Id_Evenement", "Affichable" ] try: with arcpy.da.InsertCursor(calculTableName, calculFields) as cursor: x = calculObject.get("Origine_X", None) y = calculObject.get("Origine_Y", None) title = calculObject.get("Titre_Calcul", None) description = calculObject.get("Description", None) installation = calculObject.get("installation", None) evenementId = calculObject.get("Id_Evenement", None) arcpy.AddMessage(" insertion du calcul '{0}' ".format(title)) try: id_calcul = cursor.insertRow(( title, description, installation, float(x), float(y), int(evenementId), 0 )) del cursor arcpy.AddMessage("{0} insertions.".format(calculTableName)) return id_calcul except arcpy.ExecuteError: arcpy.AddMessage(" erreur insertion de ligne: '{0}' ".format(arcpy.GetMessages())) except arcpy.ExecuteError: print("Erreur insertion calcul :"+arcpy.GetMessages()) On my develop environnement , this code run well. But I had an exception on th eproduction environnement. The returned Id_Calcul is an ObjectId already in the database. And this is in my opinion the cause of the exception. But with no certainty... The bad objectod could have been set before the exception... The only solution I found in order to overcome this issue in the production environment is to replace this code with an SQL expression "insert into" and set the objectid myself after incrementing the maximum value of the objectID def insertCalcul(calculObject:dict): id_calcul = 0 title = calculObject.get("Titre_Calcul", None) description = calculObject.get("Description", None) installation = calculObject.get("installation", None) x = float(calculObject.get("Origine_X", 0)) y = float(calculObject.get("Origine_Y", 0)) evenementId = int(calculObject.get("Id_Evenement",0)) arcpy.AddMessage(" insertion du calcul '{0}' ".format(title)) arcpy.AddMessage(" description '{0}'".format(description)) arcpy.AddMessage(" installation '{0}'".format(installation)) arcpy.AddMessage(" x '{0}'".format(str(x))) arcpy.AddMessage(" y '{0}'".format(str(y))) arcpy.AddMessage(" evenementId '{0}'".format(evenementId)) calculFields = [ "Titre_Calcul", "Description", "installation", "Origine_X", "Origine_Y", "Id_Evenement", "Affichable", "OBJECTID" ] id_max = int(get_max_objectid(egdb_conn,calculTableName)) id_calcul = id_max + 1 try: fields = ','.join(calculFields) sql=f"INSERT INTO {calculTableName} ({fields}) VALUES ('{title}','{description}','{installation}',{x},{y},{evenementId},{0},{id_calcul})" arcpy.AddMessage(" sql '{0}'".format(sql)) egdb_conn.execute(sql) arcpy.AddMessage("fin insertion") return id_calcul except arcpy.ExecuteError as e: arcpy.AddMessage(" exception insertCalcul ") arcpy.AddMessage(" Args: '{0}' ".format(e.args)) arcpy.AddError("Erreur insertion calcul : '{0} {1}' ".format(str(id_calcul),arcpy.GetMessages())) I think that something is broken in my geodatabase: an indexe , a sequence, or something like that. Is there an operation that would allow me to check the sequence of objectIDs?

‎06-19-2024

Hello I m writting a geopocessing tool with arcpy in order to insert some record in the enterprise geodatabase. I'm using InsertRow from arcpy.da... But I have an exception and the returned objectid is already in my feature table. In order to insert the row , I need to get the max ObjectID and use an SQL statement ( Insert Into)... It's like the sequence of objectid is broken or something like that. Is there any operation that can repair the ObjectID ? Or something to modify on these tables ? Best regards

‎05-12-2023

thanks

‎05-12-2023

Hello What is the best way to add a property page to an AddIn ? My AddIn is linked with another software. I need to set in the AddIn the path of the executable. I could create my own Property button but Do you see other possibilities? Best regards

‎05-04-2023

Thanks Effectively, a small powershell script could do the job : $xmlPath = "Config.daml" $xml = Get-Content -Path $xmlPath $currentDate = Get-Date -Format "M/d/yyyy h:mm:ss tt" $xml = $xml -replace '<Date>.*?</Date>', "<Date>$currentDate</Date>" Set-Content -Path $xmlPath -Value $xml

‎05-04-2023

Hi I use GitLab CI/CD in order to build the product version of an ArcGIS Pro AddIn. Is It possible to change de DAML Date automatically in order to set the Date as the builing Date ? Best Regards

‎09-28-2022

Hello In ArcGIS Manager , it's possible to import a new service from a SD file. It should be usefull to export a service as a SD file, in order to publish the same service in another server. This functionalality combined with the possibility to update datasource ( remplacement editor , publish datasource) could be use in order to publish the same Service from Staging to Production... best Regards

‎06-15-2022

Hello I've several ArcGIS Server 10.6.1 in Production, déployen in CentOS7. Sometimes I have an error when publishing a service with ArcGIS Pro, but I know that restarting ArcGISServer will fix this error, restarting the publishing service is not enough. I also have a python script running as a linux service on the VM. The python script use ArcPY and Python3 with Anaconda. Sometime a I have a failure when restarting the service and the status give me the following information : ArcWine: Loading failed, but reporting SUCCESS I have identified an issue with ArcWine (WineServer) If I killl the wineserver and restart the linux service , the winserver is automatically restarted. Likewise, If I killl the wineserver, ArcgGIS Server is not able to publish a service. If I restart the publishig service on arcgis server, winserver is automatically restarted. But ArcGIS Server s not able to publish a service. To conclude: sometime, we are facing an Issue cause by WineServer. I dont know the root cause of this issue, but this issue will prevent to publish a service or in my case restart my linux service properly. The only way to resolve this issue is to restart arcgisserver. Restaing wineserver (by killing it) ou restarting the publishingtool is not enough. Do you have any information about WineServer and knowed issues with this component of ArcGIS Server ? I need to provide information to the supervision team about issues when it occurs and the action the team need to do in order to restore the fonctionnality. best regards

‎10-19-2021

Hello Just have a look on this https://wiki.openstreetmap.org/wiki/TMS#The_Y_coordinate Best Regards

‎09-29-2021

Hello It would be great to enhance your ArcGIS REST API with a GraphQL API Best Regards

‎12-10-2020

Ok thanks for the solution you provides. It's acceptable if you have an Enterprise Licence Agreement. If not ... hope this user case will be analysed by ESRI Inc

‎12-10-2020

Hello Serve ArcGIS 3D Analyst tools is a capability of the ArcGIS GIS Server Advanced. But if you use a MosaicDataSet, in you GPservice : it won't start. Thanks

‎12-08-2020

Hello I want to publish a python script which use spatial analyst tools and a 3D Analyst tools on a MosaicDatasat. I've a GIS Advanded Server 10.6.1 avs an Image Server 10..6.1. On the first server, I'm able to publish my GP Service, but it won't start due to the MosaicDataset not alowed on a GIS Advanded Server. On the second server, I'm not able to publish my GP Service, beacause I don't have Spatial analyst and 3D Analyst extension. Finaly I concatened the keycode file of the GIS Advanced Server with the keycode of the Image Analysis , and succeed to publish on Image Server. But I asked to the support with licence I need to purchase to purchase... but nobony knows... xavier

‎05-29-2020

Hello In our aplication, we need to draw some label connected to a SymbolPicturemarker. The operator could move the SymbolPictureMarker and the label. In order to do this we needed to draw for the label : a TextSymbol a Polygone for the background a Polyligne for the contour of the backgroung For doing this, we have an Initialize fonction The ActivateLabelBorder flag is enable with thue for displaying the border of the label private void Initialize() { Origin = new MapPoint(0, 0, SpatialReference.Create(2154)); OffsetX = 0; OffsetY = -50; TextContent = ""; TextSize = 20; TextFont = "Arial"; TextColor = 0; BackgroundColor = 1; BorderColor = 0; _TextSymbol = new TextSymbol() { Text = "", Size = 10, FontFamily = "Arial", Color = ColorService.Colors[0], HorizontalAlignment = Esri.ArcGISRuntime.Symbology.HorizontalAlignment.Center, VerticalAlignment = VerticalAlignment.Middle }; _LineSymbol = new SimpleLineSymbol(SimpleLineSymbolStyle.Solid, Color.Black, 1); TextGraphic = new Graphic(Origin, _TextSymbol); LineGraphic = new Graphic(new Polyline(new MapPoint[] { Origin, Origin }), _LineSymbol); var z = Counter.GetAndIncrement(); if (ActivateLabelBorder) { var colorColorBorderLabel = ColorService.Colors[int.Parse(FeatureLabel.ColorLineBorderLabel.ToString())]; colorColorBorderLabel = Color.FromArgb(255, colorColorBorderLabel.R, colorColorBorderLabel.G, colorColorBorderLabel.B); var BorderPolygon = new SimpleLineSymbol(SimpleLineSymbolStyle.Solid, colorColorBorderLabel, ThicknessLineBorderLabel); _PolygonSymbol = new SimpleFillSymbol(SimpleFillSymbolStyle.Solid, Color.FromArgb(230, 0, 0, 0), BorderPolygon); BackgroundGraphic = new Graphic(new Polygon(new MapPoint[] { Origin, Origin }), _PolygonSymbol); BackgroundGraphic.ZIndex = z; } TextGraphic.ZIndex = z + 1; LineGraphic.ZIndex = 0; } I tried with the 100.8 sample (GetElevation from a point) It's possible to initialize a BackgroungColor , an OutlineColor, a Halo But none of the combinaison I tried can display de border of the background with n other color. Could you add in your roadmap a BorderBackgroundColor option ? Best regards xavier lhomme

Online Status	Offline
Date Last Visited	‎10-30-2024 05:51 PM

My Ideas

Latest Contributions by xavierlhomme

Select an JSONB column

Re: Broken objectid... Can't InsertCursor

Broken objectid... Can't InsertCursor

Re: AddIn property

AddIn property

Re: How to set the building date of the AddIn ?

How to set the building date of the AddIn ?

Export as SD file

WineServer issue on Linux

Re: Support for TMS

ArcGIS GraphQL API

Re: Which licence should I have on an Image Server in order to publish a python script with 3D Analyst and Spatial Analyst ?

Re: Which licence should I have on an Image Server in order to publish a python script with 3D Analyst and Spatial Analyst ?

Which licence should I have on an Image Server in order to publish a python script with 3D Analyst and Spatial Analyst ?

How to configure the border line of the background of a text symbol ?

Which licence should I have on an Image Server in ...

Re: How to set the building date of the AddIn ?

Export as SD file

ArcGIS GraphQL API

Re: How to publish a service from ArcGIS Pro to Ar...