File
|
Last Change |
|---|---|
 ../
|
|
EndoTableFieldNameSearch.py
|
765 (4 years ago) by nino.borges: First working version of a very simple program that will read a pair of csv files and extract the table and field data which matches specific terms in the field or table name, along with other information about that field and table. |
|
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. |
|
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 |
|
Endo2017BackupCSVMassSearch.py
|
761 (4 years ago) by nino.borges: Just var changes |