ViewVC Help
View Directory | Revision Log | View Changeset | Root Listing
root/ns_dev/Python/NinoCode/Active_prgs/Redgrave
Revision 783 - Directory Listing - [select for diffs]
Modified Mon Aug 15 21:24:32 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 781
Updated to integrate Service Now change request numbers.
Revision 781 - Directory Listing - [select for diffs]
Modified Fri Aug 5 02:20:22 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 780
general updates
Revision 780 - Directory Listing - [select for diffs]
Modified Fri Aug 5 02:20:05 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 779
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.
Revision 779 - Directory Listing - [select for diffs]
Modified Fri Aug 5 02:19:30 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 778
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.
Revision 778 - Directory Listing - [select for diffs]
Modified Fri Aug 5 02:19:01 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 777
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.
Revision 777 - Directory Listing - [select for diffs]
Modified Fri Aug 5 02:18:30 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 776
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.
Revision 776 - Directory Listing - [select for diffs]
Modified Fri Aug 5 02:17:53 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 775
Very simple program that will read a CSV and export a column to a text file for me.
Revision 775 - Directory Listing - [select for diffs]
Modified Fri Aug 5 02:17:23 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 772
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.
Revision 772 - Directory Listing - [select for diffs]
Modified Thu Aug 4 19:35:33 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 771
Version 2 where the appList and fields were changed to Sets to avoid duplicates.
Revision 771 - Directory Listing - [select for diffs]
Modified Thu Aug 4 18:31:02 2022 UTC (3 years, 7 months ago) by nino.borges
Diff to previous 767
First working version of this program to extract data from various reports for windows 2008 server analysis.
Revision 767 - Directory Listing - [select for diffs]
Modified Wed Sep 15 18:54:57 2021 UTC (4 years, 6 months ago) by nino.borges
Diff to previous 766
Very simple program that will read an xls and extract field data, using an external matrix, a set text files for me.
Revision 766 - Directory Listing - [select for diffs]
Modified Mon Sep 13 21:41:52 2021 UTC (4 years, 6 months ago) by nino.borges
Diff to previous 765
Running on new exports.
Revision 765 - Directory Listing - [select for diffs]
Modified Mon Sep 13 20:40:19 2021 UTC (4 years, 6 months ago) by nino.borges
Diff to previous 764
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.
Revision 764 - Directory Listing - [select for diffs]
Modified Fri Jul 30 19:41:08 2021 UTC (4 years, 7 months ago) by nino.borges
Diff to previous 763
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
Revision 763 - Directory Listing - [select for diffs]
Modified Fri Jul 30 14:45:31 2021 UTC (4 years, 7 months ago) by nino.borges
Diff to previous 762
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.
Revision 762 - Directory Listing - [select for diffs]
Modified Fri Jul 30 14:43:55 2021 UTC (4 years, 7 months ago) by nino.borges
Diff to previous 761
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.
Revision 761 - Directory Listing - [select for diffs]
Modified Fri Jul 30 14:41:20 2021 UTC (4 years, 7 months ago) by nino.borges
Diff to previous 760
Just var changes
Revision 760 - Directory Listing - [select for diffs]
Modified Thu Jul 22 01:34:35 2021 UTC (4 years, 8 months ago) by nino.borges
Diff to previous 759
Update program to now not only perform single term searches but also multi term AND and OR searches.
Revision 759 - Directory Listing - [select for diffs]
Added Wed Jul 21 21:57:37 2021 UTC (4 years, 8 months ago) by nino.borges

Convenience Links