Open topic with navigation

Data Transfer Overview

Menu selections on the Data Transfer menu allow you to import and export data. You can import and export account and vendor data. You can import general ledger and accounts payable transactions, deposit refund transactions, and budget data.

Note

Depending on the applications purchased by your company, purchase order-related tabs can display from either eFinancials or ePO menus.

File Format Types

With the exception of the AP Transaction Import files, import files can be named anything; however, files used for import must be in the correct format. The following three basic file formats can be imported (not all imports support all file types).

SDF: System Data Format

An SDF file is an ASCII text file in which records have a fixed length and end with a carriage return and line feed. Fields are not delimited.

CSV: Comma Separated Values

A CSV file is an ASCII text file in which each record ends with a carriage return and line feed. The field separator is a comma. Because character data can include commas, character fields are delimited additionally with double quotation marks. Field widths are maximums. Commas must be added for all fields in the layout even if the field is not required.

XML: Extensible Markup Language

An XML file is an ASCII text file in which each record is delimited with a set of tags. XML field specs are provided as schemas files that can be used to validate the file.

File Formats

The following table shows the eFinancials applications that enable you to import and export data, and identifies the required file formats for each.

See Also

Account Numbers

Batches

Date of Record

Import Error Message

Exception Report