yes, I see that link but the one that was not exported was Chowchilla - Van - Long Form Interview - VAN - Shield Legal
Eric3 John4|Illinois Juvenile Hall Abuse - BG - Bay Point - Shield Legal|Test Lead Trigger Lead # 617605
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.
scripts\sql_proxy.bat 3306 integrations-tip gcp-integrations
scripts\sql_proxy.bat 3307 tort-intake-professionals lr-data
( 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%'
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
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
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
*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.
*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
*Thread Reply:* Got it. Yeah take rest and you will provide me more info when you up.
*Thread Reply:* Did you already sent successful test? I know last time we send regular lead's payload but wanted to check
*Thread Reply:* The Main intakes did yes.
*Thread Reply:* Perfect, I guess we can just send few main intake payloads for them to check it
*Thread Reply:* OK, I’m logging in now.
Is there anything you need me to provide? Were you able to find the logs from Yesterday's runs?
Can you send me the test leads that are successful, so I will try generate the intake and payload
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?
MI Juv Hall Abuse - SGGH - Meadow Law - Darron Leland McDaniel
MI Foster Care Abuse - SGGH - Meadow Law - Kimberly Kay Meek 733965
There are two other leads I have to find
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
your leads are fine... what is the branch you are working on
https://github.com/shield-legal/gcp-integrations/tree/SGGH_Integrations_060425
Yes, I did. Thanks
OK. Once you pull that branch down and test let me know what the results are.
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
im be able to pull the branch... Dustin told me send him all docs.. so im going to send him tomorrow morning
Interested. He has access to the docs that we created from my run yesterday.
728724 MI YRTC SGGH ML 738785 MI YRTC SGGH ML SEC these are the leads I use for YRTC
look in the lr-data database for integrations.integrations_log
python .\tools\generate_intake.py leadid
python tools/payload.py 623133_intake_intake.json firm_SGGH/2022/mapping.json
Do you know if we’re in conference room one or two?