Latest Contributions by MichelleWilliams1

Our Apple devices are also having this issue. ~ Following ... View more

Thank you,  I've updated my utc_offset and made the where_filter = {"where":"LetterPrinted='no', AND Submit='yes'"} let me know if this is correct #Newbie. I'm getting this error:   File C:\... line 145, in main      if surveyID in x.description: TypeError: argument of type 'NoneType' is not iterable I'm not sure if my where_filter or something else. Thank you for your time. ... View more

Thank you for your quick response. I was using Python v2. v3 - The code seems to run, but I'm getting zero reports, and I submitted a new survey today, any ideas why? --- STARTING REPORT GENERATION PROCESS --- 2020-02-24 13:59:55.291881 Initialising session in AGOL Reading Survey123 information for ID: 43335467cc64408d8928c890124a9ee6  Selected template: <Item title:"BSI Infraction Letter2020B.docx" type:Microsoft Word owner:WilZZZ > Generating report(s) for submissions from last 24 hours Downloading relevant report(s) to: C:\Users\WilZZZ\Documents\BSIFeatureReportsPY REPORTS GENERATED: 0 --- REPORT GENERATION PROCESS - FINISHED --- --- STARTING EMAIL PROCESS --- Getting list of Word docx files in: C:\Users\William5\Documents\BSIFeatureReportsPY Files: Reading raw table data from Word document(s) DOCUMENTS SENT TO RECIPIENTS: 0 --- EMAIL PROCESS - FINISHED --- ... View more

I installed smtplib, python-docx, and glob but I'm still getting this error. Is it my firewall giving me problems? I might need to download to a folder. ... View more

Hi John, I'm using your script and I'm getting this error, do you know why? ... View more

It did work two days before. I rebuilt the Word document and it's working again. ... View more

I am also having an issue with names showing instead of labels in my ForeignImprovementType2 field, and I'm not using the choice filter. I've included my .xlsx file minus the propitiatory data. I'd appreciate your help. ... View more

I got his error this morning, has something changed online in the last two days? ... View more

Hi James, is the modify schema still available in 3.7.62? I tried publishing this morning and didn't see it. ... View more

Bump! ... View more

Thank you so much. The document was amazing I also learned to prepopulate a geopoint (which I needed), and how to scroll to the bottom of a survey which comes in handy for long surveys. ... View more

Thank you!!! I found it. ... View more

