PDFKeeper

Client Requirements

• Windows (32 or 64-bit) with .NET Framework 4.6.1 or higher installed.
• Any additional requirements will be referenced in the Help file that can be viewed post-install.

Compatible Database Management Systems

• Oracle Database 19c
• Oracle Database 18c
• Oracle Database 18c Express Edition
• Oracle Database 12c Release 2
• Oracle Database 12c Release 1
• Oracle Database 11g Release 2
• Oracle Database 11g Express Edition

Setup instructions are available in the Help file that can be viewed post-install.

Upgrade Information

• When upgrading from PDFKeeper 4.1.0 or lower, the database schema will require an upgrade. Database Schema Upgrade instructions are available in the Help file that can be viewed post-install.
• When upgrading from PDFKeeper 4.1.0 or lower, Oracle Data Access Components Runtime 19.3 is now required that includes an updated Oracle Data Provider for .NET. Instructions are available in the Help file that can be viewed post-install.
• When upgrading from PDFKeeper 4.x.x, the User name and Data source will need to be entered on first login.
• Starting with version 4.0.0, PDFKeeper is installed per-user, requiring older, per-machine installs to be uninstalled manually.

Improvements

• When Search Results is refreshed, the previously selected document record will be selected.

Fixes

• Add PDF Documents dialog loses focus after selecting a PDF document.
• Main form not always opening full width after Search Results grid view is filled when the width of the columns exceeded the width of Search Results grid view.
• Search Results grid view Category column not sizing correctly after selecting Toggle Right Panel to show right panel and then selecting Toggle Right Panel again to hide right panel.
• Selected Search tab on main form not always being visible after the right panel collapsed state has changed.

Additional Information

• Oracle Database 19c (19.3) requires the Microsoft Visual C++ 2013 Redistributable (x64) - 12.0.30501 to be installed on the computer hosting the database.

Known Issues

• Annotations in a PDF document are not filtered by Oracle Database.
• Embedded fonts in a PDF document are not filtered correctly by Oracle Database.

Client Requirements

• Windows (32 or 64-bit) with .NET Framework 4.6.1 or higher installed.
• Any additional requirements will be referenced in the Help file that can be viewed post-install.

Compatible Database Management Systems

• Oracle Database 19c
• Oracle Database 18c
• Oracle Database 18c Express Edition
• Oracle Database 12c Release 2
• Oracle Database 12c Release 1
• Oracle Database 11g Release 2
• Oracle Database 11g Express Edition

Setup instructions are available in the Help file that can be viewed post-install.

Upgrade Information

• When upgrading from PDFKeeper 4.1.0 or lower, the database schema will require an upgrade. Database Schema Upgrade instructions are available in the Help file that can be viewed post-install.
• When upgrading from PDFKeeper 4.1.0 or lower, Oracle Data Access Components Runtime 19.3 is now required that includes an updated Oracle Data Provider for .NET. Instructions are available in the Help file that can be viewed post-install.
• When upgrading from PDFKeeper 4.x.x, the User name and Data source will need to be entered on first login.
• Starting with version 4.0.0, PDFKeeper is installed per-user, requiring older, per-machine installs to be uninstalled manually.

Improvements

• Database connection pooling is now a setting in PDFKeeper.exe.config that can be set to True or False.

Fixes

• Memory and handle leak in application.
• Correct how Oracle secure password handling was implemented to allow database connection pooling to be enabled after being disabled in version 5.0.0.

Additional Information

• Oracle Database 19c (19.3) requires the Microsoft Visual C++ 2013 Redistributable (x64) - 12.0.30501 to be installed on the computer hosting the database.

Known Issues

• Annotations in a PDF document are not filtered by Oracle Database.
• Embedded fonts in a PDF document are not filtered correctly by Oracle Database.

Client Requirements

• Windows (32 or 64-bit) with .NET Framework 4.6.1 or higher installed.
• Any additional requirements will be referenced in the Help file that can be viewed post-install.

Compatible Database Management Systems

