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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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
520 -
Directory Listing
-
[selected]
Modified
Wed Jan 29 15:41:56 2014 UTC
(12 years, 2 months ago)
by
nino.borges
Diff to
previous 519
moved the issue track reporter into it's own project folder
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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 520
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
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 520
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 520
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 520
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, 2 months ago)
by
nino.borges
Diff to
previous 242
,
to
selected 520
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