Latest Contributions by LieslDe_Swardt1

‎06-07-2022

Thank you, for the response. I am a newbie in survey 123. Domain?

‎06-07-2022

Thank you for the reply, I actually didn't change the column name of the repeat table, initially I didn't have the repeats and then I needed to update because the "Other" questions needed to be repeats, managed to publish but encountered problem when submitting the survey, it took forever to send. that when I created a new survey from the previous spreadsheet. I have attached both spreadsheets for the survey.

‎06-07-2022

Please help, I created this survey, I am getting an error when I try to republish after updating the choices lists, I have repeats in the survey and also inserted a text field to delete the test surveys, then deleted it, I am not sure if that is what is causing the app to misbehave.

‎01-14-2022

Hi Abin, this is a bummer. Did the exact same in 2019 and it worked perfectly fine.

‎01-13-2022

Hi, did you manage to figure it out? I am currently in the same boat. My working folder has EE0020_Report 1, EE0020_Report 2 etc in it, and my unique identifier in my feature is EE0020. I need all the reports that has an EE0020 in it, to link to the specific point. It used to work, now I am not getting it right.

‎01-13-2022

Hi Everyone, I used to be able to generate an attachment match table such as the below: MatchID Filename 1 EC0020_Report 1 1 EC0020_Report 2 1 EC0020_Report 3 1 EC0020_Report 4 My feature class to which attachments was linked only had EC0020 in it, but it still managed to search through my folder and generate my attachment match table based on all the documents it found with a EC0020 in it. However, I am trying to do this now, and I keep getting an error saying my attachment table is empty. I have checked and when I make my document name EC0020, then it picks it up, but obviously you cannot have 4 documents with the exact same name. Can anyone please assist?

‎06-25-2021

Hi Philip, is there perhaps a workaround if your survey needs to be public? Recently found out that public survey does not support javascript.

‎06-25-2021

No I thought it was possible with the linked map for a person to click on the polygon they are capturing data for and have some info pulled into the survey from that specific polygon. I just need some way to be able to link the data to the correct polygon. I know the point/location of the enumerator will help with that, but a secondary verification would be amazing. Unfortunately we do not have an enterprise license or fieldworker licenses for Collector, as that would have been ideal. We have over 250 000 enumerators and 600 000 portions, hence the second verification method so that we don't mess up when we link the data captured in the field to the portions' attribute table. Thanks for the heads up on the reserved words.

‎06-24-2021

Thanks very much. I will have a look at the links you've shared, and hope there is a workaround for javascript then. I actually do need both, the point is the live location of the enumerator, and he needs to see the polygons on the survey so he can capture for the correct polygon. He doesn't need to edit or draw polygons hence I made the geoshape read only (but it doesn't pull onto the map). Will check if the polygons draw if I remove the geopoint. Thanks.

‎06-24-2021

Hi Everyone, I have created a survey through survey 123 connect using version 3.12. The goal is to capture certain information for specific properties. However the enumerator must capture the correct information for the correct property, I've therefore used geoshape and geopoint so the person can see his location. However, the polygons are not pulling in on the map, and I'm also struggling with the pulldata and the script. I've added the featurelayer (with all the polygons) manually to the web map that gets created once the survey is published, but I've been told that it would be static. The survey must be public, and hence I'm getting an error on the output that scripts are disabled. I'm just failing 100% all round. Hoping that someone can help me. Below a screen shot, and attached my excel and script file. Please note that I am extremely new to scripting.

‎05-02-2020

Hi All, I have created a form for survey123 connect mainly for stock management. I am struggling to do some calculations in the form so thought I'd rather perform them in my attribute table. My service layer consists of: feature layer, order history table and inventory utilisation table. I want to calculate the days between my deliverydate field that is within the order history table and issue date field that is within the utilisation table. It needs to be populated under Issued_delivered. One delivery speaks to multiple issue dates. Hence I had to link a table to the order history to show the issue history. My problem is that I don't know how to calculate between two tables. I'm also not sure what the effect will be when a new delivery date is inserted. The main purpose of this is to calculate safety stock, which will trigger a new order. Therefore, I need the days between delivery and issue dates, this will allow me to calculate daily utilisation which in turn will help me calculate safety stock. Please assist me with calculating between various tables in AGOL. Much appreciated.

‎03-29-2019

Thank you Thomas, however I do not have the physical photos, I only have the .bak file which contains the details of the photos?

‎03-28-2019

Hi All, We are busy with data capturing and have a bunch of geotagged photos in our sql server. I am trying to view these photos in arcmap / arcgis pro. The process I have followed so far: - Restored the .bak file in sql express in order to see the tables - Connected the database to arcgis pro - it consist of two tables (1) displaying lat and long coordinates (2) photo table with the doc ID in. Both these tables have the doc id. I have displayed the points as per the coordinates, the tricky part is now linking the photo table to the points in order to see the pictures. I have done a little bit of research and came across the tool "generate attachment table'. Not too sure how it works and if this is the path I should follow. Do I create a new geodatabase? Should I export the photo table? Just a bit lost and in desperate need of guidance. I have a standard license. Any advice and help will be appreciated. Thanks.

‎01-14-2019

Hi Joshua, thanx - I have been trying to put a script together for that, but I am still very new to python so I am failing terribly.

‎01-14-2019

Can someone please assist me with the following task at hand: I need to export the coordinates of polygon vertices in the following format: Polygon_1, y,x ; y,x ; y,x ; y,x ; y,x I have 120 000 vertices that needs to be exported in this format (either txt or xls). I have used export feature attribute to ASCII and export as table, but it exports in the following format: Polygon_1, y,x Polygon_1, y,x Polygon_1, y,x Polygon_1, y,x Polygon_1, y,x Reason it needs to be in the above mentioned array format is to be able to use it in VB and SQL. I have also tried the transpose tool, which is not giving the desired outcome. Any help will be appreciated.

Online Status	Offline
Date Last Visited	‎10-27-2022 11:59 AM

My Ideas

Latest Contributions by LieslDe_Swardt1

Re: Republishing error

Re: Republishing error

Republishing error

Re: Generate Attachment Match Table

Re: Adding multiple attachments to a single polygon using match table

Generate Attachment Match Table

Re: Query data from separate feature service in Survey123

Re: Geoshape and scripts disabled

Re: Geoshape and scripts disabled

Geoshape and scripts disabled

How to calculate number of days between a date on repeat table one and repeat table two?

Re: SQL server photos to Arcmap

SQL server photos to Arcmap

Re: Array of Coordinates

Array of Coordinates