.12 update because of onedrive.

Revision 814 - (view) (annotate) - [select for diffs]
Modified Thu Jan 11 17:03:32 2024 UTC (2 years, 2 months ago) by nino.borges
File length: 15947 byte(s)
Diff to previous 813

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.

This version was the delivered Analysis_v13 spreadsheet that added the top 10 subject line entries.

Revision 812 - (view) (annotate) - [select for diffs]
Modified Mon Jan 8 21:44:57 2024 UTC (2 years, 2 months ago) by nino.borges
File length: 13817 byte(s)
Diff to previous 811

This is the working version that has the final senders values code as well as the unique subject line count code but before I added any top 10 subject line coding was added.

This version has the working senderEmailAddressesAcrossCSVsSet and is before I'm adding code for the unique subject line count.

Revision 810 - (view) (annotate) - [select for diffs]
Modified Fri Jan 5 19:24:53 2024 UTC (2 years, 2 months ago) by nino.borges
File length: 13325 byte(s)
Diff to previous 809

When adding the special senders list where there is no NTRS domain in the TO or where there is but it's not a lanID, I initial started by wanting to have separate per CSV and then a global list.  However diana only needs a single large list but one that references what file it came from and only dedulicates on the file level.  I'm going to change the code for .8 to only have one set, that still only deduplicates on the file level, instead of two.  saving this to version control in the event she asks me to have both.

This was the final version that was used, which included the scenario calculations, and was sent to Tom and Diana.  I then changed the start path to the second topsender request and re-ran this.  This is why it points to the second top sender request.

Revision 804 - (view) (annotate) - [select for diffs]
Modified Thu Oct 12 16:03:05 2023 UTC (2 years, 5 months ago) by nino.borges
File length: 9396 byte(s)
Diff to previous 803

Per Diana, @EXNTRS.COM is a valid NTRS domain, so changing the NTRS Domain Criteria to now be NTRS.COM, which simplifies that line a bit and will capture anything with that in it.

This version adds support for gathering all possible email addresses across all CSV files, which also let me gather the unique email address count in the TO field per CSV.  Also adds the date column, as captured in the folder name, and changes the NTRS Domain Criteria to @NTRS.com or .NTRS.COM.

Revision 801 - (view) (annotate) - [select for diffs]
Modified Thu Sep 28 13:37:57 2023 UTC (2 years, 5 months ago) by nino.borges
File length: 6629 byte(s)
Diff to previous 800

Converted to a class for better reusability and commenting.

This version with a working TrueTest method which goes one step further than the RegEx.

Revision 799 - (view) (annotate) - [select for diffs]
Modified Mon Sep 25 15:44:23 2023 UTC (2 years, 6 months ago) by nino.borges
File length: 3060 byte(s)
Diff to previous 798

Version of the program before finding many other examples that could also be LAN IDs and plan on adding extra verification.

This version created the beginnings of the report.  It generates the counts and uses the regEx to pull out all of the ntrs values from the TO line, writing these to a file so that I can look for instances where it's pulling an ntrs but it's not a lan ID one.

Revision 797 - (view) (annotate) - [select for diffs]
Added Wed Sep 20 18:50:51 2023 UTC (2 years, 6 months ago) by nino.borges
File length: 1002 byte(s)

Very first version of a very simple program that will read multiple CSV files and export a report based on LanID and other general information.  This version is just gathering some test data.