Understanding the Text File Processor
This chapter provides an overview of the Text File Processor and discusses how to:
Copy, import, and reset text files.
Purge a text batch.
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).
Draft Remittance File Format AEB 19 - Spain (R74S6729).
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.
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.
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.
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.
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.
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. |
Setting Processing Options for Text File Processor (P007101)
Processing options enable you to specify the default processing for programs and reports.
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. |
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. |
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. |
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.
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.
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.
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. |
Setting Processing Options for Purge Processed Transactions (R007102)
Processing options enable you to specify the default processing for programs and reports.
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 (F007101). 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. |
Purging a Text Batch
Access the Work With Text Batches form.
From the Row menu, select Maintain Batch, and then select Purge Batch.