• Oracle Database 19c
• Oracle Database 18c
• Oracle Database 18c Express Edition
• Oracle Database 12c Release 2
• Oracle Database 12c Release 1
• Oracle Database 11g Release 2
• Oracle Database 11g Express Edition

Setup instructions are available in the Help file that can be viewed post-install.

Upgrade Information

• When upgrading from PDFKeeper 4.1.0 or lower, the database schema will require an upgrade. Database Schema Upgrade instructions are available in the Help file that can be viewed post-install.
• When upgrading from PDFKeeper 4.1.0 or lower, Oracle Data Access Components Runtime 19.3 is now required that includes an updated Oracle Data Provider for .NET. Instructions are available in the Help file that can be viewed post-install.
• When upgrading from PDFKeeper 4.x.x, the User name and Data source will need to be entered on first login.
• Starting with version 4.0.0, PDFKeeper is installed per-user, requiring older, per-machine installs to be uninstalled manually.

Changes

• Modified PDF file and application generated supplemental data will now be permanently deleted from the UploadStaging folder after being uploaded.
• pdftopng from Xpdf Tools was updated to 4.02.
• AutoUpdater.NET was updated to 1.5.8.

Fixes

• "PDFKeeper has detected that you've upgraded from an older version" message box should not be displayed when PDFKeeper is upgraded from version 5.0.0 or above.
• Upload status shows running after one or more PDF documents fail to upload.
• User Interface hanging while the Upload process is running.
• InvalidOperationException during an upload needs to be caught without displaying an error.

Additional Information

• Starting with PDFKeeper 5.0.0, Database Connection Pooling has been turned off to prevent PDFKeeper from consuming large amounts of memory on the database server causing "ORA-12518: TNS:listener could not hand off client connection".
• Oracle Database 19c (19.3) requires the Microsoft Visual C++ 2013 Redistributable (x64) - 12.0.30501 to be installed on the computer hosting the database.

Known Issues

• Annotations in a PDF document are not filtered by Oracle Database.
• Embedded fonts in a PDF document are not filtered correctly by Oracle Database.

Client Requirements

• Windows (32 or 64-bit) with .NET Framework 4.6.1 or higher installed.
• Any additional requirements will be referenced in the Help file that can be viewed post-install.

Compatible Database Management Systems

• Oracle Database 19c
• Oracle Database 18c
• Oracle Database 18c Express Edition
• Oracle Database 12c Release 2
• Oracle Database 12c Release 1
• Oracle Database 11g Release 2
• Oracle Database 11g Express Edition

Setup instructions are available in the Help file that can be viewed post-install.

Upgrade Information

• Database schema will require an upgrade. Database Schema Upgrade instructions are available in the Help file that can be viewed post-install.
• Oracle Data Access Components Runtime 19.3 is now required that includes an updated Oracle Data Provider for .NET. Instructions are available in the Help file that can be viewed post-install.
• User name and Data source will need to be entered on first login.
• Starting with version 4.0.0, PDFKeeper is installed per-user, requiring older, per-machine installs to be uninstalled manually.

New Features

• Flag Document feature has been added for setting the flag state on a selected document record and when PDF documents are uploaded as a way to mark for follow-up.
• Category feature has been added for setting or clearing the category on one or more selected document records.
• Optimistic concurrency has been added to Document Notes editing for preventing data loss during a save operation.
• Added compatibility for Oracle Database 18c Express Edition and 19c.

Improvements

• Logo for PDFKeeper has been changed.
• Manage Upload Folder Configurations form has replaced the Upload Folders and Upload Folder Configuration forms.
• Add PDF Documents form has been redesigned to allow adding more than one PDF document without leaving the form.
• All SQL statements that accept parameters have been parameterized to address SQL Injection concerns flagged by Code Analysis.
• Oracle Data Provider for .NET, included in Oracle Data Access Components Runtime 19.3 is now required offering better performance and security.
• Oracle Database user password is now being passed securely when connecting to the database preventing exposure in a page file swap or crash dump.

Changes

