|
POST
|
If you actually edit the data, does it let you save it? The reason I ask is because I can replicate this behavior, where a user with no editing privileges gives the appearance that you can edit (by clicking the attribute value and it giving you the ability to type something different). However, if you change the value and then click elsewhere to save the change, a "Data Error" will appear. Do you receive the error or does it actually change the value?
... View more
05-21-2025
05:54 AM
|
1
|
2
|
1273
|
|
POST
|
My screenshot below should work correctly. If you're writing your number values to a string field, then make sure to put quotes around the numbers. I don't know how to properly explain it, but your Code Block cannot "see" your fields. You can't directly reference them using !Field_Name! syntax. Instead, you have to pass those fields to it from the line above. And then you reference your fields that way. Hopefully my screenshot will help explain it. From there, you just have your if statements to calculate your values. And then at the very end, you need to return the value of "Race_Code" so it can calculate value in your table. Edit: @MErikReedAugusta replied as I was typing my response and didn't see it until after I posted. Their method is more elegant and better than mine lol.
... View more
05-20-2025
06:43 PM
|
3
|
1
|
3714
|
|
POST
|
Is your coworker able to directly access the underlying feature service that you are using in your dashboard (like opening it in a map)? Just to definitively rule out a permission issue.
... View more
05-20-2025
11:26 AM
|
0
|
0
|
1284
|
|
POST
|
I'm not sure what is going on with S123 last week and this week, but we had that exact same issue on multiple devices, including Windows and Android. In Windows, try resetting the app. Also, this geonet post has some good information as well.
... View more
05-20-2025
11:13 AM
|
1
|
1
|
1235
|
|
POST
|
You can see who has an active connection to the database in ArcGIS Pro. But it won't give you historic information. I believe you'd need to configure something within the DBMS in order to get the kind of information you're looking for.
... View more
05-20-2025
08:18 AM
|
1
|
1
|
799
|
|
POST
|
Yeah, I'm not aware of a property that can be programmatically accessed within Esri to determine if it is a table or view (non-versioned Esri views). Using the arcpy Describe function, you can determine a base table's registered as versioned view name, but that would only apply to datasets that are registered as versioned. You still wouldn't be able to determine views that are created outside of Esri's versioning.
... View more
05-20-2025
06:21 AM
|
0
|
0
|
2015
|
|
POST
|
Do you have any certificate errors in your Portal logs? This geonet thread is about the same exact problem, and they resolved it by importing the correct server and root certificates.
... View more
05-20-2025
06:06 AM
|
0
|
0
|
907
|
|
POST
|
Yeah, your records aren't truly null. It looks like it is just an empty string, or a value of a single space or something. If it was truly null, it would look like this: So your Arcade expression is working correctly, you'll just need to either correct the data to make the values truly null, or you'll need to account for empty strings/spaces in your Arcade expression.
... View more
05-19-2025
01:26 PM
|
1
|
1
|
2413
|
|
POST
|
The Arcade expression below might work. I think you'll need double equal signs. And the syntax for "IN" is a little different in Arcade. https://developers.arcgis.com/arcade/function-reference/array_functions/#includes $feature.Field1 == 'Open' && $feature.Field2 == 'LP' && Includes([10, 11, 12, 13, 14], $feature.Field3)
... View more
05-19-2025
12:32 PM
|
1
|
2
|
1436
|
|
POST
|
Is the data in the WorkOrder Number field truly a null value? Or could it just be an empty string with a space or something like that? As a quick test, you could try returning the value of the WorkOrderNumber variable in the Arcade expression, just to see what it is saying the value is.
... View more
05-19-2025
12:16 PM
|
0
|
3
|
2434
|
|
POST
|
If the ArcGIS Server machine is down, Portal and all applications on Portal (WAB, ExB, etc.) will continue to function, but the underlying services that the apps are consuming will not work. So in your case, your WAB/ExB apps will still open, but there will be no data inside of it (because the underlying feature services the apps are using aren't online because the ArcGIS Server is down). You'll get an error message something along the lines of "layer name failed to load." If Portal is down, then you won't be able to access WAB/ExB at all. It depends on what exactly is down, but if your web adaptor is online but Portal is offline, then you will get an error message like this. If Portal and web adaptor are down, then your browser just won't load anything and will eventually time out. If both Portal and Server are down, then you'll most likely notice something wrong with Portal first because you won't be able to load the Portal site. But that doesn't mean something isn't wrong with ArcGIS Server as well. I'm not sure what you mean by "supporting snapshots", but as far as documentation, Esri's ArcGIS Enterprise documentation might provide some insight as well as Esri's training courses might help as well.
... View more
05-19-2025
09:27 AM
|
1
|
1
|
1887
|
|
POST
|
Do you have anything else configured with your year question? I can't reproduce that behavior. Using your calculation, it seems to work fine for me (in a published survey).
... View more
05-19-2025
06:34 AM
|
0
|
0
|
2039
|
|
POST
|
If you're okay with using Python outside of ArcPy, then I will give you a couple of scripts that can be used to determine the tables and views. Of course, you'll still need to modify the scripts to forward them to your views/items DB, but it should at least give you a starting point. You'd still be able to run this as a script tool in ArcGIS Pro. It uses Python to directly connect to a MS SQL database. #Output Tables
import pyodbc
def list_tables_mssql(server, database, username, password):
try:
# Connection string
conn_str = (
f"DRIVER={{ODBC Driver 17 for SQL Server}};"
f"SERVER={server};"
f"DATABASE={database};"
f"UID={username};"
f"PWD={password}"
)
# Connect to SQL Server
conn = pyodbc.connect(conn_str)
cursor = conn.cursor()
# Query to get all user-defined tables
cursor.execute("""
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
""")
tables = cursor.fetchall()
if tables:
print("Tables in the SQL Server database:")
for schema, name in tables:
print(f" - {schema}.{name}")
else:
print("No tables found in the database.")
except pyodbc.Error as e:
print(f"SQL Server error: {e}")
finally:
if conn:
conn.close()
# Example usage
if __name__ == "__main__":
list_tables_mssql(
server="localhost\\SQLEXPRESS",
database="YourDatabaseName",
username="YourUsername",
password="YourPassword"
) #Output Views
import pyodbc
def list_views_mssql(server, database, username, password):
try:
# Connection string
conn_str = (
f"DRIVER={{ODBC Driver 17 for SQL Server}};"
f"SERVER={server};"
f"DATABASE={database};"
f"UID={username};"
f"PWD={password}"
)
# Connect to the SQL Server
conn = pyodbc.connect(conn_str)
cursor = conn.cursor()
# Query to get all views in the database
cursor.execute("""
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
""")
views = cursor.fetchall()
if views:
print("Views in the SQL Server database:")
for schema, name in views:
print(f" - {schema}.{name}")
else:
print("No views found in the database.")
except pyodbc.Error as e:
print(f"SQL Server error: {e}")
finally:
if conn:
conn.close()
# Example usage
if __name__ == "__main__":
list_views_mssql(
server="localhost\\SQLEXPRESS",
database="YourDatabaseName",
username="YourUsername",
password="YourPassword"
)
... View more
05-18-2025
10:49 AM
|
2
|
2
|
2142
|
|
POST
|
This Esri documentation has some really good information on what settings are inherited in the view from the hosted feature layer that can and cannot be changed on the view. Per the documentation, edit settings can be configured independently on the views from the hosted feature layers they are created from. Meaning that you should be able to allow editing on the view, with it still disabled on the hosted feature layer. (Note that some additional edit settings, such as editor tracking, must be made at the hosted feature layer level. But the enable/disable editing setting itself can be changed independently on the view). This is something that I just tested with my own hosted feature layer/view in AGOL and it works fine for me. Editing is disabled in the hosted feature layer, but enabled on the view and I can add new data as well as edit existing data. Your "applyedits" response in the network traffic indicates a different problem. It appears that it is trying to add a record with the same key, which is not possible to do. For example, if ObjectID is your key field and you have a record with an ObjectID of 1. And then you try to add a new record with an ObjectID of 1, it will fail because a key with that value already exists. I've never really heard of that being a problem in AGOL though. If it's possible, it might be worth trying to enable editing on your hosted feature layer and see if you are able to add new records to it, or if you receive the same error. If you don't receive any errors, it might be worth trying to delete and re-create the view again. And if you do receive errors in the feature layer itself, then I think you have a different problem that needs to be resolved.
... View more
05-16-2025
05:37 PM
|
1
|
1
|
3074
|
|
POST
|
Actually, you can use the body::accept column to limit the file type, such as .jpg. https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformmedia.htm#ESRI_SECTION1_A2F2DA5ADD8646B99D2344DF4595CD4B
... View more
05-16-2025
10:55 AM
|
1
|
1
|
1318
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 2 weeks ago | |
| 1 | 2 weeks ago | |
| 1 | 2 weeks ago | |
| 1 | 2 weeks ago | |
| 1 | 2 weeks ago |
| Online Status |
Offline
|
| Date Last Visited |
5 hours ago
|