 ../
|
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_MAL-ExcelTools.py
|
952
(4 months ago)
by nino.borges:
Added support for confirming the LH names norm.
|
|
ATT_MasterAttorneyList.py
|
951
(4 months ago)
by nino.borges:
Many updates
|
|
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
|
967
(2 months ago)
by nino.borges:
First working version of the build_similar_names function. Some QC was done and it does appear to be working.
|
|
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
|
969
(6 weeks ago)
by nino.borges:
First version of a program that will create the grouped concatenated categorical log where there is a row only for each unique priv description.
|
|
NS-CategoricalLogCreator.py
|
968
(7 weeks ago)
by nino.borges:
Version 1 of a program that will create the categorical privilege log from a DAT file. This version only turns the dat into a spreadsheet and contains the logic to concatenate but doesnt integrate the concatenation yet.
|
|
NS_MasterAttorneyList.py
|
955
(4 months ago)
by nino.borges:
Added support for alt surnames in the return_person_all_name_variations method. set version to 2.0
|
|
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
|
