Latest Contributions by MathieuBoonen

When I use the JS Function I get this string back as per below, but because the format is not true JavaScript I cannot seem to extract the one part of the record I want. which is the actual measurement  and date as two seperate strings (2021-11-15T07:33:00 and 7.6 below )from a rain gauge, so quite dependent on date time and location and as such is quite dynamic to the point when no data is available it has no value for the rain amount. <?xml version="1.0" ?> <Hilltop> <Agency>Gisborne District Council</Agency> <Measurement SiteName="Waerenga-O-Kuri"> <DataSource Name="Rainfall" NumItems="1"> <TSType>StdSeries</TSType> <DataType>SimpleTimeSeries</DataType> <Interpolation>Histogram</Interpolation> <ItemInfo ItemNumber="1"> <ItemName>Rainfall</ItemName><ItemFormat>F</ItemFormat><Units>mm</Units><Format>#.###</Format> </ItemInfo> </DataSource> <Data DateFormat="Calendar" NumItems="1"> <E><T>2021-11-15T07:33:00</T><I1>7.6</I1></E> </Data> </Measurement> </Hilltop> <?xml version="1.0" ?> <Hilltop> <Agency>Gisborne District Council</Agency> <Measurement SiteName="Waerenga-O-Kuri"> <DataSource Name="Rainfall" NumItems="1"> <TSType>StdSeries</TSType> <DataType>SimpleTimeSeries</DataType> <Interpolation>Histogram</Interpolation> <ItemInfo ItemNumber="1"> <ItemName>Rainfall</ItemName><ItemFormat>F</ItemFormat><Units>mm</Units><Format>#.###</Format> </ItemInfo> </DataSource> <Data DateFormat="Calendar" NumItems="1"> <E><T>2021-11-15T07:33:00</T><I1>7.6</I1></E> </Data> </Measurement> </Hilltop> How would I get these two parameters from the returned result. ... View more

I am successfully using watermarks to report lat long co-ordinates of photos, the problem I have now is some users are loading some of photos/images from other devices that dont create these parameters. the data seems to save okay into the survey, but when I use the photos in a report from webhooks or online in S123 online management etc, those without the Lat Longs are causing the report to error out.  I suppose the work around it to offer an image section in the survey without the watermark , as it is though you would end up creating many more tables in the survey as image function is already used 9 times in this survey. (9 extra sections (tables) , is not a nice solution) Or alternately wrap the bind::esri:paramater in an if statement. How would that look in syntax and how do you get a watermark property when it doesn't exist, or could the bind be set up that way? ... View more

I see similar odd behaviour when a survey saved on Arcgisonline (survey123) under our organisatuion in New Zealand, the date changes to a value that looks to be  GMT instead of NZDT or NZST  see screen scrape of  the data in survey123 online and the same record exported as csv or a excel document the correct date is that within the online app, but something is doing the conversion to GMT?? on the export  function. Help Please. ... View more

Hi @Ruth_JiatengXu  or anyone else with the smarts to make this work Is there an alternative to using DOM Objects as apparently DOM does not work with Survey123 according to the custom JS functions Blog reference that you provided, or has things changed and I just cant get your script to work with the dynamic data string produced? ... View more

As promised the SUrvey123 survey plus scripts😎 ... View more

I was just wondering if you could help me on a slightly different issue . I have a pulldata request in javascript for survey123 that pulls from a XML service  that is found on http://hilltop.gdc.govt.nz/data.jts?service=hilltop&request=GetData&  with a bunch of parameters for site (e.g. Wakaroa Trig) ,measurement (Rainfall)  from date (4/8/2021) , to date (9/8/2021) , interval (5 days) , summary interpolation (total) the result creates an un-formatted xml  output i have been able to see the output using  weather_json = (xmlhttp.response.GetResponseStream()); which I believe is not quite the correct syntax or function to call the object especially when the data is xml as opposed to native json (by the looks) I couldn’t get Json.PARSE or JSON.stringify to retrieve anything I have tried a few similar w3 json functions . As I am not a json guru it’s pretty much new to me.   however with the ….GetResponseStream (Did work last night not so much today ) to display the results in the survey123 but only after saving the script, (I assume that it needs an on click type function to invoke the call )form via the form p”but how? realistically All I want from the data is the second object value <E><></><I1> value </I1></E> returned. and maybe a validation that it is Rainfall from the site chosen  I just don’t know if json is rendering the string into objects that it can find or how to get that in the last step.   The ultimate may be one step further in that I find a way to find the closest rainfall sample  point with current data in relation to my current location and use that data instead of having to define the site. from a select_one site request    I believe that I am close but I just need a bit more guidance to get it right. I will add the code shortly 😁 thanks in advance for putting up with this newbie!!! ... View more

