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
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
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
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
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.