Skip to content

Latest commit

 

History

4 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 

Repository files navigation

Passport Extractions Multitool

A Windows desktop tool for working with Passport (PassportDataMaintenance) extraction files.

Download the latest version and run it. There is nothing to install.

What it does

Split a full extraction into one file per section. Point it at a single large XML or JSON extraction and it writes Taxes, Departments, Items and the rest as separate files. The format is detected from the file's content, so it does not matter what the file is named. Section bodies are copied across exactly as they were, byte for byte.

Merge the pieces back into one extraction: the reverse of Split. Point it at a folder of section files, tick the ones to include, and save the combined file. Sections are written in Passport's own order whatever order the files are in on disk, and the text is copied byte for byte, so merging a file you have just split gives back the original unchanged. You can leave sections out, and set the Passport version on the way. It refuses to merge files from different stores, or the same section twice.

Change the Passport version on existing extractions, in place, for a single file or a whole folder. Only the version is rewritten; nothing else in the file changes, and backups are kept by default.

Convert between XML and JSON. Point it at a folder and each file is converted to the opposite format, whether it is a full extraction or a single section. Where the two formats do not carry the same information, the log says what was assumed or left out. If the folder holds extractions from more than one store, pick the store and only that store's files are listed, so files from different stores are never mixed.

Verifone → JSON: turn a folder of Verifone/PDI NAXML files into Passport JSON. Departments, mix & match discounts and items are detected and converted to Departments.json, Discounts.json and Item.json. If a department has no tax group in the source, the tool asks you to assign one rather than guessing.

Compare two extractions and see what differs: two stores side by side, or a before and after of the same store. Either file can be XML or JSON, a full extraction or a single section. Every difference names the record it belongs to rather than a position in the file, and values are compared as values, so a rate written 6.5 in one file and 6.50 in the other is not reported. Read it on screen or save it as a text file.

Readable Guide: turn any extraction into a plain, readable outline of everything programmed in it, and save it as a text file.

From Database: build an extraction straight from a Passport database, the way Passport's own tool does, without needing an existing extraction file. Point it at a GlobalSTORE.ful backup, pick the sections you want (or all of them), choose JSON or XML, and save. There is no SQL Server to set up: the first time, it offers to download Microsoft's SQL Server LocalDB engine (about 53 MB, once) and installs it for you, then it just runs. Only the sections it can build reliably are written; the rest are left out rather than guessed, and what it produces matches converting that store's own extraction. Advanced users can point it at an existing SQL Server instance instead.

Converter: build Passport import files from a Commander/Verifone export. This one is still in progress, so it is hidden until you turn it on under Settings > Experimental features.

Requirements

Windows. Nothing else: the download is a single self-contained .exe.

Updates

The tool checks the releases page when it starts and shows a strip at the bottom of the menu on the left when a newer version is out. There is also Help > Check for updates... if you want to ask at any time.

It can install the update for you: it downloads the new version, checks it, closes and reopens on the new one. It only ever does that when you say yes. Nothing is downloaded or replaced in the background, and saying no leaves your version exactly as it is. Save your work first, since the tool has to close to reopen.

Windows will warn you the first time

The tool is not code signed, so the first time you run it Windows shows a blue "Windows protected your PC" screen. Click More info, then Run anyway. Your browser may also ask you to keep the download rather than discard it.

The warning is Windows saying it does not recognise the file, not that it found anything wrong with it. Expect it again after an update, because each new version is a new file as far as Windows is concerned.

Only ever download it from the releases page linked above.

Status

Beta, and under active development. It is a work in progress and may contain bugs.

  • The developer is not responsible for any missing, incorrect or lost data, or for any other issue that may result from using this tool.
  • Back up your data before using any file this tool generates, and check every output before importing it into Passport or any other live system.

Use at your own risk.

Legal

This is an independent tool. It is not developed, approved, endorsed, or supported by Gilbarco Veeder-Root, its parent, or any of its affiliated companies.

Passport is a trademark of Gilbarco Veeder-Root. All other product names and trademarks are the property of their respective owners, and are used here only to describe what the tool works with.

Licence

Free to download and use, including at work. It is not open source: the source is not published, and the tool may not be sold or passed off as someone else's work. See LICENSE for the terms and THIRD-PARTY-NOTICES.md for the open-source components bundled inside the download.

Notes

Changes in each release are listed on the releases page. The source is kept in a separate private repository.

Developed by Josh B.

About

Windows tool for Passport extraction files: split a full extraction, convert between XML and JSON, re-stamp the Passport version, and produce a readable guide.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors