Dustin Surwill (dsurwill@shield-legal.com)
2024-12-20 14:00:34

Some of what Joe was saying I believe is private knowledge

deleted-U06C7A8PVLJ
2024-12-20 14:02:48

Copy that. My lips are sealed 🤐

Dustin Surwill (dsurwill@shield-legal.com)
2024-12-23 17:47:06

can I get the Connex DB information? @deleted-U06GD22CLDC said you could provide it

deleted-U06C7A8PVLJ
2024-12-24 08:52:27

Good morning Dustin

deleted-U06C7A8PVLJ
2024-12-24 08:52:36

Sorry for late reply I was clocked out / away from my computer

deleted-U06C7A8PVLJ
2024-12-24 08:52:45

Here is the requested info:

image.png
Dustin Surwill (dsurwill@shield-legal.com)
2025-03-17 12:53:55

*Thread Reply:* Can you forward this message instead of sending an image?

Dustin Surwill (dsurwill@shield-legal.com)
2025-01-21 16:01:44

https://apim.lawruler.com/tortintakeprofessionals/swagger/ui/index#/

👀 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-01-21 16:01:54

Thank you @deleted-U07LSBPN6D8

Dustin Surwill (dsurwill@shield-legal.com)
2025-01-21 16:04:18

Here is the code I use when I import a bunch of leads and the import wizard is not working

upload_from_csv.py
deleted-U06C7A8PVLJ
2025-01-21 16:12:53

Thank you for this code as well :catroombaexceptionally_fast: I shall look into it 🙂

Dustin Surwill (dsurwill@shield-legal.com)
2025-02-04 11:53:37

Can I get the LR Flatirons report for today?

deleted-U06C7A8PVLJ
2025-02-04 11:53:58

Sure

deleted-U06C7A8PVLJ
2025-02-04 11:54:40

You want me to let Brittany know to have it scheduled to send to you through email?

deleted-U06C7A8PVLJ
2025-02-04 11:54:50

That's how I gets it

Dustin Surwill (dsurwill@shield-legal.com)
2025-02-05 11:44:52

Can I get the LR Flatirons report for today?

deleted-U06C7A8PVLJ
2025-02-05 11:47:56

Sure however Aidan is going to send a new one (he is creating it as we speak) since he had to import stuff into import wizard

deleted-U06C7A8PVLJ
2025-02-05 11:48:00

Once he is done I can let you know

deleted-U06C7A8PVLJ
2025-02-05 11:48:14

Since what I have is from 12:02 am of today and there were changing he made to it

deleted-U06C7A8PVLJ
2025-02-05 11:48:21

So he is scheduling a new report

deleted-U06C7A8PVLJ
2025-02-05 12:00:25

Also I pushed my code for luis's end into our github project so that if anything happens to my computer and the google sheets itself it is saved lol

deleted-U06C7A8PVLJ
2025-02-05 12:00:36

Let me know if I did it correctly since I pushed it into my branch which is main

deleted-U06C7A8PVLJ
2025-02-05 12:00:57
image.png
Dustin Surwill (dsurwill@shield-legal.com)
2025-02-05 12:05:59

Give me your current copy of the FL Flatirons report and have him send his copy once done

deleted-U06C7A8PVLJ
2025-02-05 12:06:35

He just sent me his which is up to date. Do you still need mine from 12:02 am from today?

Flatirons_Benchmark_Data_2.5.25-Custom Report-2025-02-05.xlsx
Dustin Surwill (dsurwill@shield-legal.com)
2025-02-05 12:06:41

No

deleted-U06C7A8PVLJ
2025-02-05 12:06:46

kk

Dustin Surwill (dsurwill@shield-legal.com)
2025-02-05 13:14:05

Can I get yours from midnight?

deleted-U06C7A8PVLJ
2025-02-05 14:34:02
image.png
deleted-U06C7A8PVLJ
2025-02-05 14:34:07

May you send me the email so i can send to her

Dustin Surwill (dsurwill@shield-legal.com)
2025-02-05 14:51:10

integrations@shield-legal.com

deleted-U06C7A8PVLJ
2025-02-05 14:54:43

Thank you

Dustin Surwill (dsurwill@shield-legal.com)
2025-02-28 15:33:14
Flatirons Benchmark.xlsx
deleted-U06C7A8PVLJ
2025-02-28 15:40:58

Thank you !

deleted-U06C7A8PVLJ
2025-03-17 13:00:24

Sure

Dustin Surwill (dsurwill@shield-legal.com)
2025-03-17 13:02:07

That is still an image. I need the API details in a text format so I can check that I copied it correctly

deleted-U06C7A8PVLJ
2025-03-17 13:02:41

