27 Working with the Text File Processor

This chapter contains the following topics:

27.1 Understanding the Text File Processor

The Text File Processor is a tool that is used to convert JD Edwards EnterpriseOne data to text files in the formats that are required by external entities, such as banks or government agencies.

To use the Text File Processor to create a text file, you must run one of the programs that has been set up to populate the Text Processor Header table (F007101) and Text Process Detail Table (F007111). These programs populate the text processor tables:

  • IDEP/IRIS Interface (R0018I3).

    (Intrastat Data Entry Package/Interactive Registration of the International Trade Statistics)

  • SEMDEC Interface - VAT EC Sales List (R0018I4).

    (Single European Market Declaration)

  • Draft Remittance File Format AEB 19 - Spain (R74S6729).

    (Asociación Española de Banca [Spanish Bank Association])

  • Draft Remittance File Format AEB 32 - Spain (R74S6722).

  • Draft Remittance File Format AEB 58 - Spain (R74S6728).

When you run any of these programs or any other programs that populate the text processor tables, the system creates a text batch in the text processor tables with the information that the program generates. For example, all of the information that is required for the IDEP/IRIS Intrastat declaration is stored as one text batch.

Text batches are stored in these tables:

  • Text Processor Header (F007101)

  • Text Processor Detail Table (F007111)

The F007101 table stores information about the extraction of information for an external system, such as information about the processes that populated the table and information about the creation of the text file. The F007111 table stores the text for the text file.

When you export or import text in the Text File Processor, the system uses the seventh field from Next Numbers System 00.

You use the Copy Text function in the Text File Processor to copy the information from the text batch to a flat file that can be copied to disk or other media, and then submitted to the appropriate entity. When you use the Copy Text function, you can specify the location and filename for the flat file that is created.

27.2 Copying, Importing, and Resetting Text Files

This section provides overviews of the copy text function and import process and discusses how to:

  • Set processing options for Text File Processor (P007101).

  • Copy text.

  • Import text.

  • Reset a text batch.

27.2.1 Understanding the Copy Text Function

Use the Copy Text function to copy text from the Text Processor Detail Table (F007111) to a text file that can be submitted to an external agency or system. When you copy the text, specify the filename and location for the text file.

The system updates the Text Processor Header table (F007101) with the date when the text was copied. The system also updates table F007101 to indicate that the batch has been processed.

Note:

If the text file is too large for the device that you selected, the system displays an error message. You should copy the text file to a larger device. You can then use a compression utility to reduce the size of the text file, if necessary.

The system displays a value of 1 (Processed/Outbound) in the Status Flag field on the Work With Text Batches form to indicate that the batch has been processed successfully.

27.2.2 Understanding the Import Process

You can import information from an external text file to the JD Edwards EnterpriseOne system. When you import a text file, the system creates a batch in the Text Processor Header table (F007101) and the Text Processor Detail Table (F007111). To move the information from the Text Processor Header and Detail tables into other tables in JD Edwards EnterpriseOne, you must run a batch program that has been designed to retrieve data from tables F007101 and F007111.

After you import text, the system displays the new batch in the detail area on the Work With Text Batches form. A value of 5 (Unprocessed/Inbound) in the Status Flag field indicates that the batch has been imported successfully.

27.2.3 Prerequisite

Before you complete the tasks in this section, you must create a text batch by running a program that uses the Text File Processor.

27.2.4 Forms Used to Copy, Import, and Reset Text Files

Form Name FormID Navigation Usage
Work With Text Batches W007101A Text File Processor (G0071), Text File Processor

Complete the User ID, Batch Number, and Transaction Number fields on the Work With Text Batches form. Then, select a record, select Maintain Batch from the Row menu, and then select Reset Batch.

Reset a text batch.
Copy Text To Text File W007101B Text File Processor (G0071), Text File Processor

Complete the User ID, Batch Number, and Transaction Number fields on the Work With Text Batches form. Then, select a record, select Process Batch from the Row menu, and then select Copy Text.

Copy information from a text batch to a flat file that can be copied to disk or other media.
Import Text To Text File Processor W007101C Text File Processor (G0071), Text File Processor

