 ../
|
EndoXlsFieldDataExtractor.py
|
767
(4 years ago)
by nino.borges:
Very simple program that will read an xls and extract field data, using an external matrix, a set text files for me.
|
|
EndoTableFieldNameSearch.py
|
766
(4 years ago)
by nino.borges:
Running on new exports.
|
|
EndoMultipleTableFieldCompare.py
|
762
(4 years ago)
by nino.borges:
This program will take a list of tables with the fields contained in those tables
and tell you which tables (fields not data) are subsumed by other tables and which
tables (fields not data) are identical. This is helpful to get an idea of how the
tables are possibly being used. Created for use in the Endo case.
|
|
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.
|
|
EndoIGServerAnalyzer.py
|
772
(3 years ago)
by nino.borges:
Version 2 where the appList and fields were changed to Sets to avoid duplicates.
|
|
EndoIGChgReqSysToServer.py
|
780
(3 years ago)
by nino.borges:
Using COM, this program will create a simplified txt file with rows from the Change Request Exports spreadsheets that hit on our server names. I'll then ingest this
on the main EndoIGServerAnalyzer program.
|
|
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.
|
|
EndoFieldsFlaggedForProdReport.py
|
764
(4 years ago)
by nino.borges:
First working version used on 2007backup.
This program will take the results from EndoMultipleTableFieldCompare and will generate a
spreadsheet report so that specific fields can be selected for production. It will use the
results in the table-field compare and prioritize the tables that are not subsumed to the left
of the workbook and the ones that are to the right, with the idea that you will have a separator tab between them. It will then highlight in green the rows that were already selected for prod. Be sure to convert the multiple csvs to pipe delimited and NOT utf-16
|
|
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.
|
|
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.
|
|
Endo2017BackupCSVMassSearch.py
|
761
(4 years ago)
by nino.borges:
Just var changes
|
|
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.
|
|
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.
|
