This is a simple little tool to create report templates for CargoWise.
It is packaged on the NuGet Package Manager as a dotnet tool, so you can install it by writing dotnet tool install CargoWiseReportTemplateCreator into a terminal.
You can then use the tool by writing cwreporttemplatecreator in a terminal.
You can use the tool multiple times on the same report file. The tool will simply create a new sheet for whatever table you are adding to the report. So as an example, you can do the following:
cwreporttemplatecreator -t JobCharge -c JR_PK JR_JH JR_GE -o "Replication Data Template.xls"
cwreporttemplatecreator -t AccChargeCode -c AC_PK AC_Code AC_Desc -o "Replication Data Template.xls"This will create a single file Replication Data Template.xls that
has two sheets, one for JobCharge and one for AccChargeCode.
You can do this with as many tables and columns you want.
Afterwards, all you have to do in CargoWise is go to Reports and make a new report with this template.