|
POST
|
We currently have an Enterprise SDE database (Oracle) that houses our GIS data. In the past we have simply created map/feature services off of this and consumed them in the AGOL world. Now we are implementing ArcGIS Enterprise Portal and have an ArcGIS Datastore Setup. We were wondering if it is possible to set something up to pull data out of our Oracle database and put it into the ArcGIS Datastore for consumption, so when these services are being consumed, it is not putting stress on our Enterprise database? These serveices can be Read-only, so we can update them from our Enterprise database periodically. So baiscally: 1. How can we make a copy of our Enterprise database data on ArcGIS Datastore 2. How can we update this data periodically to have a refresh? 3. Is this even a good practice/idea? I have been attempting to export our Enterprise database data in smaller chucks out to File GDBs and then uploading them to the ArcGIS enterprise portal and publishing them, but when I attempt to script the overwrite, i get this error: Perhaps there is a better way of doing this. Thanks.
... View more
11-02-2023
09:44 AM
|
0
|
6
|
2513
|
|
POST
|
Hi @Olwyn_Bruce , I have attached the code here: /*
* JavaScript functions for Survey123
*/
function findCode2(layerURL, userinput, field, token) {
return "OUTVALUE";
}
function findCode(layerURL, userinput, field, token){
// Output value. Initially set to an empty string (XLSForm null)
let outValue = "";
// Check to make sure both layerURL and location are provided
if (layerURL == null || layerURL === "") {
// The function can't go forward; exit with the empty value
}
// Set up query parameters
let f = "f=pjson";
let where = "where=NAME="+"'"+userinput+"'";
let outFields = `outFields=`+field;
let returnGeometry = "returnGeometry=false";
let parameters = [f, where, outFields, returnGeometry].join("&");
if (token) {
parameters = parameters + `&token=${token}`;
}
let url = `${layerURL}/query?${parameters}`;
// return url;
// Create the request object
let xhr = new XMLHttpRequest();
// Make the request. Note the 3rd parameter, which makes this a synchronous request
xhr.open("GET", url, false);
xhr.send();
let mylen = 0
// Process the result
// This an abbreviated version without being able to distinguish different types of errors
if (xhr.status === 200) {
let response = JSON.parse(xhr.responseText);
if (!response.error) {
if (response.features[0]) {
outValue = response.features[0].attributes[field];
mylen = 1
}
}
}
return outValue;
}
... View more
03-01-2023
09:17 AM
|
2
|
1
|
3012
|
|
POST
|
Thanks, this worked great for me. My PY was completing but not exiting and moving on to the next script in the BAT file. Once I added that piece of code at the end, works great.
... View more
01-11-2023
08:22 AM
|
1
|
0
|
2082
|
|
POST
|
I was having the same issue and confirm that the above fix works. Thanks
... View more
11-04-2022
09:12 AM
|
0
|
1
|
923
|
|
POST
|
Hello, just wondering if you have ever found a resolution to this issue? I am having the same problem. Thanks
... View more
05-31-2022
08:11 AM
|
0
|
0
|
1010
|
|
POST
|
@IsmaelChiviteI accomplished this using a piece of javascript and this in the calculation field: pulldata("@javascript","get_globalid.js", "findCode", 'https://services1.arcgis.com/1acZBnEF9zjV0l5X/arcgis/rest/services/Building_Data_Test3/FeatureServer/0', string(${NAME}), 'GlobalID') Thanks for your suggestion!
... View more
02-25-2022
09:02 AM
|
2
|
0
|
3330
|
|
POST
|
Thanks @IsmaelChivite for the quick response. I have never tried the Inbox before. I don't really want to have the user select the building spatially, just from a drop down. Do you have a link to any examples of how this can be done using an existing feature service and related tables?
... View more
02-24-2022
03:41 PM
|
1
|
0
|
3354
|
|
POST
|
Hello, I have an existing feature service that has spatial data (buildings) and an inspections table related to it. I want to collect inspections against them using Survey123. Basically I would like to have a dropdown of all the building names - which would then find the globalid of that building - and populate the foreign key of the inspections so the relationship remains valid. I don't know how to do this in Survey123. I am able to populate my dropdown based on my feature layer using this in the appearance column: autocomplete search("name?url=https://services1.arcgis.com/1acZBnEF9zjV0l5X/arcgis/rest/services/Test/FeatureServer/0") But how do I populate my Foreign Key within the Survey in the related table automatically based on the building selection? Thanks
... View more
02-24-2022
01:47 PM
|
2
|
8
|
3393
|
|
IDEA
|
Thanks for the Push function tip - reduces/simplifies my code!
... View more
01-31-2022
02:18 PM
|
0
|
0
|
2336
|
|
POST
|
This is great, i have been struggling with this for over a day. Thanks for the help.
... View more
12-29-2021
03:07 PM
|
0
|
0
|
7015
|
|
IDEA
|
This option would be very useful for me as well - I want my users to select a polygon - instead of drawing one or a placing a point and doing post processing. Does anyone know if this is possible?
... View more
03-22-2021
02:13 PM
|
0
|
0
|
3833
|
|
POST
|
@NataleeDesotell did you ever find a solution to this? I am being asked something similar. Thanks Darryl
... View more
02-18-2021
10:42 AM
|
0
|
0
|
1807
|
|
POST
|
Can you post the code you used to do this "easier" method? Thanks
... View more
01-29-2021
10:41 AM
|
0
|
0
|
6641
|
|
IDEA
|
I also would like to see this implemented. Does anyone at ESRI know if this is in the plans for future releases of Dashboards? Currently I am running a daily script on our server to update a AGOL stand alone table that has just 1 record and 1 column holding the current date. This seems like overkill for something so basic.
... View more
01-11-2021
01:56 PM
|
0
|
0
|
2187
|
|
BLOG
|
Thanks so much for this method to look into someone else's dashboard - Works great!
... View more
12-23-2020
09:37 AM
|
0
|
0
|
33246
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-11-2019 11:04 AM | |
| 2 | 03-15-2024 09:49 AM | |
| 1 | 02-16-2024 02:12 PM | |
| 1 | 11-28-2023 12:32 PM | |
| 1 | 11-27-2023 11:50 AM |
| Online Status |
Offline
|
| Date Last Visited |
4 weeks ago
|