Green Shoe Garage · Field Instrument FI-133

PORTAGECMMS cargo translator · export files in, import files out

The portage trail Lanes carrying each record type from the source bank to the target bank. Lane thickness is record count. A lane narrows where records or fields are lost.

No cargo landed yet. Load a source export at LANDING.

Landing

Drop the source export here. Workbooks with several sheets, exports split across several files, vendor title rows, merged headers and units written into cells are all expected. Nothing is translated until you have read the cargo summary.

Drop .xlsx, .csv or .txt exports here

Sniffer idle.

Cargo summary

One entry per landed table, before any translation. Confirm the record type the sniffer assigned before moving on.

Mapping bench

Two things live here. Columns the cargo model has no field for can be carried across as extension fields, if the target has room and if you say so. And any column, mapped or carried, can be put through a transform before it is read, so a value that is nearly right can be repaired once rather than by hand a thousand times. Every transform that moves a value is written into the exception report.

Nothing landed yet.

Mapping profile

A profile is the mapping, the carry choices, the transforms, the cadence approvals and the arbitration, written out as plain JSON so the work done once on this pair of systems can be reused on the next site. Before a profile is applied it is checked against the export in front of you, because a profile written on last quarter's export is the quiet way a load ends up full of empty columns.

Cargo weight

What is actually being held, measured from your cargo rather than guessed from the row count. A browser has a ceiling and PORTAGE would rather show you where it is than let you find it halfway through a migration.

Passes

A migration too big for one pass can be run in several, by site or by record type. Write a receipt after each pass, load the receipts back here, and the evidence merges into one exception report and one summary. Receipts hold the counts, the findings and the exceptions, never the cargo.

Idle

About PORTAGE

PORTAGE, Field Instrument FI-133. Version 1.5.0.

A CMMS cargo translator. It reads exported files and writes import files. It never connects to any maintenance management system, and it never sends anything anywhere. Everything happens in this page, on this machine.

License: GPL-3.0.

Asset provenance. Every mark on screen is hand authored inline SVG and CSS, original work under the same license. Typography uses platform font stacks. No font, image or sound file is embedded or fetched. No third party library is used: the zip reader and writer, the DEFLATE compressor and decompressor, the xlsx reader and writer and the CSV parser are all written here.

Feedback. Notes, defects and dialect corrections go to Green Shoe Garage at greenshoegarage.com, or open an issue on the project repository. Include the session export and the exception report if you can.

Session

The whole job travels as one JSON file: landed cargo, dialect choices, hierarchy findings, cadence approvals and reconciliation arbitration. Hand it to someone else and they pick the migration up where you left it.

Self test