 ../
|
PrivLogQC/
|
895
(10 months ago)
by nino.borges:
Removing client specific names, as this is for all cases.
|
|
RelativitySearchReport/
|
904
(9 months ago)
by nino.borges:
Having the program quit excel resulted in some issues so changing it so that it only closes the workbook after a save instead.
|
ATT-MalTest.py
|
885
(10 months ago)
by nino.borges:
A program to create an ATT MAL and test entries against it.
|
|
ATT-PrivDescriptionConcat.py
|
886
(10 months ago)
by nino.borges:
This very simple program will concatenate the fields for the priv description.
|
|
ATT-PrivLogQC.py
|
887
(10 months ago)
by nino.borges:
This program will assist with the process of performing QC on past and present AT&T privilege logs.
|
|
Amazon-AnalyzeNamesDeepNormOutput.py
|
871
(15 months ago)
by nino.borges:
This program will assist with analyzing the more complex 'deep' output logs from the Names Norm program. This will take in all of the vals output files and the priv log,
and will compare the high confidence downgrades and upgrades to determine if these were changed, if there are any surviving attorney values in the legalSource field.
|
|
Amazon-AnalyzeNamesNormOutput.py
|
841
(15 months ago)
by nino.borges:
This program will assist with analyzing the output logs from the Names Norm program. The team has various levels of issues and this will put the higher issues into a sep file,
making the process of finding these easier while not getting rid of those other lower priority issues.
|
|
Amazon-PastFlaggedNamesCheck.py
|
840
(15 months ago)
by nino.borges:
This very simple program will attempt to locate, using just first name and last name, any names that have been flagged in the past as non-attorneys.
|
|
Amazon_ConsilioToFullNamesOveride.py
|
845
(15 months ago)
by nino.borges:
Updated this to use RE for the email matching. too many non-email values mixed in here, as the file from consilio is messy.
|
|
Amazon_NameSearches.py
|
848
(15 months ago)
by nino.borges:
Now that I make the NamesNormQC a library and I'm not running code in it, I'm able to now call that instead of trying to mirror it here, which was a mess. Much better.
|
|
Amazon_NamesNormQC.py
|
877
(14 months ago)
by nino.borges:
Adds a new integrity check that will look for email addresses outside of email address fields in the MAL. Also updated the existing email address integrity check to do a better job of finding duplicates across work email and alt email.
|
|
Amazon_PerformDeepNamesNormQC.py
|
872
(15 months ago)
by nino.borges:
Added support for writing the "to Field" or "from Field" information to the issue messages, in advance of possibly making this a single report. Also going to eventually make this so it itterates over a list and not doing these one by one.
|
|
Amazon_PerformMalIntegrityChecks.py
|
880
(13 months ago)
by nino.borges:
Added support for looking for duplicate numbers on the attorney and Downgrade tabs and looking for rows where Last name is missing but first name exists.
|
|
Amazon_PerformNamesNormQC.py
|
849
(15 months ago)
by nino.borges:
Now that I make the NamesNormQC a library and I'm not running code in it, I'm able to now call that in other programs. Due to that, I moved the run code here.
|
|
Amazon_PrivLogQC.py
|
881
(13 months ago)
by nino.borges:
No substantial changes to logic, just adding more header rows. Going to update logic on next version, so setting this one here as clean.
|
|
CsvRowCompare.py
|
779
(3 years ago)
by nino.borges:
This program will take two CSV files and do a row to row compare. For this to work both CSVs need to have the same colums.
Set colOmitList to FALSE if you dont want it to parse at all and remove any columns. for that to work though you have to normalize the date
and number fields.
NOTE: the concur data HAS pipes in it, so verify each report.
|
|
Endo2010CopyCompareWProd.py
|
778
(3 years ago)
by nino.borges:
This program will take exports from the 2010Copy database and, using a unique key like CallID or stdActivity,
compare these entries with SIF2007Backup or SIF 2008-2012 entries and generate a report that, on select fields
will show how the matched field compares. The csvs should be checked for field consistency across the files
and a fieldCompare matrix will need to be created, since field names wont be the same.
Also there is almost ALWAYS pipes in the data, so you will either need to manually fix after or before OR start using csv lib.
|
|
Endo2017BackupCSVMassSearch.py
|
781
(3 years ago)
by nino.borges:
general updates
|
|
EndoConcurDataMerge.py
|
777
(3 years ago)
by nino.borges:
This program will inspect and then combine a large set of spreadsheets with multiple tabs of Concur export data.
This is to compare this new merger with a previous merger performed by endo/apks.
|
|
EndoCsvFieldDataExtractor.py
|
776
(3 years ago)
by nino.borges:
Very simple program that will read a CSV and export a column to a text file for me.
|
|
EndoFieldsFlaggedForProdReport.py
|
781
(3 years ago)
by nino.borges:
general updates
|
|
EndoFieldsFlaggedSummaryReport.py
|
775
(3 years ago)
by nino.borges:
This program will take the results from the marked-up table-field report
and export a summary of how many fields are selected as which flag per table.
|
|
EndoIGChgReqSysToServer.py
|
790
(3 years ago)
by nino.borges:
edited to be able to use this file to test the auxilium top level files. will need to edit this to use the different sources, like going back to service now.
|
|
EndoIGServerAnalyzer.py
|
793
(2 years ago)
by nino.borges:
Added support for other Domains SQL Servers Matrix.
|
|
EndoMultipleRowDataCompare.py
|
763
(4 years ago)
by nino.borges:
This program will take the results from EndoMultipleTableFieldCompare and will check the rows in those tables to see if they are also the same. This is slightly less useful if you only have a top 50 row sample. better if it's the full table dumps.
|
|
EndoMultipleTableFieldCompare.py
|
781
(3 years ago)
by nino.borges:
general updates
|
|
EndoTableFieldNameSearch.py
|
781
(3 years ago)
by nino.borges:
general updates
|
|
EndoXlsFieldDataExtractor.py
|
781
(3 years ago)
by nino.borges:
general updates
|
|
Lilly-DataFlowSearch.py
|
825
(20 months ago)
by nino.borges:
version .06, also used this for searching for other key terms, like for mobile apps.
|
|
McDonaldsCsvSearch.py
|
792
(2 years ago)
by nino.borges:
A simple program that will read a CSV and perform searches, exporting results and a report
|
|
McDonaldsDispoTools.py
|
794
(2 years ago)
by nino.borges:
a set of functions that I can call which will help me with the 2 ePower disposition projects
|
|
NTRS-50SouthCapitalAnalysis.py
|
815
(2 years ago)
by nino.borges:
Very simple program that will read multiple CSV files and export a report based on specific questions. This was the final version of this first delivered report.
|
|
NTRS-TopSenderAnalysis.py
|
827
(20 months ago)
by nino.borges:
.12 update because of onedrive.
|
|
NTRS_ICC_CountsAnalysis.py
|
826
(20 months ago)
by nino.borges:
.05 adding excel support
|
|
PrivilegeLogGenerator.py
|
884
(10 months ago)
by nino.borges:
This program will take a DAT export from Relativity and turn this into an Excel Spreadsheet Privilege Log.
|
|
SF-SubjectLineDeconstructor.py
|
802
(2 years ago)
by nino.borges:
Very simple program that will read a list of subject lines and deconstruct them to consilidate them into a list of something attorneys
can use to pull out responsive terms.
|
|
vCardSearchAndDownload.py
|
875
(14 months ago)
by nino.borges:
I started getting forbidden messages when trying to download some vcards from other sites, so I added support for urllib, which does a bit better of a job with dealing with sending header information. I also broke out a few variables, so I can better support other element texts, etc. Works great for Hogan Lovells now too.
|
