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 detailed 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