Ohh give me one second to copy the actual text of it from Nick's end

deleted-U06C7A8PVLJ
2025-03-17 13:03:23

Connex API details: API Gateway: <https://apigateway-tortintakeprofessionals-cxm.io.connexone.cloud> App client ID: 56ajeqn78m5q219ospg96t255l App client secret: 1mgfp7m488tpfopcvdrdvlpra29immdjm4dh3ciheljn10jcul3q CXM API Key : Basic Y29ubmV4OjBuMXljMG4hTw== API documentation : <https://tortintakeprofessionals-cxm-api.io.connexone.cloud/documentation>

deleted-U06C7A8PVLJ
2025-03-17 13:03:36

I completely forgot that Nick sent us this

deleted-U06C7A8PVLJ
2025-03-17 13:03:40

But I hope this helps

Dustin Surwill (dsurwill@shield-legal.com)
2025-03-17 13:04:51

I copied it correctly but am getting: '{"errors":[{"detail":"You must provide a valid token/credentials.","status":403,"title":"Forbidden"}]}'

deleted-U06C7A8PVLJ
2025-03-17 13:07:33

```Connex API details:

API Gateway: https://apigateway-tortintakeprofessionals-cxm.io.connexone.cloud App client ID: 56ajeqn78m5q219ospg96t255l App client secret: 1mgfp7m488tpfopcvdrdvlpra29immdjm4dh3ciheljn10jcul3q CXM API Key : Basic Y29ubmV4OjBuMXljMG4hTw== API documentation : https://tortintakeprofessionals-cxm-api.io.connexone.cloud/documentation```

deleted-U06C7A8PVLJ
2025-03-17 13:07:47

Yeah this is what Nick sent with the screenshot

deleted-U06C7A8PVLJ
2025-03-17 13:08:02

So if it doesn't work then sadly I don't have other credentials for it

deleted-U06C7A8PVLJ
2025-03-25 14:11:20

Hey Dustin. A little birdy told me you have a nice visual of Ryan's system and I wanted to see if I can take a look at it as well :meow_attention:

Dustin Surwill (dsurwill@shield-legal.com)
2025-03-25 14:23:33

I shared it with you, you have to open it in diagrams.net. here is a link that should work: https://app.diagrams.net/#G1o-6-eOAA80iEJ_MhhObt5bBpK9zEXu2p

app.diagrams.net
Flowchart Maker &amp; Online Diagram Software
<a href="http://draw.io">draw.io</a> is free online diagram software for making flowcharts, process diagrams, org charts, UML, ER and network diagrams
Original URL: https://app.diagrams.net/#G1o-6-eOAA80iEJ_MhhObt5bBpK9zEXu2p
deleted-U06C7A8PVLJ
2025-03-25 14:24:19

Thank you !

deleted-U06C7A8PVLJ
2025-03-25 14:24:31

Looks massive 🤯

deleted-U06C7A8PVLJ
2025-03-25 14:25:00

New system should just do Leadspedia to LR to GCP and maybe one or two more systems but yeah

deleted-U06C7A8PVLJ
2025-03-25 14:25:14

(Well a lot less than this) :meow_attention:

Dustin Surwill (dsurwill@shield-legal.com)
2025-03-25 14:25:29

The table in the financial dashboard is the orange one at the far right dashboard.matview.matview_financial_details

Dustin Surwill (dsurwill@shield-legal.com)
2025-03-25 14:25:39

This is only for the shield dashboard table

deleted-U06C7A8PVLJ
2025-03-25 14:26:08

Gotcha

deleted-U06C7A8PVLJ
2025-03-25 14:26:16

So there's more ? (Aka TIP dashboard) lol

Dustin Surwill (dsurwill@shield-legal.com)
2025-03-25 14:26:30

yes we did not do that one

deleted-U06C7A8PVLJ
2025-03-25 14:29:04

Ah i see. I could only imagine how that one looks lol

Dustin Surwill (dsurwill@shield-legal.com)
2025-04-14 13:03:49

commit messages should not be this long: https://github.com/shield-legal/Benchmark-Script/commit/85f943a995904818f1885368580011cccd06df71 It looks like most of the message should go into a file

Dustin Surwill (dsurwill@shield-legal.com)
2025-04-14 13:04:23

good commit messages are: [one line summary (think like email subject)] [multi-line description if more detailed information is necessary, but assume it will only be looked at if there was a problem with the changes in that commit]

deleted-U06C7A8PVLJ
2025-04-14 13:04:51

Copy that @Dustin Surwill I can do my commits as one or two sentences if needed

deleted-U06C7A8PVLJ
2025-04-14 13:18:42

