Latest Contributions by PeterDalrymple

Thank's so much Xander! That makes perfect sense now. I very much appreciate your time and patience! ... View more

Done! Perishable Data Collection is what you're looking for. Thanks again! ... View more

Absolutely. What is the best way to do that? I searched for you to invite to the group, but couldn't find you. ... View more

Thanks Xander. Does this work? ... View more

Unfortunately it didn't like it.... Results: Execution Error:Invalid Parameters for Count Messages: Use Console Function to output messages. Thanks! ... View more

Thanks for the reply. This is what I get in the messages when I add the Console(Count(tbl)); line. And without it... The expression tests without error when using var tbl = FeatureSetByName($map,"Bridge_Observations"); or var tbl = FeatureSetById($datastore, /* Bridge_Observations */ "1"); but neither produces a result in the pop-up.  The Bridge_Observations (w/o quotes) does exist within the same service as the current layer. However, the map seems to strip the underscore from the table in the Content tab of my map.  vs.  Not sure if that would cause the issue. When I write my expression with the space instead of the underscore, I get a parse error on line 12. I also tried renaming to BridgeObservations, but still no joy. Here is the current expression: var tbl = FeatureSetByName($map,"Bridge_Observations"); Console(Count(tbl)); var siteid = $feature["LOCATION_ID"]; var sql = "LOCATION_ID = '" + siteid + "'"; Console(sql); var visits = Filter(tbl, sql); var cnt = Count(visits); var history = ""; if (cnt > 0) { history = cnt + "Recent Observations:"; for (var visit in visits) { var txt_date = Text(Bridge_Observations.DATE_TIME, ' - (Y/MM/DD) '); history += TextFormatting.NewLine + txt_date; } } else { history = "No Recent Observations"; } return history; Thanks again for your help! ... View more

Thanks Xander! Here is the expression: var tbl = FeatureSetById($datastore, /* Bridge_Observations */ "1"); var siteid = $feature["LOCATION_ID"]; var sql = "LOCATION_ID = '" + siteid + "'"; Console(sql); var visits = Filter(tbl, sql); var cnt = Count(visits); var history = ""; if (cnt > 0) { history = cnt + "Recent Observations:"; for (var visit in visits) { var txt_date = Text(Bridge_Observations.DATE_TIME, ' - (Y/MM/DD) '); history += TextFormatting.NewLine + txt_date; } } else { history = "No Recent Observations"; } return history; "Bridge_Observations" is the table of inspections that is related to feature layer for which I am adding the expression. LOCATION_ID is the key field. ... View more

This is great! Assuming I'm adapting the script correctly (no errors were thrown), I cannot get the result to show in the pop-up when adding the attribute expression. Is there a trick with the custom html you reference above to get this to display in the pop-up? Thanks! ... View more

Hi James, Can you expand any further on how to add this question type? I've added the 'file' type in the Field Types section of the 'types' worksheet and included a question of that type in my survey worksheet. However, when I convert the XLS, I am not seeing the same result in Survey123 Connect as Treg shows below. Thanks, Peter ... View more

