Topic Overview 


XML Central provides the ability to export data from within System Five. In this topic is a list of the export types and the information that is available for export for each of the types. The export types and their related export options are deta
iled in Table 1.


Export Type
Export Options
None
This type is a place holder in the event that an export type has not yet been selected.
Inventory
Exports the contents of the Inventory from within the System Five database. In Departmental Systems, the Price Schedules for each Department are included in the Export.
Options:
wwExportSellingComment
wwExportPurchaseComment
wwExportWebComment
wwExportFreeForm
wwExportLkupWords
wwExportPurchasePrice
wwExportAlternatePart
wwExportContractPrice
wwExportSupplier
wwExportBrand
wwExportKitInfo
wwExportPictures
wwExportMatrixSizes
wwExportMulti
wwExportTranslate
wwExportEncode
wwExportInvoiceComment
wwExportSPIF
wwExportSearchWords
wwExportLabour
wwExportNoLocations
Categories
Exports the Main Category information from within the System Five database.
Option:
wwExportCategories
Sub Categories
Exports the Sub Category information from within the System Five database.
Options:
wwExportMainCat
wwExportMulti
Invoices
Exports the Invoices from within the System Five database.
Options:
wwExportCoInfo
wwExportAccounts
wwExportUnitFile
wwExportMulti
wwExportTranslate
wwExportEncode
wwExportPayments
wwExportWarningComment
wwExportLkupWords
wwExportFreeForm
Customers
Exports the Customers from within the System Five database.
Options:
wwExportWarningComment
wwExportFreeForm
wwExportHistoryComment
wwExportPriceSchedule
wwExportContractPricing
wwExportStandingPurchaseOrder
wwExportContacts
wwExportShippingAddress
wwExportMulti
wwExportTranslate
wwExportEncode
wwExportPriceExceptions
Suppliers
Exports the Suppliers from within the System Five database.
Options:
wwExportWarningComment
wwExportFreeForm
wwExportHistoryComment
wwExportPriceSchedule
wwExportContractPricing
wwExportStandingPurchaseOrder
wwExportContacts
wwExportShippingAddress
wwExportMulti
wwExportTranslate
wwExportEncode
Country
Exports the contents of the Country table from within the System Five database.
Purchases
Exports the Purchase Orders from within the System Five database.
Options:
wwExportCoInfo
wwExportSupplier
wwExportComments
wwExportLkupWords
wwExportFreeForm
wwExportMulti
wwExportTranslate
wwExportEncode
wwExportLines
wwExportInventory
Appointments
Exports the Appointments from within the System Five database.
Option:
wwExportCustomer
UserOptn
Exports the User specific options from within the System Five database.
Options:
wwExportBlobs
wwExportEncode
wwExportComments
wwExportPictures
WForm
Exports the Form design information from within the System Five database.
Options:
wwExportBlobs
wwExportEncode
wwExportComments
wwExportPictures
Contacts
Exports the Contact information from within the System Five database.
Options:
wwExportMulti
wwExportTranslate
wwExportEncode
SComment
Exports the Comment information included in the legacy Short Comment table from within the System Five database.
Option:
wwExportTranslate
ARPyment
Exports the Accounts Receivable Payment information from within the System Five database.
Options:
wwExportCustomer
wwExportMulti
wwExportTranslate
Items
Exports the Item Stock record information from within the System Five database.
Options:
wwExportTranslate
wwExportInventory
wwExportPurchasePrice
wwExportMulti
wwExportKitInfo
ItemLogs
Exports the Inventory Item log information from within the System Five database.
Kits
Exports the Kit Information from within the System Five database.
Option:
wwExportTranslate
Units
Exports the Unit information from within the System Five database.
Options:
wwExportFreeForm
wwExportComments
wwExportLkupWords
wwExportEncode
wwExportInventory
wwExportItem
wwExportMeta
wwExportStatus
Ledger
Exports the Chart of Account with 4 Digit account numbers from within the System Five database. This is the structure of the Chart of Accounts only. The Transaction information must be exported separately.
LongLedger
Exports the Chart of Account with 20 Digit account numbers from within the System Five database. This is the structure of the Chart of Accounts only. The Transaction information must be exported separately.
ARTran
Exports the contents Accounts Receivable Sub Ledger from within the System Five database.
Option:
wwExportTranslate
Transactions
Exports the General Ledger Transaction information from within the System Five database.
Option:
wwExportTranslate
wwExportMulti
wwExportEncode
Words
Exports the contents of the Words table from within the System Five database. The Words table contains the User information, settings and security settings. Therefore the contents of this table should be kept in a secure location.
Option:
wwExportEncode
wwExportTranslate
AltSuply
Exports the Alternate Supplier information for Inventory Items from within the System Five database.
Option:
wwExportTranslate
Modifiers
Exports the Modifiers information from within the System Five database.
Option:
wwExportTranslate
AltParts
Exports the Superseding Parts information from within the System Five database.
Alternate Parts were replaced by Superseding Parts in release version 5.32.0.1 
Option:
wwExportTranslate
BlobHead
Exports the data stored in Binary format from within the System Five database. This includes pictures and text.
Option:
wwExportTranslate
wwExportPicturesToFile
Employee
Exports the contents of the Employee table from within the System Five database.
Option:
wwExportTranslate
TimeSheet
Exports the contents of the Employee Time Sheets that contain entries from within the System Five database. Blank Time Sheet entries are ignored.
Option:
wwExportTranslate
Keywords
Exports the contents of the Keyword list from within the System Five database.
Option:
wwExportTranslate
Bill
Exports the Accounts Payable Bill information from within the System Five database.
Options:
wwExportTranslate
wwExportSupplier
Check
Exports the Accounts Payable Check information from within the System Five database.
Options:
wwExportTranslate
wwExportSupplier
wwExportBills
Terminal
Exports the Terminal specific information from within the System Five database.
Option:
wwExportTranslate
ItemHist
Exports the contents of the Inventory Item History table from within the System Five database.
Option:
wwExportTranslate
SPIF
Exports the contents of the SPIF table from within the System Five database.
Option:
wwExportTranslate
Currency
Exports the contents of the Multi-Currency table from within the System Five database.
Option:
wwExportTranslate
CurRates
Exports the contents of the Currency Rates table from within the System Five database.
Option:
wwExportTranslate
CommentData
Exports the contents if the Comment table from within the System Five database.
Option:
wwExportTranslate
JobCost
Exports the contents of the Job Costing table from within the System Five database.
Options:
wwExportTranslate
wwExportCheckList
Errors
Exports the contents of the Error Log table from within the System Five database.
Option:
wwExportTranslate
Grid
Used internally by System Five to export information from the Girds within the application.
Do not use this for basic exports.
DataTree
Used by System Five's Polling Application and is not intended for basic exports.
Existing
Used by the Additional Processing feature. Do not use this export type for basic exports.

Table 1: The export types and related Options