Now that I make the NamesNormQC a library and I'm not running code in it, I'm able to now call that in other programs.  Due to that, I moved the run code here.

Finally changed this so that it's a library, so I removed the run code at the bottom.  Programs will now be able to call this library now that the pickle will work properly.

Updated this to use RE for the email matching.  too many non-email values mixed in here, as the file from consilio is messy.

This program will take a spreadsheet, supplied by Consilio, of the formatted names to email addresses table that they use and create a FullNamesOveride file.
The columns are normally Raw Entry	Formatted Name	Priv Entity Email Address
Assumes the top row is the header row, which is skips.

This program will assist with analyzing the output logs from the Names Norm program.  The team has various levels of issues and this will put the higher issues into a sep file,
making the process of finding these easier while not getting rid of those other lower priority issues.

No significant changes, just updated to run on a different dat file, so I had to change the field indexes.

Added support for the "full name overide" list because I'm seeing lots of inconsistencies in the MAL.  I need a way to overide in some instances based on email address.  Also updated for the new 12.1 MAL, which added a column (last updates), changed a col name and added more rows to both tabs.

Added support to do the actual compares and output the issue values to a log file, further refining the logic.  Also added some support to add some manual manipulation on some of the values for things where inconsistent in the MAL.

Added support for situations where the doc author is blank because it's an email. This is the version I ran on the newer workspace.

Added the Author metadata and formatted fields to the check.  This increased the unmatched count.

0.2.0 adds testing all of the email fields listed in the named tuple, instead of just TO.

.12 update because of onedrive.

version .06, also used this for searching for other key terms, like for mobile apps.

Added additional columns and this now takes quite a bit longer.  Not terrible yet.  I also needed to add a bit of code to deal with columns that were a datetime data type.

Version 2 refactors to solve the slowness issue.  This way makes a lot less calls to the API and takes much less time to finish.  I'm getting some false positives though, with things like eCTS matching the word objects, so I'm going to change this to a regex in the next version.

Adding the previous batch coding support and solving around issues where there are characters missing in the previous live report that exist in the export files, making it so that there are missing matches.  This version fixes that.

This version added code to name the dated header columns correctly.  QCd this by selecting 5 rows at random and comparing them to Tom's table.

Very simple program that will read multiple CSV files and export a report based on specific questions.  This was the final version of this first delivered report.

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

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

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.

For some reason part of this file was using 8 spaces and part was using the normal 4.  I edited this manually so that it's all 4 spaces.

Added the system table and added methods for importing roms.

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.

Converted to a class for better reusability and commenting.

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

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.

Gromulus, which is a catalog inventory for roms, games and maybe one day applications.

Added support for other Domains SQL Servers Matrix.

Updated to support the MS Assessment and Planning Toolkit SQL report that Balaji sent to me.  Also updated the Aspect SQL file section to further parse the server name since I found that they are mixing regular servernames with full servernames like foo.bar.com.

Added support for the change requests numbers that were found on the original Windows servers with os 2008 and earlier report.

Updated to support SNOW list.

Added support for the Service Now business owner and business approver.

Updated to integrate Service Now change request numbers.

general updates

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.

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.

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.

A directory to hold text files with notes on coding.

First working version of this program to extract data from various reports for windows 2008 server analysis.

Updated LedgerFromCSV to auto mark everything as cleared.

Running on new exports.

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

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.

Update program to now not only perform single term searches but also multi term AND and OR searches.

Final delivery with full name splitting to separate fields (as well as the combined) 

Version that went to XMRS

Second version that makes the elements in the array all upper.  First version went from 37,601 to 26,143.  This version dedupes a bit more to 24,821.

A simple program that will add the cover art to a folder of flac files but only ever on the thumb drive dir on the NAS. In this version I was trying to have the function call a subprocess on an entire dir, which didnt work. I'll switch to doing it file level instead.

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

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

Updated to be compatible with python3, which made the bak files.

Updated all tools libs to be python 3 compatible. 

added some missing code request txt files

Second working version of a program that attempts to consolidate a huge spreadsheet using logic given by client.  This was a major rewrite, so I started a new.

Final of ver 2 where it works with 2 passes and on second pass tries to consolidate by removing middle name.

Creates an excel spreadsheet report listing the document counts for each of a particular AMs cases.  Relativity only for now.

Adding more support for UTF by using io library for better file open control. Updated ver to 2.1

Added NextBatesShouldBe and PreviousBatesShouldBe methods.

Updated due to changes in column names in this last XPM app update.

Updated to version 1.7 to fix an issue where the XPM update removed some fields that the program was expecting.  Updated so EVERYTHING is a look up list of column name.  No more column letters or numbers.

Added support to set the cell color to the setCellProperties method.

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

update to 1.3, which just tests the non-working when complied filter arrow remove.

Added support for UTF dat files

