Dustin Surwill (dsurwill@shield-legal.com)
2025-05-05 13:21:15

What is your GitHub username so I can get you access to some code examples?

Josh Josue (jjosue@shield-legal.com)
2025-05-05 13:21:44

josh-SL

Dustin Surwill (dsurwill@shield-legal.com)
2025-05-05 13:30:29

Here examples of the same file in 2 branches of getting attachments from emails: https://github.com/shield-legal/gcp-integrations/blob/main/email_processing/imap.py https://github.com/shield-legal/gcp-integrations/blob/fixing-db-issues/email_processing/imap.py

👍 Josh Josue
Dustin Surwill (dsurwill@shield-legal.com)
2025-05-15 13:40:26

from func_fill_db.lawruler import LawRuler can be replaced by from email_processing.lawruler_class import LawRuler (The 2 files should be the same). Here is that LawRuler class: https://github.com/shield-legal/gcp-integrations/blob/main/email_processing/lawruler_class.py

download_acts_docs.py
Dustin Surwill (dsurwill@shield-legal.com)
2025-05-16 13:30:29

LR_API_SECRET="3RsxCggviuYBdBZQ15DT1faJFOPRJLMG"

Dustin Surwill (dsurwill@shield-legal.com)
2025-05-16 13:42:37
all_requirements.txt
Josh Josue (jjosue@shield-legal.com)
2025-05-20 15:41:10

c-24159

Dustin Surwill (dsurwill@shield-legal.com)
2025-05-20 15:45:34

SELECT lq.**, cq.** FROM case_question cq LEFT JOIN lead_question lq ON id=questionid LEFT JOIN lead l on lq.leadid = l.id WHERE l.casetypeid IN ({", ".join(["%s"] ** len(case_types))}) AND cq.casetypeid IN ({", ".join(["%s"] ** len(case_types))}) ORDER BY headerid ASC, priority ASC

Dustin Surwill (dsurwill@shield-legal.com)
2025-05-20 15:54:05
output_1704.xlsx
Josh Josue (jjosue@shield-legal.com)
2025-06-10 13:31:53

Hey Dustin, what table holds the Default### id's?

Dustin Surwill (dsurwill@shield-legal.com)
2025-06-10 13:36:31

Not a table. Here are some of them, I still need to find the doc with all of them: https://docs.google.com/spreadsheets/d/11vlVZdga6tmzhMWZoAgJeCBwedXeZO_MZnaSNIijEM4/edit?gid=534236854#gid=534236854

👍 Josh Josue
Dustin Surwill (dsurwill@shield-legal.com)
2025-06-10 13:42:46

They also show up in the case_question table without the c- in front. lawrulerfield='11'

Josh Josue (jjosue@shield-legal.com)
2025-06-10 13:43:30

so instead of a question, it's just "lawrulerield='11'"

Dustin Surwill (dsurwill@shield-legal.com)
2025-06-10 13:44:17

lawrulerfield is a column in the case_question table. I was giving an example to find them in the sql

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-06 13:57:39

Here are my notes from that meeting: ```82-85 reports convert from lr email report to automated generate & upload to onedrive 1 folder per campaign (they will create) report file named with the date to not override currently excel files run the reports at midnight create a mapping between LR case type (id) and the folders combine redudent columns (questions)

ask about if the folder runs out of space or otherwise errors

look into using user credentials?

get reformatting template/params from Aiden & Brittany get reports that do not need modification from Brittany (LR report)

function that generates a report similar to LR in BQ for later use and allows for column modifications (it will auto deploy on commit to branch [dev] or main [prod]): PR with scheduled function: https://github.com/shield-legal/lawruler-ui/pull/4 current cloud scheduler: https://console.cloud.google.com/cloudscheduler/jobs/edit/us-west4/LR_Report_Builder?inv=1&invt=Ab4xoA&project=tort-intake-professionals current cloud function: https://console.cloud.google.com/run/detail/us-west4/test-func-casetype-bq/metrics?inv=1&invt=Ab4xoA&project=tort-intake-professionals```

👍 Josh Josue
Josh Josue (jjosue@shield-legal.com)
2025-08-06 15:30:00

Hey Dustin, I need access to that cloud scheduler https://console.cloud.google.com/cloudscheduler/jobs/edit/us-west4/LR_Report_Builder?inv=1&invt=Ab4x-w&project=tort-intake-professionals

accounts.google.com
Google Cloud Platform
Google Cloud Platform lets you build, deploy, and scale applications, websites, and services on the same infrastructure as Google.
Original URL: https://console.cloud.google.com/cloudscheduler/jobs/edit/us-west4/LR_Report_Builder?inv=1&invt=Ab4x-w&project=tort-intake-professionals
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-06 16:11:17

My mistake, permission has been granted

Josh Josue (jjosue@shield-legal.com)
2025-08-06 16:11:25

thanks!

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-06 17:13:49

The cloud scheduler json payload is controlled by this page: https://shieldlegal.dev/reporting/lawruler/scheduled_bigquery The code which is: https://github.com/shield-legal/internal-tools-site/blob/main/reporting/lawruler/scheduled_bigquery/views.py

👍 Josh Josue