This program performs the various integrity checks on the MAL. This performs the email integrity check that is in the Names Norm class but they does the row integrity check on a local copy of the MAL spreadsheet.  works well so far.

This version adds logic for instances where there is a split role attny but there is no date value in the priv log, which I didnt initially think would ever happen but found instances where it does.  Also adds support for situations where the name cant parse because there are multiple commas in the metadata name value.

Fixed a bug where it was writing more than one non match attempt to the issues.  This was because of that extra else.  This was incorrect and the else belonged at the very end of cycling through the different variations, not during.  Putting this after all the variations have run but still no match fixed the issue.

Fixed an annoying bug where, although I was checking to make sure the first name and last name both exist in the person I'm about to test when I need to match first name and last name only, I was looking at the full list of matching last names, so the report was wrong.

Added the same (except for the text where it says low priority instead of high) split out for split role people to the email failed so lets match names section.  this was copied from the email did match section.  Really need to refactor this code since it has a lot of repeating code.

This version finishes the evaluation on the email address matches split role and reports on the results by adding an issue.  Also added part at end of the email address match section to catch where I can match an email address in the metadata, the person is an attorney, but there is no matching value in the formatted field.  This is a potential missing attorney and it a high confidence flag because I had the email address.

I'm adding some code to work out if a split role attorney was an attorney at the time of the doc date.  I'm just getting it to print out here, so this is not yet complete.

Consolidated all of the additions into the issuesMatrix into a fuction. commented out all the individual adds and tested using the function.  results were identical except for a period in the text that was a typo anyway.

Updated the dates_as_counsel attribute so that it's now a list of two value tuples, instead of just a raw string.  this parsed version will work much better when I attempt to determine if split role attorneys will fall within one of those ranges.  Also updated search_by_email method to search both the work_email_address and the alt_work_email_address, exiting as soon as it finds the first match.  There shouldnt be any duplicates, including the alt email addresses, across rows.

This version adds support for the additionalValuesDict, adding the date value and the legal sources values.

In this pretty substantial update, I added support for the adding information from the split role attorney tab.  I also added methods for searching by the unique row number in the spreadsheets, searching by UUID, and support for searching by any field which results in a list instead of just exiting after finding the first value.  This version adds both the unique row number from the spreadsheet and adds the dates_as_counsel fields to the dataclass.

Now that I make the NamesNormQC a library and I'm not running code in it, I'm able to now call that instead of trying to mirror it here, which was a mess.  Much better.

They changed a column name to 'comments', so updated dataclass. also added some warning messages when the consilio override ingestion cant find a matching email address in the MAL.  I'm seeing many of these.

This version fixes a bug where it wasnt importing the downgrades tab because of an error in missing logic.  Also adds a pseudo private method that does some smarter deduplication in a set because I wanted to make sure I only had unique addresses in the initial RE result, looking for that as an error.  If I have 3 email addresses where only one should exist (like in the from) but they are the same email address, I wanted to make sure I wasnt raising a warning because they are not unique.  if there is more than one unique, that is a warning.  Finally also added support for providing a warning if the override name has a different last name from the MAL for the same record.  I'm now using consilio values for my override but there is concern they could be completely wrong.  So far I'm finding them more accurate actually and not totally off. however still want to be warned.

This program to test searching the MAL.

This very simple program will attempt to locate, using just first name and last name, any names that have been flagged in the past as non-attorneys.

the last updated values from the MAL were giving me issues when trying to save out a pickle file.  I think it's actually reading these as a datetime obj, which is why I get this error.  For now going to comment this out and will add it back in once I have a reason to use it.

This version added some strip due to values in the MAL having beginning or trailing whitespace.

This program will assist with the process of performing Names Normalization QC on the Amazon privilege logs.

I changed the log that records the duplicates in the formatted (not the metadata) field to a matrix so I can see in which field or fields the issue exists.

This version supports deduplicating the metadata fields by using unique email addresses.  Any values that do not have email addresses at all, will stay included but two values in the same metadata field that have the same email address, will dupe out.  This resulted in a substantial drop in mismatches, so apparently the majority of these are where the metadata field has duplicates.

First version of this program that will assist with the process of performing QC on the Amazon privilege logs.  Starting this with the named tuple data structure for now and trying to keep this very readable because I'm sharing the code.

.05 adding excel support

This is the completed version that was used for the final export of the systems.  This includes support for writing to an Excel file.

This version uses a RegEx and is working great.  Need to increase the column count and decide how I want to deal with the output.

First version of a simple program that will, using COM, search an Excel spreadsheet for specific key terms and, if it finds it, will copy the entire row out to a file organized by key term.  This is the first working version but is just too slow.  I think I'm making too many calls to the API.  I'm going to refactor this to see if I can speed it up substantially. 

Added code to mark the batch field as To Confirm UAT or To Confirm LanID.  This made the delivered the v3 report.

This program will open multiple xlsx files, using the Excel COM API, and will perform a simple combining of the data into a single xlsx report.  This version is the first delivered report.

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

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.

