 ../
|
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
|
949
(4 months ago)
by nino.borges:
added support for names to MAL checks which will compare the normalized names to the MAL, using the metadata values.
|
|
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_ExportSTRFromMal.py
|
974
(6 weeks ago)
by nino.borges:
A separate module that calls the STR string creator from the master attorney module.
|
|
ATT_MAL-ExcelTools.py
|
952
(4 months ago)
by nino.borges:
Added support for confirming the LH names norm.
|
|
ATT_MasterAttorneyList.py
|
985
(4 weeks ago)
by nino.borges:
This version adds the build_similar_names function and also adds the includeSimilarNamesExclusion option on return_str_string method.
|
|
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_ExportSTRFromMal.py
|
948
(4 months ago)
by nino.borges:
|
|
Amazon_NameSearches.py
|
919
(7 months ago)
by nino.borges:
Just use changes
|
|
Amazon_NamesNormQC.py
|
980
(5 weeks ago)
by nino.borges:
Added support for the similar names exclusions in this version.15
|
|
Amazon_PerformDeepNamesNormQC.py
|
947
(4 months ago)
by nino.borges:
Fixing some conflicts
|
|
Amazon_PerformMalIntegrityChecks.py
|
946
(4 months ago)
by nino.borges:
Fixing some conflicts.
|
|
Amazon_PerformNamesFromListLookup.py
|
933
(7 months ago)
by nino.borges:
This program will take a list of firstname, lastname, category (which I think is actualy organization) and attempt to generate a report of who is new and, if found, possible matches.
Assumes the first row is just the header row.
|
|
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.
|
|
ConcordanceDatToDictionary.py
|
950
(4 months ago)
by nino.borges:
Finishing up the method.
|
|
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.
|
|
EmptyFieldReport.py
|
934
(7 months ago)
by nino.borges:
This program will analyze a cleaned dat file and tell you which fields have data in them and which fields are empty. This expects a pipe delimited dat file that has been cleaned
and that the first line is the headder row.
|
|
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.
|
|
Lilly-PathAnalysis.py
|
935
(7 months ago)
by nino.borges:
Very simple program that will perform some custom analysis on large directory tree dumps in a log file.
|
|
Lilly-PathAnalysis2.py
|
936
(7 months ago)
by nino.borges:
Very simple program that will perform some custom analysis on large directory tree dumps in a log file.
|
|
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
|
|
NS-CategoricalGroupedLogCreator.py
|
983
(4 weeks ago)
by nino.borges:
This is the version that I've used and tested on the actual log.
|
|
NS-CategoricalLogCreator.py
|
984
(4 weeks ago)
by nino.borges:
This is the completed version, which I used on the actual log.
|
|
NS-PrivLogQC.py
|
975
(6 weeks ago)
by nino.borges:
This program will assist with the process of performing QC on past and present NS privilege logs.
|
|
NS_ExportSTRFromMal.py
|
986
(4 weeks ago)
by nino.borges:
A simple program that will call the method to export an STR from the current MAL
|
|
NS_MasterAttorneyList.py
|
982
(4 weeks ago)
by nino.borges:
Added support to run a check on the MAL ID numbers. I dont use these but members of the team does, so I added this as a check.
|
|
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
|
945
(4 months ago)
by nino.borges:
cleaned up some conflicts.
|
|
RelativityAuditFlattenerXml.py
|
964
(3 months ago)
by nino.borges:
Updated by adding a method that is a faster bulk write of the Excel API call and then another method that just writes to CSV and doesnt use the API at all.
|
|
RelativityAuditReportJsonInspector.py
|
957
(3 months ago)
by nino.borges:
First version of this program to try to inspect the JSON schema on a Relativity audit history report.
|
|
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.
|
|
TermsToDtSearchEntry.py
|
937
(7 months ago)
by nino.borges:
A simple program that takes a list of key terms and creates a single DT search string with OR between them. Supports paren when w/x is found.
|
|
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
|