On the Work With Text Batches form, select Import Text from the Form menu.

Import information from an external text file to the JD Edwards EnterpriseOne system.

27.2.5 Setting Processing Options for Text File Processor (P007101)

Processing options enable you to specify the default processing for programs and reports.

27.2.5.1 Process

Path Microsoft Word Template

Specify whether to override the location of the Microsoft Word template to be used during creation of the text file. The ActiveX copy text creates a Microsoft Word document based on the normal.dot template, which is normally located in c:\Program Files\Microsoft Office\Templates\normal.dot. If the Microsoft Office objects have been installed in a different path, you need to enter the correct path for the location of the normal.dot template.

27.2.6 Copying Text

Access the Copy Text To Text File form.

Transaction Number

Enter a unique alphanumeric field that identifies a text batch. The transaction number is determined by the process that creates the text batch.

New file/Override existing file

Select this option to create a new file. If a file exists with the name and path that you specify in the Destination Text File Path and Name processing option, the system overwrites the existing file.

Append to existing file

Select this option to append the text to the file that you specify in the Destination Text File Path and Name processing option.

Destination Text File Path and Name:

Enter the full path and filename for the text file that result from the text batch that you are copying. The system will store the text file in the location and filename you specify here.

27.2.7 Importing Text

Access the Import Text To Text File Processor form.

Source Text File Path and Name:

Enter the full path and filename of the text file that you are importing.

27.2.8 Resetting a Text Batch in the Text File Processor

If you need to process a text batch a second time, you must first reset the batch. Resetting a batch updates the status flags in the Text Processor Header table (F007101). The system changes outbound statuses to blank (Unprocessed/Outbound) and changes inbound statuses to 5 (Unprocessed/Inbound).

To reset a text batch, on the Work With Text Batches form, select the record you want to reset, then from the Row menu, select Maintain Batch, and then select Reset Batch.

27.3 Purging a Text Batch in the Text File Processor

This section provides an overview of the purge process and discusses how to:

  • Set processing options for Purge Processed Transactions (R007102).

  • Purge a text batch.

27.3.1 Understanding the Purge Process

You purge a text batch to remove it from the Text Processor Detail Table (F007111). You can purge only batches of processed transactions. When you purge a batch from the Work With Text Batches form, the system calls version ZJDE0001 of the Purge Processed Transactions program (R007102). You can also run any version of this program from the Text File Processor menu (G0071).

You can use a processing option in the Purge Processed Transactions program to specify whether the system removes the records in the batch from the Text Processor Header table (F007101), as well as from table F007111.

If you do not remove records from table F007101 when you purge a batch, the processed flag for those records is changed from processed to purged.

When you purge a batch that was created through draft remittance, the system also runs the Purge Draft Remittance Records program (R03B673).

To set up an additional batch program to run when you purge a batch, enter the name of the additional batch program in the Additional Purge Process field (GPPR) in the F007101 table. When you run the purge program on a batch that includes the name of a batch program in the Additional Purge Process field, the system runs version ZJDE0001 of that batch program.

27.3.2 Form Used to Purge a Text Batch

Form Name FormID Navigation Usage
Work With Text Batches W007101A Text File Processor (G0071), Text File Processor

Complete the User ID, Batch Number, and Transaction Number fields on the Work With Text Batches form. Then, select a record, select Maintain Batch from the Row menu, and then select Purge Batch.

Purge a text batch.

27.3.3 Setting Processing Options for Purge Processed Transactions (R007102)

Processing options enable you to specify the default processing for programs and reports.

27.3.3.1 Process

1. Purge Header Records

Specify whether to delete corresponding header records from the Text Processor Header table (F007101) along with detail records from the Text Processor Detail Table (F007111). Deleting only detail records updates the processed flag in the Text Processor Header file to 2 (purged/outbound) or 7 (purged/inbound). Records marked as purged cannot be reset to an unprocessed status. Values are:

Blank: Detail records.

1: Header and detail records.

27.3.4 Purging a Text Batch

Access the Work With Text Batches form.

From the Row menu, select Maintain Batch, and then select Purge Batch.