Search Optifacts User Documentation
Table of Contents (on this page)
Introduction
This document provides instructions for retail field translations. This table is used to translate incoming data into Optifacts format.
Procedure
From the Optifacts main menu:
Type 11 – Retail Transfer and press enter.
Type 5 – Editor: Field Translation and press enter.
The Retail Translation Table displays.
Add a new entry
- Type A to add a new record.
- Enter all the applicable data about the frame pressing enter past each field. (OPTI2.8 - OPTI must be capitalized.)
- System Name - Enter the system name for the file format that will contain this field. Note: OPTI must be capitalized.
- Account Code - Enter 0 for all accounts or enter a specific account number. Note: The number must be right justified. A correct example would be [ 123] and an incorrect example would be [123 ].
- Field Name - The field name recognized by the Optifacts system.
- Field Order - The number to match order in the retail field location editor (menu 11-5-4).
- Source String - Enter the exact pattern of the data as it occurs in the input record. An example is the lite-up chosen from TNT or VisionWeb. (Type NULL if blanks expected or ANY OTHER for suffix or prefix).
- Return String - The translated string to pass to Optifacts to replace the source string.
- Prefix - Enter ^ where spaces are required.
- Suffix - Enter ^ where spaces are required
- Notes - Information or description of the translation entry.
- Example:
- Press Escape to save the data.
- Press ctrl-c to exit without saving the data.
Edit an existing entry
- Type Q to Query.
- Type the applicable details using the fields provided and press escape.
The specified data will display on the screen.
- Type U to update the data.
- Make any necessary changes.
- Press escape to save the data.
- Press crtl-c to exit without saving.
- Type E to exit and return to the Retail Transfer menu.
