Getting Clean Data OUT of CargoWise Is Harder Than Putting It In

Getting data out of CargoWise is only the beginning. A report also needs to preserve the source rows, explain its currency basis and show when the extraction is incomplete.

The charge-code trap

Two freight charges can share the same code. A parser that stores one row per charge code can overwrite the earlier amount. In the worked example in Volume 3, both freight rows survive, along with a credit, a zero cost and an unknown cost.

The unknown cost matters. The example reports known costs and revenues separately, but leaves whole-job margin incomplete until the missing amount is supplied. A blank field does not become zero just because the dashboard needs a number.

Operational costs and posted accounts are different sources

WiseTech's Universal XML Guide distinguishes job-related costing from posted accounting transactions. Choose the source that matches the business question before building the query. A shipment profitability view is not automatically a posted sales ledger or cash report.

For retrieval, start with documented Native Key and Partial patterns, known-job shipment requests and existing accounting-batch exports. Keep interface, company context and response status explicit. Validate any additional date filters against your own current schema rather than assuming one universal query dialect.

A report needs a completeness check

Count expected and returned identities. Preserve the source snapshot. Keep transaction checkpoints aligned with accepted data, and test replay and interrupted runs. Display the last complete extraction alongside the report, so a dashboard refresh cannot disguise stale source data.

Volume 3 is available

CargoWise Data Extraction & Accounting via eAdapter is a 33-page guide with seven chapters and two appendices, plus four XML templates, Python examples with 15 checks and SQL for a local reporting database.

The templates follow the vendor references identified in the book. The runnable examples use fictional records and demonstrate local behaviour. They do not claim a live compatibility test against your CargoWise installation.

Read Chapter 1 free (PDF), or get Volume 3 for $149.

The three-volume bundle is $297, with Volume 1 included free when you buy Volumes 2 and 3.