Latest Contributions by DougBrowning

Looks like it is trying to do something with my other Relationship classes and saying unsupported. But the Failed 300d is something.  What does that mean? QEGLPlatformContext: eglSwapBuffers failed: 300d <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: Plots <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: PlotCircle <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: Routes <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: LPI <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: Gap <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: SpeciesRichness <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: SoilStability <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: PlotObservation <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: PlotChar <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: KnownErrors <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: AIMPhotos <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <15>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateRelationships" filename="XFormFeatureService.qml" line="1180"] qml: Updating relationship for: UnknownPlants <10>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="updateChildRelationship" filename="XFormFeatureService.qml" line="1114"] qml: Unsupported childKeyField type: esriFieldTypeString <12>1 2019-04-19T20:15:32Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="default" filename="XFormFeatureService.qml" line="1180"] qrc:/qml/XForms/XFormFeatureService.qml:1180: TypeError: Cannot read property 'name' of undefined <15>1 2019-04-19T20:15:50Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="default"] JNI: onPause: API 26+ <12>1 2019-04-19T20:15:50Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="default"] QEGLPlatformContext: eglSwapBuffers failed: 300d <15>1 2019-04-19T20:15:50Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="expression for onStateChanged" filename="Portal.qml" line="227"] qml: Application state changed: 0 <15>1 2019-04-19T20:15:50Z localhost Survey123forArcGIS 22814 - [AppStudio@11205 category="qml" function="expression for onStateChanged" filename="Portal.qml" line="227"] qml: Application state changed: 0 ... View more

Well this one just got me again today.  No idea what it is this time.  Is there any way to find clues or just good luck? It all ran fine in test.  Created a new copy and then stuck on Getting Service info again. Thanks ... View more

When you say change manually do you mean you are changing the Feature Service that the survey points to or just changing it in the form?  You need to change the service so that it matches the 255 the form now wants. Have you recently updated 123 app or connect?  I thought the newer versions could handle a field size change now.  So if you have not that may work.  Or it could be that you did update and it is trying to change all your list fields to 255?  Do you know for sure it is that field?  You say it is a 2016 form so not sure if the form or Connect has been updated. If you need republish in the end there are some ways. First make a backup copy using export to GDB.  Check this file to make sure you got it all and your global ids are ok.  I have done this method many times except not when global id relationships are in there. One way is to let 123 wipe the service and "fix" it.  (That is what it is warning you off right?) Then use ArcPro and the Append tool to copy the data from your export over to the new service. (You can do it in ArcMap but it is harder and more prone to die, esp on a lot of data).  This is where I am worried about the parentgloabalid and such.  Pro does have a new setting to preserve globalids on copy though I think. The other way, esp if it is a linked service, is to download the gdb. Change the field sizes in the GDB. Publish this as a service from Pro or Map overtop of the original.  Since it has all your data in it will go up with it.  Again worried about globalids here. Hope that helps ... View more

See the line right above it. You must make a view first in order to do a join.  Did you set he inDB and all that? Yes those are field names.  See when you do a join it names the fields joinname.fieldname (just like when joining in ArcMap).  So you must reference then that way. Note I am only doing the join because in mine i need to get some attributes from a another table in my service.  You prob do not need that part. ... View more

Yep.  Here is my script that names the photos based on fields in the survey.  It also creates dirs to export to based on fields.  It was adapted from the standard one Esri posted in the past. #------------------------------------------------------------------------------- # Name: XX.py # Purpose: Exports the photos from the Survey123 Photos form from a exported GDB # Assumes state dir is already there # Will check for and create PrimaryKey dir if needed # For now it will overwrite every file as it goes. Plus and minus to this. # # Author: dbrowning # # Created: 10/31/2018 # Modified: 10/31/2018 # # # #------------------------------------------------------------------------------- import os, arcpy # vars-------------------- inDB = r"SomethingIN.gdb" # to get the names and PrimaryKey photoForm = "Photos" # actual attachements table attachName = "Photos__ATTACH" outDir = r"Something\Photos" # should be standard fldBLOB = 'DATA' fldAttName = 'ATT_NAME' dateLoadedInDb = "2018-09-01" # vars-------------------- # join to Photos form to get the PrimaryKey and state info # Note the first year they called it PlotKey instead arcpy.MakeTableView_management(inDB + "\\" + attachName, "attachView") arcpy.AddJoin_management("attachView", "REL_GLOBALID", inDB + "\\" + photoForm, "globalid") # funky due to the join fieldList = [attachName + "." + fldBLOB, attachName + "." + fldAttName, photoForm + ".PlotKey", photoForm + ".Office", photoForm + ".filename_T1", photoForm + ".filename_T2", photoForm + ".filename_T3" \ ,photoForm + ".filename_Soil1", photoForm + ".filename_Soil2", photoForm + ".filename_Soil3", photoForm + ".MiscPhoto1filename", photoForm + ".MiscPhoto2filename", photoForm + ".MiscPhoto3filename"] with arcpy.da.SearchCursor("attachView", fieldList) as cursor: for row in cursor: binaryRep = row[0] # save to disk # build output path of base + State + PrimaryKey (PlotKey + DateLoadedInDb) # for now need to check for blank PlotKey and blank Office - which should be fixed already if row[3] == None or row[2] == None: print "Warning Null values found in the Office or PlotKey field. Skipping photo. Must fix!!" print " ATT_NAME is " + row[1] else: baseOut = outDir + "\\" + row[3][:2] + "\\" + row[2] + dateLoadedInDb # check to see if already PrimaryKey dir there - if not create it if not os.path.exists(baseOut): os.makedirs(baseOut) # Need to get the actual file name from the right field. No real other way to do it with a SC so had to write it out whichPhoto = row[1].split("-")[0] if whichPhoto == "T1": fileName = row[4] + ".jpg" elif whichPhoto == "T2": fileName = row[5] + ".jpg" elif whichPhoto == "T3": fileName = row[6] + ".jpg" elif whichPhoto == "Soil1": fileName = row[7] + ".jpg" elif whichPhoto == "Soil2": fileName = row[8] + ".jpg" elif whichPhoto == "Soil3": fileName = row[9] + ".jpg" elif whichPhoto == "MiscPhoto1": fileName = row[10] + ".jpg" elif whichPhoto == "MiscPhoto2": fileName = row[11] + ".jpg" elif whichPhoto == "MiscPhoto3": fileName = row[12] + ".jpg" # in case some / got in there. this should not happen now! fileName = fileName.replace("/","") # save out the file open(baseOut + os.sep + fileName, 'wb').write(binaryRep.tobytes()) del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

