Workflows¶
Check Files in Manifest¶
To verify all the files referenced in the manifest file are present, the command manifest-check can be used.
In order to do this, the manifest must be a single table tsv file encoded in UTF-8. Excel files will NOT work on their own. It must be first converted.
Once converted, the command tripwire manifest-check followed by the path to the .tsv file and the path to where the files are located, will initiate the check.
The order of operations:
convert excel file into batches of .tsv files. One format per .tsv file
Use tripwire manifest-check command
Convert Excel to .tsv file¶
This has become increasing more challanging to do with more recent version of Microsoft Excel. Here is how I was able to get it.
Open the manifest Excel document.
Copy the data for a single format into a new Excel document and using “Save As”, save it using the File Format “UTF-16 Unicode Text”.
Open that file in Microsoft Visual Studio Code (aka VS Code). This is not the same as Microsoft Visual Studio.
In the bottom right hand corner of VS Code, click the text that says “UTF-16”. A text box will pop up, and select “Save With Encoding”.
Select UTF-8.
Optionally change the extension of the file from .txt to .tsv.
You should now have a tsv that you can work with.