Here you go! I couldn't find a file upload button, so I pasted it here.  type name label hint constraint constraint_message required required_message appearance default readonly relevant calculation choice_filter repeat_count label::language1 hint::language1 media::audio media::image body::accuracyThreshold bind::esri:fieldType bind::esri:fieldLength bind::esri:fieldAlias body::esri:inputMask bind::esri:parameters bind::saveIncomplete bind::type bind::esri:warning bind::esri:warning_message body::esri:style parameters begin_group certificate <center>MONTHLY INSPECTION AND SAFETY REPORT</center>           w8 field-list                                             text Name <font size=2>Employee Name        y   w5                         30                   date ExpirationDate <font size=2>Driver's License Expiration Date     y   w3                                             text Reg <font size=2>Vehicle Registration Y or N     y   w1                         1   >X               text RegExp <font size=2>Vehicle Reg Exp Exempt     y   w1                         10                   text Truck <font size=2>Truck #       y   w1                          10                   integer Mileage <font size=2>Mileage       y   w1                         9                   text Claim <font size=2>Accident/Claim Pkg Y or N     y   w1                         1   >X               date Ins <font size=2>Ins Exp Date       y   w1                         10                   end_group                                                             begin_group TruckTools <bold><center>Truck Tools</center></bold>           w8 field-list                                             note Banner <center>CONDITION CODES ~  S - SATISFACTORY  U - UNSATISFACTORY  R - REPAIR/REPLACE  CAL - CALIBRATION  EXP -  EXPIRATION</center>           w8                                              select_one Cond ToolCond_HeatGun <center>Heat Gun</center>       y                             3                   date ToolCond_HeatGunCalDate <center>Heat Gun Cal Date</center>       y   w3                                             date ToolCond_HeatGunExpDate <center>Heat Gun Exp Date</center>       y   w3                                             select_one Cond ToolCond_Blower <center>Blower / Hose</center>                                     3                   select_one Cond ToolCond_Gas <center>Gas Tester</center>                                     3                   date ToolCond_GasCalDate <center>Gas Tester Cal Date</center>           w3                                             date ToolCond_GasExpDate <center>Gas Tester Exp Date</center>           w3                                             select_one Cond ToolCond_Gantry <center>Gantry</center>                                     3                   select_one Cond ToolCond_Extinguisher <center>Fire Extinguisher</center>       y                             3                   date ToolCond_ExtinguisherExp <center>Fire Extinguisher Expiration Date</center>       y   w3                         3                   text ToolCond_ExtinguisherModWt <center>Fire Extinguisher Model & Weight</center> Like Amerex B456 10     y   w3                           30                   select_one Cond ToolCond_HandTools <center>Hand Tools</center>       y                             3                   select_one Cond ToolCond_Calibration <center>Calibration Enforcer / Gas Cylinder</center>                                     3                   date ToolCond_CalExpDate <center>Calibration Enforcer / Gas Cylinder Exp Date</center>         w3                                             select_one Cond ToolCond_Barricade <center>Manhole Barricade</center>                                     3                   select_one Cond ToolCond_Manhole <center>Manhole Lid Lifting</center>       y                             3                   select_one Cond ToolCond_Wheel <center>Measuring Wheel</center>       y                             3                   select_one Cond ToolCond_WheelChalks <center>Wheel Chalks</center>       y                             3                   text ToolExplainUR Truck Tools: Explain any items marked with "U" or "R"            w8                                              text ToolConcerns Truck Tools: Comments or Concerns:           w8                                              image photo1 Take a photo of the issue           w8                               bottomLeftWatermark=${watermarkT}           end_group                                                             begin_group Safety <bold><center>Safety Kits & PPE</center></bold>           w8 field-list                                             select_one Cond SafeCond_Shield <center>Face Shield</center>       y                             3                   select_one Cond SafeCond_Hat <center>Hard Hat</center>       y                             3                   select_one Cond SafeCond_Coveralls <center>Nomex Coveralls</center>       y                             3                   select_one Cond SafeCond_Hood <center>Nomex Hood</center>       y                             3                   select_one Cond SafeCond_Glasses <center>Safety Glasses</center>       y                             3                   select_one Cond SafeCond_Vest <center>Safety Vest</center>       y                             3                   note EmptyA <center> </center>       y   w2                           3                   select_one Cond SafeCond_Burn <center>Burn Kit</center>       y                             3                   date SafeCond_BurnExpDate <center>Burn Kit Exp Date</center>       y   w3                                             select_one Cond SafeCond_FirstAid <center>First Aid Kit</center>       y                             3                   date SafeCond_FirstAidExpDate <center>First Aid Kit Exp Date</center>       y   w3                                             select_one CondVehicle SafeCond_VehCleanIS <center>Vehicle Cleanliness Inside</center>       y                             3                   select_one CondVehicle SafeCond_VehCleanOUT <center>Vehicle Cleanliness Outside</center>       y                             3                   select_one CondVehicle SafeCond_VehMaint <center>Vehicle Maintenance</center>       y                             3                   note EmptyB <center> </center>       y   w1                          3                   text ExplainUR Safety: Explain any items marked with "U" or "R"            w7                                             text Concerns Safety: Comments or Concerns:           w7                                             image SignatureInsp Inspector's Signature w4 signature date DateInsp Date w3 today() image photo1 Take a photo of the issue bottomLeftWatermark=${watermarkS} hidden Supervisor Supervisor 20 calculate watermarkT                     concat(${Name}," Tool Issue",'\n@[date]')                                     calculate watermarkS                     concat(${Name}," Safety Issue",'\n@[date]')                                     end_group                                                             ... View more