|
Fixed Position Format |
Top Previous Next |
|
An ASCII format where the same fields have the same position on each line. When selected the upper centre panel becomes visible Fixed Position Format refers to the position of the characters in a file, in which each item in a field has the same starting position. (in other words, the text lines up). For Databuild to read this file, and to populate the table with the correct value for each field, you need to specify the starting position of each field entry. Do this by quoting the number of characters to be read before this point. Use the counter at the top of the text box to read this number.
Before importing, enter the following: Template file. You can load (
Template: Possibly the name of the Supplier. You can save this template and load when importing price files from this supplier (if the format is constant). If you are importing from many suppliers, keep a different template file for each one
Factor: You can increase or decrease all prices by a fixed factor
Header Lines: Type the number of lines you want the system to ignore when importing (they may include headings such as an address or title which will not be part of your price file).
Strip Quotes: Some price files will show quotation marks around items. Check this to remove quotation marks before importing.
From Values: Indicate starting position of items in each field
Until Values: Indicate finishing position of items in each field
|