• AutoUpdater.NET was updated to 1.5.7.
• iTextSharp was updated to 5.5.13.1.
• pdftopng from Xpdf Tools was updated to 4.01.01.
• Description of PDFKeeper has been changed to "Open Source PDF Document Management System".

Fixes

• PDFKeeper was incorrectly detecting that an upgrade was performed from a prior version when no user settings exist from a prior version.

Development Changes

• All source code has been refactored and reorganized.

Additional Information

• This is the 10th year anniversary edition, officially released on the 10th year anniversary of PDFKeeper.
• Database Connection Pooling has been turned off to prevent PDFKeeper from consuming large amounts of memory on the database server causing "ORA-12518: TNS:listener could not hand off client connection".
• Oracle Database 19c (19.3) requires the Microsoft Visual C++ 2013 Redistributable (x64) - 12.0.30501 to be installed on the computer hosting the database.

Known Issues

• Annotations in a PDF document are not filtered by Oracle Database.
• Embedded fonts in a PDF document are not filtered correctly by Oracle Database.

Client Requirements

• Windows (32 or 64-bit) with .NET Framework 4.6.1 or higher installed.
• Any additional requirements will be referenced in the Help file that can be viewed post-install.

Compatible Database Management Systems

• Oracle Database 18c
• Oracle Database 12c Release 2
• Oracle Database 12c Release 1
• Oracle Database 11g Release 2
• Oracle Database 11g Express Edition

Setup instructions are available in the Help file that can be viewed post-install.

Upgrade Information

• Starting with version 4.0.0, PDFKeeper is installed per-user, requiring older, per-machine installs to be uninstalled manually.
• Direct Upload folder configuration files from PDFKeeper 3.x.x are not compatible with the Upload Folders feature introduced in PDFKeeper 4.0.0.

Database Compatibility Changes

• Added Oracle Database 18c, 12c, and 11g Release 2.

Improvements

• Exception type is now displayed and logged during an unhandled exception event.
• Sumatra PDF is now being closed by the Add PDF Document form after View Original or Preview has been selected while Sumatra PDF was open.

Changes

• Replaced the numeric datatype with number in the database schema creation script for Oracle as numeric is deprecated.
• Replaced all usage and references to the Oracle Database connect and resource roles in the schema creation script and Help file with only the required privileges as the connect and resource roles have been deprecated by Oracle.

Fixes

• Unhandled exception when PDFKeeper is unable to delete the "PDFKeeper Upload" shortcut when closing.
• Unhandled exception when exporting a PDF from a document record that no longer exists.
• Unhandled exception when selecting a document record in the Search Results DataGridView that no longer exists.

Known Issues

• Annotations in a PDF document are not filtered by Oracle Database.
• Embedded fonts in a PDF document are not filtered correctly by Oracle Database.

Client Requirements

• Windows (32 or 64-bit) with .NET Framework 4.6.1 or higher installed.
• Any additional requirements will be referenced in the Help file that can be viewed post-install.

Compatible Database Management Systems

• Oracle Database 11g Express Edition

Setup instructions are available in the Help file that can be viewed post-install.

Upgrade Information

• Starting with version 4.0.0, PDFKeeper is installed per-user, requiring older, per-machine installs to be uninstalled manually.
• Direct Upload folder configuration files from PDFKeeper 3.x.x are not compatible with the Upload Folders feature introduced in PDFKeeper 4.0.0.

Changes

• Updated links in the Oracle Database Express Edition (XE) Database Setup and Database User Administration help topics.
• View Original button is now selected in place of the Title text box when the Add PDF Document dialog loads.
• Default file name in Save As dialog is now set to the title of the PDF for the selected document record.
• iTextSharp was updated to 5.5.13.
• AutoUpdater.NET was updated to 1.4.11.

Fixes

• Unhandled Exception when saving a PDF for the selected document record to a file system and the target file name already existed.
• Combo box on "Search by String" tab is no longer selecting the first string in the drop down list that contains the text in text box, overwriting the text in the text box when the Search button is selected.

Known Issues

