DOS WARES Export Mapper

DOS WARES is capable of writing flat-file and structured exports of individual transaction records, selected database cursors, and entire tables (files).

From menu selection eXchange ‣ Export-Import ‣ Exports, export maps may be defined to write masterfile and transaction text data in specialized formats, such as

  • JSON structured documents (.JSN).
  • QUICKBOOKS import format (.IIF).

Executing an Export

Export maps define both the structure of the exported data and the method for naming and locating the exported files. Demand exports are executed through the EXPORTDATA command, which is usually managed through a control record for either a PROCESS or a REPORT.

WARES posting controls can generate transaction exports using database triggers. This alternative to demand exports will create export files from database activity without user interaction.

Add JSON Exporting to WARES

The WARES 450 patches bundle has been updated to include JSON exports. Use the patch instructions from Update Patches files to install the JSON datafile from the patches. This bundle includes:

  • Revised programs EXPORTDATA and POST_EXPORTDATA.
  • Updated mapper window CTL_EXPORT with added JSON features.
  • Export maps for setup files ADDRESSES, ACCOUNTS, and PRODUCTS.
  • Export maps for inventory transactions: RECEIPTS, SHIPMENTS, ADJUSTS, HISTORY, DETAILS, DETAIL_HISTORY.
  • Export maps for billing files: TARIFFS, CHARGES, INVOICES, and PAYMENTS.
  • Dictionary updates adding fieldnames required for JSON exports.
  • Process records to perform batch exports of the files previously listed.

Note

For interactive export of transactions, changes to control records POST_RECEIPTS, POST_SHIPMENTS, and POST_ADJUSTS to export transactions using database triggers.

Note

On-line WARES documentation is not updated to explain JSON exporting or the steps for transaction exporting as reports or through posting controls.