This tooling assists in the migration from Mariner Software's Paperless to Paperless-NG.
- MSP - Mariner Software Paperless
- PNGX - Paperless-NGX
- Basic migration works
- MSPL loses the Organization (should be straightforward to fix this - it is separate to Merchant inside SQLite)
Mariner software is apparently no longer business, and as such migrating away from this software is a priority (before it doesn't work after a system upgrade).
MSP stores all attribute data in a SQLite database, and the related PDFs are stored on the filesystem in a date based layout.
See receipts.sql for the query we use to extract all the data.
PNGX offers a REST API to upload documents, correspondents, tags etc and configure them.
Backup everything and ensure you can recover in the event of a catastrophe.
The most likely issue is the migration tooling to terminate, leaving the most recent migration incomplete. PNGX is fairly robust at restarting imports (skipping the previous one). However the metadata won't be updated. You are better off deleting everything and starting again.
Read the SQLite database and extract required metadata about each file that needs to be migrated.
Verify that all files are currently in place in the MSPL archive.
Verify that all attributes have a target attribute in PLNG. (we could set a mapping of attributes, and force the user to declare an attribute be dropped if they don't want it).
If the target already exists, skip the file. We will assume that the attributes are correct once the upload is done. This might be a bad assumption.
Upload each file, setting all attributes on the target file.
Include the ID from the MSPL receipt (Z_PK) so we can find the location of the file on the target side.
See the verify section for some concepts here.
Once all files for a given day are complete, write a checkpoint file so we don't have to recheck that day.
The Merchant is stored in the Title field
The Title is stored in the Title field The Merchant is stored in the Organization field