Export Vendor Data


Utilities Menu -> XML Data Exports -> Export Vendor Data

System Maintenance Menu -> Configure System Settings -> Automatic Job Scheduling -> Function XMLEX13A -> runs Export Vendor Data to an XML export

System Maintenance Menu -> Configure System Settings -> Automatic Reporting -> Function XMLEX13B -> runs Export Vendor Data to a CSV file output


This utility can be used to generate an XML or a CSV export data file for a range of vendor records and the exported data includes all fields in the Vendor Information table.

This export process is NOT triggered by any Daily Close posting process.

The prompts in this Export Vendor information utility are:

FROM VENDOR #
Leave this field blank to include all vendors, or enter a starting vendor number for the range, or look for a starting vendor in the Vendor Search window.

TO VENDOR #
Leave this field blank to include all vendors, or enter an ending vendor number for the range, or look for an ending vendor in the window.

OUTPUT TYPE
Select one of the following types of export file:
  • Select XML to create an xml output file in the XML Data Exports directory defined in the Company Daily Close Parameters.
    The name of the resulting XML file is prefaced with the company code and then APVF (Accounts Payable Vendor File) followed by the date and time.
    i.e. TRS_APVF_YYYYMMDD_HHMMSS.xml

    EMAIL:
    The option to email the resulting XML files to the operator currently signed in, is setup in the Company Daily Close Parameters.

    The XML export can also be triggered automatically from the Automatic Job Scheduling by the function XMLEX13A.

    Note: The XML Export Vendor Information does not require or utilize the parser because the data will overlap and it is not in a transactional format, nor does it write to the View Application Log.

  • Select CSV to generate a 'Comma Separated Values' file which saves the data in a table structured format that looks like a spreadsheet but has a .csv extension.
    This CSV file is created in the directory defined for the XML files in the Company Daily Close Parameters.

    SEND EMAIL
    This email option is provided for the CSV export.

    Check this box to send an email.
    Uncheck this box to suppress an email.

    The CSV export can also be triggered automatically from the Automatic Reporting by the function XMLEX13B.


Finished?
Click ACCEPT to export the data in the range directly to the XML or CSV file in the XML Data Exports directory defined in the Company Daily Close Parameters.

Click CANCEL to abort the export action.


Topic Keyword: XMLEX13 (3900)
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)