topic Re: Send Emails in Citizen Problem Reporter in Geoprocessing Questions

Send Emails in Citizen Problem Reporter

JaredPilbeam2 — Fri, 27 Sep 2019 16:35:32 GMT

I'm not sure if this the right place to post my question. I'm working on a Citizen Problem Reporter app. There's a Geoprocessing tool called Send Emails. I'm stuck on the Send Email Notifications section (pg. 34) question 9, 10:
https://www.esri.com/content/dam/esrisites/en-us/media/pdf/learn-arcgis/configuring-citizen-problem-reporter.pdf

How do I set this up? I'm able to view/edit the HTML it's referring to. I need help deciphering the two small paragraphs in questions 9 & 10.

Re: Send Emails in Citizen Problem Reporter

Anonymous User — Fri, 10 Jan 2020 15:25:55 GMT

I can answer the number 9 part:

In you email template put a keyword like {SUBMITDT}, I personally used the db field surrounded by curly brackets. Then in the email configuration under the General Email Settings put {SUBMITDT} in the Find field and put what data field value you want to replace {SUBMITDT} with in the Replace field, for example I replaced {SUBMITDT} with CreationDate, which is the name of the field in the database.

I still waiting to find out how to format the query for number 10

Re: Send Emails in Citizen Problem Reporter

JaredPilbeam2 — Mon, 13 Jan 2020 16:04:31 GMT

Eventually I got it to work with some help from Esri. What you said in the first part of your post is correct.

And as far as setting the SQL Query goes, you can either use emailstatus is Null or emailstatus=''. In the Field to Update you choose the Email Status field. And in the Sent Value field put Sent.

So when a problem is submitted and servicefunctions.py script runs an email will be sent and the Email Status field will be populated with Sent. The next time the script runs no new emails will be sent for that problem because the field doesn't meet the query-- as it's not Null or empty, rather Sent.

Re: Send Emails in Citizen Problem Reporter

WilliamRockwell1 — Tue, 21 Jan 2020 19:14:45 GMT

Thanks Jared Pilbeam‌

Any chance you could share a screenshot of your email template? I'm having a slow start getting one together. Thanks for any help.

Re: Send Emails in Citizen Problem Reporter

JaredPilbeam2 — Sat, 11 Dec 2021 23:11:28 GMT

Hi William,

Sure, no problem. I've customized it a bit, but you should just be able to copy this into your template.html file to see how it looks.

<!DOCTYPE html>
<html>
<body>
    <p>Hello {Category},</p>
    <p font-family: Arial>This is an email generated by the Will County Citizen Reporter. Someone has a question about a(n) {Prob}. Please contact them at your earliest convenience.</p>
    <p><b>Details of inquiry:</b> "{Details}"</p>
    <div style="padding:5px;background-color:DodgerBlue"><b>Point of Contact</b></div>
    <table style="width:100%;">
        <tbody>
            <tr>
                <td style="border:0.5px solid rgb(215,215,215)"><span style=" font-weight: bold;">Name</span><br /></td>
                <td style="border:0.5px solid rgb(215,215,215)">{Name}</td>
            </tr>
            <tr>
                <td style="border:0.5px solid rgb(215,215,215)"><span style="font-weight: bold;">Phone</span><br /></td>
                <td style="border:0.5px solid rgb(215,215,215)">{Phone}</td>
            </tr>
            <tr>
                <td style="border:0.5px solid rgb(215,215,215)"><span style="font-weight: bold;">Email</span><br /></td>
                <td style="border:0.5px solid rgb(215,215,215)">{Email}</td>
            </tr>
        </tbody>
    </table>

    <p>Regards,</p>
</body>
</html>
<td style="color:DodgerBlue; font-family: Arial, sans-serif; font-size: 14px;">
    GIS Division<br />
    gis@willcountyillinois.com<br />
    (815) 774-6343<br />
</td>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Send Emails in Citizen Problem Reporter

WilliamRockwell1 — Tue, 21 Jan 2020 19:45:25 GMT

Thanks!!!

Re: Send Emails in Citizen Problem Reporter

Danielle_Journey — Tue, 19 Jan 2021 17:41:55 GMT

Hi @JaredPilbeam2

I'm currently configuring the "Send Emails" portion for our CPR and I was curious about your email settings for notifying the departments internally. For example, once a citizen reports a problem, the external email is sent to the citizen, and the "Email Status" field is updated to "Sent". For the internal email to the departments to notify them that a problem had been submitted, what "SQL Query" and "Sent Value" worked for your setup, if you don't mind sharing? Thank you!!

Re: Send Emails in Citizen Problem Reporter

JaredPilbeam2 — Tue, 19 Jan 2021 19:12:28 GMT

Hi@Danielle_Journey ,

I never actually used the citizen problem reporter to its fullest as it's too confusing. I simply open the files from the ServiceSupport folder in a text editor as I need them. But, I would say create another field and then reference that field with a similar query. Sorry I couldn't be more helpful.

Re: Send Emails in Citizen Problem Reporter

Danielle_Journey — Tue, 19 Jan 2021 20:11:59 GMT

That's what I am noticing too! Thanks for the reply!