As a test delete all your relevants and see if it still crashes.  This was happening to me because I was hiding 10 fields that were large select_one lists.  I could hide like 6 - then at 7 it would crash.  I had to unhide some until it stopped crashing. Just a guess since your form is huge.  You may want to consider putting the 1-8 sections in a repeat if your schema allows. ... View more

Are you still considering moving this to My Documents so that most corporate IT systems back it up?  Currently mine does not get backed up because of this and I have lost it all once already.  The current location is very strange. Ideally I wish I could just pick any dir I want.  And be able to switch between multiple directories - so I can change projects easily.  Kind of like Projects in Pro. Right now I have almost 50 forms in my Connect!  Trying to get them all straight is more work than the form.  If I could load a dir of just each state....sweet.   Also a better way to list them in connect.  Due to naming standards all 50 forms are "XYCompany Program ..." which makes telling which is which impossible. Thanks ... View more

It is not even my code. If I edit the popup, change to html, add <font color="{expression/expr4}">Text</font>, save, it works. If I go back into the popup, edit, change to html, it then wipes any custom code I had - changing the line above to <font color="#0e00e0">Text</font>.  This means I would have to rebuild all of this every time I need to edit.   Weird but it does it every time. Thanks ... View more

Ok thanks for the info. What about - Is it possible to access a {relationships/1/objectid} field in Arcade?  These are simple check boxes to turn on in the web map but Collector is ignoring them. thanks ... View more

I missed this survey but for me I use Arcade in my web map to summarize related records. In my latest use I am using it for QA.  Like out crew must do lines 1, 2, 3. var msg = "" var sql = "PlotKey = '" + $feature.PlotKey + "'"; var tbl = Filter(FeatureSetByName($map,"GAP"), sql); var txt = '' for (var f in OrderBy(tbl,"LineKey")) { txt = txt + Right(f.LineKey,1) + '-' } txt = Left(txt,Count(txt)-1) if (txt != '1-2-3') { msg = "\nLine Number Issue! Found: " + txt } var sql = "PlotKey = '" + $feature.PlotKey + "'"; var tbl = Filter(FeatureSetByName($map,"Plot Char"), sql); var tblCnt = count(tbl) if (tblCnt < 1) { msg = msg + "\n----No Plot Char form found!" } else if (tblCnt > 1) { msg = msg + "\n----More than 1 Plot Char form found!" } if (msg == '') { return '<font face="verdana" color="green">Everything Looks good!</font>' } else { return msg } ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Oh I was doing it in the return statement.  That is where I use my \n.  I do this so that I have a return of '' it does not leave a blank like for no reason.   Adding HTML is a bit of a pain.  Whenever I go back in to edit the popup it changes back to just text and then wipes any custom HTML. Thanks ... View more

I tried using this trick to set the font color.  But every single time I go back in to edit the Popup it changes back to not showing HTML and wipes my html tag changes. ... View more

Arcade says Invalid string when I try that.  This is an Arcade popup not python. ... View more

Is it possible to access a {relationships/1/objectid} field in Arcade? Can I access other Arcade expressions?  Like {expression/expr0} ?  I would like to have a master check like If {expression/expr0} == 1 and {expression/expr1} == 1 and etc} Arcade will not let me use {} at all so how do i access these fields? Thanks  ... View more

I do understand this post. ... View more