topic Append extracted data to SDE (Collector for ArcGIS Workaround) in ArcGIS Collector Questions

Append extracted data to SDE (Collector for ArcGIS Workaround)

JacquelineKovarik — Thu, 12 Nov 2015 16:54:02 GMT

Hello,

I have been unable to synchronize collected data in one of my Collector apps (I believe this might be due to the number of attachments). I've tried all suggestions in this forum, and now have manually extracted and converted my collected data into a File Geodatabase.

I'm wondering how to go about "merging" this file geodatabase into my SDE geodatabase on our GIS Server, while maintaining the Global IDs and related attachments I've configured.

Has anyone been through this process? If so, could you provide some info on how you did it?

Thank you!

Jacqueline

Re: Append extracted data to SDE (Collector for ArcGIS Workaround)

danbecker — Thu, 12 Nov 2015 17:35:40 GMT

Here are instructions I wrote for myself a few months ago. A few of the steps regarding new feature class you can omit because you already have a "new feat class" which is your original SDE gdb. Rem. to add field, as specified in step 2.

HOW TO MOVE FEATURE ATTACHMENTS FROM 1 GDB TO ANOTHER

1. create new geodatabase

2. create new feat. class in new geodatabase

-geometry has to be the same as the source feature class that has feat. attachments

-for fields, use the import button and specify source feature class

-add additional field name: alias_GID type: text, length: 150

3. enable attachments on new feature class

4. append source feature class to new feature class

-NO TEST

-add field source.GlobalID to target.alias_GID

5. create new field in new feature attachment table named "REL_alias_GID" type: text, length: 150

5. append source feature attachment table to new feature attachment table

7. field calculate new feature attachment table REL_alias_GID to [REL_GLOBALID]

8. join new feature class.alias_GID .. TO .. new feature attachment table.REL_alias_GID

left table is new feature attachment table

right table is new feature class

9. field calculate new feature attachment table REL_GLOBALID to new feature class.GLOBALID

Re: Append extracted data to SDE (Collector for ArcGIS Workaround)

JacquelineKovarik — Thu, 12 Nov 2015 19:47:28 GMT

Hi Dan,

Thanks for the quick reply! I stumbled upon this amazing Python script this afternoon that did exactly what I was looking for:

bnadler/Append-Features-With-Attachments · GitHub

It saved me hours of work, and I hope it does the same for others looking for an easier solution!

Thanks,

Jacqueline

Re: Append extracted data to SDE (Collector for ArcGIS Workaround)

CraigPrisland2 — Fri, 21 Jul 2017 20:26:28 GMT

Hi Dan,

Thanks for the instructions. I just had one quick question. In your last step you mention to field calculate the GlobalID field. I cannot figure out how you did this. Since this is a GlobalID field type, the Field Calculate option is grayed out. Am I missing something? Thanks in advance!

Craig

Re: Append extracted data to SDE (Collector for ArcGIS Workaround)

Anonymous User — Thu, 13 Sep 2018 22:32:26 GMT

Hi Jacqueline,

I have a same issue. I want to transfer my FGDB with Collector attachments to SDE without losing attachments. I tried to run this script but I am getting an error. I just changed the updateFeatureClass & targetFeatureClass parameters in the entire script

def main():
updateFeatureClass = r'\\central\gis\development\slm_pj\PJ\OSC_SurveyData_Final.gdb\osc_lito'
targetFeatureClass = r'Database Connections\GISDATA@gdbmaint@stgisgdb1.sde\gdbmaint.GISDATA.OSCTest\gdbmaint.GISDATA.osc_lito'

Error:

File "U:\PJ\SLM\Codes\Append-Features-With-Attachments-master\AppendFeaturesWithAttachments.py", line 74, in appendFeatures
editor= arcpy.da.Editor(desc.path)
RuntimeError: cannot open workspace

Any idea what should I do to run it successfully?

Thanks in Advance.