Several interactive Address Book programs can run in batch mode and accept data from a Z file, allowing you to process mass amounts of data from an outside source easily and efficiently using existing programs to validate the data.
You can process any number of records to add, change, or delete. You also have the advantage of:
Data selection to limit the records you want to process.
Processing options that allow you to choose the version of the interactive program to process the records.
Error report printing.
Generally, these DREAM Writer program numbers correspond to the interactive program numbers with a Z appended to the end and the Z file numbers correspond to the program file number with a Z appended to the end. For example, P01051Z corresponds to the Address Book Information program P01051 and F01018Z corresponds to the Address Book - Email / URL addresses F01018.
See Import Using Z File Processing in the JD Edwards World Technical Tools Guide for detailed information about Z file fields and data processing and Overview to Import/Export in the JD Edwards World Technical Tools Guide for information about importing data into the system.
The following table includes the Address Book Z file processing programs.
From Address Book (G01), enter 27
From Address Book Advanced & Technical Operations (G0131), choose Z File Processing
From Address Book Z File Processes (G0101Z), choose an option
This appendix includes the following topics:
Technical considerations for Address Book Z File programs includes the following topics:
Matching Values in Header and Detail Z Files
Values in Numeric Fields
Fields with a Value from the Constants Symbol to Identify Field
Hidden Fields
Action Code/Search Type Security Z-File Program (P0103Z)
For programs that contain a subfile, you enter data for a header Z file and a detail Z file. You use the values in the control fields to tie the two together. In addition, there are some key fields that must match and be identical between the two files. For example, the value in the Address Book Number field in F0111HZ and F0111DZ must match. Furthermore, if you left justify the value in the Address Book Number field in the header, you must also left justify it in the detail. If you use the Long Address Number in the header with a prefix, you must also use the Long Address Number in the detail with a prefix.
JD Edwards World recommends that you right justify numeric fields in the Z files. You must right justify any key fields that the system needs to match in the header and detail files. For example, you must enter the same value in the Line Number ID field for Phone Book Information in both the F01075HZ and F01075DZ files. The program deletes the leading zeros and right justifies the value in the Line Number ID (VDIDLN) field in F01075HZ prior to reading the F01075DZ detail file. If the Line Number ID (SFIDLN) field in F01075DZ is left justified, it does not match the VDIDLN value and the program does not process the records.
There are several data items that allow you to specify a value (symbol) in the Symbol to Identify field in the Constants in order to use different forms of the same data item. For example, you can use a symbol for the Address Book Number, Asset Number, and Account Number fields. If the Z File program allows for this type of entry, the header portion of the screen contains the data items #N8, ANI, ASII, etc. However, there is a risk if you use one of these symbols for entry that is not unique. For example, the key field is #N8 in the Address Book Who's Who Z File process. You can enter the Short Address Number, the Long Address Number or the Tax ID to locate a Who's Who record for an address. The Short and Long numbers are unique and retrieve the correct record. The Tax ID is not unique and the interactive program attempts to access a window that the Z-File program cannot access. This results in an error message and ends the Z File program. JD Edwards World recommends you carefully consider which symbol you use for these types of data items and choose only those that ensure a unique match.
You can identify the hidden fields as those that begin with SH. For example, SHxxxx where xxxx is the data item name. There are some hidden fields that do not have equivalent SF fields because you do not see or use them when you to perform routine business tasks. The program assigns a value when you add a record and the program uses it to locate the correct fields. Be aware that in some programs, such as the Who's Who or Phone Numbers, the program assigns hidden field values when you add a record and the program enters the value in the detail Z file after the add. For example, the SHRCK7 field in the F01075DZ file will contain a value when you add a phone number.
You want to delete a Related Address Record for Address Number 1001. On the screen, you can do so by clearing the Related Address Code and the Related Address fields and clicking Change. When using the Z-File program you must leave the Related Address Code (SFRAC) and the Related Address (SF#N8) fields blank. You must enter the value for the Related Address Code field in the SHRAC field so the program retrieves the original record you want to delete.
The data fields in the Z Files are all character fields. Hidden field values can be numeric if the data item is numeric. For example, the Line Numbers and Address Book Number fields are numeric fields when they are hidden fields. The date fields are normally 8 characters so you can enter your date in a system value with separators as you would on the screen. The program expects the date in hidden fields to be a Julian date format, to match values in the production file.
You must access the Action Code/Search Type Security Z-FILE program (P0103Z) by choosing Name Search Type from the Security Z File Processes menu (G9401Z). Be aware of the following fields:
Use the Transaction Action (VDEDTC) field to set the Action code. Valid values include A (Add), C (Change), D (Delete).
To delete single records:
Set the subfile hidden field SH#ID to the User/Group ID or Search Type you want to delete.
Leave the SF#ID field blank.
Set the F0103HZ action code to C.
See the appropriate set of Z file processing options in Chapter 58, "Z File Processing Options".
Do not change the existing data selection. The Processed Y/N field is set to NE Y. This prevents the program from processing records more than once.
You can add additional selections to limit the data.
Do not change the data sequence.