• Annotations in a PDF document are not filtered by Oracle Database 11g Express Edition.
• Embedded fonts in a PDF document are not filtered correctly by Oracle Database 11g Express Edition.

Client Requirements

• Windows (32 or 64-bit) with .NET Framework 4.6.1 or higher installed.
• Any additional requirements will be referenced in the Help file that can be viewed post-install.

Compatible Database Management Systems

• Oracle Database 11g Express Edition

Setup instructions are available in the Help file that can be viewed post-install.

Upgrade Information

• Starting with version 4.0.0, PDFKeeper is installed per-user, requiring older, per-machine installs to be uninstalled manually.
• Direct Upload folder configuration files from PDFKeeper 3.x.x are not compatible with the Upload Folders feature introduced in PDFKeeper 4.0.0.

Improvements

• User settings from prior version starting with version 4.0.0 will be migrated.
• Horizontal slide bar is now being displayed on the search results data grid view when the combined length of the search results exceed the width of the main form.
• Empty sub-folder(s) are now being removed from configured upload folder(s) by the upload process.
• Search Results Data Grid View now gets focus after a search.
• Author Combo Box on the "Search by Author" tab now drops down when a key is pressed after receiving focus.
• Subject Combo Box on the "Search by Subject" tab now drops down when a key is pressed after receiving focus.
• Author and Subject Combo Boxes on the "Search by Author and Subject" tab now drops down when down arrow key is pressed after receiving focus.
• Subject combo box drop down on the "Search by Author and Subject" tab will now always show correct subjects for the selected author when navigating with the keyboard.

Fixes

• "Improper usage of query operators and/or characters" error notification on the "Search by String" tab is being displayed for strings that end in characters that match a character based query operator.
• Paste menu and tool bar items are not always enabled when Notes text box has focus and the clipboard contains text.
• Corrected the Sumatra PDF usage description on its help topic.

Known Issues

• Annotations in a PDF document are not filtered by Oracle Database 11g Express Edition.
• Embedded fonts in a PDF document are not filtered correctly by Oracle Database 11g Express Edition.

Client Requirements

• Windows (32 or 64-bit) with .NET Framework 4.6.1 or higher installed.
• Any additional requirements will be referenced in the Help file that can be viewed post-install.

Compatible Database Management Systems

• Oracle Database 11g Express Edition

Setup instructions are available in the Help file that can be viewed post-install.

Upgrade Information

• Starting with version 4.0.0, PDFKeeper is installed per-user, requiring older, per-machine installs to be uninstalled manually.
• Direct Upload folder configuration files from PDFKeeper 3.x.x are not compatible with the Upload Folders feature introduced in PDFKeeper 4.0.0.

Improvements

• Installation is now per-user, no longer requiring elevated rights to install.
• User interface has been completely redesigned, adding additional search capabilities.
• PDF documents can now be opened from the Search Results list with the default PDF viewer or Sumatra PDF viewer (included in the binary release).
• Document Capture and Direct Upload have been replaced by a single integrated Upload process.
• All User Documentation is now contained within the help file.
• All database setup scripts are now called from the help file.
• Conversion script was created to switch the lexer in an existing database schema to the WORLD_LEXER where the lexer was changed.

Changes

• .NET Framework 4.6.1 is now targeted.
• WORLD_LEXER is now the default lexer for new database schemas.
• iTextSharp was updated to 5.5.12.
• PDF Preview images are now generated by pdf2png from Xpdf Tools v4.00, replacing GhostScript.
• Sumatra PDF was updated to 3.1.2.
• Application update is now handled by AutoUpdater.NET 1.4.7.
• Nini is no longer used to read and write XML configuration files. This functionality is now performed using .NET Framework serialization.

Development Changes

• Visual Studio 2013 is now used to build PDFKeeper.
• All code has been completely rewritten to address maintainability issues.

Known Issues

• Annotations in a PDF document are not filtered by Oracle Database 11g Express Edition.
• Embedded fonts in a PDF document are not filtered correctly by Oracle Database 11g Express Edition.