Latest Contributions by TL2

‎07-12-2017

I am trying to convert the attachment tables DATA tab (BLOB/VARBINARY) into Base64. USE UTILITIES SELECT CAST(CAST('' as XML).value('xs:base64Binary(sql:column("DATA"))', 'VARBINARY(MAX)') AS NVARCHAR(MAX)) FROM FeatureClass_ATTACH_evw WHERE REL_OBJECTID = '51' go Results: "�က䙊䙉Ā ĀĀ" Is there a way to convert the BLOB into Base64?

‎07-11-2017

Republishing a survey with Survey123 Connect after just updating some Coded Domain Values does update the options within the survey but does not update the domains in the HFS. How can I update the domains in the hosted feature service without loosing my data. When I access the Admin Rest endpoint it gives me the option to Update Definition but there is nothing to edit, the Input is blank. Portal Federated with Server 10.4.1

‎07-11-2017

I am seeing the latest update in AppStudio for Survey123 and Connect were on 6/18. Can the new 2.2 version be added soon please. Thanks.

‎06-23-2017

James Tedrick‌ I have been trying to set up a survey which is tied to a federated service with a repeat and attachments on both the FS and Table. I am receiving the error below when attempting to publish even though both of my services are set to Supports ApplyEdits With Global Ids: true. My FS - ID: 0 in service MXD. Global Ids enabled, attachments enabled (based on GIDS), editor tracking enabled, archiving enabled, indexed on globalid field (unique: yes, ascending: yes) Supports ApplyEdits With Global Ids: true at rest end point. My Table - ID: 1 in service MXD. Global Ids enabled, attachments enabled (based on GIDS), editor tracking enabled, archiving enabled, indexed on globalid field (unique: yes, ascending: yes) Supports ApplyEdits With Global Ids: true at rest end point. My FS and Table relationship: Simple, 1-M, No Notifications, Origin is FS, Dest. is Table based, primary key: GlobalID, foreign key: parentrowid I have created my survey and published it to the portal as a HFS. I then export as file geodatabase and import the feature layer and table into my sde and create attachments etc and relationships. Scenario 1 I publish an mxd with the IDs noted above. When I add the item description URL to my survey and delete the .itemINFO file I recieve the following error... I have verified that both my FS and Table both have Supports ApplyEdits With Global Ids: true. Scenario 2 When I create a new survey based on the Feature Service option within Survey123 and select the same feature service as above I receive the same error as above. In Scenario 2 it sets my attachments to false (probably because those image fields to not get carried through the feature layer. Should I be able to use a feature service with a related table federated with portal in a survey?? UPDATE: I changed my feature-table relationship to GlobalID and parentrowid (guid) and that fixed one error.

‎06-13-2017

I was able to use the submission url successfully. Archiving must be enabled. (add attribute index geoprocessing tool did not work, maybe I did that wrong) Also, the submission url formatting IS https://domain.com/arcgis//sharing/rest/content/items/xxxxxxxxxPortal Item IDxxxxxxxxxx IS NOT https://domain.com/arcgis/home/item.html?id=xxxxxxxxxPortal Item IDxxxxxxxxxx

‎06-09-2017

I would like more detail/documentation on publishing surveys with services federated with my portal and server. What are the requirements for the published feature service? I would like to take an existing survey, add the rest end point to the submission url and publish. Currently I am getting this error. My work flow: 1. Publish my survey to ArcGIS Portal 10.4.1. 2. Export my HFS as FG. 3. Create Service MXD with feature class from exported FG. (enabled attachments after adding globalids. Ran 'add attribute index geoprocessing tool') 4. Copy Survey, insert rest end point of federated feature service. (update form_id to that of the layer from service) 5. Receive Error. Alternatively: 1. Using the same federated feature service. 2. In Connect adding a new survey. 3. It creates the new survey with the correct schema but the submission URL is not the rest endpoint, its a feature service item description url. 4. Also when publishing I receive the same error as above.

‎06-05-2017

Gary, GeoEvent can be VERY frustrating. The properties look correct. I troubleshoot by recreating the inputs, reimporting the layer definition, deleting and recreating the service & checking logs to make sure connections are working.

‎05-17-2017

Can you use another field as the Where field instead of ObjectID when updating a feature?

‎05-16-2017

I have two feature classes, both have the same Track_ID, field Zone. I would like to monitor the input of feature class #1. When there is a new entry, its updates a field in feature class #2 based on the field Zone (where Zone = Zone) I cant figure out how to accomplish this and where to use the wehre clause and which service definition to use. My input works fine so far, but not my service or output. Thanks!

‎05-03-2017

ArcGIS Pro maintains attachments with append.

‎05-03-2017

I would like to copy data from one hosted feature service to another and maintain attachments. Creating a local copy in arcmap does not seem to hold attachments. Any suggestions? Thanks.

‎05-02-2017

Thanks James...

‎05-02-2017

When I open a new Survey123 Connect App in AppStudio it says version 1.0.1. Below that it askes me if I would like to upgrade to version 2.0. As expected, when I select Update to version 2.0 it brings me to the Survey123 Connect downloads page ( I would think this link would not be there if this was already version 2.0). I would like to confirm that the Survey123 Connect is version 2.0 in AppStudio. Is there something in the code that would tell me? AppStudio would have you believe that it is infact version 2.0, however, it is not clear. Thanks.

‎04-27-2017

Thanks for getting the code to AppStudio so quick! Also, 2.0 seems to have fixed Bug BUG-000103903....THANKS!

‎04-25-2017

I was eventually able to add the fields I needed, however, now I run into this issue... I am experiencing trouble adding a field to multiple Hosted feature services in our HA environment using this method - http://support.esri.com/technical-article/000012167. I am able to use the method above in our non HA environments but not in our HA. The HA server machines seem to not sync properly as when I refresh the rest end point, the added fields toggle on/off. - WEBPAGE REFRESH RESULTS --> ArcGIS 10.4.1 Server Federated with Portal in a HA Cluster. Thanks.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by TL2

Convert VARBINARY (BLOB) to Base64 String using T-SQL

How to update coded values of HFS published with Survey123 without overwriting service?

Re: Sailing Around the World Release (2.2)

Re: Survey 123 & Federated Services: Clarification

Re: Survey 123 & Federated Services: Clarification

Survey 123 & Federated Services: Clarification

Re: GeoEvent Field Calculator to overwrite field.

Re: Can "update a feature - feature service" output connector updating some fields and leave others unchanged?

Use GeoEvent to update one feature class based on entry from another.

Re: How to copy features w/ attachments from one hosted feature service to another?

How to copy features w/ attachments from one hosted feature service to another?

Re: Is Survey123 Connect Version 2.0 in AppStudio? Please Confirm.

Is Survey123 Connect Version 2.0 in AppStudio? Please Confirm.

Re: Chernobyl Remembrance Day Release (2.0)

Re: Error Adding Field to HFS in HA Cluster (Portal)

Re: Field Maps, Minimum file count still required ...

Re: ⚠️ Authentication Issue with ArcGIS Connector ...

Re: ⚠️ Authentication Issue with ArcGIS Connector ...

Re: ⚠️ Authentication Issue with ArcGIS Connector ...

Re: ⚠️ Authentication Issue with ArcGIS Connector ...