deleted-U04GZ79CPNG
2024-10-02 15:19:31

• NJ Juv Hall Abuse - BG - Ghozland - Shield Legal start date: 8/30 • PA Juv Hall Abuse - BG - Ghozland - Shield Legal start date: 8/30 • New Hampshire YDC Abuse - BG - Ghozland - Shield Legal start date: 8/15 • NJ Juvenile Hall Abuse - AFG/BG - Levinson - Shield Legal start date: 8/9 • NJ Juvenile Hall Abuse - Crump - BG - BLX start date: 7/29

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2024-10-22 17:57:29

Hey Brittney, that test lead for meadow with ghoul and was a test lead. The lr automation wasn’t switched off.

deleted-U04GZ79CPNG
2024-10-22 18:06:33

Yes, I saw that from the activity log and I figured it was an inadvertent send. Meadow Law was mostly concerned that we were signing more clients on that case type and they did not want that to happen. I will let Alexandra know so she can give them an update when she speaks with them next.

deleted-U04GZ79CPNG
2024-10-22 18:08:33

Did you shut off the automation yet? If not, I can do so that way you can test whatever you need to without issue

Ahsan (ahsan@shield-legal.com)
2024-10-23 09:35:15

Yes I shut the automation off.

deleted-U04GZ79CPNG
2024-11-15 12:34:32

@Ahsan Can I call you on slack really quick?

Ahsan (ahsan@shield-legal.com)
2024-11-15 12:34:58

yea

Ahsan (ahsan@shield-legal.com)
2024-11-15 12:41:52

*Thread Reply:*

VGA Ghozland Cases.xlsx
deleted-U04GZ79CPNG
2024-11-15 13:07:51

Hello, any update on the Levinson SA numbers?

Ahsan (ahsan@shield-legal.com)
2024-11-15 13:11:41

For the Levinson we just re-triggered the other 265ish leads, those should hit the log file at 11:30 and process by 11:42

Ahsan (ahsan@shield-legal.com)
2024-11-15 13:12:02

I can send the previous log file we have currently and then send the other file once they process

deleted-U04GZ79CPNG
2024-11-15 13:12:48

Ok

Ahsan (ahsan@shield-legal.com)
2024-11-15 13:23:25

This was the previous log

2024.10.17 SA - All Gaming Clients Push from Shield.xlsx
deleted-U04GZ79CPNG
2024-11-15 13:25:42

Thank you

Ahsan (ahsan@shield-legal.com)
2024-11-15 13:25:57

once those other 265ish leads hit, will send you that as well

deleted-U04GZ79CPNG
2024-11-15 13:26:49

Awesome, thanks!

deleted-U04GZ79CPNG
2024-11-15 13:28:31

There's a broken equation for the shield legal ID

deleted-U04GZ79CPNG
2024-11-15 13:28:45

I think it's referencing another file?

Ahsan (ahsan@shield-legal.com)
2024-11-15 13:28:52

that was for a header, that can be removed

deleted-U04GZ79CPNG
2024-11-15 13:30:19

None of the tabs have SA number and our lead ID together. Looks like tab 3 is supposed to, but our lead ID is a broken equation

Ahsan (ahsan@shield-legal.com)
2024-11-15 13:34:26

I did a xlookup on the cleanmldf to match the first and last name to the id off the shield tab

deleted-U04GZ79CPNG
2024-11-15 13:35:01

Ok

deleted-U04GZ79CPNG
2024-11-15 14:14:51

I told Meadow I would have the report with the updated SA numbers around 1145. Any update?

Ahsan (ahsan@shield-legal.com)
2024-11-15 14:26:00

Leads just finished pushing into meadow, pulling th elog now

Ahsan (ahsan@shield-legal.com)
2024-11-15 14:41:45

Hey Brittney, excel file and the raw csv

VGA ML Levinson Pull 11-15-24.xlsx
bquxjob_6b2e9ed3_19331837327.csv
deleted-U04GZ79CPNG
2024-11-15 14:44:41

They needed the report 15 minutes ago for their meeting with the defense, so I sent what I had. I will send them these updates shortly.

Ahsan (ahsan@shield-legal.com)
2024-11-15 14:45:47

Sorry about that. GCP took a while to process and send the leads into their system

deleted-U04GZ79CPNG
2024-11-15 14:46:39

No worries. Thanks for sending the reports!

Ahsan (ahsan@shield-legal.com)
2024-11-15 14:46:57

That also has all the leads we have piped to them btw

Ahsan (ahsan@shield-legal.com)
2024-12-05 11:51:20

