POST
|
Setting up the Directions widget in Web App Builder on AGOL, after setting my enterprise location for travel modes, the drop down doesn't show up in the application. This widget works in our portal environment and displays the travel modes dropdown. I've read a few things about needing to download the application, modify the widget.js file and then host locally. This seems like a bit of a stretch just to get something that should already work, to work. I have the image below of the configurations settings. Could someone let me know if I have just put in the wrong URL or if something else is going on here. Once configured with the travel modes url, the travel modes dropdown does not appear.
... View more
04-23-2020
02:42 PM
|
0
|
0
|
923
|
POST
|
Thank you for the reply Melissa. What we do for some of our services is create a view pulling data from multiple databases/tables etc.. register it with our sde database and then publish that out as a service. For example: we have street gis features. In our asset management software we have records of work performed, inspections, etc... instead of requiring people to perform processing or maintain joins, we create views. In that example it may be how many times have we fixed potholes on a street segment in the last 2 years and when did we last do it. With a view, this is always accurate to the data in both systems and available to everyone in our city via our internal portal. I hope that makes sense.
... View more
11-08-2019
01:26 PM
|
3
|
0
|
5055
|
POST
|
We are exploring the viability of using branch versioning. Our organization utilizes SQL views for much of what we serve out to our portal as enrichment services. Looking over the structure of how the branch versioned tables are built, it appears we won't be able to call just a generic select statement to pull data from the base table, but will have to incorporate some heftier sql just to get the correct rows to return. Is this something that has been addressed and I've just missed it? Or does ESRI have a sample of the code needed to pull the current state of features in the default version? We'd love to explore branch versioning, but if it removes support for database views (or over complicates them), it would be a real buzzkill.
... View more
10-11-2019
06:10 AM
|
4
|
9
|
5487
|
POST
|
Don, You are correct. I know several months ago when I published a service from Pro, the Cityworks SOE was showing up for me when I checked the service in server. Now when I look at a recently published service from Pro, I do not see the option any more. We are running server 10.6.1 and Pro 2.3.2
... View more
05-07-2019
05:34 AM
|
2
|
6
|
3373
|
POST
|
When I publish a layer through Pro, I notice the Cityworks SOE is now an option in my server environment. I have yet to test it though, but it does show up for me. You'll have to turn it on in Server, as it isn't an option to turn on in Pro when publishing.
... View more
03-22-2019
05:15 PM
|
0
|
8
|
3373
|
POST
|
The site worked when visiting through https. Thank You and the team for their hard work on this! Quick question, we will be doing a major push on our open data initiative and I am about halfway done building the site. When we push this live, it will also have a custom domain. Are any new sites automatically getting a cert or should we work with esri to make sure it happens?
... View more
01-23-2019
06:32 PM
|
0
|
1
|
1509
|
POST
|
I have multiple query layers and SQL spatial views in our environment which we serve out to our Enterprise Server. All of them work fine except for one. In it, I am specifying a derived field as Days Since Issued. I use this same function in other views and it works correctly. However, in this one particular service, it seems it is treating the DATEDIFF(DAY, issued,GETDATE()) as a static field. Meaning, the day I serve out the service, that day is saved and the field isn't updated beyond that day. (so what was 1 day from being issued on the day I served it out to our enterprise server remains 1 day no matter how long ago it was). The views are registered with the Enterprise database (10.6.1) and appear correctly in ArcMap and in ArcPro. I'll provide example code /*First Query that doesn't work as expected when a service*/
SELECT cast(ROW_NUMBER() OVER (ORDER BY a.case_number) AS int) AS OBJECTID
,a.case_number, a.case_name, a.location, c.case_status, b.case_type
,b.case_type_desc, a.date_entered, a.date_issued, a.date_expiration
,iif(a.date_issued IS NULL, NULL, DATEDIFF(DAY, a.date_issued, GETDATE())) AS daysSinceIssued
,geometry::Point(a.cx, a.cy, 3419) AS shape
FROM ...Table1 a LEFT JOIN
...Table2 b ON a.case_type_id = b.case_type_id LEFT JOIN
...Table3 c ON a.case_status_id = c.case_status_id
WHERE b.case_type LIKE 'BLDC%' AND a.cx > 1800000
/*Second Query that does work as expected when a service*/
SELECT CAST(ROW_NUMBER() OVER (ORDER BY requestid ASC) AS int) AS OBJECTID
,requestid, problemcode, description, details, priority, probaddress
,reqcategory, submitto, datetimeinit, datetimeclosed, PRJCOMPLETEDATE, status
,iif(status IN ('CLOSED', 'COMPLETE'), CASE WHEN isnull(datetimeclosed,
GETDATE()) < isnull(prjcompletedate, GETDATE()) THEN datetimeclosed ELSE prjcompletedate END, NULL) AS dateclosed
,DATEDIFF(DAY, datetimeinit, GETDATE()) AS daysSinceRequest
,iif(datetimeclosed IS NULL, NULL, datediff(day, datetimeinit, datetimeclosed)) AS daysToClose
,geometry::Point([srx], [sry], 3419) AS shape
FROM ...Table1
WHERE [initiatedby] = '#############' AND [srx] > 1800000 Excerpt from above where I'm seeing a difference /*This acts as a static field which is not how I would expect*/
iif(a.date_issued IS NULL, NULL, DATEDIFF(DAY, a.date_issued, GETDATE())) AS daysSinceIssued
/*This acts how I would expect as a dynamic field and keeps the values up to date*/
DATEDIFF(DAY, datetimeinit, GETDATE()) AS daysSinceRequest results as a service: This query correctly updates the daysSinceRequest field (today's date 9/24/2018) This query does not correctly update the daysSinceIssued field (today's date 9/24/2018) Any thoughts or ideas are appreciated. I've pushed out a fresh copy of the service that doesn't work to see if it will update correctly by chance there is just an underlying issue with the current service that isn't being fixed when overwriting it. My only other thought is is could be with what I'm creating the objectid on. I know requestid's are created with the next available sequential number. While case_number is unique, I can't guarantee they are sequential when added. Maybe the rearranging of objectid's is causing the issue if that is indeed occurring. Yet there hasn't been a new issued case since this has been served out and still isn't updating.
... View more
09-24-2018
06:50 AM
|
0
|
0
|
644
|
POST
|
I could be doing something wrong, but for our dev site, I set up the html and css in a text editor, make sure everything works, and then copy over to the HUB site to test. Any .svg I attempt to use with the <svg> tag doesn't seem to work when copied over to the hub text editor. Are these just not supported yet? and if not, are they currently on the horizon for support?
... View more
07-03-2018
12:08 PM
|
0
|
3
|
879
|
POST
|
A Question on ArcGIS Hub / Open Data. Is there a timeframe for supporting https on custom domains? If not, is there currently a workaround that can be applied (requesting a new ssl, etc..) to ensure https traffic has no issue accessing the custom domain?
... View more
06-08-2018
06:50 AM
|
0
|
35
|
6923
|
POST
|
So I was running into similar problems and will give a rundown of my findings. In my case, we have capitol improvement points and lines on a map. I am creating a dashboard to filter by year, type, status, etc using the widgets instead of selectors. I needed a table with all the records to supply data to the widgets/metrics from both points and lines. The fields in the points and lines match, so I created a sql view to union the points and lines into a table, then created a new objectid from the globalid’s. Then registered the view with the geodatabase. Quasi code below select c.*, cast(ROW_NUMBER() OVER(ORDER by c.globalid) as int) As objectid from (points union lines) c this gave me the table I needed for the metrics. When using it in the dashboard I could create metrics, but as another poster mentioned, I could not use widgets using data from the table to control layers on the map even though the fields matched 1 to 1. Conversely, I could use layer selections on the map to filter the widgets created by the standalone table. So it works in one direction, but not both. With that attempt thwarted, I decided to go the sql spatial route. I got the x,y from the points, then created an x,y from the lines based on the nearest point on a line to the centroid of the feature extent.(dealing with multiple line segments per feature). With the x,y’s, I updated the view to a spatial view of points. Same code as above, adding in the logic to pull x,y’s from both tables, then geometry::point(x,y,srid) as shape after the row_number function. In this attempt I could see the points, see the attribute table, etc..., in the map. But when trying to create a metric with the service, I got the cannot acces data icon. Same sharing as before. third attempt, create the table view as before only adding in the x,y’s as fields. Then create a query layer in pro and generate the points in the query layer instead of the view. I used the globalid as my uniqueid in the query layer spatial properties window which then generates your esri_oid. Same issue as above when trying to create metrics only this time it said cannot access data of 1038 records(number of records in my query layer). Or something similar. Still didn’t work, but an error at least giving me the count of records in the layer. (I’ll note that even though it says it can’t access the data, if you select a drop down to select fields for statistics, etc, all the fields from the layers populate). Progress. final attempt. for some reason, I was stuck on objectid being the issue. I was using globalid in the spatial properties window of the query layer dialog as my unique Id because it defaults to that. But I had also created a new objectid in the union view, so it was also unique. I used objectid as my unique Id in the spatial properties window and created the query layer. This time, the query layer created, but did not create an esri_oid field and instead made my objectid field the unique Id field with the field type objectid instead of integer. Plugged this layer into the dashboard and everything worked flawlessly. Success. now, I didn’t go any further down the rabbit hole to test why it wasn’t working before. Did it need a field called objectid to be the unique identifier? Did the fact I had objectid as an integer field in my query layer throw everything off because it wasn’t the designated unique field? I’m guessing one or both of those 2 is the problem but I didn’t test. Notes:: as stated above. Creating widgets from standalone tables and then trying to filter map layers by those tables didn’t give an action option for the map layers. now, I still have my cip polylines. I’ve created a centroid point for them, but still want to show the associated lines when I select a point on the map.(using globalid as my connection between the 2 layers). I can filter just the lines I want when I select a point. But, when I don’t have a point selected, all the lines show up and I can’t control them with the widgets either since they were created using the points query layer. The question I have is. Is there a way to default a layer to filter out all the features and only show a feature after an action. In my case, I select a point on the map and the lines associated with that point show up. If no points are selected, all the lines are “hidden”. If not, is this functionality on the radar for dashboards? sorry for the extremely long winded response. I was hoping to give users a workaround or ideas as to why the query layers may not be working as well as provide enough information for debugging purposes.
... View more
05-27-2018
06:51 PM
|
4
|
3
|
2003
|
POST
|
Thank you for the update. Our field staff will be happy to see it fixed as they use that functionality a lot.
... View more
04-16-2018
06:36 AM
|
0
|
0
|
667
|
POST
|
We have the same issue. When our iPad’s updated collector to the latest version, tapping the magnifying glass crashes the app. It does not matter what map is loaded(one of ours or an esri web map), it happens as well whether the user is connected to our portal or to agol.
... View more
03-31-2018
09:05 AM
|
0
|
3
|
667
|
POST
|
Yeah, running Fiddler, but I don't really know what all the messages mean. Connecting PRO through the portal managed logins doesn't spit out any errors. When trying to connect through the adfs login: 1: /portal/sharing/rest/oauth2/saml/authorize HTTP/1.1 302 Found 2: Tunnel to adfs server HTTP/1.0 200 Connection Established 3: adfs server: /adfs/ls/?SAMLRequest=blahblahblah HTTP/1.1 302 Found *Errors start 4: adfs server: /adfs/ls/wia?SAMLRequest=blahblahblah HTTP/1.1 401 Unauthorized 5: adfs server: /adfs/ls/wia?SAMLRequest=blahblahblah HTTP/1.1 401 Unauthorized 6: adfs server: /adfs/ls/wia?SAMLRequest=blahblahblah HTTP/1.1 400 Bad Request
... View more
01-25-2018
12:02 PM
|
0
|
1
|
998
|
Title | Kudos | Posted |
---|---|---|
3 | 11-08-2019 01:26 PM | |
4 | 10-11-2019 06:10 AM | |
2 | 12-28-2017 11:29 AM | |
2 | 05-07-2019 05:34 AM | |
4 | 05-27-2018 06:51 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|