Hi James. See below for log file text: <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Logging started: 2018-05-25T12:54:47 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Application Name: Survey123ConnectforArcGIS <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Application Version: 2.8.4 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Application File Path: C:/Users/pdalrymple/Applications/ArcGIS/Survey123ConnectforArcGIS/Survey123ConnectforArcGIS.exe <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Application Directory Path: C:/Users/pdalrymple/Applications/ArcGIS/Survey123ConnectforArcGIS <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ AppFramework Version: 2.1.22 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Qt Version: 5.9.1 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Operating System: Windows 7 SP 1 (6.1) <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Operating System Type: windows <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Operating System Version: 7sp1 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Kernel Type: winnt <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Kernel Version: 6.1.7601 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Build ABI: i386-little_endian-ilp32 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Current CPU Architecture: x86_64 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Build CPU Architecture: i386 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ SSL Library Version: OpenSSL 1.0.2n 7 Dec 2017 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Host name: DSK-069734 <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Domain name: cityofsalem.net <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Default locale: en_US <14>1 2018-05-25T19:54:47Z DSK-069734 Survey123ConnectforArcGIS 6048 - - $ Release Type: store <15>1 2018-05-25T19:55:05Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="expression for onStateChanged" filename="Portal.qml" line="192"] qml: Application state changed: 2 <15>1 2018-05-25T19:55:09Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="expression for onStateChanged" filename="Portal.qml" line="192"] qml: Application state changed: 4 <15>1 2018-05-25T19:55:09Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="reset" filename="Portal.qml" line="597"] qml: Token expiry timer not restarted <15>1 2018-05-25T19:55:14Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="write" filename="Config.qml" line="64"] qml: Saving Configuration <15>1 2018-05-25T19:55:14Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="write" filename="Config.qml" line="66"] qml: apiUrl https://survey123.arcgis.com/api <15>1 2018-05-25T19:55:14Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="write" filename="Config.qml" line="67"] qml: ignoreSslErrors false <15>1 2018-05-25T19:55:16Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="ArcGIS.AppFramework.File"] ArcGIS.AppFramework.File: __thiscall ZipReader::ZipReader(class QObject *) <15>1 2018-05-25T19:55:16Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="ArcGIS.AppFramework.File"] ArcGIS.AppFramework.File: __thiscall ZipReader::ZipReader(class QObject *) <15>1 2018-05-25T19:55:16Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="ArcGIS.AppFramework.File"] ArcGIS.AppFramework.File: __thiscall ZipWriter::ZipWriter(class QObject *) <15>1 2018-05-25T19:55:16Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="onCompleted" filename="XLSFormTemplate.qml" line="44"] qml: Copying XLSForm template: :/qml/Connect/XLSFormTemplate.xlsx to: C:/Users/pdalrymple/AppData/Local/Temp/XLSFormTemplate.xlsx <15>1 2018-05-25T19:55:16Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="onCompleted" filename="XLSFormTemplate.qml" line="52"] qml: Removed existing XLSForm template: C:/Users/pdalrymple/AppData/Local/Temp/XLSFormTemplate.xlsx <15>1 2018-05-25T19:55:16Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="onCompleted" filename="XLSFormTemplate.qml" line="61"] qml: XLSForm template: C:/Users/pdalrymple/AppData/Local/Temp/XLSFormTemplate.xlsx isWritable: true <15>1 2018-05-25T19:55:16Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="startQuery" filename="NewSurveyDialog.qml" line="253"] qml: Form query: orgid:jMCHJcLe13FaKCFB AND ((type:"Microsoft Excel" AND tags:"XLSForm") OR (type:"Form" AND NOT tags:"noxlsform")) AND tags:"Template" <15>1 2018-05-25T19:55:17Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="onSearchCompleted" filename="PortalSearchModel.qml" line="86"] qml: Search completed: 2 item(s) <15>1 2018-05-25T19:55:17Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="update" filename="FilteredListModel.qml" line="62"] qml: Empty filterText <15>1 2018-05-25T19:55:24Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="downloadXlsForm" filename="NewSurveyDialog.qml" line="895"] qml: Download 969cc774b46044a596610dd3998fbcc5 Advanced <15>1 2018-05-25T19:55:24Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="ArcGIS.AppFramework.Network"] ArcGIS.AppFramework.Network: void __thiscall NetworkRequest::onFinished(class QNetworkReply *) url: QUrl("https://www.arcgis.com/sharing/rest/content/items/969cc774b46044a596610dd3998fbcc5/data?") <15>1 2018-05-25T19:55:24Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="ArcGIS.AppFramework.Network"] ArcGIS.AppFramework.Network: void __thiscall NetworkRequest::onFinished(class QNetworkReply *) redirectUrl: QUrl("https://ago-item-storage.s3-external-1.amazonaws.com/969cc774b46044a596610dd3998fbcc5/Template.xlsx?X-Amz-Security-Token=FQoDYXdzEHwaDPaCxXp%2BG5DY7uTQ8CK3A%2B23xR3nSVgkK%2FTfRlAw4Amdo%2B37%2Fx%2BoG3LjxXe3Ig7HLhWmWC6zTBvlz4gy6kiDYss19wE66a2LZafxBPNeQm42GjxY%2FuFr8Vse2gedE8LHhpxcuD4YKZggRElkX1U6qMSVE7fZ62z3aCCZgBzpkydxu9YESOYMGoWe60f0S%2FjxYABUm8kq62WSypwfaCqNzCVkYY71xoLydtzWqfrecowJ%2F2iynfNKzOU8g0sSK7gebfrzd2sIJWCkNesb0pgBlrJFbhVhjCAN4Fz%2FyeH4dEIteZ%2F47r0Ws64T0YAtCAt7rGpP%2F0ONpVW%2BZXicQLK58yeWy5wSPi06%2B5YXt9hDFJ%2BkoFQrXuDJbkWRIN6hQAUGu86QHAAEXGsHXHmhSa6VzqU7Y%2BY%2BeYu5Y%2FFueDepNh6c6BZQgqY1oS2SOXsmcOGz7XpJk7c7CgeIbRcZWiawFIgtIfV1%2ByyvMN4f1kWKPjEvryB1XKfWggXeWJ1Os6EzpO2xgoDcE0MQkzgvL%2BX8BuVUc%2BTWO%2B4ICkLnQydSpFI%2FaadOAkn8KzvTZXaGN6tYH0se2PXn9QcF5ta4HjBzBgsFHl1uUSYopbGh2AU%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20180525T195524Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAJLJ2C4ROIBNRYIKQ%2F20180525%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=15fbdeaa96dbda0eb0e82479719f7b98ffb62435bee9a7b26e1cef39a890857f") <15>1 2018-05-25T19:55:25Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="onDownloaded" filename="NewSurveyDialog.qml" line="856"] qml: XLSForm downloaded: C:/Users/pdalrymple/AppData/Local/Temp/Template.xlsx <15>1 2018-05-25T19:55:26Z DSK-069734 Survey123ConnectforArcGIS 6048 - [AppStudio@11205 category="qml" function="onItemInfoChanged" filename="NewSurveyDialog.qml" line="870"] qml: XLSForm itemInfo: { "access": "public", "accessInformation": null, "appCategories": [], "avgRating": 0, "banner": null, "categories": [], "commentsEnabled": true, "created": 1458621984000, "culture": "en-us", ... View more

