Dwight Thomas (dwight@shield-legal.com)
2024-09-24 13:37:19
Dwight Thomas (dwight@shield-legal.com)
2024-09-24 13:37:27

zM{`L3U}W7G5

Zekarias Haile (zhaile@shield-legal.com)
2024-09-24 13:43:00

595734

Dwight Thomas (dwight@shield-legal.com)
2024-10-10 16:10:31

By chance did you just get thank link?

Zekarias Haile (zhaile@shield-legal.com)
2024-10-10 16:11:23

yes, I see that link but the one that was not exported was Chowchilla - Van - Long Form Interview - VAN - Shield Legal

Dwight Thomas (dwight@shield-legal.com)
2024-10-10 16:13:37

Oh..., so you need this extracted?

Zekarias Haile (zhaile@shield-legal.com)
2024-10-10 16:14:25

yes export from MPA please

Dwight Thomas (dwight@shield-legal.com)
2024-10-10 16:14:41

Doing it now..

👍 Zekarias Haile
Dwight Thomas (dwight@shield-legal.com)
2024-10-10 16:28:08

Try that

Zekarias Haile (zhaile@shield-legal.com)
2024-10-10 16:28:51

Okay. Thanks

Zekarias Haile (zhaile@shield-legal.com)
2024-10-28 17:48:02

Eric3 John4|Illinois Juvenile Hall Abuse - BG - Bay Point - Shield Legal|Test Lead Trigger Lead # 617605

Zekarias Haile (zhaile@shield-legal.com)
2024-10-30 11:57:53

https://mcpl.aspendiscovery.org/GroupedWork/c7322759-14af-f90d-fd63-30b0e1633bac-eng/Home?searchId=20083289&recordIndex=2&page=1&searchSource=local&referred=resultIndex|https://mcpl.aspendiscovery.org/GroupedWork/c7322759-14af-f90d-fd63-30b0e1633bac-eng/Home?searchId=20083289&recordIndex=2&page=1&searchSource=local&referred=resultIndex

Montgomery County Public Libraries
Zekarias Haile (zhaile@shield-legal.com)
2024-10-31 16:35:33

https://console.cloud.google.com/bigquery?project=integrations-tip&ws=!1m11!1m10!12m5!1m3!1sintegrations-tip!2sus-west4!3se528829e-b5e1-40f9-b4c6-7ec52fc73751!2e1!14m3!1sintegrations-tip!2sbquxjob57e7dcdb192e47f73f0!3sus-west4|https://console.cloud.google.com/bigquery?project=integrations-tip&ws=!1m11!1m10!12m5!1m3[…]tegrations-tip!2sbquxjob57e7dcdb192e47f73f0!3sus-west4

accounts.google.com
Zekarias Haile (zhaile@shield-legal.com)
2024-11-11 12:16:46

Good morning, I have created a test lead for LA county Foster cares.. wanted to let you know. so that you wont create new one.

👍:skin_tone_5: Dwight Thomas
Dwight Thomas (dwight@shield-legal.com)
2024-11-11 12:17:28

Appreciate it man!!! Thanks!!!

Zekarias Haile (zhaile@shield-legal.com)
2024-11-11 12:18:04

Np!

Dwight Thomas (dwight@shield-legal.com)
2024-11-11 12:37:04

What is the Test Lead ID?

Zekarias Haile (zhaile@shield-legal.com)
2024-11-11 12:40:25

625982

👍:skin_tone_5: Dwight Thomas
Dwight Thomas (dwight@shield-legal.com)
2025-01-08 16:57:25

scripts\sql_proxy.bat 3306 integrations-tip gcp-integrations

Dwight Thomas (dwight@shield-legal.com)
2025-01-08 16:59:53

scripts\sql_proxy.bat 3307 tort-intake-professionals lr-data

Zekarias Haile (zhaile@shield-legal.com)
2025-01-08 17:23:04

( campaign LIKE '%Illinois Juv%' AND customer LIKE '%Crump/Slater%' OR campaign LIKE '%Maryland Juv%' AND customer LIKE '%Crump/Slater%' OR campaign LIKE '%Depo Provera%' AND customer LIKE '%Crump/Napoli%' OR campaign LIKE '%Chowchilla%' AND customer LIKE '%ACTS/Crump%' OR campaign LIKE '%Chowchilla%' AND customer LIKE '%Crump/Slater%' OR campaign LIKE '%Gaming Addiction%' AND customer LIKE '%Crump/Meadow%'

Dwight Thomas (dwight@shield-legal.com)
2025-01-08 17:54:02

Select ct.id CaseTypeID, ct.name CaseTypeName, ls.name StatusName, count (**) TOTAL from public.lead lead inner join public.leadstatus ls on lead.statusid = ls.id inner join public.case_type ct on ct.id = lead.casetypeid --WHERE ct.name LIKE '%Illinois Juv%' GROUP BY ct.id, ct.name, ls.name order by 1,4 desc --limit 2

Dwight Thomas (dwight@shield-legal.com)
2025-01-08 17:58:39

SELECT intakestatus, casetypeid, count(**) as TOTAL FROM integrations-tip.gcp_integrations_postgres.lead_data_view group by intakestatus, casetypeid ORDER BY 3 DESC LIMIT 1000

Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 16:22:53
Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 16:23:52
Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 16:24:18
Zekarias Haile (zhaile@shield-legal.com)
2025-02-24 16:24:35
Dwight Thomas (dwight@shield-legal.com)
2025-03-26 09:49:55

Hello Zekarias…,

Zekarias Haile (zhaile@shield-legal.com)
2025-03-26 09:50:24

GM, Dwight

Dwight Thomas (dwight@shield-legal.com)
2025-03-26 09:50:33

Did I leave my bag there?

Dwight Thomas (dwight@shield-legal.com)
2025-03-26 09:50:43

My laptop bag?

Zekarias Haile (zhaile@shield-legal.com)
2025-03-26 09:51:11

No, bag here

Dwight Thomas (dwight@shield-legal.com)
2025-03-26 10:34:07

I found it

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-04-11 15:24:33

2503043

Zekarias Haile (zhaile@shield-legal.com)
2025-04-11 15:33:07

2503010

Zekarias Haile (zhaile@shield-legal.com)
2025-04-22 12:33:59

https://coursera.org/share/60bef09752a9df28fa5397b8ea0e32e4

Coursera
Zekarias Haile (zhaile@shield-legal.com)
2025-04-22 12:35:46
Dwight Thomas (dwight@shield-legal.com)
2025-04-22 13:20:35

"INC-DATE": "c-1512",

Zekarias Haile (zhaile@shield-legal.com)
2025-05-12 14:02:58

https://teams.microsoft.com/l/meetup-join/19:meetingOTMzMjUzNTEtOTcwMS00ZTZmLWI3ZTUtYTlmNDIyYmJjMTI1@thread.v2/0?context=%7B%22Tid%22:%228cef5a146400450dbc43fe328fd9769e%22,%22Oid%22:%22b82053c0-1de9-4f59-b9c4-154a4ffe2b73%22%7D|https://teams.microsoft.com/l/meetup-join/19:meetingOTMzMjUzNTEtOTcwMS00ZTZmLWI3ZTUtY[…]%22,%22Oid%22:%22b82053c0-1de9-4f59-b9c4-154a4ffe2b73%22%7D

Microsoft Teams
Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 12:20:34

Good Morning Dwight, I hope you had a great flight! If you haven't seen SGGH email, they are asking to send them few Meadow case types payload. And Wanted to check on you to see if I could help

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 12:26:01

*Thread Reply:* Thank you I just got in to Milwaukee from Chicago. We should be able to provide test leaves for the main intakes the secondary intakes. We are in the testing phase now. If you could do a search for metal lead that do not have secondary interviews… You should be able to pull thepayloads to provide them with the information that’s being passed.

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 12:27:02

*Thread Reply:* I told Dustin I’m gonna need about two hours to take a nap cause I’ve been up since yesterday morning. Once I’m up and able to login I can provide you with more detailed information however you should be able to check the logs for all SGGH metal Campaigns the only ones that we did not run a test for is clergy abuse

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 12:34:24

*Thread Reply:* Got it. Yeah take rest and you will provide me more info when you up.

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 12:36:47

*Thread Reply:* Did you already sent successful test? I know last time we send regular lead's payload but wanted to check

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 15:11:30

*Thread Reply:* The Main intakes did yes.

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 15:12:14

*Thread Reply:* Just woke up…,

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 15:13:54

*Thread Reply:* Perfect, I guess we can just send few main intake payloads for them to check it

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 15:20:44

*Thread Reply:* OK, I’m logging in now.

👍:skin_tone_3: Zekarias Haile
Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:11:53

Hello Zekarias...

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:12:06

yes

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:13:02

Is there anything you need me to provide? Were you able to find the logs from Yesterday's runs?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:17:03

Can you send me the test leads that are successful, so I will try generate the intake and payload

👍:skin_tone_5: Dwight Thomas
Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:20:33

For how many campaigns were you able to send successful test? Im thinking to send them 2 or 3 case types payload... what do u think?

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:23:25

748176

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:23:46

MI Juv Hall Abuse - SGGH - Meadow Law - Darron Leland McDaniel

👍:skin_tone_3: Zekarias Haile
Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:27:56

MI Foster Care Abuse - SGGH - Meadow Law - Kimberly Kay Meek 733965

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:28:36

This are actual leads right?

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:31:30

Yes we resubmitted the jobs

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:31:46

There are two other leads I have to find

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:32:02

sounds good

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:42:51

I was able to generate the intake for the 1st one but when I tried to generate the payload it's erroring out since I dont have intake_2032 on my folder

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:44:44

I can resubmit the lead on my end

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:46:47

Did you submit 754634?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:48:08

your leads are fine... what is the branch you are working on

Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:48:44
Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:51:35

OK. Have you done lunch yet?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:53:38

Yes, I did. Thanks

👍:skin_tone_5: Dwight Thomas
Dwight Thomas (dwight@shield-legal.com)
2025-06-12 16:54:22

OK. Once you pull that branch down and test let me know what the results are.

👍:skin_tone_3: Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 16:55:27

But as Dustin replied to the email saying that we are going to send all intake and secondary's in one push... so im asking him if we have to wait to have successful test for the secondary's as well

Zekarias Haile (zhaile@shield-legal.com)
2025-06-12 17:12:23

im be able to pull the branch... Dustin told me send him all docs.. so im going to send him tomorrow morning

👍:skin_tone_5: Dwight Thomas
Dwight Thomas (dwight@shield-legal.com)
2025-06-12 17:15:32

Interested. He has access to the docs that we created from my run yesterday.

Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:42:01
Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:44:09

728724 MI YRTC SGGH ML 738785 MI YRTC SGGH ML SEC these are the leads I use for YRTC

Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 15:52:49
Zekarias Haile (zhaile@shield-legal.com)
2025-06-16 16:40:57

look in the lr-data database for integrations.integrations_log

Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 15:25:56

python .\tools\generate_intake.py leadid

Zekarias Haile (zhaile@shield-legal.com)
2025-06-18 15:26:36

python tools/payload.py 623133_intake_intake.json firm_SGGH/2022/mapping.json

Dwight Thomas (dwight@shield-legal.com)
2025-06-24 13:58:44

Do you know if we’re in conference room one or two?

Zekarias Haile (zhaile@shield-legal.com)
2025-06-24 13:59:05

one

Dwight Thomas (dwight@shield-legal.com)
2025-07-08 16:07:28
Dwight Thomas (dwight@shield-legal.com)
2025-07-08 17:06:59
👍:skin_tone_3: Zekarias Haile