Latest Contributions by PanGIS

‎10-17-2019

hi, maybe this: Convert labels to annotation—ArcGIS Pro | ArcGIS Desktop

‎10-17-2019

Hi everyone, I' ve created a model that updates a table in PostgreSQL The model runs perfectly as model and as tool as well. Exported the Model into python script an it runs in Arc Python window. I have created also a script that calls the toolbox and model inside and it works when run into Arc Python Window. When I put it in Windows scheduler the task starts and completes but the table isn't updated meaning that the script doesn't run correctly. I tried to run the same script in PyScripter and I get this error message: Message File Name Line Position Traceback <module> C:\Folder\script_startModel.py 15 TableReadings2 C:\Folder\Toolbox.tbx 75 ExecuteError: Failed to execute. Parameters are not valid. The value does not exist. ERROR 000732: Output Location: Dataset Database Connections\database_publish.sde does not exist or is not supported The value does not exist. ERROR 000732: Output Location: Dataset Database Connections\database_publish.sde does not exist or is not supported The value does not exist. ERROR 000732: Input Table: Dataset database.sde.Building_Readings does not exist or is not supported ERROR 000989: Tool CalculateField cannot use VB expressions for services ERROR 000989: Tool CalculateField cannot use VB expressions for services ERROR 000989: Tool CalculateField cannot use VB expressions for services ERROR 000989: Tool CalculateField cannot use VB expressions for services Failed to execute (ScriptReadings2). I tried to run the same script in Windows CMD and I get this error message: C:\Users\username>C:\python27\Arcgis10.5\python.exe C:\Folder\Script_startModel.py Traceback (most recent call last): File "C:\Folder\Script_startModel.py", line 15, in <module> arcpy.ModelReadings2_Toolbox() File "C:\Folder\Toolbox.tbx", line 75, in ModelReadings2 arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid. The value does not exist. ERROR 000732: Input Table: Dataset database_publish.sde.Building_Readings does not exist or is not supported Failed to execute (ScriptReadings2). The main issue seems to be the database which is not recognised. Any idea? Thanks

‎10-17-2019

I found the answer here: https://community.esri.com/thread/51894#comment-579306

‎10-07-2019

Thank you Joshua Bixby, I need to covert the first column into the last (string to numeric). I attempted the Replace because I thought I could simplify it but, as you pointed out.....I did not. I cannot convert them to 0 because it will false my analysis (they are temp and other values) I need a NO VALUE

‎10-06-2019

Hi Dan, Thank you for your reply. I did not explained myself well. The original table has a field (string type) with numbers and some "nan" values. When I say nan I mean the word "nan". Since I need to convert this values into numbers I remove the word nan by using the python exp.: !ACmodeString!.replace("nan","<Null>"). Now I have that string field populated by numbers and <Null> records. What I need to do is to convert all these values into integer in a new field (short type). I'll try to upload some data as soon as possible. Here a not very nice example:

‎10-06-2019

Hi, I am running a model. 1. for field 1(string) I have "integer numbers" and a value "nan" I use field calc with the expression: !ACmodeString!.replace("nan","<Null>") 2. Once I have the null records I run again Filed Calc to copy these values from the string field into a integer field with a expression like Field1(string) = Field2(integer) [ I have tried both VB and Python] a. with python I get this error: ERROR 999999: Error executing function. The value type is incompatible with the field type. b. with python again int(!acmodestring!) erro: ERROR 000539: Error running expression: int(u"<Null>") Traceback (most recent call last): File "<expression>", line 1, in <module> ValueError: invalid literal for int() with base 10: '<Null>' c. with VB I get an alert: If I click yes it finishes. the same happens for a filed that needs to be converted in float. I need to get rid of this alert. The issue seems to be the null value. Thanks!

‎10-03-2019

George Thompson Asrujit SenGupta It works guys! thank you!!!! I added some new fields, also the shape so it will show the geometry, and the symbology works. Another question if I may, I am sorry to stress out too much: The query that works is this one: SELECT b.objectid, b.globalid, b.shortname, b.longname, b.shape, r.timestamp, r.room, r.acmode, r.actemp FROM BLKJ_Building b, Readings r WHERE b.shortname = r.room I would like to select the last time stamp only and a range. (the range ideally for a time slider) for last time stamp I've tried this one, but doesn't work. Any idea of what should be the correct one? SELECT b.objectid, b.globalid, b.shortname, b.longname, b.floor, b.shape, MAX(r.timestamp), r.room, r.acmode, r.actemp FROM Building b, Readings r WHERE b.shortname = r.room