Thanks clarifies it immensely , Should have known about the w3 resource years ago, just never had the time but at least sick leave now  is good for learning. now onto error trapping objects that don't consistently exist.. (poor Survey123  calculation formula strings) :? ... View more

Thanks Zach Such a quick reply. So if there are multiple objects, as in the Onecall API returned response that appears to be in multiple arrays (1 per day) to report items such as  "description" do they need some form of index id for each one, i.e. [0] [1] [2] etc. to each reported array. pulldata("@json", ${weather_json},"weather[0}.daily[0].description" and then  ${weather_json},"weather[0}.daily[1].description" or if it is an array within an array  do they need to be nested in some for of script structure above, of course as  separate responses in Survey123. I will take a look at your resource as provided, so I am preempting that already.. Thanks Mat ... View more

I have a similar issue and maybe it is outside the capabilities of javascript and @json calls  from within Survey123, with the attached I have tried various API's ( I'd prefer onecall api) under openweather.org  but I cannot get the results I expect for individual values, or maybe I just need to be shown how to  extract from the output that actually does work.. The ultimate for me is to read the last 5 days rain as well as the next 7 day forecast and present the results into a ranking of severity to use as a activity planning matrix eg if Main equals Rain then weather rate = 10 on a scale of 1 -10. I have attached the script for the big part will work it is just getting at the individual  outputs. probably javascript against the weather_json (WITHIN THE ATTACHED) code which I possibly need to export to a intermediate table or something. But with no exprience in Java scripting I can only take it so far within getting a better understanding of script functions etc. A full listing of java functions and use would be great. Any guidance or help would be awesome... Mat ... View more

I have found in order for this to work for me I have had to include quotation marks around the  conditioned format data if it has spaces in the response, or introduce a hidden character as in an unscrore colored white if you dont want the quotes marks to appear in the response on the report as per: showing both methods ${if invest_priority==”A”}Priority_A${/}${if invest_priority==”B”}"Priority B"${/} ... View more

Has this been removed or incorporated in another module file type in the current version 3.10 , as I note I can attach a video via desktop browser by selecting all file types whilst editing a survey but not off a Apple I Phone. as the phone defaults to photo only attachment type. ... View more

The field is a date format , so unique values it is. Maybe I will create 3 fields day month and year as integer values, then calculate out each using text strings left and right functions etc and at least I can group them easily by month and year and query the day as a numeric value. I am surprised I have not seen this issue earlier as I have been using Arc products since 1991....Goes to show you are always learning when it comes to GIS.... ... View more

I have a similar issue but what i wish to do is select records where date is greater than or equal to one specific date . When I build a query the query the column tool converts the date to yyyy-mm-dd hh:mm:ss  e.g.Select OPDATE >= date '2007-03-25 00:00:00' the thing is it drops a bunch of records that it should pick up greater than this date. I wonder if it has anything to do with American vs European date formats or  how the record was keyed into the database. As all dates normally look like 25/03/2007 when viewed in the table  i.e. dd/mm/yyyy as per: So how do I ensure I get the correct records without missing any ,if you can imagine I have over 15000 records spanning 13 years I don't want to write a query for each and every potential date value). eg OPDATE IN (date '2007-03-25 00:00:00' ,date '2007-03-26 00:00:00' ,date '2007-03-2700:00:00' ,date '2007-03-28 00:00:00' ,date '2007-03-29 00:00:00' .....) ( which equates to 4749 potential date results  or 365.25 days a year for 13 years ) ... View more

Dissolve is another method to generate one large polygon if you just want the features  It needs one common attribute to ensure a single polygon is created and IF  they are all touching one another, otherwise you will end up with a multipart polygon. Alternatively Aggregate Polygons is another Tool which does a nice job from a cartographic sense. ... View more