Revision
1017 -
Directory Listing
-
[select for diffs]
Modified
Wed Mar 25 16:55:16 2026 UTC
(2 days, 17 hours ago)
by
nino.borges
Diff to
previous 1016
,
to
selected 451
Added some code to catch the timeout issues that I'm seeing. This will allow it to handle these better, instead of crashing, and will report a TO for any that do time out.
Revision
1000 -
Directory Listing
-
[select for diffs]
Modified
Wed Mar 18 17:12:13 2026 UTC
(9 days, 17 hours ago)
by
nino.borges
Diff to
previous 999
,
to
selected 451
Add RelativitySearchReportBatched v1 - direct API search report generator
Replaces the previous two-step workflow (manual CSV export + RelativitySearchReport.py) with a single program that
connects directly to the Relativity REST API via harvested session cookies. Queries saved searches across one or more
workspaces, groups them by folder, and generates a formatted Excel report per workspace - including hyperlinks to
each search in the Relativity UI and the full Notes field content. Optionally executes each search to capture
document counts. Supports --interactive mode for step-by-step confirmation and per-search timing during initial
testing.
Revision
994 -
Directory Listing
-
[select for diffs]
Modified
Sun Mar 15 03:35:46 2026 UTC
(13 days, 7 hours ago)
by
nino.borges
Diff to
previous 993
,
to
selected 451
Commit 1 Initial commit:
Initial commit - MusicDriveSync
MusicDriveSync is a wxPython desktop application for managing music on car
thumb drives. The user maintains a large FLAC library on a NAS, organized as
Artist/Album/Tracks. Rather than physically inserting drives to update them,
each thumb drive has a corresponding folder on the NAS. The app lets the user
browse the NAS library, see which tracks are already on a given drive
(highlighted green), copy missing tracks to the drive folder, and remove
tracks from it. Syncing to the physical drive is done separately via rsync.
This initial commit includes a working application with the following:
- config.py: reads and validates musicdrivesync.ini
- MusicDriveSync_Lib.py: NAS library scanning with cache, drive folder
scanning with progress callback, comparison index, copy and remove stubs
- panels/LibraryPanel.py: wx.TreeCtrl-based library tree with green
highlighting for tracks present on the active drive, Show Missing Only
filter, and Copy Selected button
- panels/DrivePanel.py: wx.TreeCtrl-based drive folder tree with Remove
Selected button and confirmation dialog
- main.py: top-level frame wiring drive selector, both panels, status bar
progress during library and drive scans, path accessibility checks on startup
---
Commit 2 Changelog and CLAUDE.md:
Add changelog system, fix CLAUDE.md conflicts, and apply session bug fixes
Introduces a changelog/ folder to track bugs, architectural decisions, and
lessons learned across the life of the project.
- changelog/CHANGELOG_INDEX.md: master index table for all entries
- changelog/00001_arch.md: DataViewTreeCtrl to wx.TreeCtrl migration
- changelog/00002_bug.md: missing drive scan progress feedback fix
- changelog/00003_arch.md: library panel color logic reversal
- CLAUDE.md: corrected two conflicts with the current codebase:
color coding description updated (green = on drive, normal = needs copying);
DataViewCtrl note replaced with TreeCtrl decision with pointer to changelog;
UI layout diagram corrected; changelog folder added to project structure
- panels/DrivePanel.py: converted from DataViewTreeCtrl to wx.TreeCtrl
- MusicDriveSync_Lib.py: added progress_callback to ScanDriveFolder()
- main.py: wired drive scan progress to status bar; added path accessibility
checks at startup
---
Commit 3 Fix Remove Selected:
Fix Remove Selected, add safety guard, and document NAS read-only rule
- Fixed "No tracks selected" on Remove and Copy buttons. Both panels were
using TreeItemId.GetID() as a dict key which is unreliable across the wx
layer. Replaced with wx.TreeCtrl's native SetItemData/GetItemData. The
separate _item_data dict was removed from both panels entirely.
See changelog/00004_bug.md.
- Fixed 5-minute UI freeze after removing tracks. OnRemoveTracks was calling
ScanDriveFolder() on the UI thread after every remove. Replaced with an
in-memory filter of _drive_tracks using the list of removed relative paths.
- Silent remove failures now surface as a warning dialog.
- Added path prefix guard to RemoveTracksFromDrive(). Any file whose path
does not begin with drive_path is unconditionally skipped.
- Added Absolute Rules section to CLAUDE.md: the NAS music library is
strictly read-only. The app may never delete or modify files there.
- changelog/00004_bug.md: documents the SetItemData fix and lessons learned.
---
Commit 4 Copy and Tools menu:
Implement CopyTracksToDrive, add Tools menu with Empty Folder Report
CopyTracksToDrive (MusicDriveSync_Lib.py):
- Copies files preserving full folder structure relative to music_library_path
(e.g. Compilations/Album/track.flac mirrors exactly on the drive folder)
- Uses shutil.copy2 to preserve file timestamps and metadata
- Skips files that already exist at the destination
- Accepts a progress_callback(done, total) for status bar updates
OnCopyTracks / _on_copy_complete (main.py):
- Copy now runs in a background thread, no UI freeze for large selections
- Status bar updates as each file is copied (e.g. "Copying to Taco... 3/12")
- After completion, newly copied files are added to _drive_tracks in memory
by reading their tags directly, no full rescan needed
- Both panels disabled during copy and re-enabled on completion
Tools menu (main.py):
- Added Tools menu to the right of File in the menu bar
- Empty Folder Report: scans the active drive folder and lists all
subdirectories that contain no FLAC files (may still contain jpg/png etc.)
- Results shown relative to drive root for readability
- EmptyFolderReportDialog class added to main.py
FindFoldersWithoutFlac (MusicDriveSync_Lib.py):
- Two-pass walk: marks all dirs containing FLACs and their ancestors, then
collects highest-level dirs with no FLACs using topdown pruning
Revision
992 -
Directory Listing
-
[select for diffs]
Modified
Sat Mar 14 15:34:32 2026 UTC
(13 days, 19 hours ago)
by
nino.borges
Diff to
previous 991
,
to
selected 451
Initial commit MusicDriveSync
MusicDriveSync is a wxPython desktop application for managing music on car thumb drives. The user maintains a large
FLAC library on a NAS, organized as Artist/Album/Tracks. Rather than physically inserting drives to update them, each
thumb drive has a corresponding folder on the NAS. The app lets the user browse the NAS library, see which tracks
are already on a given drive (highlighted green), copy missing tracks to the drive folder, and remove tracks from it.
Syncing to the physical drive is done separately via rsync.
This initial commit includes a working application with the following components:
- config.py: reads and validates musicdrivesync.ini; single config source for all modules
- MusicDriveSync_Lib.py: NAS library scanning with cache, drive folder scanning with progress callback, comparison
index, copy and remove stubs
- panels/LibraryPanel.py: wx.TreeCtrl-based library tree with green highlighting for tracks present on the active
drive, "Show missing only" filter, and Copy Selected button
- panels/DrivePanel.py: wx.TreeCtrl-based drive folder tree with Remove Selected button and confirmation dialog
- main.py: top-level frame wiring drive selector, both panels, status bar progress during library and drive scans,
and path accessibility checks on startup
Revision
991 -
Directory Listing
-
[select for diffs]
Modified
Mon Mar 9 21:52:02 2026 UTC
(2 weeks, 4 days ago)
by
nino.borges
Diff to
previous 990
,
to
selected 451
I meant to have this as the commit message for 1.5 but I had an issue wiht the message. so I added some spaces to the files to force another commit.
Gromulus v1.5: user metadata save workflow, schema expansion, and UI refactor
- Added user-editable game metadata workflow with explicit Save button (no autosave).
- Added dirty-state tracking and Save/Discard/Cancel prompts when navigating away or closing with unsaved changes.
- Added DB schema support for new metadata fields:
- favorite_game
- release_date, release_date_scraped
- game_genre, game_genre_scraped
- cooperative, cooperative_scraped
- max_players, max_players_scraped
- Wired UI to user-first metadata precedence with _scraped fallback for release date, genre, cooperative, max players, and description.
- Added release date display/storage conversion:
- GUI display MM-DD-YYYY
- DB storage YYYY-MM-DD
- Refactored main game info panel:
- moved hash/file/No-Intro/TOSEC detail fields into Reports -> Game Properties modal
- added compact TOSEC/NoIntro match indicators
- added Favorite, Release Date, Genre, Cooperative, Max Players, Description, and User Notes controls
- Enhanced artwork previews from prior update:
- larger preview boxes
- aspect-ratio-preserving scaling
- click-to-open full-size modal viewer
- Updated schema/documentation files to stay aligned:
- models.py
- Database Dictonary.md
- canonical DB utility schema/migration logic
Revision
990 -
Directory Listing
-
[select for diffs]
Modified
Mon Mar 9 21:20:37 2026 UTC
(2 weeks, 4 days ago)
by
nino.borges
Diff to
previous 989
,
to
selected 451
Gromulus v1.5: user metadata save workflow, schema expansion, and UI refactor
- Added user-editable game metadata workflow with explicit Save button (no autosave).
- Added dirty-state tracking and Save/Discard/Cancel prompts when navigating away or closing with unsaved changes.
- Added DB schema support for new metadata fields:
-
- ,
- ,
- ,
- ,
- Wired UI to user-first metadata precedence with fallback for release date, genre, cooperative, max players, and description.
- Added release date display/storage conversion:
- GUI display
- DB storage
- Refactored main game info panel:
- moved hash/file/No-Intro/TOSEC detail fields into modal
- added compact TOSEC/NoIntro match indicators
- added Favorite, Release Date, Genre, Cooperative, Max Players, Description, and User Notes controls
- Enhanced artwork previews from prior update:
- larger preview boxes
- aspect-ratio-preserving scaling
- click-to-open full-size modal viewer
- Updated schema/documentation files to stay aligned:
-
-
- canonical DB utility schema/migration logic
Revision
988 -
Directory Listing
-
[select for diffs]
Modified
Sun Mar 8 04:15:07 2026 UTC
(2 weeks, 6 days ago)
by
nino.borges
Diff to
previous 987
,
to
selected 451
Added a database dictionary markdown file which attempts to describe at a highlevel the database, tables, fields and the reason for these. also updaed the models.py file to reflect the updated database, since it was so out of date. I'm currently not using it beyond documenting the schema. also added a Projet Guidelines file and lessons learned file. These are my attempt at tryiing out spec-driven development. Projectguidelines is the core guide that will act as the source of truth of the application.
Revision
987 -
Directory Listing
-
[select for diffs]
Modified
Sun Mar 8 04:11:11 2026 UTC
(2 weeks, 6 days ago)
by
nino.borges
Diff to
previous 986
,
to
selected 451
UI: enlarge artwork previews, preserve image aspect ratio, add click-to-open full-size artwork modal
- Increased preview widget size by ~5% for Box/Title/Ingame artwork.
- Fixed preview rendering to scale images proportionally and center them (no horizontal stretching).
- Added clickable artwork previews with hand cursor.
- Added modal full-size artwork viewer with scrollbars and close button.
- Added graceful handling for missing/unreadable artwork files.
Revision
981 -
Directory Listing
-
[select for diffs]
Modified
Tue Feb 24 22:38:58 2026 UTC
(4 weeks, 3 days ago)
by
nino.borges
Diff to
previous 980
,
to
selected 451
Added a method for looking for issues on the MAL ID values. Although I dont use these, members of the team does and pointed out some duplicate numbers, so I added a method to look for duplicates and gaps. It does this for both attorney and non-attorney people.
Revision
979 -
Directory Listing
-
[select for diffs]
Modified
Sat Feb 14 03:49:44 2026 UTC
(6 weeks ago)
by
nino.borges
Diff to
previous 978
,
to
selected 451
Refactor metadata import and UI workflows; add system-scoped DAT handling, artwork ingestion, and artwork previews
- Scope No-Intro/TOSEC imports to selected local system and track import metadata
- Improve hash matching using file-level hashes with system-aware joins
- Add artwork ingest workflow with type selection, dry-run mode, and busy indicators
- Add bottom-row artwork previews (box/title/ingame) driven by selected game
- Improve UI responsiveness and layout (system-switch busy dialog, taller game list, preview row positioning)
Revision
978 -
Directory Listing
-
[select for diffs]
Modified
Fri Feb 13 22:49:37 2026 UTC
(6 weeks ago)
by
nino.borges
Diff to
previous 977
,
to
selected 451
System-scoped DAT import refactor and metadata matching improvements
Refactored DAT import workflow so No-Intro and TOSEC imports are tied to a selected local main_app_system instead of global table replacement.
Updated UI import flow to prompt for target system before DAT import.
Added schema support for per-system DAT scoping (app_system_id) and DAT import tracking (dat_import_history with source/version/date/count).
Updated No-Intro/TOSEC import logic to replace rows only for the selected system and upsert last-import metadata.
Switched game metadata matching to use main_app_file_hash.file_md5_hash (via container_file_id) instead of container hash.
Updated game list/detail lookups to use file-level hash matching, including case-insensitive MD5 comparison.
Improved TOSEC/No-Intro lookup accuracy and kept read paths non-destructive (schema writes only during migration/import paths).
Added/updated indexing and normalization hooks to support system-scoped matching performance and backward compatibility.
Revision
969 -
Directory Listing
-
[select for diffs]
Modified
Mon Feb 9 20:45:17 2026 UTC
(6 weeks, 4 days ago)
by
nino.borges
Diff to
previous 968
,
to
selected 451
First version of a program that will create the grouped concatenated categorical log where there is a row only for each unique priv description.
Revision
968 -
Directory Listing
-
[select for diffs]
Modified
Fri Feb 6 21:29:55 2026 UTC
(7 weeks ago)
by
nino.borges
Diff to
previous 967
,
to
selected 451
Version 1 of a program that will create the categorical privilege log from a DAT file. This version only turns the dat into a spreadsheet and contains the logic to concatenate but doesnt integrate the concatenation yet.
Revision
966 -
Directory Listing
-
[select for diffs]
Modified
Wed Jan 7 20:45:17 2026 UTC
(2 months, 2 weeks ago)
by
nino.borges
Diff to
previous 965
,
to
selected 451
Added return_person_all_name_variations and added the additional name fields, now that it was approved. This seems to work well. I also added the version version of build_similar_names, which I'm still debugging.
Revision
965 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 23 18:20:42 2025 UTC
(3 months ago)
by
nino.borges
Diff to
previous 964
,
to
selected 451
Adding support for expansion of international email address domains, for client email addresses, because we noticed that international client addresses usually have domain aliases for other international domains.
Revision
964 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 9 18:56:37 2025 UTC
(3 months, 2 weeks ago)
by
nino.borges
Diff to
previous 963
,
to
selected 451
Updated by adding a method that is a faster bulk write of the Excel API call and then another method that just writes to CSV and doesnt use the API at all.
Revision
956 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 5 16:50:27 2025 UTC
(3 months, 3 weeks ago)
by
nino.borges
Diff to
previous 955
,
to
selected 451
Added return_str_string2 which is a more complicated version of the original method. I kept the original in there but I'm using using this more updated method when ExportFullSTRList is called.
Revision
942 -
Directory Listing
-
[select for diffs]
Modified
Tue Sep 9 17:03:07 2025 UTC
(6 months, 2 weeks ago)
by
nino.borges
Diff to
previous 941
,
to
selected 451
Originally _normalize_multi would deduplicate the values in the cell using a set. I changed my mind and changed this to allow duplicates. If the original cell had dups, I want the dictionary cell to have dups.
Revision
937 -
Directory Listing
-
[select for diffs]
Modified
Thu Aug 7 20:39:47 2025 UTC
(7 months, 2 weeks ago)
by
nino.borges
Diff to
previous 936
,
to
selected 451
A simple program that takes a list of key terms and creates a single DT search string with OR between them. Supports paren when w/x is found.
Revision
934 -
Directory Listing
-
[select for diffs]
Modified
Thu Aug 7 20:37:52 2025 UTC
(7 months, 2 weeks ago)
by
nino.borges
Diff to
previous 933
,
to
selected 451
This program will analyze a cleaned dat file and tell you which fields have data in them and which fields are empty. This expects a pipe delimited dat file that has been cleaned
and that the first line is the headder row.
Revision
933 -
Directory Listing
-
[select for diffs]
Modified
Thu Aug 7 20:37:07 2025 UTC
(7 months, 2 weeks ago)
by
nino.borges
Diff to
previous 932
,
to
selected 451
This program will take a list of firstname, lastname, category (which I think is actualy organization) and attempt to generate a report of who is new and, if found, possible matches.
Assumes the first row is just the header row.
Revision
931 -
Directory Listing
-
[select for diffs]
Modified
Thu Aug 7 20:35:31 2025 UTC
(7 months, 2 weeks ago)
by
nino.borges
Diff to
previous 930
,
to
selected 451
This program will compare the list of email addresses from the MAL and, if a downloaded vCard for this email exists, will generate a report that will be saved to a spreadsheet
to then send to the Redgrave legal team for verification and ultimately import into the MAL.
Revision
916 -
Directory Listing
-
[select for diffs]
Modified
Wed Aug 6 22:15:19 2025 UTC
(7 months, 2 weeks ago)
by
nino.borges
Diff to
previous 915
,
to
selected 451
Added support for the Lighthouse normalized column in the spreadsheet and added support for multiple email addresses in the email fields and updated the return_list_of_matching_values method to also support multi value fields. Finally added the method return_person_all_name_variations which will return all the different name variations for a found person.
Revision
912 -
Directory Listing
-
[select for diffs]
Modified
Fri Aug 1 21:26:37 2025 UTC
(7 months, 3 weeks ago)
by
nino.borges
Diff to
previous 911
,
to
selected 451
A simple program that will take two CSV files, formatted for Excel or Excel-generated and compares the values.
In this instance it was a two value CSV where the first value was the bates and the key between the files.
Revision
911 -
Directory Listing
-
[select for diffs]
Modified
Mon Jun 23 22:56:57 2025 UTC
(9 months ago)
by
nino.borges
Diff to
previous 910
,
to
selected 451
First version of a very simple program will take a Relativity saved search criteria report (for now from Lighthouse) and perform a sync-compare between workstream search folders.
Revision
908 -
Directory Listing
-
[select for diffs]
Modified
Sat Jun 7 03:32:34 2025 UTC
(9 months, 2 weeks ago)
by
nino.borges
Diff to
previous 907
,
to
selected 451
Updated to fix the issue where I'm opening the connection on import but closing at the end of each function. added a database manager class and added the OnExit in the UI mainloop to close the db connection.
Revision
907 -
Directory Listing
-
[select for diffs]
Modified
Sat Jun 7 03:32:11 2025 UTC
(9 months, 2 weeks ago)
by
nino.borges
Diff to
previous 906
,
to
selected 451
Updated to fix the issue where I'm opening the connection on import but closing at the end of each function. added a database manager class and added the OnExit in the UI mainloop to close the db connection.
Revision
905 -
Directory Listing
-
[select for diffs]
Modified
Fri Jun 6 22:14:57 2025 UTC
(9 months, 2 weeks ago)
by
nino.borges
Diff to
previous 904
,
to
selected 451
Changed the file name CreateGromulusDB to GromulusDatabaseUtilities and changed it to be a class of utilities, instead of a simple make new db script. Now allows for, in additon to making the db, db backup and export and import to-from a JSON file. Also changed the schema to add a tosec system table, instead of using the no intro one.
Revision
890 -
Directory Listing
-
[select for diffs]
Modified
Sat May 24 02:09:35 2025 UTC
(10 months ago)
by
nino.borges
Diff to
previous 889
,
to
selected 451
A set of functions that will help with file encoding detection and issues.
This is version 2 of this library which **requires carset-normalizer be installed**. Previously used chardet.
Revision
882 -
Directory Listing
-
[select for diffs]
Modified
Wed May 7 17:01:15 2025 UTC
(10 months, 2 weeks ago)
by
nino.borges
Diff to
previous 881
,
to
selected 451
This very simple program will take a Relativity saved search information export and convert it to a more useful report that can be shared with others and contains
detail contained in the notes section of the search. This assumes the best practice of notating what the search does in the Notes field.
Revision
880 -
Directory Listing
-
[select for diffs]
Modified
Fri Jan 31 19:41:10 2025 UTC
(13 months, 3 weeks ago)
by
nino.borges
Diff to
previous 879
,
to
selected 451
Added support for looking for duplicate numbers on the attorney and Downgrade tabs and looking for rows where Last name is missing but first name exists.
Revision
879 -
Directory Listing
-
[select for diffs]
Modified
Fri Jan 10 22:09:56 2025 UTC
(14 months, 2 weeks ago)
by
nino.borges
Diff to
previous 878
,
to
selected 451
Finished adding what the program checks for in the notes and uncommented manual section because I forgot to do that when I did my last commit.
Revision
878 -
Directory Listing
-
[select for diffs]
Modified
Fri Jan 10 22:04:34 2025 UTC
(14 months, 2 weeks ago)
by
nino.borges
Diff to
previous 877
,
to
selected 451
Adds a new integrity check, by calling this from the Names Norm QC library, that will look for email addresses outside of email address fields in the MAL
Revision
877 -
Directory Listing
-
[select for diffs]
Modified
Fri Jan 10 22:03:53 2025 UTC
(14 months, 2 weeks ago)
by
nino.borges
Diff to
previous 876
,
to
selected 451
Adds a new integrity check that will look for email addresses outside of email address fields in the MAL. Also updated the existing email address integrity check to do a better job of finding duplicates across work email and alt email.
Revision
875 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 31 03:27:12 2024 UTC
(14 months, 3 weeks ago)
by
nino.borges
Diff to
previous 874
,
to
selected 451
I started getting forbidden messages when trying to download some vcards from other sites, so I added support for urllib, which does a bit better of a job with dealing with sending header information. I also broke out a few variables, so I can better support other element texts, etc. Works great for Hogan Lovells now too.
Revision
873 -
Directory Listing
-
[select for diffs]
Modified
Mon Dec 30 21:18:00 2024 UTC
(14 months, 3 weeks ago)
by
nino.borges
Diff to
previous 872
,
to
selected 451
First working version of a program that will connect to a company people search website, like KLGATES, and perform searches based on something like email address. If that person is found, it will download the vcard. This version works perfectly for that site, although just one at a time.
Revision
872 -
Directory Listing
-
[select for diffs]
Modified
Mon Dec 23 22:53:20 2024 UTC
(15 months ago)
by
nino.borges
Diff to
previous 871
,
to
selected 451
Added support for writing the "to Field" or "from Field" information to the issue messages, in advance of possibly making this a single report. Also going to eventually make this so it itterates over a list and not doing these one by one.
Revision
871 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 20 17:00:12 2024 UTC
(15 months ago)
by
nino.borges
Diff to
previous 870
,
to
selected 451
This program will assist with analyzing the more complex 'deep' output logs from the Names Norm program. This will take in all of the vals output files and the priv log,
and will compare the high confidence downgrades and upgrades to determine if these were changed, if there are any surviving attorney values in the legalSource field.
Revision
870 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 20 16:58:54 2024 UTC
(15 months ago)
by
nino.borges
Diff to
previous 869
,
to
selected 451
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.
Revision
868 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 17 17:59:43 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 867
,
to
selected 451
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.
Revision
867 -
Directory Listing
-
[select for diffs]
Modified
Sat Dec 14 02:01:57 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 866
,
to
selected 451
in author, when resorting to a name search when the email doesnt match, because in this field the email address is not always in a paren, the email address was surviving and not removed. added an extra line to make sure it's removed before trying to parse the name.
Revision
866 -
Directory Listing
-
[select for diffs]
Modified
Sat Dec 14 01:55:21 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 865
,
to
selected 451
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.
Revision
865 -
Directory Listing
-
[select for diffs]
Modified
Sat Dec 14 00:36:53 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 864
,
to
selected 451
Updated the variations function to force add AMAZON.COM if there is an @amazon. in the domain name because Eli said I could be confident that the same email name will show up as the amazon.co.uk, amazon.it, etc. This should increase my matches.
Revision
864 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 22:42:46 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 863
,
to
selected 451
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.
Revision
863 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 22:11:54 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 862
,
to
selected 451
Copied, almost word for word, the first name last name matching piece under the email, when you cant match email, to the part where you werent even able to extract an email, which also needed to be first name last name matched.
Revision
862 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 20:06:27 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 861
,
to
selected 451
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.
Revision
861 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 19:50:55 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 860
,
to
selected 451
I had to place the put the for loop into the "if allPossibleVariationsList" because I was getting an issue where it was returning some none from the MAL but still using older variation variables. this way, and not referring to the variation variables in the matchFlag check works better. that was a terrible bug.
Revision
860 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 18:22:14 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 859
,
to
selected 451
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.
Revision
859 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 17:58:37 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 858
,
to
selected 451
I'm still just printing the results of the split role date check but it's working correctly now. Next step will be to action on these decisions.
Revision
858 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 17:52:35 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 857
,
to
selected 451
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.
Revision
857 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 16:33:58 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 856
,
to
selected 451
With the additions to the issues list now a function, I simply removed the commented out old lines. Again tested it to be sure I didnt mess something up.
Revision
856 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 16:28:48 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 855
,
to
selected 451
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.
Revision
855 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 13 16:10:56 2024 UTC
(15 months, 1 week ago)
by
nino.borges
Diff to
previous 854
,
to
selected 451
This program is similar to Amazon_PerformNamesNormQC but it will perform a deeper level of names norm QC. I may just replace Amazon_PerformNamesNormQC with this file but for now i'd
like to keep both. This is the first working version of this program but with a lot still missing.
Revision
854 -
Directory Listing
-
[select for diffs]
Modified
Thu Dec 12 18:26:19 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 853
,
to
selected 451
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.
Revision
850 -
Directory Listing
-
[select for diffs]
Modified
Wed Dec 11 15:42:57 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 849
,
to
selected 451
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.
Revision
849 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 10 18:01:33 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 848
,
to
selected 451
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.
Revision
848 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 10 18:00:23 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 847
,
to
selected 451
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.
Revision
847 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 10 17:59:30 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 846
,
to
selected 451
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.
Revision
846 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 10 17:22:55 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 845
,
to
selected 451
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.
Revision
844 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 6 21:56:09 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 843
,
to
selected 451
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.
Revision
843 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 6 21:48:19 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 842
,
to
selected 451
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.
Revision
841 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 6 21:46:55 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 840
,
to
selected 451
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.
Revision
840 -
Directory Listing
-
[select for diffs]
Modified
Fri Dec 6 21:46:10 2024 UTC
(15 months, 2 weeks ago)
by
nino.borges
Diff to
previous 839
,
to
selected 451
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.
Revision
838 -
Directory Listing
-
[select for diffs]
Modified
Mon Dec 2 20:03:00 2024 UTC
(15 months, 3 weeks ago)
by
nino.borges
Diff to
previous 837
,
to
selected 451
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.
Revision
837 -
Directory Listing
-
[select for diffs]
Modified
Mon Dec 2 19:18:05 2024 UTC
(15 months, 3 weeks ago)
by
nino.borges
Diff to
previous 836
,
to
selected 451
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.
Revision
835 -
Directory Listing
-
[select for diffs]
Modified
Wed Nov 27 16:08:34 2024 UTC
(15 months, 4 weeks ago)
by
nino.borges
Diff to
previous 834
,
to
selected 451
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.
Revision
832 -
Directory Listing
-
[select for diffs]
Modified
Wed Nov 20 19:16:50 2024 UTC
(16 months ago)
by
nino.borges
Diff to
previous 831
,
to
selected 451
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.
Revision
830 -
Directory Listing
-
[select for diffs]
Modified
Tue Nov 19 21:44:44 2024 UTC
(16 months ago)
by
nino.borges
Diff to
previous 829
,
to
selected 451
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.
Revision
828 -
Directory Listing
-
[select for diffs]
Modified
Tue Nov 19 17:07:03 2024 UTC
(16 months, 1 week ago)
by
nino.borges
Diff to
previous 827
,
to
selected 451
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.
Revision
823 -
Directory Listing
-
[select for diffs]
Modified
Wed Feb 14 20:10:43 2024 UTC
(2 years, 1 month ago)
by
nino.borges
Diff to
previous 822
,
to
selected 451
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.
Revision
821 -
Directory Listing
-
[select for diffs]
Modified
Wed Feb 14 18:55:17 2024 UTC
(2 years, 1 month ago)
by
nino.borges
Diff to
previous 820
,
to
selected 451
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.
Revision
820 -
Directory Listing
-
[select for diffs]
Modified
Wed Feb 14 14:49:42 2024 UTC
(2 years, 1 month ago)
by
nino.borges
Diff to
previous 819
,
to
selected 451
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.
Revision
819 -
Directory Listing
-
[select for diffs]
Modified
Thu Jan 18 19:49:21 2024 UTC
(2 years, 2 months ago)
by
nino.borges
Diff to
previous 818
,
to
selected 451
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.
Revision
817 -
Directory Listing
-
[select for diffs]
Modified
Tue Jan 16 21:37:56 2024 UTC
(2 years, 2 months ago)
by
nino.borges
Diff to
previous 816
,
to
selected 451
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.
Revision
816 -
Directory Listing
-
[select for diffs]
Modified
Tue Jan 16 20:12:09 2024 UTC
(2 years, 2 months ago)
by
nino.borges
Diff to
previous 815
,
to
selected 451
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.
Revision
815 -
Directory Listing
-
[select for diffs]
Modified
Tue Jan 16 20:11:13 2024 UTC
(2 years, 2 months ago)
by
nino.borges
Diff to
previous 814
,
to
selected 451
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.
Revision
814 -
Directory Listing
-
[select for diffs]
Modified
Thu Jan 11 17:03:32 2024 UTC
(2 years, 2 months ago)
by
nino.borges
Diff to
previous 813
,
to
selected 451
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.
Revision
812 -
Directory Listing
-
[select for diffs]
Modified
Mon Jan 8 21:44:57 2024 UTC
(2 years, 2 months ago)
by
nino.borges
Diff to
previous 811
,
to
selected 451
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.
Revision
810 -
Directory Listing
-
[select for diffs]
Modified
Fri Jan 5 19:24:53 2024 UTC
(2 years, 2 months ago)
by
nino.borges
Diff to
previous 809
,
to
selected 451
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.
Revision
809 -
Directory Listing
-
[select for diffs]
Modified
Thu Jan 4 21:03:18 2024 UTC
(2 years, 2 months ago)
by
nino.borges
Diff to
previous 808
,
to
selected 451
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
808 -
Directory Listing
-
[select for diffs]
Modified
Thu Dec 21 22:52:40 2023 UTC
(2 years, 3 months ago)
by
nino.borges
Diff to
previous 807
,
to
selected 451
Added a method to hash the contents of a ZIP file. The zip lib doesnt support being able to open a zip in memory and hash each file, so I wrote this to accomplish this. For now it returns a list with a list inside containing the embedded file name and the hash of that file. might change this to a tuple in a list.
Revision
806 -
Directory Listing
-
[select for diffs]
Modified
Thu Dec 21 18:25:36 2023 UTC
(2 years, 3 months ago)
by
nino.borges
Diff to
previous 805
,
to
selected 451
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.
Revision
804 -
Directory Listing
-
[select for diffs]
Modified
Thu Oct 12 16:03:05 2023 UTC
(2 years, 5 months ago)
by
nino.borges
Diff to
previous 803
,
to
selected 451
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.
Revision
803 -
Directory Listing
-
[select for diffs]
Modified
Thu Oct 12 16:00:49 2023 UTC
(2 years, 5 months ago)
by
nino.borges
Diff to
previous 802
,
to
selected 451
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
802 -
Directory Listing
-
[select for diffs]
Modified
Thu Sep 28 13:38:29 2023 UTC
(2 years, 5 months ago)
by
nino.borges
Diff to
previous 801
,
to
selected 451
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.
Revision
798 -
Directory Listing
-
[select for diffs]
Modified
Thu Sep 21 19:18:39 2023 UTC
(2 years, 6 months ago)
by
nino.borges
Diff to
previous 797
,
to
selected 451
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 -
Directory Listing
-
[select for diffs]
Modified
Wed Sep 20 18:50:51 2023 UTC
(2 years, 6 months ago)
by
nino.borges
Diff to
previous 796
,
to
selected 451
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.
Revision
791 -
Directory Listing
-
[select for diffs]
Modified
Tue Sep 13 14:10:49 2022 UTC
(3 years, 6 months ago)
by
nino.borges
Diff to
previous 790
,
to
selected 451
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.
Revision
790 -
Directory Listing
-
[select for diffs]
Modified
Tue Sep 13 14:07:38 2022 UTC
(3 years, 6 months ago)
by
nino.borges
Diff to
previous 789
,
to
selected 451
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.
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
,
to
selected 451
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
,
to
selected 451
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
,
to
selected 451
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
,
to
selected 451
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 774
,
to
selected 451
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
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
,
to
selected 451
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
,
to
selected 451
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
,
to
selected 451
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
,
to
selected 451
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
754 -
Directory Listing
-
[select for diffs]
Modified
Sun Jun 6 18:54:14 2021 UTC
(4 years, 9 months ago)
by
nino.borges
Diff to
previous 753
,
to
selected 451
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.
Revision
753 -
Directory Listing
-
[select for diffs]
Modified
Sun Jun 6 18:48:46 2021 UTC
(4 years, 9 months ago)
by
nino.borges
Diff to
previous 752
,
to
selected 451
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.
Revision
752 -
Directory Listing
-
[select for diffs]
Modified
Thu Apr 22 02:49:58 2021 UTC
(4 years, 11 months ago)
by
nino.borges
Diff to
previous 751
,
to
selected 451
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.
Revision
740 -
Directory Listing
-
[select for diffs]
Modified
Mon Mar 22 18:13:25 2021 UTC
(5 years ago)
by
nino.borges
Diff to
previous 739
,
to
selected 451
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.
Revision
719 -
Directory Listing
-
[select for diffs]
Modified
Wed Jan 20 21:06:55 2021 UTC
(5 years, 2 months ago)
by
nino.borges
Diff to
previous 718
,
to
selected 451
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.
Revision
710 -
Directory Listing
-
[select for diffs]
Modified
Tue Aug 18 22:05:33 2020 UTC
(5 years, 7 months ago)
by
nino.borges
Diff to
previous 709
,
to
selected 451
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.
Revision
709 -
Directory Listing
-
[select for diffs]
Modified
Wed Aug 5 17:41:37 2020 UTC
(5 years, 7 months ago)
by
nino.borges
Diff to
previous 708
,
to
selected 451
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.
Revision
705 -
Directory Listing
-
[select for diffs]
Modified
Tue Jul 14 19:00:09 2020 UTC
(5 years, 8 months ago)
by
nino.borges
Diff to
previous 704
,
to
selected 451
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.
Revision
701 -
Directory Listing
-
[select for diffs]
Modified
Thu May 21 21:36:34 2020 UTC
(5 years, 10 months ago)
by
nino.borges
Diff to
previous 700
,
to
selected 451
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
Revision
695 -
Directory Listing
-
[select for diffs]
Modified
Wed May 13 19:22:06 2020 UTC
(5 years, 10 months ago)
by
nino.borges
Diff to
previous 694
,
to
selected 451
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.
Revision
678 -
Directory Listing
-
[select for diffs]
Modified
Mon May 4 19:40:48 2020 UTC
(5 years, 10 months ago)
by
nino.borges
Diff to
previous 677
,
to
selected 451
A simple program that will take an exported evidence report from XPM App and make and East Team
specific evidence log that can be shared with clients.
Revision
669 -
Directory Listing
-
[select for diffs]
Modified
Tue Dec 31 16:56:53 2019 UTC
(6 years, 2 months ago)
by
nino.borges
Diff to
previous 668
,
to
selected 451
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.
Revision
620 -
Directory Listing
-
[select for diffs]
Modified
Wed Nov 2 16:45:13 2016 UTC
(9 years, 4 months ago)
by
nino.borges
Diff to
previous 619
,
to
selected 451
Version 2.2.0. Added full support for the SOW short form whne they have an MSA and added support on the UI elements, hiding those and unhiding too.
Revision
615 -
Directory Listing
-
[select for diffs]
Modified
Wed Oct 12 16:07:51 2016 UTC
(9 years, 5 months ago)
by
nino.borges
Diff to
previous 614
,
to
selected 451
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.
Revision
610 -
Directory Listing
-
[select for diffs]
Modified
Wed Sep 21 15:07:05 2016 UTC
(9 years, 6 months ago)
by
nino.borges
Diff to
previous 609
,
to
selected 451
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.
Revision
607 -
Directory Listing
-
[select for diffs]
Modified
Thu Jun 16 15:56:39 2016 UTC
(9 years, 9 months ago)
by
nino.borges
Diff to
previous 606
,
to
selected 451
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.
Revision
599 -
Directory Listing
-
[select for diffs]
Modified
Thu Jan 7 15:45:38 2016 UTC
(10 years, 2 months ago)
by
nino.borges
Diff to
previous 598
,
to
selected 451
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.
Revision
552 -
Directory Listing
-
[select for diffs]
Modified
Wed Jun 18 13:56:42 2014 UTC
(11 years, 9 months ago)
by
nino.borges
Diff to
previous 551
,
to
selected 451
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.
Revision
541 -
Directory Listing
-
[select for diffs]
Modified
Mon May 5 20:23:52 2014 UTC
(11 years, 10 months ago)
by
nino.borges
Diff to
previous 540
,
to
selected 451
Changed the tpm assign box to select only, to force it to the current TPMs and to deal with an issue where just by selecting another case, it was triping the transfer tpm event.
Revision
517 -
Directory Listing
-
[select for diffs]
Modified
Tue Jan 21 19:41:20 2014 UTC
(12 years, 2 months ago)
by
nino.borges
Diff to
previous 516
,
to
selected 451
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.
Revision
516 -
Directory Listing
-
[select for diffs]
Modified
Tue Jan 21 19:11:14 2014 UTC
(12 years, 2 months ago)
by
nino.borges
Diff to
previous 515
,
to
selected 451
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.
Revision
487 -
Directory Listing
-
[select for diffs]
Modified
Thu Nov 21 16:42:23 2013 UTC
(12 years, 4 months ago)
by
nino.borges
Diff to
previous 486
,
to
selected 451
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.
Revision
464 -
Directory Listing
-
[select for diffs]
Modified
Mon Oct 7 19:04:50 2013 UTC
(12 years, 5 months ago)
by
nino.borges
Diff to
previous 463
,
to
selected 451
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.
Revision
462 -
Directory Listing
-
[select for diffs]
Modified
Tue Oct 1 19:53:25 2013 UTC
(12 years, 5 months ago)
by
nino.borges
Diff to
previous 461
,
to
selected 451
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.
Revision
459 -
Directory Listing
-
[select for diffs]
Modified
Fri Sep 20 20:32:02 2013 UTC
(12 years, 6 months ago)
by
nino.borges
Diff to
previous 458
,
to
selected 451
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.
Revision
458 -
Directory Listing
-
[select for diffs]
Modified
Tue Sep 17 14:41:23 2013 UTC
(12 years, 6 months ago)
by
nino.borges
Diff to
previous 457
,
to
selected 451
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.
Revision
453 -
Directory Listing
-
[select for diffs]
Modified
Wed Sep 11 17:59:42 2013 UTC
(12 years, 6 months ago)
by
nino.borges
Diff to
previous 452
,
to
selected 451
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.
Revision
451 -
Directory Listing
-
[selected]
Modified
Tue Sep 10 21:25:57 2013 UTC
(12 years, 6 months ago)
by
nino.borges
Diff to
previous 450
Removed some CHAI language from EULA
Revision
413 -
Directory Listing
-
[select for diffs]
Modified
Tue Jul 23 15:49:27 2013 UTC
(12 years, 8 months ago)
by
nino.borges
Diff to
previous 412
,
to
selected 451
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.
Revision
411 -
Directory Listing
-
[select for diffs]
Modified
Tue Jul 23 15:41:59 2013 UTC
(12 years, 8 months ago)
by
nino.borges
Diff to
previous 367
,
to
selected 451
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.
Revision
266 -
Directory Listing
-
[select for diffs]
Modified
Mon Feb 4 19:25:36 2013 UTC
(13 years, 1 month ago)
by
nino.borges
Diff to
previous 265
,
to
selected 451
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.
Revision
258 -
Directory Listing
-
[select for diffs]
Modified
Tue Jan 29 15:56:46 2013 UTC
(13 years, 1 month ago)
by
nino.borges
Diff to
previous 242
,
to
selected 451
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