I'm tagging this as the final version of version 1. This version works, although it's limited, but it doesnt support zip files and archives in general.  I'm going to re-do the tables so that it better supports this.  This will then start the version 2.

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.

Very simple program that will read a list of subject lines and deconstruct them to consilidate them into a list of something attorneys
can use to pull out responsive terms.

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

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.

This program will compare VVV catalogs of the media drives on the NAS to those on Marty and display the duplicates issues and differences.

a set of functions that I can call which will help me with the 2 ePower disposition projects

A simple program that will read a CSV and perform searches, exporting results and a report

edited to be able to use this file to test the auxilium top level files.  will need to edit this to use the different sources, like going back to service now.

Edited to work on SNOW but doesnt support both at the same time.

Added support for grabbing the Service Now parent change request number too.

Updated to integrate Service Now change request numbers.

general usage update.

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.

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.

Very simple program that will read a CSV and export a column to a text file for me.

Version 2 where the appList and fields were changed to Sets to avoid duplicates.

cleaned up the code so that it marks it as cleared by default and upated paths.

Very simple program that will read an xls and extract field data, using an external matrix, a set text files for me.

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.

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.

Just var changes

Updated to do a better job of deduplicating the pii field.

Name Normalizer method taken to the point of dedupe down to 22,210 records.

First working but basic version of program that akes a spreadsheet for this case that has lots of duplication and consolidates it based on a 5 dimensional array.
This also concatenates specific fields and attempts to fix names.
NOTE: take the spreadsheet and convert to pipe delim.

updated to support  python3

making a music utilities dir for my various music programs.

Moving my various music related programs to a music utilities folder.

Updated to be Python 3 compatible, which makes that bak file.

Starting work on 2.2 which will add a relativity field map.

First working version of a program that attempts to consolidate a huge spreadsheet using logic given by client.

First working of this program used for the LCHC project where a spreadsheet needed to be consolidated around the user name.

Simple program that will take a DAT which has the bates and a date field (dateSort), convert that date value to yyyymmdd
and then rename the corresponding file to datevalue-bates, so that it chron sorts.

Updated to point to BatesRangeFunctions module in tools dir.

Version 2 which is a major re-write allowing for more tools and functions to be usable on scanned dat.  Create excel report, create bates range report.

A simple program, mostly for Eclipse, that will take an incoming prod DAT file and make an overlay file with things like the prodBeg number, Volume, Evidox Media ID, etc.
For now the load file needs to be asci.

Updated to 1.6 to fix a bug where it would crash if the matter name had a illegal windows file name character, like a slash.

This version does away with the madness of a specific list of columns to delete and instead uses a list of approved field names.  Updated to version 1.5

adding checking for the source too.

Finished up the dat report dialog and added a bit more code to try to determine the encoding.

Updating the main function to do a proper return and added some testing to the bottom to run it in non GUI mode to do some testing. shell for the dat report dialog too.

adding a folder and UI for incoming prod analyzer

Moving into it's own folder

Small changes to make it work with a test UI

Second round of changes requested by team

First round of changes requested by the team.

Moved GUI_Base to the toolbox folder

No real changes.

Added some error checking at the end to make sure all found images are accounted for in the LFP.

A program for performing some basic verification on an incoming production.

Updates to reflect stuff moved from iad to XDD

Program to help in detection of near duplicates in paper world

Simple program for detecting gaps in bates number lists

This was the first non-class version of a lib to interact with Eclipse SQL.  has been replaced already

A GUI program that will allow for performing admin functions on Eclipse using the SQL library that I made

nothing

Small changes

Simple program taht will help me fix broken music covers

simple program to play with splitting a check

Added another JS.

Initial working Version.

Final version before leaving AD

minor changes in use

Final versions before leaving AD.

A folder for my Evidox programs

Changed version to 2.4. Added a validator for the file name. changed the var name for the number validator, since that name was too generic.

Added support for compressed vs non-compressed and now supports special language for specific dC people

version 1

a program for extracting email domains and outputting the unique values.

Updated the date.

Second bug release of v 2.  This version reads and writes to multiple RL tables, saving things like new clients and new contacts.  Made this v 2 because new versions will be based on this idea of being able to save and gather info about a client, like if they have custom t and c.

Creating the webapp as the new front end.

Created a program that will take a PTS report and cull out parts to then put into a spreadsheet. in the future it will make the spreadsheet.

Added support for changing the production imaging to per GB and per page.

This was moved

Moving the SOW_Automator into it's own folder and setting up the folders properly.

Version 1.07. Cosmetic changes mostly and sort sales names.

Updated pricing tab so that it turns each control red, if that control goes below our approved pricing.

Version .01 of this program. At this point it works for me and other people. This is before I changed it to a notebook.

This version completely works.  This is before refactoring.

First working version of this program that has everything in the if main section.

update before leaving

update before leaving

update before leaving

added the update production page program and the add produciton UI program.

A program for working with the HPM.

A skel file for the base HBPD Reports.

added the init to the folder to make it callable. Finished the db clases. Started the reporting class.

Got rid of the yellow. Not sure what I was thinking here...

New program to convert eDiii to dat, so that it can be loaded into RL

Added a simple about.

