IM (800) 929-1953

Defining an Import Format

Formats are saved for future use
Define only how the SouthWare® file is to be affected - you don't have to define fields in the import file that won't be used
Option to assign a key for selected key fields or assign a default for other selected fields
Option to insert a fixed value in a field
Option to leave a field unchanged in existing records
Option to add new records, to update existing records, or both

Input File Options

Fixed Format ASCII files - format with fixed position fields such as found in text files, spool files, print files
Fixed Position Text Files (often called a Flat File when used in conjunction with EDI products)
DIF format - data interchange format commonly used by spreadsheets
Comma-delimited format - easily-created format commonly used by databases
Other-delimited formats - delimiter can be tab, merge code, or any ASCII character
Multiple record types
Combine multiple record types for a single target record
Handles special editing characters such as dollar signs, minus signs, and slashes or dashes in dates
Option to assign key fields, assign fixed data to a field if not available in the input file, and leave certain fields unchanged
Option to use SouthWare's ReportMate™ to output selected data and then use ImportMate II™ to change it during import

Stand-Alone Databases

Create Your Own Sales Period History

Create your own period history records that are automatically updated by invoicing
Up to 10 types of records for invoice header information
Up to 10 types of records for invoice line item information
Up to 5 key fields per type
Up to 15 fields per type

Total Integration with SouthWare Excellence Series™