Defining Delimited File Formats with Multiple Formats

From the JD Edwards EnterpriseOne Table Conversion director, access the Select Input form or the Select Outputs form.

1. Select User Defined Format, and then click Define Format(s).

2. On the User Defined Format - Type form, select the Delimited - Characters such as commas or tabs separate each column option.

3. Select the Multiple Formats - Rows are in two (2) or more formats option, and click Next.

4. On the User Defined Format - Column Delimiter form, select the delimiter that separates the columns in the file:

   • Tab

   • Comma

   • Semicolon

   • Space

   • Other

5. Select the textual qualifier that is used to enclose a string of text, and click Next:

   • None

     Select this option if no character is used to qualify text in this user-defined file.

   • Single Quotations

     Select this option if a single quotation mark is used to qualify text in this user-defined file.

   • Double Quotations

     Select this option if a double quotation mark is used to qualify text in this user-defined file.

6. On the User Defined Format - Multiple Format Definition form, enter the number of formats that are included in the user-defined format.

7. To define the character length of the Form Designator Column, enter a value in the Length field, and click Next.

8. On the User Defined Format - Multiple Format Names form, name each format and define the values for each using the Name and Designator columns, and then click Next.

   The Designator name should describe the data in the user-defined formats.

   For example, suppose that a text file contains purchase order information. Lines in the table have information for a whole purchase order with the first field designated as POH; lines with a first field designated as POI contain information about individual items in the purchase order; and lines in the table with a first field designated as POT contain information about purchase order totals. In this scenario, you would enter POH as the designator of the first format, POI as the designator of the second format, and POT as the designator of the third format.

   Note: You can rename the columns for each format to help you remember the formats with which you are working. For example, you can rename the columns according to their function in the file, such as Header, Detail, and Total. These names appear in the Inputs list on the Mapping form of the table conversion.

9. On the User Defined Format - Column Layout form, select a format from the list of available formats.

   You define the columns for the format so that the system can parse the information from the file.

   Note: To move rows, including the Format Designator, select the row and drag it to a new location.

10. To add additional columns, click Add to define the column.

11. On the New Column Properties form, modify these fields as required, and click OK:

    • Name

    • Length

    • Type

12. To edit an existing column, select it, click Edit, and change the properties on the Column Properties form.

13. To model the columns after an existing table, business view, or foreign table, click Model, select the appropriate tab, and then select the table or business view that you want to use as a model for the user-defined format.

    Note: You cannot model the columns after an existing object unless the layout of the two objects match.

14. Click OK, and then click Next.

    The system copies the format from the model that you selected and places it into the column layout grid.

15. On the User Defined Format - Finish form, click Finish.