a simple program that allowed me to parse a pdf and spreadsheet where the rows didnt line up at all.

Added version .02 to tag, so taht I can completely change UI.

Changed event call backs that referenced a event ID because that was not always stable. Updated version to 1.9.0 beta .07

updated prg version number to 1.8.2

Removed the < > and replaced with () when you upload a other party produciton. Windows wont allow the <> chars in a folder name

updated version to beta 5 of 1.9

Finished adding the manager reporting and the expanded cost updating.

A program to test the enumerations in the HW db.

changed it so that it uses seperateAlpha3

updated the exp date to december 4 2014

added css file and updated report to refine project view

change

moved the issue track reporter into it's own project folder.

Fixed a bug where lib was pointing to wrong folder for expedat and incremented the version. changed tag folder name too, to show new version.

Added a reporting module library.

save

Added a new seperate alpha that used re

Started adding the small menu to the project list.

refactor more

Added more html and multiple pages.

Refactored

Tagging the 1.8.0 release of the MCP.

Moved the main mcp code to the trunk, for easier versioning.

Updated the build to 009

Updated to copy to c drive.

Adding support for adding a case in the console UI.

Changed it so that view edit doesnt make a new access connection (a second one) but instead uses the instance from console. Also added a add case dialog and started making the add case call back.

Updated to fix bug where it was not taking upload type.

Updated was location to new.

This program will help us crft the deviciency reports from Narco, post query.

Fixed a bug where it would start 1 number beyond the selected number, in the bates.

Fixed a small bug where it was not using new folders for the vendor folder to IDS copying.

Random code updates

Updated program a lot.

Updated to build 003

Updated so that update pricing now refereshes the case settings window. updated version to build 002.

Added the logo that will be the splash screen.

Fixed a small bug in case scan where there were too many values to unpack when getting caseList.

Added a busy dialog to the transfer case utility, completing the transfer case module. One day I'll add a separate menu dialog.

Added support for transffering cases between TPMs in other offices and intra office. Updated the main View Edit to support this. Now just need a busy dialog and a dialog for transfering through the menu option.

Changed back to not using working folder per request and added full support for the new structure.

Added a new view called My Active Cases, filtering the case list to only show your active cases for all modules.

Added support for the working folder, IDS and made expedat library encrypted.  Also fixed a bug where it would error out if copy up was less than 1k.

Removed some CHAI language from EULA

A simple app that will let me add natives with load files to a review tool.

Updated the main method because it was missing extensions where there was mixed case and extra f in tiff.

Added the eula confirmation section to the program and updated to release version 1.0.0

Moved singleTiffToLFP to the PDFExportToDataLoad project.

Moved singleTiffToLFP to the PDFExportToDataLoad project.

Added a new program and made a GUI for it.  This is actually singleTifToLFP but this name makes more sense.

deleted a dup file that dropbox made

Finished and tested the OnEditCaseName by adding list comprehension that edits the 3 case lists in place.

Added a Davita only section of the MCP case scan that creates a web page that is our case orgnizer.  This is the first version of this organizer page.

Added a version 1 of a simple program that compares the exported records of the sales search and microfilm dbs to the values in the int check 3 RL db.

updating case scan to grab full folders and support davita.

updated priv desc to add more items to lists

Adding case name editing ability

Updated the installer to support the Eula and force accept to install.

Finished the Chai installer. It now lets you package and then instal with shortcuts.

Updated Chai_Installer

Updated Chai_Installer

Updated Chai_Installer

Updated Chai_Installer

Updated version to 1.0.0

Updated the tools menu to clean things up a bit.

Added the disclosure letter feature with dialogs and warning message on main view edit.

Updated the native production dialog so that it gives the user the option of picking from db field names.

Updated ProduceNative in ConcordanceExt so that it will support multiple field options when renaming.

Katie found a bug with the update vendorfolder. Fixed bug and changed the version to 1.7.0.

Because I havent make a trunk yet, it created another tags under my version.

Tagging the 1.7.0 release of the MCP.

updated the size of the edit vendor folder dialog

Added the vendor folder dialog file

Added a view vendor folder method and pointed the menu item here. Also added import of edit vendor folder dialog

moved the list of archive file types to the lib, so that there would be one place only to change it, and pointed copy up here.  Also added a warning dialog to copy up to warn when it's about to gather the compressed size of an archive.

Added the case directories settings

Added the alternate media path function and tested.

Finished adding feature Copy From Vendor Folder (#39) to copyup. Added menu items for settings, linked vendor folders and alternate media path to view edit ui

MCP: save

MCP: Copy up split into source media local and remote.

MCP: Copy up split into source media local and remote.

MCP: Copy up split into source media local and remote.

Added roll film dirs.

Updated the expiration date

added an ini.py file to make it easier to call the lib dynamically

Added Vendor Folder capability to lib and to the UI

added iproHelpertools to toolbox

Added 'View My Case Notes' and 'View Production Spec' to the View Edit Module.

Added the DDSC Logo to the repository and gatherpathforbegno.py

added ipro_redactionreport2

save

Moving todo items to trac

Updated the todo list and removed the who is using mcp section