Latest Contributions by CharlottePeters2

I've had the attribute table issue with 16gb and 32gb RAM machines and RAM wasn't maxing out. Updating to AGP 2.5.1, I'm still having issues getting some attribute tables to load even though the features still display on the map.  What worked for me so far is I created a new FGDB and exported the messed up FC to the new FGDB. I suspect that my issue has to do with the fact I was working with a FGDB that originated from ArcMap. In some instances, I had to use AGP's upgrade tool in order to edit ArcMap FGDB annotation or FCs in AGP. I don't remember if upgrading made a difference with the attribute table not opening though.  In the future, if I need to migrate an ArcMap project to AGP then I'm going to create a new FGDB with AGP and import all the FCs from the ArcMap FGDB to the new AGP FGDB.  ... View more

Another update. I have since updated to AGP 2.5.1 and haven't had any "ExcelToSQLite has stopped working" errors. ... View more

UPDATE: Well...it was nice while it lasted. Installing the latest database engine seemed to resolve the error for a short period, but getting the error again. Can't seem to tie the error to any particular action yet. A co-worker is having similar issues, but with ModelBuilder. I haven't received the error with ModelBuilder.  My system versions: Windows 10 ArcGIS Pro 2.4.2 concurrent use license housed on a server in another city Licenses to 3D analyst, data interoperability, geostatistical analyst, image analyst, network analyst, publisher, and spatial analyst In the Python Package Manager packages list, I have python v. 3.6.8 and sqlite v 3.27.2 Add-in Manager has ICAP tools 2.0.0, Military Tools for ArcGIS Pro 3.3.0.199, Crime Analysis 2019.1.17, and XTools.XTools Pro 19.0 For R-ArcGIS Support, I had R 3.6.0 with 'arcgisbinding' package 1.0.1.232 (just updated to 1.0.1.237) C ... View more

Hi, On new projects, I only have the default folder connections that AGP creates. On existing projects, I may create additional folder connections, and they do contain Excel spreadsheets. I have Excel tables in some of the projects, but the error occurs even on new projects. An update to the error dialog, I also will get the error at random times when I'm using the geoprocessing tools, like 'smooth line'. I've used 'smooth line' several times in a session on the same dataset, and the error will pop up during one of those times. I'll post back once I've tried updating the database engine. Thanks, Charlotte  ... View more

Hi Kory, I have the 2007 version of the database engine. I'll see if IT can update it and let you know the outcome. Thanks, Charlotte ... View more

After some more troubleshooting, I figured out the masking issue. Even though I removed the old mask from my project, it was still in my FGDB along with the new mask. When I deleted the old mask from the FGDB, the layer masking worked correctly using the new mask. I'm guessing that for layer masking purposes, only one mask can exist for an annotation layer in the GDB. Cheers. ... View more

To create attachments in ArcCatalog, right click the FC in ArcCatalog>>Manage>>Create attachments. It creates the [parent name]_ATTACH table and [parent name]_ATTACHREL relationship. The graphic shows attachment tables/relationships created for tables. By default, the _ATTACH table contains the following fields where the REL_GLOBALID field is used to relate to the parent GlobalID: One way I tried was to create relationship classes between each FC and the one _ATTACH table that I had ArcCatalog create for FC0 so: FC1:FC0_ATTACH using parent GlobalID from FC1 to FC0_ATTACH REL_GLOBALID FC2:FC0_ATTACH using parent GlobalID from FC2 to FC0_ATTACH REL_GLOBALID and so on for the other FCs That didn't work in the sense that the table would show up in ArcMap, ArcGIS Online, and Collector for ArcGIS but I couldn't add any attachments except for FC0. Another way I tried was to add GUID fields to the FC0_ATTACH table for every FC I wanted to relate, which sounds like what you suggested earlier. FC1:FC0_ATTACH using parent GlobalID from FC1 to FC0_ATTACH FC1_GlobalID FC2:FC0_ATTACH using parent GlobalID from FC2 to FC0_ATTACH FC2_GlobalID and so on That approach yielded the same results as the first approach. To add to the confusion of how ESRI handles attachments. I used ArcCatalog to auto create attachments for an Assessment FC, which gave me: Assessment FC Assessment_ATTACH table Assessment_ATTACHREL relationship I looked at the Relates property for Assessment FC in ArcMap and could not see the _ATTACHREL relationship listed; however, I could still add attachments. The relationship shown in the graphic below is for another table and not for the Attachment table. Then I manually created a relationship between a Camera FC (in the same FGDB as Assessment) to the Assessment_ATTACH table using parent GlobalID to child REL_GLOBALID. Since the Assessment_ATTACH relationship works for Assessment FC, I thought I could hitch the Camera FC to the same attachment table and inherit all the attachment capabilities afforded the Assessment FC. Wrong! I could still add attachments for the Assessment FC, but not for the Camera FC. I look at the relate properties for the Camera FC and the relationship I created between Camera FC:Assessment_ATTACH is in the list. It makes me wonder if there is something going on behind the scenes to make the attachment relationships work that isn't exposed to the user. Also wonder if a personal GDB would treat attachments differently seeing as how it follows the Access database schema. A rabbit hole for another day. For now, I'll do it the ESRI way and create attachments for every FC/table that needs it. Thanks. ... View more

Thanks for the suggestion on preserving the GUID. Whether I use GUID or another relate field, I still cannot seem to create a single table that will accept attachments, photos in my case, from multiple feature classes (FC). I have 5 FCs that need to have attachments. Instead of creating an attachment table for each FC, I want to have a single attachment table and relate all the FCs to the table via one:many relationships. When I create the relationships, ArcMap, ArcGIS Pro, and ArcGIS Online do not recognize the table as an attachment table. When I use the 'create attachments' feature in ArcCatalog, I can attach files to a single FC. ... View more