 ../
|
PrivLogQC/
|
927
(7 months ago)
by nino.borges:
general use changes
|
|
RelativitySearchCriteria/
|
928
(7 months ago)
by nino.borges:
major updates with pickle.
|
|
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.
|
|
ATT_CSV_Compare.py
|
912
(7 months ago)
by nino.borges:
A simple program that will take two CSV files, formatted for Excel or Excel-generated and compares the values.
In this instance it was a two value CSV where the first value was the bates and the key between the files.
|
|
ATT_MAL-ExcelTools.py
|
915
(7 months ago)
by nino.borges:
A library of tools for manipulating the actual MAL Excel spreadsheet.
|
|
ATT_MasterAttorneyList.py
|
916
(7 months ago)
by nino.borges:
Added support for the Lighthouse normalized column in the spreadsheet and added support for multiple email addresses in the email fields and updated the return_list_of_matching_values method to also support multi value fields. Finally added the method return_person_all_name_variations which will return all the different name variations for a found person.
|
|
Amazon-AnalyzeNamesDeepNormOutput.py
|
917
(7 months ago)
by nino.borges:
Updated version to start adding features but didnt.
|
|
Amazon-AnalyzeNamesNormOutput.py
|
918
(7 months ago)
by nino.borges:
Minor use changes.
|
|
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_ContractorNamesAnalysis.py
|
932
(7 months ago)
by nino.borges:
This program will take a text file of raw contractor names, which are those wiht the [C], and attempt to find a match in the MAL.
|
|
Amazon_NameSearches.py
|
919
(7 months ago)
by nino.borges:
Just use changes
|
|
Amazon_NamesNormQC.py
|
920
(7 months ago)
by nino.borges:
added methods for partial matches and sloppy searches.
|
|
Amazon_PerformDeepNamesNormQC.py
|
921
(7 months ago)
by nino.borges:
multiple comma support
|
|
Amazon_PerformMalIntegrityChecks.py
|
922
(7 months ago)
by nino.borges:
Just use updates
|
|
Amazon_PerformNamesNormQC.py
|
923
(7 months ago)
by nino.borges:
just use updates
|
|
Amazon_PrivLogQC.py
|
924
(7 months ago)
by nino.borges:
use changes and additional reporting.
|
|
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
|
925
(7 months ago)
by nino.borges:
support for ReformatResturantCode
|
|
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
|
|
PrivilegeLogFieldCompare.py
|
914
(7 months ago)
by nino.borges:
This program will take a DAT export from Relativity and will compare the values in the fields.
|
|
PrivilegeLogGenerator.py
|
926
(7 months ago)
by nino.borges:
general use changes
|
|
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.
|
|
VW_FlattenCsvHoldReport.py
|
930
(7 months ago)
by nino.borges:
This simple program will take a VW hold report and flatten two fields, resulting in a report with many more rows.
|
|
vCardAnalyzeAndReport.py
|
931
(7 months ago)
by nino.borges:
This program will compare the list of email addresses from the MAL and, if a downloaded vCard for this email exists, will generate a report that will be saved to a spreadsheet
to then send to the Redgrave legal team for verification and ultimately import into the MAL.
|
|
vCardSearchAndDownload.py
|
929
(7 months ago)
by nino.borges:
general use changes
|
