Latest Contributions by AhmadSALEH1

‎08-27-2018

Hello, I Have 3 dates fields as the image below: What I am trying to do is to populate 'Created' and 'Updated' fields with values from 'Designdate' field and add time to this field. The time value will be static and doesn't change ( 12:01:00 AM) the result should be something like this "1/1/2015 12:01:00 AM". Till now I couldn't figure out how to do this using python , what I have so far is the below script but this will populate the fields with dates only without the time. Any Ideas?. import datetime import arcpy targetfc=r"D:\d2\New File Geodatabase.gdb\gf" updateDateFields=['created','updated','DesignDate'] time='12:01:00 AM' with arcpy.da.UpdateCursor(targetfc, updateDateFields) as userUpdateCursor2: for row in userUpdateCursor2: row[0]=row[2] row[1]=row[2] userUpdateCursor2.updateRow(row) del userUpdateCursor2‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Thank you,

‎08-09-2018

Thank you Randy for your input, I changed my approach a little bit, and used your hint, the action link was changed to http://myserver/arcgis/rest/services/myservice/MapServer/0/query?where=NID=%27test%27&f=json&token=Token here and I removed all other variables from the form. Thank you, Ahmad

‎08-07-2018

Hello, I have a web page that takes a query then submits it the the ArcGIS server rest end point, http://myserver/arcgis/rest/services/myService/MapServer/0/query the web page looks like the following image and I sucessfully pass the parameters and receive the results. My issue is that I am reading from a secured service and every time I hit the button "Get the Map" it asks me to login the arcgis server. I know that I can use a token to get the results, but unfortunately I couldn't figure out how to include it in the submit button. <form name="sdform2" action="http://MyServer:6080/arcgis/rest/services/MyService/MapServer/1/query" method="post"> <tr valign="top"> <p hidden> <td>Where:</td> <td> <input type="text" Name="where" Id=whereNodes value="NID='test'" size="45"> </p> <br> <br> <table border=".1"> <tr align="center"> <td width="120">Title</td> <td> <p hidden> <input type="text" id="outNodeFields" name="outFields" value="*" size="75"> <select name="f"> <option value="kmz">KMZ</option> <option value="json">json</option> </select> </p> </td> <td> <input type="submit" value="Submit"> </td> </tr> </table> </form>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Any help is highly appreciated. Thank you, Ahmad

‎08-02-2018

Thank you Kelly, this was helpful. Regards, Ahmad

‎08-02-2018

Richard, Thank you for the informative and detailed answer, I was able to figure this out using based on your answer. here is my method for future reference. 1- I created a third table, and started dumping the project ID and the object ID from the points layer, I did that using python, and striping out the project based on the comma. 2- Joint between the new table and the project table. 3- relationship between the new table and the points. Thanks a lot, Ahmad

‎07-30-2018

Hello, I am starting this discussion just to see if you guys have any ideas on how to implement the following scenario. I have points layer “Locations” these points represent light poles in real life, in some cases a single pole is connected to several projects, and to reflect that I use commas to add more than project in the Project ID field, this was I populate multiple project id’s for the same pole. On the other hand, I have Projects table that stores specific data about each project. Now the challenge is that I need to relate the 2 tables together so whenever a user selects a point on the map he can get a list of all projects connected to this point with their related data. Here is an example: for the Point #5: its referencing project B,D,C how do I relate this data to the highlighted rows in the Project tables. is there any workaround to do this? Thanks a lot, Ahmad

‎07-26-2018

Hello, ArcGIS Online is configured to use ArcGIS World Geocoding Service, using this geocoding service for batch geocoding consumes credits, so I moved to create my own geocoding service and I added it to utility services in the ArcGIS organization account and I was able to use it in the search box in WAB, but I couldn’t figure out how to set it as a default geocoder for my organization to avoid consuming the credits! http://doc.arcgis.com/en/arcgis-online/administer/configure-services.htm I am asking this because when I use the Add data widget it doesn’t ask me to choose which geocoder to use to batch geocode a CSV? Also using ArcGIS Maps for Office, and here I am quoting the documentation in the below like: “ArcGIS Maps for Office uses the default geocoder your administrator configured in ArcGIS” https://doc.arcgis.com/en/maps-for-office/install-and-configure/configure-a-custom-geocoder.htm it seems that there is a place to configure this but I couldn’t find it out, any help is highly appreciated! Thank you, Ahmad

