UPDATE YOUR DATA AUTOMATICALLY

With Data/File Importer you have the ability to take data files created by other software products and add new records or update existing records in your Ormandy system. It's very simple to use, so you do not have to be a programmer. And it's very flexible, so you can use it in many different ways.

Data/File Importer is a module that you can use to automatically input data into selected files. You simply specify how each field in a file is to be affected by an imported file. Data/File Importer prompts you for all the information it needs and checks to make sure that the data you are bringing in is valid. You get the ease and speed of automated updates with the same verifications you would get if you keyed the data directly into your system.

WITH DATA/FILE IMPORTER, YOU CAN:

• Access data created by most software products via commonly-used data formats.
• Create valid new records even if your incoming data file doesn't contain all the necessary fields.
• Update selected records in existing records while leaving other fields unchanged.
• Test incoming data files before importing to make sure there are no surprises.
• Streamline common updates for such situations as electronic time clocks and vendor-supplied price
       files.
• Use Report Generator to output data to be changed, then use Data/File Importer to change it.
• Use the DocTransfer module to streamline the process ofimporting data from EDI products or other
       trading partner document files.

INPUT FILE OPTIONS

• DIF format - data interchange format commonly used by spreadsheets
• Comma-delimited format - easily created format commonly used by databases
• Fixed Format ASCII files - format with fixed position fields such as found in text files, spool files,
       print files
• Handles special editing characters such as dollar signs, minus signs, andslashes 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 filed unchanged
• Option to use Report Generator to output selected data and then use Data/File IMporter to change
       it during import
• Fixed position text files (often called a flat file when used in a conjunction with EDI products)
• 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

TESTING AND UPDATING DATA

• Option to test a range of input records
• Automatic testing with error report prior to update
• Option to skip testing for frequency

DEFINING AN IMPORT FORMAT

• Formats are saved for future use
• Define only how the 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
• Field values are validated when possible
• Option to add new records, to update existing records, or both

OPEN COMPONENT TECHNOLOGY

• Allows direct access to import capabilities from with other programs and software