Second round of changes requested by team

First round of changes requested by the team.

Updated by adding a GUI and making the main program GUI friendly.

Added some methods to delete columns and a method to change the format of a number/date cell.

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

Copied this from the fix bates range tool in the summation dir and deleted the stuff that I dont need.  I use these functions quite often and for many tools.

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

small updates

small changes

Added support for incoming and outgoing prod tabs and rewrite as a function.

Updated so that it checks the last mod date. will now skip if the mod date of the source is not newer.

Final version before leaving AD

Final version before leaving AD

Final versions before leaving AD.

Updated to allow saving or displaying.

Initial version of a tree size getter that is new and better than the walk way

A folder for my Evidox programs

Changed version to 2.5. Added feature to ask for pricing approval with click of button. this commit is version 2.5 final.

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

version 1

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

Updated the date.

Had to comment out the inclusion of the constant because it wouldnt compile.

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.

Updated library to now support copying and pasting the contents of an entire word document into another word document.

Tagging version 1.10

Moved all of the default low and regular prices out of the two individual classes and into a shared dictionary called defaultPriceMatrix, which is shared by the two tabs that need it. Also fixed the per page endorsing so that it allows it to go to 0, since people waive this.  Also added per GB imaging to just the shared dictionary for now.

Tagging the 1.09.1 release of the SOW_Automator.

Version 1.08. Added support for production services.

This is version 1.06, even though it says 1.07. this version added all the math and was right before I started making the cosmetic changes from nicole.

Version 1.02. Remade as a notebook and added a pricing section.  Works great.

This is after refactoring and is the version that I gave to app support and ESI

working on a new version of the MCP.

Moved dir out of main dir.

Moved active prgs dir out of main dir.

Moved JB dir out of main dir.

update before leaving

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.

Added support for creating reports in Excel.  Viewed and printed tabs are done.  doc count viewed is almost done.

A skel file for the base HBPD Reports.

Added init to the Relativity folder, so that I can import stuff.

Added some code so that I can catch my own exception.

A program that will take the history export from the HPPR, parse, and then make a spreadsheet with the results.

Updates

made a small change so that it pulls from w and not t.

Added the request where they asked me to take 1 spreadsheet that had multi lines for a patient but each line having a diff question, and merge so that petient and all questions were on 1 line.

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.

code changed

Changed the view edit to console and updated the installer to remove the old short cuts for view edit and add case.

Added initial version

Adding the installer to the repository.

Fixed bug where transfer case would error out because getcasedata wasnt updated to include casepathstyle.

Added support for Registering uploads

Updated Expedat lib to find correct expedat depending on win ver

Adding a file to track quick requests from narco.

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.

More modificaitons to family from lfp

Updated program a lot.

Created a new program for gathering families from LFP data.

On edit 343 I accidently messed up AddCaseToAccessDB as a typo. This fixes that.

Added a splash screen to ViewEdit, CopyUp and AddCase.

Moved CreateCaseStylePathFolders out of view edit console and into mcplib so that copyup could use it too. Added ability to copy up to also test if the user already selected new vs old style and it updates it in the db.

Added support in view edit for the case path style setting and added a popup that forces you to choose if you select an IDS system. Also added ability to have the MCP create the data folders.

For some reason the mycases, activecases,officecases lists are no longer sorting by client matter. Changed to force the sort.

Changed the Generic lable to Generic (old cases only) from working dir.  Created the Expedat Walk generator in MCP_Lib to act as a expedat dir walker. Changed the vendor upload dialog so that it now supports unlimited folder depth, by using the generator.

Fixed a small bug in My Active Cases view where it wasnt refreshing the screen.

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

updated to catch more roll film variations.

Updated version to 1.0.1

Updated version to 1.0.1

Updated the expedat connection to connect to the new IDS location.

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.

Added initial support for upload and hosting pricing and added an initial gui dialog to change it.  Updated version to 1.8.0

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

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

Making a tags dir under the MCP

Added the Edit the vendor folder dialog and linked everything up in view edit. Added methods to change this in the db.

Added a vendor folder method, which calls the access method in lib

Removed the unneeded import of wx.grid

Finished and tested Alternate Media Path feature with settings feature.

Added the case directories settings

added a taghist example to randomcoderequests.

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.

MCP: Changed copy up so that it only does the connection test if it's going to copy to the DIS

changed expire date on chai v8 and 10. Added GatherSize to MCP lib.

changing folder grouping in mcpLib

Added Concordance Ipro Map big and Small programs

Added backend 'view my case notes' ability to view edit and added same to ui and back end of copyUp.

Changed View Edit UT to support changing of the cases list. Nothing behind it though.

Changed MCP version to .17 and changed compression options in MCP_Copyup.

test

ConcordanceBatchDELFlagged Added

Changes to todo list

misc changes

Initial Import