Morning Brittany, did the ERD permissions grant work?

deleted-U04GZ79CPNG
2024-12-05 12:15:43

Hello! Do you mean the database that Dustin showed me yesterday?

Ahsan (ahsan@shield-legal.com)
2024-12-05 12:16:15

yea, the ERD doc showing the relationship for the tables

deleted-U04GZ79CPNG
2024-12-05 12:17:23

Yes. Dustin gave me access to that yesterday and I didn't have any problems. I shared it with Aidan, also

👍:skin_tone_4: Ahsan
deleted-U04GZ79CPNG
2024-12-05 13:13:56

In a meeting right now with Caseworks. Has there been a a successful test push to them? I know you have other fires today, but let me know when you have a chance

Ahsan (ahsan@shield-legal.com)
2024-12-05 13:16:27

Per Daniel, no. We currently are in the middle of another test right now but dealing with this wagstaff bush fire. We have been testing their system the last 2 days. Daniel is the one on that integration so he may reach out to them tomorrow if today doesn't give us a successful test.

deleted-U04GZ79CPNG
2024-12-05 13:18:01

Ok, thank you for the update!

deleted-U04GZ79CPNG
2025-01-07 18:17:50

Please send over the SA numbers when you have a moment. I would like to get Meadow the data today if possible. If not, tomorrow asap

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2025-01-07 18:27:40

every lead for vga, we went by casetype number not name, ex 1705 is vga Levinson, vga w Crump is 1892, Ghozland 1749 I think

bquxjob_99bab1b_194434e17d8.csv
deleted-U04GZ79CPNG
2025-01-07 18:27:59

Thank you!

Ahsan (ahsan@shield-legal.com)
2025-01-07 18:28:14

intake processed is our time stamp of sending into their system

deleted-U04GZ79CPNG
2025-01-07 18:35:57

Is the external id the SA number?

deleted-U04GZ79CPNG
2025-01-07 18:38:48

Additionally, I am not showing any duplicates in the lead ID column for multiple pushes. Can you confirm for me how I would determine if there are potential duplicates to weed out?

Ahsan (ahsan@shield-legal.com)
2025-01-07 18:40:02

Oh, sorry. Dustin has the table setup to overwrite it. The dup report we had previous was from Meadow's system

deleted-U04GZ79CPNG
2025-01-22 14:48:31

Hello @Ahsan! Forwarding you an email from Meadow about them not receiving 2 clients

:copy_emoji: Ahsan
deleted-U04GZ79CPNG
2025-01-22 14:49:48

I will wait on replying until I hear back from you about their status for the integration

Ahsan (ahsan@shield-legal.com)
2025-01-22 14:52:42

doesnt look like we had a return id for these leads, refiring them now 🚀 , will let you know once we get a successful post

deleted-U04GZ79CPNG
2025-01-22 14:57:53

Thank you!

Ahsan (ahsan@shield-legal.com)
2025-01-22 15:44:36

There was some old code for mappings that was causing an error. We did the fix and pushed to prod. Just waiting on the automation to kick off for the return id

deleted-U04GZ79CPNG
2025-01-22 15:50:32

Awesome. Let me know when it is successful and I will let Ashley know

Ahsan (ahsan@shield-legal.com)
2025-01-22 15:50:56

I will just post the update in the meadow channel to keep coms simple and everyone together

deleted-U04GZ79CPNG
2025-01-22 15:52:00

Works for me

deleted-U04GZ79CPNG
2025-02-04 18:30:31

They added a new field to the VGA intakes, fyi. Injured party's phone number

Ahsan (ahsan@shield-legal.com)
2025-02-04 18:31:21

Yea we are updating the mapping and trying to fix the mappings

deleted-U04GZ79CPNG
2025-02-04 18:58:54

Ok. I just wanted to make sure you got the message

deleted-U04GZ79CPNG
2025-02-05 17:51:06

Hello! Have you started sending secondary vga interviews to meadow yet?

Ahsan (ahsan@shield-legal.com)
2025-02-05 17:51:58

No, we are still testing, one may have gotten through though as I was setting up the webhook but otherwise nothing has been sent other than a test lead.

deleted-U04GZ79CPNG
2025-02-05 17:52:38

We are getting the secondary interview reporting ready and want to include any relevant IDs. Thank you

Ahsan (ahsan@shield-legal.com)
2025-02-05 17:55:29

673531, 675786, is our test lead, 645104 was a production lead that slipped through.

deleted-U04GZ79CPNG
2025-02-05 17:56:54

Thank you