Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JamieLeitch1
JamieLeitch1
Deactivated User
since
09-13-2017
07-09-2024
29
Posts created
10
Kudos given
3
Solutions
19
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(1 Idea Submissions)Latest Contributions by JamieLeitch1
|
POST
|
Yes, there is a dump file created when the add-in crash happens. All of a sudden I couldn't publish to AGOL anymore either. It turns out that the first solution posted here solved all of these issues: Error: External sharing process failed I removed the PYTHONPATH environment variable from my system. I did not have the PYTHON variable. Now I wonder if this will cause problems with ArcMap?
... View more
01-22-2019
12:58 PM
|
1
|
1
|
2352
|
|
POST
|
Yes I've done that. I've also done a manual uninstall and clean install. I also have problems running the Solutions Deployment Tool add-in. Pro freezes and eventually crashes and asks if I want to send an error report. Neither of these issues are happening on other computers in my org.
... View more
01-22-2019
12:42 PM
|
0
|
3
|
2352
|
|
POST
|
This seems to be dependent on which folder I click and whether I double-click or single-click. In the Add Folder Connection dialog if I click on my C drive on the left pane and then double-click on certain folders in the right pane Pro will crash. If I just click on a folder and click Open it will add the folder successfully and not crash. If I click on a mapped network drive on the right pane, it crashes immediately.
... View more
01-22-2019
09:41 AM
|
0
|
0
|
2352
|
|
POST
|
I open ArcGIS Pro, create a new blank project, right-click on Folders in the Catalog pane, then click Add Folder Connection. If I then click on any folder in the dialog box, ArcGIS Pro disappears from my screen and seems to shut down. However, the task is still running in Windows task manager until I end it manually. Does anyone know why this might be?
... View more
01-22-2019
09:17 AM
|
0
|
8
|
2576
|
|
POST
|
I am running ArcGIS Pro 2.2.4 on Windows 7 64-bit and have the ArcGIS Solutions Deployment Tool addin installed. When I open Pro and click the Solutions Deployment tool button, the tool seems to open, then a few seconds later Pro shuts down. Has anyone else experienced this? Is there a solution to this problem?
... View more
12-21-2018
07:03 AM
|
0
|
1
|
685
|
|
POST
|
I have a web map in ArcGIS online containing a hosted feature layer and a related table (one feature to many related records). Is there a way to select a related table record and have the associated feature selected in the feature layer?
... View more
12-20-2018
10:45 AM
|
0
|
0
|
771
|
|
POST
|
This is true. However, I've searched/replaced the definitions of every trigger, stored procedure, and function, and the records of every table to find occurrences of the old name. This is not to say that it won't fail in the future as configuration changes are made to the original gdb. Further testing and time will tell...
... View more
12-20-2018
06:33 AM
|
0
|
0
|
1258
|
|
POST
|
Actually, on a test enterprise geodatabase I was able to essentially "find and replace" any occurrence of the old database name with the new database name, and I can now connect to this new database using ArcGIS Desktop. I haven't done extensive testing, but I am able to edit feature classes, and publish services to Server. If my testing continues to be successful, I will be able to create a SQL Server Agent to perform the backup, restore, and alterations to tables and stored procedures and run on a schedule. I created a SQL stored procedure that showed me all of the objects in the database that contained a record with the old database name in it. I could then run queries to update these tables with the new database name, and also alter the stored procedures with the new database name.
... View more
12-20-2018
05:47 AM
|
0
|
2
|
1258
|
|
POST
|
I've encountered this same error when trying to connect to an enterprise geodatabase in SQL Server 2017 that had been restored from a backup and renamed using SQL Management Studio. The problem is that there are several tables and stored procedures that contain the name of the original database that the backup was made from. To connect to this new renamed restored database, you need to update these tables and stored procedures with the new database name. Check these tables: GDB_ITEMS SDE_column_registry SDE_geometry_columns SDE_layers SDE_process_information SDE_table_registry And these stored procedures: create_version delete_version edit_version You should see the name of the original database within those objects. Best test what happens in a test db first if you do the find/replace.
... View more
12-19-2018
11:24 AM
|
1
|
4
|
5805
|
|
POST
|
I'm new to ArcGIS Online. On my organization's home page I can share some featured content using a "Featured Content" group. Can the home page for my org. display different content depending on whether a logged-in named user is looking at it or a member of the public? thanks
... View more
10-16-2018
12:32 PM
|
0
|
1
|
987
|
|
POST
|
I got this from Support and it worked for me: 1. In the Catalog window: a. Right-click the FGDB -> Refresh 2. In the Contents window: a. Remove the Street_Lights layer and Street_Lights_Inspections table from the map b. Add these back to the map by dragging them from the Catalog c. Now try 'Add New To Relationship' through the Attributes window.
... View more
06-18-2018
08:31 AM
|
2
|
1
|
6304
|
|
IDEA
|
I would like the ability to expose and edit SQL for hosted feature layer views. This would allow much greater customization and control over the views. An example where this can be used is when you want to filter the layer based on something dynamic. For example, if you have a feature layer that has CreationDate and EditDate attributes and you want to filter for records where the EditDate is within 14 days of the CreationDate: select * from [FeatureLayer] where EditDate <= DATEADD(day,14,convert(date,CreationDate)) Another example is where you want to have a dynamically generated attribute on the view that is perhaps a concatenation of two attributes in the feature layer: Select [FeatureLayer].*, concat([Status] + '-' + [Priority]) as [Defect_priority] from [FeatureLayer] Or even Case statements: Select [AssetID], case when [EditDate] > DATEADD(day,14,convert(date,CreationDate)) then 'Overdue' when [EditDate] <= DATEADD(day,14,convert(date,CreationDate)) then 'OnTime' when [EditDate] is null then 'Open' Else '' end as [CurrentStatus] All of this can be done in an RDBMS such as SQL Server, however it could be useful to have this functionality for organizations that are using AGOL only.
... View more
06-07-2018
05:49 AM
|
5
|
1
|
1078
|
|
POST
|
I just discovered ArcGIS Online Assistant. First I created a new hosted feature layer view in AGOL and set a filter on it. Then I logged into AGOL Assistant and selected "View an Item's JSON" in the "I Want to..." menu. I then selected the new feature layer view and scrolled down to the Data window. I clicked the edit icon at the top of this window and found the layer definition property "layerDefinition". Then I edited the JSON to look like this: "layerDefinition": { "definitionExpression": "EditDate <=DATEADD(day,14,convert(date,CreationDate))", "defaultVisibility": true } And this seems to have worked!
... View more
06-04-2018
09:04 AM
|
0
|
0
|
896
|
|
POST
|
I've got an operations dashboard set up in AGOL. I want to add an indicator to the dashboard that shows the number of records that have EditDate attribute that is within 14 days after the CreationDate attribute. It doesn't seem possible to do a calculation like this in dashboard. I thought maybe I could create a Feature Layer View with a calculated attribute, but it doesn't seem possible. Is there a way to do this?
... View more
06-04-2018
07:01 AM
|
0
|
1
|
1121
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 12-19-2018 11:24 AM | |
| 1 | 01-22-2019 12:58 PM | |
| 1 | 04-13-2018 06:26 AM | |
| 2 | 04-20-2018 12:45 PM | |
| 1 | 05-09-2018 07:10 AM |
Activity Feed
- Got a Kudo for Allow SQL, Calculated Fields for Hosted Feature Layer View. 07-05-2023 09:25 AM
- Got a Kudo for Re: Can not connect to SDE when restored from backup. 04-28-2022 11:49 AM
- Got a Kudo for Re: ArcGIS Pro 2.2.4 Crashing when Adding Folder Connection. 11-11-2020 02:05 AM
- Got a Kudo for Re: Relationship Class in ArcGIS Pro can't add records to related table. 11-11-2020 02:05 AM
- Got a Kudo for Re: Enable Attachments on Hosted Feature Layer in ArcGIS Online Doesn't do anything?. 11-11-2020 02:05 AM
- Got a Kudo for Allow SQL, Calculated Fields for Hosted Feature Layer View. 09-17-2020 06:07 PM
- Got a Kudo for Allow SQL, Calculated Fields for Hosted Feature Layer View. 07-08-2020 06:03 AM
- Got a Kudo for Relationship Class in ArcGIS Pro can't add records to related table. 06-24-2020 08:01 AM
- Got a Kudo for Relationship Class in ArcGIS Pro can't add records to related table. 02-22-2020 06:47 AM
- Got a Kudo for Add domain to existing AGOL hosted feature service resets pop-up in web map. 10-10-2019 10:27 AM
- Posted Re: ArcGIS Pro 2.2.4 Crashing when Adding Folder Connection on ArcGIS Pro Questions. 01-22-2019 12:58 PM
- Posted Re: ArcGIS Pro 2.2.4 Crashing when Adding Folder Connection on ArcGIS Pro Questions. 01-22-2019 12:42 PM
- Posted Re: ArcGIS Pro 2.2.4 Crashing when Adding Folder Connection on ArcGIS Pro Questions. 01-22-2019 09:45 AM
- Posted Re: ArcGIS Pro 2.2.4 Crashing when Adding Folder Connection on ArcGIS Pro Questions. 01-22-2019 09:41 AM
- Posted ArcGIS Pro 2.2.4 Crashing when Adding Folder Connection on ArcGIS Pro Questions. 01-22-2019 09:17 AM
- Tagged ArcGIS Pro 2.2.4 Crashing when Adding Folder Connection on ArcGIS Pro Questions. 01-22-2019 09:17 AM
- Tagged ArcGIS Pro 2.2.4 Crashing when Adding Folder Connection on ArcGIS Pro Questions. 01-22-2019 09:17 AM
- Got a Kudo for Allow SQL, Calculated Fields for Hosted Feature Layer View. 01-02-2019 05:46 PM
- Posted ArcGIS Solutions Deployment Tool Shuts Down Pro on ArcGIS Pro Questions. 12-21-2018 07:03 AM
- Tagged ArcGIS Solutions Deployment Tool Shuts Down Pro on ArcGIS Pro Questions. 12-21-2018 07:03 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
07-09-2024
09:03 PM
|