... So in my attempts to navigate the ESRI, ARCGIS website to post a question... it has led me to this point... so... hopefully this would be the place to ask a simple question.... I feel lost and confused...
I have attachment data posted in ArcGIS online, but due to a misunderstanding of the MAX TABLE RETURN when publishing content, i'm limited to downloading 1000 records...... So one path i'm looking into in order to get to my data down and republish... i will need to download it in 1000 feature chunks using "Create local copy for editing". (Note that i have over 9000 points and 4 GB worth of attachment data... up in the cloud)
So now i have 8 databases, each with an attachment table, identical schema and assumed global IDs that were generated when publishing to AGO. How might one merge these attachment tables and maintain the relationship into a single MASTER dataset?
Getting the feature classes together seems is a simple enough task but i assume it can't be as easy as "loading data" into the attachment table? THere was a help doc related to restoring relationship table... but really lookin for guidance . Also i would use the Export to file geodatabase option that was recently added with the July AGO release but unfortunately, it fails due to the fact that i don' think they were expecting someone to host over 5 GB worth of attachment data
What is the easiest way to merge data together into a single attachment table and dataset?
Sorry, I can't be of much help with this, but someone from the ArcGIS Online community may be of more help. Suggest you use the Move selection from the Actions list on the right to move this thread to the ArcGIS Online space.
Also you might add the "arcgis_online" tag.
Here is a method I used in the past, I don't know that it is the best method, but it worked in my case. Hopefully it will help you out or give you some ideas:
Add new text field to All Participating Feature Classes & Their Attachment Tables
Add and Calculate New Field to Equal GlobalID for Feature Classes, and REL_GlobalID for Tables
Merge Feature Classes. Merge Tables.
Add New Long Integer Field to Merged Table (Like REL_OID).
Join Merged Table to Merged Feature Class Based on Text Equivalent to GlobalID.
While Joined, Populate New Field with OID from Merged Feature Class.
Feature Class to Feature Class - Remove GlobalID in Field Map.
Enable Attachments on Merged Feature Class (Creates New Table & Relationship).
Right Click Newly Created Attachment Table and Load Data from the Merged Table.
In the Field Map, Specify the New Field Based on the Field Containing the OID Obtained from Merged Feature Class, Leave the Remainder Default.
Check Results in ArcMap.
I am also having the same issue as the original poster.
I seem to get confused somewhere around the step about Feature Class to Feature Class - Remove Global ID in Field Map. Am I creating another feature class? Or just removing the Global ID?
I created a new feature class, enabled attachments and then loaded the data from the Merged Table. I specified the new field with the REL_OID field and left the remainder default. When I open up ArcMap I am still not seeing the attachments...
Do you have any further guidance?
The Feature Class to Feature Class portion was a work-around method to simply remove Global IDs. I can't remember exactly which portion, but the Global IDs were preventing one of the later steps. Did the joining merged data and field calculation portion work out all right?
Thanks! Using your instructions and then a little bit of this:
I finally managed to get it to work. Adding a GIS_ID and removing the Global IDs is what finally got this to work for me.
I have managed to replicate the process once and I need to do it one more time, hopefully writing down the steps so I have how I got this to work documented...
again...thank you thank you thank you!!!
Here are the instructions I came up with:
Classes with Attachments
Hopefully this works for you! One thing that I am still working on is getting the merged feature classes serviced back up on to AGOL. It seems that AGOL is not happy with the removal of the GLOBALID field...this could also be operator error
Thank you. I have run into an issue. What happens when both tables have entries with the same REL_GlobalID? When we merge the tables and try to join with the merged feature class by the ‘NewTextField’ it will join to the wrong one since they have the same REL_GlobalID. Does this make sense?
Trista C. Hahn
1552 South 7th Street
St. Louis, Missouri 63104-3805