 ../
|
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
|
|
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
|
814
(2 years ago)
by nino.borges:
Changed the column name CSV Date to Folder Date and tried adding support for no sorting in the write log method, because the team asked that the Top10Subject lines values be sorted in the spreadsheet by count and not by the subject line value. These results saved as analysis report v15.
|
|
NTRS_ICC_CountsAnalysis.py
|
819
(2 years ago)
by nino.borges:
Adding the previous batch coding support and solving around issues where there are characters missing in the previous live report that exist in the export files, making it so that there are missing matches. This version fixes that.
|
|
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.
|
