instant soup 2 is my next campaign
800664 373279 777419 797053 745826
@Richard Schnitzler 600 Michigan Juv Hall Abuse DL BG Flatirons
@Richard Schnitzler 2064 instant soup 2, there is 1 customfield at the injured party role. ignore that, its already been resolved
*Thread Reply:* Line 584: "phone": "c-25878-15",
*Thread Reply:* Yeah that's the one i mentioned has been fixed lol
*Thread Reply:* Ah, I see, good, first cup of coffee lol, your good then !
*Thread Reply:* no worries. i'm working off of just my laptop screen so i get it
I might just come into the office at some point tomorrow as it’ll be easier to work with the monitors lol
Sounds like the office is open on the weekends and the old times were 8-4:30 but it sounds like it has expanded
Do you know for how long? I wouldnt come in until maybe 5:30
@Zekarias Haile hey I am reviewing your mapping.json now. you missed a few fields in the account, and alot of fields in the roles
*Thread Reply:* I will take a look tomorrow. Can you share some of the missed fields please?
*Thread Reply:* I already fixed them and sent a test but the signer account was missing fields and the signer role was missing all the fields. I think one of the providers was missing fields as well
@Dustin Surwill I'm starting to notice that the question about the injured party being deceased is more common that originally thought. perhaps a function should be created for it
Los Padrinos is ready to be tested
@Dustin Surwill let me know when 1977 is on the new endpoint i'll send a test
*Thread Reply:* test is not in the mapping?
*Thread Reply:* ah right, i'll add that. good catch
*Thread Reply:* once its added to endpoint i'll make adjustment to api triggers
Paraquat 13 , 1998 is up as well now and can be tested
*Thread Reply:* adjust api_triggers and send test to generate json for Richard
*Thread Reply:* is 1977 good too?
*Thread Reply:* Make a log of which lead_ids you used for json vs prod test
*Thread Reply:* these two tests will be what i can send for the time being i'll try to work later tonight as well
alameda county will be the next one i work on
802221 - 1977 - Los Padrinos test 714613 - 1998 - Paraquat 13
tests will come in at 11:30. I won't be able to get them initially to richard maybe in an hour or two
@Richard Schnitzler 1998 Paraquat
*Thread Reply:* Should we be leaving an empty provider role in the mapping?
*Thread Reply:* I thought it wasn’t empty. Let me double check
*Thread Reply:* I thought i made the adjustments
@Richard Schnitzler Does the the checkmark mean they are good? I do not believe that reactions notify the poster, please reply in a thread that they are good.
Yes @Dustin Surwill I was marking them as reviewed with the checkmark, I can comment to alert
@Dustin Surwill looks like i mixed the two up, first one is 1977 the second one is 1998
but i removed the empty provider from 1977
@Dustin Surwill do you remember what we decided would be the role category for the "Court appointed special advocate"
*Thread Reply:* Currently i made it "Contact"
suggestion @Dustin Surwill. make a check against every campaign's injured party's birthday and if so change the role category to CHILD - MINOR
so once its at the new endpoint and i trigger the api we can test it
I will start MD Juv Hall Abuse - DL/BG - Flatirons - Shield Legal now
Thats the one Im working on. See my message at 5:56PM
Mormon Victim Abuse OSOL - DL - Flatirons - Shield Legal 2001
2001 has been added to git and ready to test as well
I plan on going to the office tomorrow afternoon
Timing just not working out great. Also just not really in the middle of anywhere I plan on driving to so it makes it’s kind of out of the way on the weekend
Paraquat - LegaFi - DL - Shield Legal next campaign im working on 1987
1987 initial pull request created and on git. once on the new endpoint it is also ready to test.
@Daniel Schussler Once the PR has the files for the campaign and test is in the mapping change api_triggers so you get the payload for Richard.
Once he approves, remove test from the mapping then resend to send them the test. Make sure to keep a log of which leads you have used
@Dustin Surwill I thought you needed to add them to the new main py so they would send to the new endpoint
No, once the mapping is updated that is what they will do see below:
Ok then if they are all already in the right spot, I’ll update the api triggers and send tests
@Daniel Schussler for your question about CASA, review https://dicellolevitt.atlassian.net/wiki/spaces/shl/pages/51150864/Alameda+County+Juv+Hall-DL-Flatirons-Shield+Legal-2044 & the list of roles that they have sent
@Daniel Schussler for your question about CASA, review https://dicellolevitt.atlassian.net/wiki/spaces/shl/pages/51150864/Alameda+County+Juv+Hall-DL-Flatirons-Shield+Legal-2044 & the list of roles that they have sent
@Daniel Schussler I added a behind the scenes check for injuredparty age and utility functions for decedent
Tests sent 1987 - 705539 - Paraquat legafi 2001 - 801056 - Mormon OSOL 2044 - 778522 - Alameda County
ill be at the gym for a bit so i won't be able to send the files to richard immediately
*Thread Reply:* Looks good from myside, reviewed
isn't 1955 done already @Dustin Surwill
1987 and 2001 failed i'll check later
*Thread Reply:* Line 20 & 785 "mailingState": "c-255875",
@Daniel Schussler Once Richard approves your payloads and retrigger to send to dl, let me know. I plan on sending an update email later tonight with all the leads we sent as tests this weekend
Out at the moment, will update as soon as I am back home
File "/workspace/main.py", line 61, in main
new_endpoint(obj)
File "/workspace/new_endpoint.py", line 36, in new_endpoint
importlib.import_module(f"{obj.log_row['case_type_id']}.main").main(obj)
File "/workspace/2001/main.py", line 9, in main
update_mailing_street_obj(obj, 'Signer', "c-25852", "c-25853")
File "/workspace/new_endpoint.py", line 217, in update_mailing_street_obj
obj_with_name["mailingStreet"] = f"{address1} {address2}".strip()
~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
TypeError: 'str' object does not support item assignment
is there a problem with the address street function
L9 in 2001 main.py. you are passing a str instead of a role object. Change the function call to _name instead of _obj to fix
looks like thats what is probably the issue with 1987 even though it didn't show
<https://us-west4-integrations-tip.cloudfunctions.net/1987-firm_DiCello_Levitt>
api_triggers was not set correctly for 1987
ah looks like i put 1987 instead of test on the api url
Type II Child Diabetes - DiCello Levitt - DiCello Levitt - Shield Legal 1908 is my next one
NJ Juvenile Hall Abuse - DL - Flatirons - Shield Legal 1806
current tests 1806 - 802905 - NJ juv hall 1987 - 705539 - Paraquat legafi 2001 - 801056 - Mormon OSOL 2044 - 778522 - Alameda County
@Dustin Surwill 1987 - 705539 - Paraquat legafi sent to DL
@Richard Schnitzler please review my payloads from yesterday between 1:47 pm & 4:25 pm
*Thread Reply:* Done, not sure why I missed it
@Dustin Surwill richard confirmed 2044 , ok to send to DL ?
2044 - 778522 - Alameda County test sent to DL
1806 - 802905 - NJ juv hall sent to DL 1987 - 705539 - Paraquat legafi sent to DL 2044 - 778522 - Alameda County test sent to DL
current tests 1977 - 802221 - Los Padrinos 2001 - 801056 - Mormon OSOL
1806 - 802905 - NJ juv hall sent to DL 1987 - 705539 - Paraquat legafi sent to DL 1998 - 714613 - Paraquat 13 sent to DL 2044 - 778522 - Alameda County test sent to DL
Mormon Victim Abuse - DL - Flatirons - Shield Legal 2000 my next campaign
1806 - 802905 - NJ juv hall sent to DL 1977 - 723033 - Los Padrinos sent to DL 1987 - 705539 - Paraquat legafi sent to DL 1998 - 714613 - Paraquat 13 sent to DL 2044 - 778522 - Alameda County test sent to DL
current tests 2001 - 801056 - Mormon OSOL
Good morning guys, I can do one mapping today @Daniel Schussler can you let me know which campaign you want me to work on? sorry I wasn’t able to help out in the weekend.
@Zekarias Haile i dont think we started this one yet.
2000 - 743970 - Mormon DL Flat testing
2001 - 801056 - Mormon OSOL sent to DL
starting Type II Child Diabetes - DiCello Levitt - DiCello Levitt - Shield Legal1908
AZ YRTC - DL - Flatirons - Shield Legal 1975 starting
*Thread Reply:* Looking good! Approved
2000 - 743970 - Mormon DL Flat sending to DL
Instant Soup Cup Child Burns - DL - Flatirons - Shield Legal 2015 being created
2015 - 720165 - Instant Soup testing
*Thread Reply:* Just starting, I was doing other stuff
Ethylene Oxide - DL - Flatirons - Shield Legal 1839 starting
1975 - 710589 - AZ YRTC sending to DL
2015 - 720165 - Instant Soup sending to DL
*Thread Reply:* Got a issue on 412: "businessName": "c-26186",
Otherwise loos good!
Hair Relaxer Cancer - Crump/Dicello - Shield Legal 303 starting on
Regarding test emails, @Dustin Surwill and his team should be using a singular email address that is easily identifiable for any user to recognize as a test.
*Thread Reply:* Send it! Approved!
1839 - 623438 - Ethylene Oxide sending to DL
Salon Professional Bladder Cancer - Dicello - Shield Legal 556 next
303 - 110658 - Hair relaxer cancer testing
556 - 321897 - Salon Professional Bladder testing
San Diego Juv Hall YRTC - DL - Flatirons - Shield Legal 2042 starting
303 - 110658 - Hair relaxer cancer Sent to DL
*Thread Reply:* Line 446 & 12. last Name on Signer & Account
@Richard Schnitzler last name has been fixed
*Thread Reply:* Need Case Type and Parent matter, right?
*Thread Reply:* @Richard Schnitzler This has case type and parent matter
*Thread Reply:* Looks good, approved!
LA Wildfires - DL - Flatirons - Shield Legal 1941 starting
*Thread Reply:* why did you skip 2009, 171, 1686, 1675, 1791, 1822?
*Thread Reply:* oh i legit thought it was just the next one
*Thread Reply:* i'll do one of those next
*Thread Reply:* @Daniel Schussler when you build the main.py remove_bad_email(obj, 'c-29318') to it
556 - 321897 - Salon Professional Bladder sent to DL
1941 - 682892 - LA wildfires testing
Do NOT push until morning. 303 is backfilling and a push may skip or only partially process some leads
Trinity Private School Abuse - DL - Flatirons - Shield Legal 2009 next for me
Starting on Illinois Juv Hall Abuse TV - DL/BG - Flatirons - Shield Legal 1717
2046 - 754888 - Kanakuk Kamps testing
https://dicello-my.sharepoint.com/personal/mabramowitzdicellolevittcom/layouts/15/onedrive.aspx?id=%2Fpersonal%2Fmabramowitz%5Fdicellolevitt%5Fcom%2FDocuments%2FSL%20API%20data%20notebooks%2FQuestionnaire%20Data%20Maps&ga=1|https://dicello-my.sharepoint.com/personal/mabramowitzdicellolevittcom/layouts/15/oned[…]PI%20data%20notebooks%2FQuestionnaire%20Data%20Maps&ga=1 1941 - 682892 - LA wildfires sent to DL 1976 - 800635 - NV YRTC sent to DL
*Thread Reply:* @Richard Schnitzler approved
MD Juv Hall Abuse - DL - Flatirons - Shield Legal 1675 starting
1675 - 806462 - MD juv hall testing
*Thread Reply:* Negative on this one chief, missing case type, parent matter, and I see a whole mess of c- and blank fields
*Thread Reply:* Error of somekind?
*Thread Reply:* @Richard Schnitzler
*Thread Reply:* Much better! Approved
2046 - 754888 - Kanakuk Kamps sent to DL
2009 - 713984 - Trinity sent to DL
<Response [500]> [{"errorCode":"APEX_ERROR","message":"System.LimitException: Apex CPU time limit exceeded\n\nClass.MatterWebServiceHelper.removeBlankQuestionsInList: line 533, column 1\nClass.MatterWebServiceHelper.checkDuplicateQuestionnaires: line 502, column 1\nClass.MatterWebServiceHelper.mapQuestionnaires: line 191, column 1\nClass.MatterWebServiceHelper.mapMatterCreationRequest: line 111, column 1\nClass.MatterWebService.doPost: line 31, column 1"}]
2016 - Polinsky Childrens Center Abuse - DL - Flatirons - Shield Legal - starting
2016 - Polinsky Childrens Center Abuse - DL - Flatirons - Shield Legal - starting
Starting New Hampshire YDC Abuse - DL - Flatirons - Shield Legal - 1791
*Thread Reply:* ParentMatterID & CaseTypeID not available
*Thread Reply:* Skip for now. Do we have the questions? - Yes Check the questions xlsx
2009 - 713984 - Trinity re sending to DL 2016 - 785825 - Polinsky testing
NJ Juvenile Hall Abuse SEC - DL - TC - DiCello Levitt - 1822 - starting
*Thread Reply:* This is in the sharepoint drive
*Thread Reply:* i looked for it couldn't find it. i'll jump on it after
@Dustin Surwill we don't have the questionnaire map for ^
Porterville Developmental Center Abuse - DL - Flatirons - Shield Legal - 2041
2009 - 713984 - Trinity re sent to DL 2016 - 785825 - Polinsky sent to DL
1791 - 748367 - New Hampshire testing
2041 - 807826 - Portersville testing 2042 - 782762 - San Diego Testing 1675 - 806462 - MD juv hall testing
2042 - 782762 - San Diego Testing 1675 - 806462 - MD juv hall testing
2041 - 807826 - Portersville testing 2042 - 782762 - San Diego Testing 1675 - 806462 - MD juv hall testing
@Richard Schnitzler I reviewed 1791 and approve it
@Dustin Surwill extra set of eyes if you wish
2041 - 807826 - Portersville sent to DL
2042 - 782762 - San Diego sent to DL
606 is Mapped and Committed Needs a Test to review
1791 - 748367 - New Hampshire sent to DL
1675 - 806462 - MD juv hall sent to DL
*Thread Reply:* theres a first name / last name issue . richard suggested account
Starting Hair Relaxer PFS - Dicello Levitt - 1663
*Thread Reply:* No questions on Confluence & SharePoint
*Thread Reply:* Beautiful, approved
1804 - 808894 -st paul test above
Illinois Juv Hall Abuse TV - DL/BG - Flatirons - Shield Legal 1717 Should be ready to test and review
current update 1675 - 806462 - MD juv hall (first / last name error needed) 1804 - 808894 -st paul test needs validation 1822 - Dustin working on 2045 - Dustin working on 2072 - mirror of 2043 test can be sent if necessary 606 - test lead needs to be created and tested 1717 - test leads needs to be created and tested 1995 - has not been created yet. last campaign
current update 1675 - 806462 - MD juv hall (first / last name error needed) 1804 - 808894 -st paul test needs validation 1822 - Dustin working on 2045 - Dustin working on 2072 - mirror of 2043 test can be sent if necessary 606 - test lead needs to be created and tested 1717 - test leads needs to be created and tested 1995 - has not been created yet. last campaign
1804 - 808894 -st paul sent to DL
1717 - 809062 - illinois juv hall test
1675 - 806462 - MD juv hall sent to DL
32>30 Field limit to 30 on that 'Relationship' field
1995 - 733196 - la wildfires flyers testing
@Richard Schnitzler 1995 resident zip on 4 is fixed
2072 - 753806 - San Bern DL DL test
1995 - 733196 - la wildfires flyers sent to DL
whats left 1822 - Dustin working on 2045 - Dustin working on 606 - test lead needs to be created and tested 1717 - testing
1822 & 2045 should be ready for testing if you want to do that
also investigating an error with 2072
File "/workspace/new_endpoint.py", line 37, in new_endpoint
importlib.import_module(f"{obj.log_row['case_type_id']}.main").main(obj)
File "/workspace/2072/main.py", line 9, in main
update_mailing_street_obj(obj, 'Signer', "c-25852", "c-25853")
File "/workspace/new_endpoint.py", line 283, in update_mailing_street_obj
obj_with_name["mailingStreet"] = f"{address1} {address2}".strip()
~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
TypeError: 'str' object does not support item assignment
Should be calling update_mailing_street_name
for 1822, would i flip it to re-triggered or from secodary to dispo to secondary completed
2045 - 738762 - Santa Clara testing
@Dustin Surwill 1717 richards. Looked good on my end.
@Richard Schnitzler is 1663 mapping done?
*Thread Reply:* No, still needs questions, and the questions we had didn't all have custom fields, so as much as I was able I did, don't think we want to test that yet
1717 - 809062 - illinois juv sent to DL
1822 - needs test lead 2045 - 738762 - Santa Clara testing 606 - test lead needs to be created and tested 1717 - sent to DL 1663 - ????
*Thread Reply:* Seeing 68 questions with a 'c-' in the answer
*Thread Reply:* Line 807: "businessName": "c-16014",
@Dustin Surwill 1822 test lead created 809945
im assuming i flip it between secondary completed and dispo?
or is there a status i want to avoid
Secondary retriggered. Do not set the automation for secondary completed atm
@Daniel Schussler avoid secondary completed atm
ok i haven't done anything yet with the lead
2072 - needs confirming 2045 - needs confirming 606 - QA still 1663 - test lead i believe created 1822 - test lead created
606 - 809311 - tepezza DL flat sent to DL
if successful we will just have the two tests to confirm and send and the two secondaries left.
not much more i can do without the confirmation of the other campaigns
2072 - 753806 - san bernardino dl dl sent to DL successfully with 201
2045 - 738762 - Santa Clara sending to DL
1822 - 809945 - NJ juv SEC sent to DL
1663 - 809965 - hair relaxer pfs sent to DL
@Daniel Schussler @Richard Schnitzler Here are all the changes for the comments that Sikich made with the last batch of tests: https://github.com/shield-legal/gcp-integrations/pull/235/commits/5e2905a70e929f7b9aadffede260d9ad9f36e887
how should shrink Hospital of Declared Brain/Circulatory Death by 4 chars?
"Declared Brain/Circulatory Death Loc." ?
@Nicholas McFadden has joined the conversation
researched the mapping of 1663, there is no questions for the signer. when that is the case we pull information from the injured party to fill the empty fields. judging the payload, the middle name of the lead ended up in the role. would the function see that and decided that the signer and injured party are different? @Dustin Surwill
injured party does not have the middle name in that field
yeah the middle name was in the signer first name field, probably why the injured party info didn't populate
@Richard Schnitzler @Daniel Schussler Please review this snippet for the new doc endpoint, specified here: https://dicellolevitt.atlassian.net/wiki/spaces/shl/pages/67665921/Document+Upload+Web+Service+Work+in+Progress+Document ```def newuploaddocs(obj: IntegrationMappingObject, matter_id: str): postgres = obj.postgres
urls_data = {
'matterId': matter_id,
'documents': [{
'documentName': filename,
'type': guess_type(filename)[0]
} for filename, content in obj.attachments]
}
logs = []
urls = <a href="http://requests.post">requests.post</a>('<https://dicellolevitt--dlfull.sandbox.my.salesforce.com/services/apexrest/DocumentUpload>', json=urls_data)
logs.append(['Create signed URLs', urls.__str__(), urls.text])
postgres.update_document_response(obj.log_row['id'], json.dumps(logs))
urls_json = urls.json()
signed_urls = {doc['documentName']: doc['signedUrl'] for doc in urls_json['documents']}
for filename, content in obj.attachments:
signed_url_response = requests.put(signed_urls[filename], data=b64encode(content), headers={'Content-Type': guess_type(filename)[0]})
logs.append([filename, signed_url_response.__str__(), signed_url_response.text])
postgres.update_document_response(obj.log_row['id'], json.dumps(logs))
complete_data = {'ids': [doc['fileId'] for doc in urls_json['documents']]}
complete = <a href="http://requests.post">requests.post</a>('<https://dicellolevitt--dlfull.sandbox.my.salesforce.com/services/apexrest/DocumentUpload/Complete>', json=complete_data)
logs.append(['Complete signed URLs', complete.__str__(), complete.text])
postgres.update_document_response(obj.log_row['id'], json.dumps(logs))```
@Richard Schnitzler @Daniel Schussler Please review this snippet for the new doc endpoint, specified here: https://dicellolevitt.atlassian.net/wiki/spaces/shl/pages/67665921/Document+Upload+Web+Service+Work+in+Progress+Document ```def newuploaddocs(obj: IntegrationMappingObject, matter_id: str): postgres = obj.postgres
urls_data = {
'matterId': matter_id,
'documents': [{
'documentName': filename,
'type': guess_type(filename)[0]
} for filename, content in obj.attachments]
}
logs = []
urls = <a href="http://requests.post">requests.post</a>('<https://dicellolevitt--dlfull.sandbox.my.salesforce.com/services/apexrest/DocumentUpload>', json=urls_data)
logs.append(['Create signed URLs', urls.__str__(), urls.text])
postgres.update_document_response(obj.log_row['id'], json.dumps(logs))
urls_json = urls.json()
signed_urls = {doc['documentName']: doc['signedUrl'] for doc in urls_json['documents']}
for filename, content in obj.attachments:
signed_url_response = requests.put(signed_urls[filename], data=b64encode(content), headers={'Content-Type': guess_type(filename)[0]})
logs.append([filename, signed_url_response.__str__(), signed_url_response.text])
postgres.update_document_response(obj.log_row['id'], json.dumps(logs))
complete_data = {'ids': [doc['fileId'] for doc in urls_json['documents']]}
complete = <a href="http://requests.post">requests.post</a>('<https://dicellolevitt--dlfull.sandbox.my.salesforce.com/services/apexrest/DocumentUpload/Complete>', json=complete_data)
logs.append(['Complete signed URLs', complete.__str__(), complete.text])
postgres.update_document_response(obj.log_row['id'], json.dumps(logs))```
as far as i can see everything looks good
Same, i have issues with this Doc, but your code looks fine