‎07-12-2018

In the web map I can see this in the popup where I can click on the "Show Related Records" link to open the related table. While in WAB I have to do multiple clicks to open the related table: Then And after clicking on the three dots I should select "view in attribute table" I cant get it why not to make open the attribute table simple as the web map! Does anyone has a workaround to do to show the related features same as the web map ? Thank you, Ahmad

‎07-12-2018

Mike, Did you find a solution, I am having this issue with WAB, its really annoying. Thank you, Ahmad

‎07-10-2018

Hi, I am trying to register a feature class as a version, and I got this error: (Failed to register as versioned, Cannot find the object "d153" because it doesn't exist or you don't have permissions) Here what I did before, the feature class was already registered as versioned moving the edits to base so I wanted to un-register then register without moving the edits to the base. to do that I compressed the database to state 0 then unregistered the feature class and when I tried to register it again I got this message! This message doesn't make any sense: 1- because I am using the data owner user "sde" ( the database was configured with the sde user as the owner) so I think I have the permission to that. 2- the message reference the delete table "d153" which was droped when the feature class was un-registered as versioned. what might be the issue here? Update#1: I remembered that I restored the database from the backup before doing that, and I didn't Re-sync the sql sever logins after restoring, so I executed this query in SQL EXEC sp_change_users_login 'Update_One', 'sde', 'sde' As a result of this I got a new error when I try to register as version it says that the column 'sde_sate_id' is the geometry table is specified more than once.!! Thanks alot, Ahmad

‎07-10-2018

Abdallah, Your model uses field calculator to populate some fields, right? in that case try to change the expression type in the field calculator from VB to Python and it will work with you.

‎06-29-2018

Chris, As you said its not the end of the world, but its annoying that we cant control it. Thank you.

‎06-29-2018

Rex, You're right about the tool and I am aware of it, but I am trying to limit the number of tools that the user runs, adding to that the time that take the user to create the connection and drag drop it to the tool then run it. In my case this is time consuming. And I created a template to avoid all of these steps, the user should be able to grab a copy of the template > change the version or create a new one> start editing. Thank you though for you input.

‎06-27-2018

Hi, I have an mxd file that I use as a template, this mxd references 2 databases (502 and 280 in the screenshot below). Now my question is when I try to create a version using create new version button in versioning tool bar then how to know which parent version is related to which database?? the drop down menu shows 2 parent versions with the same name dbo.default !! I cannot till which till which is which, so If I am trying to create a new version to edit the schools I should do this in the 280 database but with the current window end up creating the version in the 502 database. I am looking for method that doesn’t include trial and error. Another method to do that is by using the version manager window then right click above the default version then create a new version. This window says the database that you’re in but it doesn’t have the capability to navigate between all databases in the mxd!! I believe both of them depends on layer location in the TOC the above layer is the first one in the new version window and is the default in the version manager widow. Thanks, Ahmad

‎06-27-2018

I think if esri included this capability in the model builder it would be easier than using submodels. people can start doing their process automation without the need to learn how to code

Online Status	Offline
Date Last Visited	‎05-27-2024 05:35 PM

My Ideas

Latest Contributions by AhmadSALEH1

Concatenate Date and Time in a date field

Re: Using tokens in arcgis rest api queries

Using tokens in arcgis rest api queries

Re: Setting a custom geocoder as the default within ArcGIS organization

Re: Create a relationship between tables on a "LIKE" basis

Create a relationship between tables on a "LIKE" basis

Setting a custom geocoder as the default within ArcGIS organization

Show Related Records in WAB in one step

Re: Did related records in popups change in Portal 10.5.1?

Can't Register feature class as versioned

Re: Python script fails to run a model

Re: Control where to create the version in an MXD that has multiple database connections

Re: Control where to create the version in an MXD that has multiple database connections

Control where to create the version in an MXD that has multiple database connections

Re: Insert more than one iterator in one model

Re: Change the service link when using "store cred...

Change the service link when using "store credenti...

Re: Underlying DBMS errorFail to enable database o...

Re: Azure Active Directory integration with ArcGIS...

How to call an SQL Server stored procedure from Ar...