Latest Contributions by LanceCole

Interesting, I have a published mockup I had made the other day with two feature classes and one table for which it is working on AGOL.  However, these were all contained in a single database.  I will look into this further once I get home this evening as I do not have access to the files I used to publish the data. Just for clarification.  You want/need to access this linked data for use in ArcGIS for Collector not just AGOL, correct? ... View more

Siran,‌ Yes, to create a relationship class the table and feature need to be in the same database or within the same user-schema for a ArcSDE geodatabase.  Please see Modeling limitations of relationship classes. ... View more

Siran,‌ If you created a hosted feature layer view in AGOL using the Join Features Tool, you cannot edit this hosted feature directly nor can you re-publish the data from ArcGIS Desktop or Pro without first removing the layer view.  However, I believe you can still edit the underlying feature data and table that was published to AGOL.  I am note able to confirm this at the moment, but will double check this evening. Where are you trying to run the calculate function you referenced and on what data.  In Arcade use "Return Null" in SQL it is simply "NULL", both without the quotes.  There is a known issue using Arcade to set strings to Null.  I do not believe that has been resolved to date.   ... View more

Ali Azzouhri‌,  Logon to my.esri.com and navigate to My Organizations > Manage Users select your name and click the edit button (the pencil) Scroll down and there is a section to enable training, set View training and Access e-Learning to Yes ... View more

Michelle, Just curious, are you able to create a signature file using the Create Signature File tool?  If not, what error is given. ... View more

Anna, If you are in reference to having to have Excel 2007 installed to use XLSX files even when you have a newer version installed.  There are several workarounds depending upon which version of ArcGIS you are using.  Please take a look at Understanding how to use Microsoft Excel files in ArcGIS and select your version of ArcMap for specific instructions.  You may need to install the Microsoft Access Database Engine 2010 Redistributable as Microsoft has discontinued support for the Office 2007 drivers. This package will install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications.  One other note, I believe you need to download and install the 32-bit version of the Microsoft Access Database Engine 2010 Redistributable even for 64-bit systems on ArcGIS Desktop and Pro. ... View more

I hate to give this reply but, have you tried restarting your system.  The standard IT response.  You may have a temp file with an orphaned lock file.  We have see this or similar errors especially, if we have been having network problems to file shares. ... View more

Vasiliki, With the georeferenced image loaded make sure the correct image is selected in the dropdown in then go to the View Link Table button on your Georeferencing toolbar.  This will display the links you previously created and should enable the Update Georeferencing and Rectify options once the Link window is open.  You can add and delete the previous georeferenced link points from here including all of them. ... View more

To add the excel sheet to ArcMap please see Adding a Microsoft Excel table to ArcMap.  This will appear under the List by Source tab of your table of contents. To display this in ArcMap either the excel sheet has to have X, Y and Z (if needed) data or it need to have a common index to link the data to other features.  I am assuming the excel sheet has the coordinate data you can use Adding x,y coordinate data as a layer.  This data will now display in your ArcMap session. As to what else you are trying to do, it is a little ambiguous and you would need to clarify your request. ... View more

Ali Azzouhri, You can try a few things by logging onto my.esri.com. 1) once logged on, go to My Organization > Overview, their should be an option to "Contact My Administrator" or their contact info 2) Also on this page should be ESRI contact(s) for your Customer Service Representative, they can help you as well determine who is your ESRI Administrator.  Or you can contact ESRI general customer service for your area 3) As another option go to My Organization > Manage Users, their may be a list of users including one that has "Admin" next to their name.  This option will be dependent upon your level of access and type of licensing. 4) If this is in response to an ArcGIS error message to contact your administrator and you are the only one using/or installing ArcGIS components, that would be you. Sorry. Because of the sensitive information contained on the pages noted above, I cannot send any screen shots. ... View more

Siran, An afterthought... give this approach a try since you are trying to display a linked table data in collector. 1) Remove the joins in your map on the ArcGIS platform you are publishing from 2) Add a Relationship Class to the database between the feature class and table you need to link the data.  Note that a relationship class is not the same as creating a in memory join or relates.  If needed, please see Creating a Simple Relationship Class for additional information.  You will need a relationship class for each feature class to be linked to the table.  Although, all of the feature classes can point to the same table, if needed. 3) Publish the feature classes and table to AGOL as feature Service.  The relationship classes will transfer when you publish the data. 4) Create a AGOL Map with the data published and save.  Please insure at least one feature is editable so it will show in the available maps to Collector. 5) Open the Map in Collector. 6) Select a feature that has a relationship class to the underlying table.  A link will be available to the table row in the attribute information for the feature selected as shown below. 7) Select that link and the information from the linked row will be displayed. You can even edit the data by selecting Edit, if enabled. I hope this is helpful.  let me know if you have any questions. ... View more

Siran‌, I believe this is by design, in memory joins and relates are not supported to be published.  Please see Author maps to publish feature services. Joined data When you publish a map service with feature access capability to a GIS Server site, joined columns are included in the map service but are not included in the feature service. The feature service includes only the columns from the join table (the table or feature class on which you defined the join). If symbology for the layer is based on a joined column, the map service includes the renderer you used to symbolize features, but the feature service reverts to a simple renderer. If the renderer in the layer is based on a column from the left most feature class in the join, the map server and feature server include the renderer. You cannot publish joined data to an ArcGIS Enterprise portal or ArcGIS Online. Remove joins before publishing a feature service (hosted feature layer) to either of these applications. That being said, you can publish your features and table(s) with out the joins then create a hosted feature layer view in AGOL.  Please see Join Features analysis tool fro AGOL.  Make sure you check the "Create results as hosted feature layer view" at the bottom of the tool before running the analysis.  Unfortunately, this is a view and not directly editable although you can edit the underlying table and feature services.  However, once have used the Join Features Tool on your data you cannot update the data by republishing from ArcGIS Desktop or Pro when using this method.  Please see Create hosted feature layer views for additional information and limitations. Hopefully, Collector will support Arcade Expressions in a near future release.  This can be done using a lookup with Arcade in about 3 lines of code to build an expression for AGOL Pop-ups, but it does not function in Collector at this time. Another option would be to append your needed URL to your feature data as an attribute before publishing if you need to regularly update your data. ... View more

Dan, I agree.  Typically seeing zero (0) data is a red flag something is up unless expected. ... View more

Roberto, Seeing the zero (0) in your data makes me wonder if you may have holes or voids in your original data.  You may want to try and combine focal statistics with another function such as Elevation Void Fill, Fill, or possibly even Nibble depending upon your data type. ... View more

Kaeleigh, What is the file extension of the file you are trying to add, JPEG?  If so, rename it to JPG and try to add it again. Lance ... View more