‎10-02-2019

Hi! Very basic question. not for me.... I am trying to create a database view with this statement. (both from catalog and from toolbox) CREATE VIEW readings_view AS SELECT (b.shortname,b.longname,r.timestamp,r.room,r.acmode,r.actemp) FROM #nameofFeatureClass# b, #nameOfTable# r WHERE b.shortname = r.room; I get this error There is already a relationship 1:M between the two. but I am trying to crate this view and publish it as I need to crate a symbology from related table. I read that creating a database view is a possible way but I cannot get it. What do I do wrong? I am trying to replicate what is in here: Example: Create database views in SQL Server using SQL—Help | ArcGIS Desktop thanks!!!

‎09-12-2019

No, it does not meet the minimum requirements. I had a similar issue when I upgraded to server 10.6.1 and my PG was 9.5.10: I was not able to register my database into server. I would recommend to upgrade.

‎09-10-2019

Hi, have you checked whether your PostGRE vesion meets the minimum requirement for 10.7? PostgreSQL database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.4—System Requirements | ArcGIS Desktop

‎09-10-2019

Hi Ahmed, in a previous message you said " Hi Christian, Thanks for your response. I created an online account with my gmail id. Then I purchased the product (ArcGIS Pro 2.4). Got an activation link from Esri and thus did that. ----> what does the activation link says and what have you done? Afterwards, I downloaded the installer file from esri and installed it. But when I tried to open that I got that message...……"

‎09-09-2019

What does the Esri Activation email say? Usually, you find all the info there. What kind of license have you purchased?

‎09-06-2019

Hi all, I created a secured folder in my AGServer. The folder is accessible from the localhost and it works fine. but when I try to login from another machine the http://server:6080/arcgis/rest/login switches into: https://server:6443/arcgis/rest/login and the page is not found. I am trying to understand whether it is a problem of certificate (we have only a SelfSigned) , Port (the firewall is off); or what else? any idea? thanks!

‎09-06-2019

Also, when you purchase a license, you should receive an authorization email that allows you to convert your public or create a new organizational account. Have you done it?

‎09-06-2019

It might be useful to see the following: go to https://marketplace.arcgis.com and login with the agol credential that are linked to the ESRI authorization. Go to Console is ArcGIS PRO listed? if so you can go to manage license and assign the license to your account.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by PanGIS

Re: Labeling in Arc Pro

Model / Script works in ArcMap but doesn't run when in Windows Scheduler

Re: Calculate field string into int and float => error

Re: Calculate field string into int and float => error

Re: Calculate field string into int and float => error

Calculate field string into int and float => error

Re: Database view - Help with Statement

Database view - Help with Statement

Re: Error when registering PostgreSQL database with ArcGIS Server

Re: Error when registering PostgreSQL database with ArcGIS Server

Re: Can't authorise ArcGIS Pro and thus can't start using the software. Please suggest ways to complete the process. Error says.'Your account couldn’t be used to authorize ArcGIS Pro because it is an ArcGIS public account’.

Re: Can't authorise ArcGIS Pro and thus can't start using the software. Please suggest ways to complete the process. Error says.'Your account couldn’t be used to authorize ArcGIS Pro because it is an ArcGIS public account’.

Access Secure Services: cannot reach the login page

Re: Can't authorise ArcGIS Pro and thus can't start using the software. Please suggest ways to complete the process. Error says.'Your account couldn’t be used to authorize ArcGIS Pro because it is an ArcGIS public account’.

Re: Can't authorise ArcGIS Pro and thus can't start using the software. Please suggest ways to complete the process. Error says.'Your account couldn’t be used to authorize ArcGIS Pro because it is an ArcGIS public account’.

Re: Survey opened via link in Field App does not p...

Re: How do display a time series by year in Dashbo...

Re: Calculate created_user

Re: Option to create new survey from existing surv...

Re: 3D mensuration tools on Imagery tab are disabl...

Python Snippets