*Thread Reply:* Git commit messages Git commit messages 2 For our projects I can limit our git commit messages to be smaller however from what I am seeing in general they can be paragraphs too. I just like being detailed so I don't have to remember it later on lol

Dustin Surwill (dsurwill@shield-legal.com)
2025-04-14 13:19:42

*Thread Reply:* But flow charts and documentation should not be in the commit message

deleted-U06C7A8PVLJ
2025-04-14 13:19:59

*Thread Reply:* Ohhh gotcha. I can leave that as a comment then

deleted-U06C7A8PVLJ
2025-04-14 13:20:06

*Thread Reply:* Thanks for the pointer

Dustin Surwill (dsurwill@shield-legal.com)
2025-04-14 13:20:17

*Thread Reply:* Or in a file, markdown or txt

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-04-14 13:20:29

*Thread Reply:* That is true !

Dustin Surwill (dsurwill@shield-legal.com)
2025-04-14 13:06:15

good commit messages are: [one line summary (think like email subject)] [multi-line description if more detailed information is necessary, but assume it will only be looked at if there was a problem with the changes in that commit]

deleted-U06C7A8PVLJ
2025-07-11 18:19:14

For the shield project since May I have access to create cloud functions please 🙏

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-11 18:31:28

Shield Legal BI?

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-11 18:31:56

Done

deleted-U06C7A8PVLJ
2025-07-11 18:52:35

Yes 🙌 Thank you

deleted-U06C7A8PVLJ
2025-07-11 18:52:45

I shall check if I have access shortly just getting home

deleted-U06C7A8PVLJ
2025-07-11 19:14:18

Thank you I now have access ✅

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-15 19:49:19

You do not have to include Alex on every message. You do not have to mention me on every message.

deleted-U06C7A8PVLJ
2025-07-15 19:52:10

Sounds good

deleted-U06C7A8PVLJ
2025-07-15 19:52:33

I can see you added those case types and looks like everything is on there. I appreciate your help on this 🙂

deleted-U06C7A8PVLJ
2025-07-15 19:52:56

Also I just let alex know in general since it is her department (and she also helped me for some of the dashboards) as a friendly heads up

deleted-U06C7A8PVLJ
2025-07-15 19:53:20

But I will just keep it between you and I if I have questions about the database, shield website, etc

👍 Dustin Surwill
deleted-U06C7A8PVLJ
2025-07-15 19:54:22

Sorry one last question. Around what type typically these bigquery tables are created / updated? I won't work on these until tomorrow but just want to know just in case they ask. I think you said 4 am??

deleted-U06C7A8PVLJ
2025-07-15 19:54:28

what time **

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-15 19:55:04
image.png
deleted-U06C7A8PVLJ
2025-07-15 19:56:07

Thank you! Okay sounds good

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-30 11:17:08

Are you going to need assistance to update the scripts to use the csv instead of xlsx?

deleted-U06C7A8PVLJ
2025-07-30 11:22:06

I am willing to take any help I can get but I think I should be fine for that tbh

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-30 11:33:52

Alameda County Juv Hall - DL - Flatirons - Shield Legal - backfill 7/27 Bard PowerPort - DL - Flatirons - Shield Legal - backfill 7/24 Hair Salon Bladder Cancer - DL - Flatirons - Shield Legal - backfill 7/29 Mormon Victim Abuse OSOL - DL - Flatirons - Shield Legal - backfill 7/28 NJ Juvenile Hall Abuse - DL - Flatirons - Shield Legal - backfill 7/27 NV YRTC - DL - Flatirons - Shield Legal - backfill 7/29 PA Juvenile Hall Abuse - DL - Flatirons - Shield Legal - 7/29 San Bernardino Juv Hall - DL - Flatirons - Shield Legal - backfill 7/27

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-31 11:58:39

https://github.com/awesome-selfhosted/awesome-selfhosted

🙌:skin_tone_2: deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-08-04 11:34:49

He filtered the last column in the first tab; I would remove the filters to see which case type numbers he included

deleted-U06C7A8PVLJ
2025-08-04 11:35:05
image.png
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-04 11:42:37

About a third we have log of sending

Flatirons Reconciliation 8-01-2025 (1).xlsx
🫡 deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-08-04 18:20:19

These are the ones that didn't get API over the weekend / friday (signed dates are friday - sunday). Just in case you want to see the ones that didn't pass through. The other 60-ish (which are not in this report) were successful so I removed them from this report. So these 7 clients aren't on the MRT

Flatirons_Audit_8-4-2025-Custom Report-2025-08-04.xlsx
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-04 18:21:21

leadid,processedat,response 815735,2025-08-04 20:41:11.220885,"

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-04 18:22:41

leadid,processedat,response 815735,2025-08-04 20:41:11.220885,"