Hi James, Thanks for the quick response. I am still experiencing the same issue. I went to the link you provided. Below is the text. Survey123 API: 2.8.0  Build info: 2.8.69 Survey123 API build date: 2018-05-22T19:55:00.388Z ... View more

Hi Jake, I ran this tool on a number of hosted feature layers and it worked great! However, these feature layers are continually being updated by field crews using Collector and it appears as though the attachment path gets broken as soon as another user adds/edits geometry/attributes in those feature layers with attachments. This seems to break the photo path for all records in the feature layer. In looking at the paths, it seems like the token gets changed for all attachments in the feature layer ("8?token=iSfCjwRyNOfrk-I......" vs "8?token=fsWapS3kGkwPwVz....."). Any way to avoid this? Thanks! ... View more

Hi and thanks for the response, I am not able to upgrade higher than 10.2.2.3552 at this point. Uninstall/re-install did not change the performance of the tool initially until I went through all remaining ArcGIS Program files and deleted any remaining scripts (i.e. ArcHydro and some Batch Edit String Fields scripts). Reinstalling the software at that point fixed the issue. Hard for me to say why or how that fixed the issue, but the Geotagged Photos to Points tool now functions without error. To provide more detail regarding the approach I was using: Input folder: A desktop folder with six geotagged photos (all photos were properly geotagged) Output Feature Class: Tried using an empty file geodatabase and my default geodatabase both into a Feature Dataset as well as directly into the geodatabase. Output to a shapefile was not an option as indicated elsewhere on the web; maybe this was an option in earlier versions. Optionals: Tried naming an invalid photos table and leaving it blank as well as running the tool with both check boxes checked and unchecked. No combination of these optionals changed the performance. Let me know if you have any other questions. Thanks! Pete >>> Adrian Welsh <[email protected]> 4/24/2016 3:23 PM >>> GeoNet ( https://community.esri.com/?et=watches.email.thread) GeoTagged Photos to Points ERROR 999999 reply from Adrian Welsh ( https://community.esri.com/people/MidnightYell2003?et=watches.email.thread) in Managing Data - View the full discussion ( https://community.esri.com/message/604175?et=watches.email.thread#comment-604175) Pete, Dan listed a pretty comprehensive bug list. From glancing at the list, it does not appear to still be an issue in 10.4. Do you have a way to upgrade to 10.4 (or maybe even 10.3.1 to see if it is still an issue)? Can you also give a more detailed approach to what you are trying to do? Reply to this message by replying to this email, or go to the message on GeoNet ( https://community.esri.com/message/604175?et=watches.email.thread#comment-604175) Start a new discussion in Managing Data by email ( mailto:[email protected]) or at GeoNet ( https://community.esri.com/choose-container.jspa?contentType=1&containerType=14&container=2050&et=watches.email.thread) Following GeoTagged Photos to Points ERROR 999999 ( https://community.esri.com/message/604175?et=watches.email.thread#comment-604175) in these streams: Inbox This email was sent by GeoNet because you are a registered user. You may unsubscribe ( https://community.esri.com/unsubscribe.jspa?email=pdalrymple%40cityofsalem.net&token=5d9694a55b475d55b31629ab24fdd01845dc556c8c7588d0fe3962b1328a9e0e) instantly from GeoNet, or adjust email frequency in your email preferences ( https://community.esri.com/user-preferences!input.jspa) ... View more