Chapter 145: Loading Address Updates
Purpose: This chapter describes how to load customer name and address updates that originate from the National Change of Address (NCOA) Service. This function allows you to update customer addresses or identify invalid addresses. You can load address changes using either the ACS or the MBS file formats described in this chapter.
This program updates names and addresses for sold-to customers only; it does not update any ship-to customer addresses.
You can update bill-to names and addresses with sold-to address changes if:
• The Update a Bill-to Address with Sold-to Address Changes (E13) system control value is set to Y.
• The old name and address of the sold-to customer is an exact match of the old name and address of the bill-to customer.
If the bill-to customer name and address does not match the sold-to customer name and address, only the sold-to information updates.
Restrictions: The customer's name and address will be updated only if:
• the Sold To Customer exists on the system
• the last change date in the Sold To Customer file is earlier than the date you enter at the Load & Process Address Changes screen
• the customer has no open (unshipped or partially shipped) orders
In this chapter:
• Process Address Changes Screen (PACS)
• Load and Process Address Changes Screen (LMBS)
• Work with Changed Customers Screen (MBSI)
• Display Changed Customers Screen (Reviewing the Address Before and After the Update)
• Work with Unchanged Customers Screen (MBSF)
• Work with Customer Changes Screen (Reviewing Unapplied Address Changes)
• Copying the ACS File from CD to the iSeries
Overview: Depending on whether you can copy address changes to the required files on the iSeries or if you use a menu option within CWDirect to load a tape, you use a different process to process address changes. Each process is described below.
If the files are already populated: If you can create records in the ACS Tape file or the MBS Tape file on the iSeries, you use the Process Address Changes Screen (PACS) to process address updates. In this process:
1. The system checks the ACS Tape file or the MBS Tape file, depending on your entry in the Input file type field at the Process Address Changes screen, and uses this information to populate the MBS Work file.
2. For each record, if the system is able to process the address change, it creates a record in the MBS Changed Customer file for your review. You can use the Work with Changed Customers Screen (MBSI) to review these changes and purge them. Otherwise,
3. If the system is unable to process the address change, the record remains in the MBS Work file. You can use the Work with Unchanged Customers Screen (MBSF) to review these record and resubmit or purge them.
If you need to load a tape: You use the process described below if you need to load a tape in order to populate the ACS Tape file or the MBS Tape file. In this situation, you use the Load and Process Address Changes Screen (LMBS) to populate the file and process the changes; or, you can populate the file and subsequently use the Work with Unchanged Customers Screen (MBSF) to process the changes as a separate step. In this process:
1. The system copies the information in the tape device to the ACS Tape file or the MBS Tape file, depending on your entry at the Input file type (MBS/ACS) field.
2. If you select Process immediately:
• For each record, if the system is able to process the address change, it creates a record in the MBS Changed Customer file for your review. You can use the Work with Changed Customers Screen (MBSI) to review these changes and purge them. Otherwise,
• If the system is unable to process the address change, the record remains in the MBS Work file. You can use the Work with Unchanged Customers Screen (MBSF) to review these record and resubmit or purge them.
3. If you do not select to Process immediately, you will need to use the Work with Unchanged Customers Screen (MBSF) to submit the address changes.
Address change logic: The system uses this logic to analyze address changes and load the MBS Work file:
• Check the value in the Zap indicator:
• if = Z extract the new zip code
• otherwise, extract the zip code and the address
• Determine the delivery code
• Determine if address is deliverable
• Determine the name prefix
• Determine the name suffix
• Update the work file
• Update the Sold To Customer file, if the following conditions are met; otherwise, write the error to the MBS Work file.
• the customer exists on the system
• the last change date on the tape is greater than the last change date for the customer
• there are no open orders for the customer (based on a value in the On order $ field in the Customer Sold To History file)
• If the address is non-deliverable, update the Mail and Rent fields in the Sold To Customer file to N
• Create a "before" and "after" image of the Sold To Customer's address in the work file to identify what information is changed
• If ZIP code change, update ZIP code only; otherwise, update full address and first and last name
• Update address and change date (if Process immediately = Y on Load and Process Address Changes Screen (LMBS)), then delete record from work file; otherwise, retain record in work file until you process file using the Work with Unchanged Customers Screen (MBSF)
For more information: See the MBS and ACS File Formats for more information on the fields described above.
Process Address Changes Screen (PACS)
Purpose: Use this screen to process address changes when the ACS Tape or the MBS Tape file is already loaded with address change information. If you need to load the information from a tape, use the Load and Process Address Changes Screen (LMBS) menu option.
How to display this screen: Enter PACS in the Fast path field at the top of any menu, or select Process Address Changes from a menu.
CSR1350 ENTER Process Address Changes 3/10/03 16:40:40 EZK Mail Order
Process Deliverable Addresses Only N
Change Date . . . . . . . . . . .
Input File Type (MBS/ACS) . . . .
F3=Exit F9=Submit F12=Cancel |
Field |
Description |
Process deliverable addresses only |
This value indicates whether to process only those names and addresses identified as deliverable on the tape. Valid values are: Y = Process only deliverable addresses N = (default): Process all records on the tape, including those identified as undeliverable (flag at position 582 on the tape). When processing the records for non-deliverable addresses, the system updates the values in the Mail and Rent fields to N. This ensures that you do not send any more catalogs to this address or sell the customer's name to another company. Alphanumeric, 1 position; required. |
Change date |
The date when the address changes become effective. The system compares this date against the change date in the Customer Sold To file. If the change date you specify here is: • later than the change date in the Sold To Customer file: the system applies the name and address change • earlier than the change date in the Customer Sold To file: the system does not apply the name and address change; instead, the system creates a record in the MBS Address Change File for you to review. Use the Work with Unchanged Customers Screen (MBSF). Numeric, 6 positions (MMDDYY format); required. |
This value indicates where the address changes are located. Valid values are: ACS = The system checks the ACS Tape file for address changes. MBS = The system checks the MBS Tape file. Alphanumeric, 3 positions; required. |
Completing this screen: Complete each field as indicated above and press F9 to submit address updates. See Process Overview for more information.
Load and Process Address Changes Screen (LMBS)
How to display this screen: Enter LMBS in the Fast path field at the top of any menu or select the Load MBS Address Changes option from a menu.
CSR0585 ENTER Load & Process Address Changes 12/19/96 12:44:39 Mail Order
Process Immediately . . . . . . . Y
Process Deliverable Addresses Only N
Change Date . . . . . . . . . . .
Input Device . . . . . . . . . . .
Input File Type (MBS/ACS) . . . .
F3=Exit F9=Submit F12=Cancel |
Field |
Description |
This value indicates whether you want to load the tape and process the address updates on the tape in a single step. Valid values are: Y = (default): Load the tape and process the records on the tape now. N = Load the tape only. Select the Work with Unchanged Customers Screen (MBSF) at a later time to process the records and update the names and addresses. Alphanumeric, 1 position; required. |
|
Process deliverable addresses only |
This value indicates whether to process only those names and addresses identified as deliverable on the tape. Valid values are: Y = Process only deliverable addresses N (default) = Process all records on the tape, including those identified as undeliverable (flag at position 582 on the tape). When processing the records for non-deliverable addresses, the system updates the values in the Mail and Rent fields to N. This ensures that you do not send any more catalogs to this address or sell the customer's name to another company. Alphanumeric, 1 position; required. |
Change date |
The date when the address changes become effective. The system compares this date against the change date in the Customer Sold To file. If the change date you specify here is: • later than the change date in the Sold To Customer file: the system applies the name and address change • earlier than the change date in the Customer Sold To file: the system does not apply the name and address change; instead, the system creates a record in the MBS Address Change File for you to review. Use the Work with Unchanged Customers Screen (MBSF). Numeric, 6 positions (MMDDYY format); required. |
Input device |
The system name of the tape drive you use to load the address updates, such as TAP01. Alphanumeric, 10 positions; required. |
This value indicates how the tape is formatted. Valid values are: ACS = The tape is in USPS ACS (address change service) format. MBS = The tape is in MBS format. Alphanumeric, 3 positions; required. |
Step-by-step instructions: Follow these steps to load the address changes on the tape to the iSeries, and, optionally, process them:
1. Insert the tape in the appropriate tape drive.
2. Complete this screen, making sure you specify the tape drive where the tape is loaded.
3. Press F9.
4. Go to the Work with Submitted Jobs screen, enter 7 next to the LOADMBS job to answer the following message:
Load MBS tape on tape drive TAP01 G=Go C=Cancel option.
5. If you selected ACS format, the message will request you load the ACS tape.
6. Enter G.
For more information: See Process Overview.
Purpose: This table describes the format of the MBS and ACS Tape files. The Process Address Changes Screen (PACS) and Load and Process Address Changes Screen (LMBS) require files in one of the formats described below.
|
MBS Tape file (CSMBST) |
ACS Tape file (CSACST) |
|
||
Field |
Position (From-To) |
Length |
Position (From-To) |
Length |
Valid values |
Customer # |
|
|
17-25 |
9 |
|
First name |
1-20 |
20 |
64-78 |
15 |
If the ACS move type (position 39) contains B (business) then positions 44-87 are not parsed into name components, but are treated as a single 41-character business name field. |
Last name |
21-40 |
20 |
44-63 |
20 |
|
Prefix code |
41 |
1 |
79-81 |
3 |
The MBS format uses a single-position code, whereas the ACS format uses the literal value. 1 = MR 2 = MRS 3 = MIS 4 = DR 5 = REV 6 = SR 7 = MS 8 = FR 9 = CO * = MR & MRS & = DR & MRS ' ' |
Suffix code |
42 |
1 |
85-87 |
3 |
The MBS format uses a single-position code, whereas the ACS format uses the literal value. A = JR B = SR C = MD D = DDS E = II F = III ' ' |
Address 1 |
43-72 |
30 |
118-177 |
60 |
The components of the ACS old address field are parsed as follows: Field Position Size Primary No. 118-127 10 Pre-directional 128-129 2 Street name 130-157 28 Street suffix 158-161 4 Post-directional 162-163 2 Unit designator 164-167 4 Secondary no. 168-177 10 |
Address 2 |
73-102 |
30 |
|||
City |
103-122 |
20 |
178-205 |
28 |
The first 20 positions of the ACS city maps to the MBS city code. |
Filler |
123-127 |
5 |
|
|
|
State |
128-129 |
2 |
206-207 |
2 |
|
Zip |
130-134 |
5 |
208-212 |
5 |
|
Zip+4 |
135-138 |
4 |
|
|
ACS does not provide old ZIP+4. |
Filler |
139-150 |
12 |
|
|
|
Dwelling code |
151 |
1 |
40 |
1 |
Valid MBS codes: U = Unknown S = Single B = Business A = Multi with Apartment M = Multi, with no Apartment The ACS record does not have a matching field, but a code may derive from the ACS Move type. Valid move types: F = Family move (equals U in MBS layout) I = Individual move (equals U in MBS layout) B = Business (equals B in MBS layout) |
Filler |
152-158 |
7 |
|
|
|
Priority |
159-161 |
3 |
|
|
No matching ACS field. |
Key |
162-169 |
8 |
|
|
No matching ACS field. |
Multi-buyer Code |
170 |
1 |
|
|
No matching ACS field. |
Filler |
171-185 |
15 |
|
|
|
Zip Level |
186-188 |
3 |
|
|
No matching ACS field. |
Carrier Route |
191-194 |
4 |
|
|
No matching ACS field. |
NCOA Indicator |
195 |
1 |
37 |
1 |
F = Family Move I = Individual Move B = Business (ACS code) If F or I, new address at position 491 |
Filler |
196-198 |
3 |
|
|
|
Zap Indicator |
199 |
1 |
1 |
1 |
Valid MBS codes: X = Undeliverable Z = Zip Change If Z, new zip at position 130 If ACS position 38 contains one of the following values, then this is a "Nixie" record (undeliverable) and the MBS Zap indicator are loaded with a value of X: |
|
|
|
|
|
A = attempted, not known B = returned for better address C = not deliverable as addressed D = outside delivery limits E = in dispute G = PO box closed I = insufficient address K = moved, left no address L = illegible M = no mail receptacle |
|
|
|
|
|
N = no such number P = returned for postage Q = not deliverable as addressed R = refused S = no such street U = unclaimed V = vacant W = temporarily away X = no such office |
|
|
|
|
|
The MBS file will not contain COA records reflecting changes only to the ZIP code. A postal customer would not submit a COA form if the zip code changed but he/she did not move, so there would be no COA request to trigger a record in this file. Note: The first record on the ACS tape contains an H in this field, indicating that this is a header record and should not be used. |
Tier Code |
200 |
1 |
|
|
No matching ACS field. |
Filler |
201-233 |
33 |
|
|
|
Old Zip Code |
234-238 |
5 |
208-212 |
5 |
|
NCOA Move Date |
239-242 |
4 |
33-36 |
4 |
|
Filler |
243-277 |
35 |
|
|
|
Old Finalist Dwelling Code |
278 |
1 |
|
|
No matching ACS field. |
Filler |
279-364 |
86 |
|
|
|
Address Reverse Indicator |
365 |
1 |
|
|
No matching ACS field. |
Filler |
366-381 |
16 |
|
|
|
String |
382-383 |
2 |
|
|
No matching ACS field. |
Standard Addr1 |
384-413 |
30 |
|
|
No matching ACS field. |
Standard Addr2 |
414-443 |
30 |
|
|
No matching ACS field. |
Standard City |
444-456 |
13 |
|
|
No matching ACS field. |
Standard State |
457-458 |
2 |
|
|
No matching ACS field. |
Filler |
459-478 |
20 |
|
|
|
Delivery Point Barcode |
479-481 |
3 |
342-344 |
3 |
|
Filler |
482-490 |
9 |
|
|
|
New Addr1 |
491-520 |
30 |
244-303 |
60 |
The components of the ACS new address field are parsed as follows: Field Position Size Primary No. 244-253 10 Pre-directional 254-255 2 Street name 256-283 28 Street suffix 284-287 4 Post-directional 288-289 2 Unit designator 290-293 4 Secondary no. 294-303 10 |
New Addr2 |
521-550 |
30 |
|
|
|
New City |
551-565 |
15 |
304-328 |
25 |
|
New State |
566-567 |
2 |
332-333 |
2 |
|
New 9-digit Zip |
568-576 |
9 |
334-343 |
10 |
|
New Carrier Route |
577-580 |
4 |
|
|
No matching ACS field. |
Move Type |
581 |
1 |
39 |
1 |
I = Individual Move F = Family Move C = Company Move B = Business Move |
Undeliverable Type |
582 |
1 |
38 |
1 |
C = Not Deliverable G = Box Closed K = Moved, Left No Address F = Moved to Foreign Address Z = Invalid Postal Record F = Moved to foreign address If ' ', zip code or address change |
|
|
|
|
|
If ACS position 38 contains one of the following values, then this is a "Nixie" record (undeliverable), and the MBS Zap indicator will be loaded with a value of X: A = attempted, not known B = returned for better address C = not deliverable as addressed D = outside delivery limits E = in dispute G = PO box closed |
|
|
|
|
|
I = insufficient address K = moved, left no address L = illegible M = no mail receptacle N = no such number P = returned for postage Q = not deliverable as addressed R = refused S = no such street U = unclaimed V = vacant W = temporarily away X = no such office |
Filler |
583-592 |
|
|
|
|
Customer code |
593-601 |
9 |
17-25 |
9 |
|
|
602-772 |
|
|
|
Not used by MICROS. |
Work with Changed Customers Screen (MBSI)
Purpose: Use this screen to review the customer's name and address before and after the address updates. You can also use this screen to delete a change, purge all name and address changes or print a list of changes.
The system creates these updates after you use the Load and Process Address Changes Screen (LMBS) or the Process Address Changes Screen (PACS).
You can review name and address updates that did not take effect through the Work with Unchanged Customers Screen (MBSF). Customers may be unchanged because the updates were not processed, the customer was not found, the customer has open orders, or the change date for the customer was later than the change date on the tape.
How to display this screen: Enter MBSI in the Fast path field at the top of any menu or select the Work with MBS Before and After Images option from the menu.
CSR0579 DISPLAY Work with Changed Customers 10/11/95 10:53:08 Mail Order Company
Customer #
Type options, press Enter. 4=Delete 5=Display
Opt Customer Customer name City State Number 5584 KITT ROSENHAGEN KALAMAZOO MI 5584 CAROLE POLLACK VESTAL NY 5584 DAVID KRAWITZ BROOKLINE MA 5584 DONNA VINCENT LOS ANGELES CA 5674 MARGARET E CIARAMELLO TUCSON AZ 5674 HARRIET MILLER KNOXVILLE TN 5720 LESLEY DEVOE LONG BRANCH NJ +
F3=Exit F8=Purge F12=Cancel F21=Print |
Field |
Description |
Customer # |
A number to identify a customer. The customer record must exist on the system for any address updates to be performed. Numeric, 9 positions; display-only, assigned by the system. |
Customer name |
The customer's name. Alphanumeric, 25 positions; display-only. |
City |
The city where the customer lived before the address update (if the address update resulted from a move). Alphanumeric, 25 positions; display-only. |
State |
The code for the state or province where the customer lived before the address update (if the address update resulted from a move). Alphanumeric, 2 positions; display-only. |
Screen Option |
Procedure |
Remove a record from the screen |
Enter 4 next to a record to delete it. Note: This does not undo the address update; it simply purges the record from the MBS Changed Customers file. |
Review the address before and after the update |
Enter 5 next to a record to advance to the Display Changed Customers Screen (Reviewing the Address Before and After the Update). |
Purge all address updates from the MBS Changed Customers file |
Press F8. |
Print a report listing the customer addresses before and after the update |
Press F21 to print the Changed Customers Report. |
Display Changed Customers Screen (Reviewing the Address Before and After the Update)
Purpose: Use this screen to review the changes to a customer's name and address before and after the update.
How to display this screen: Enter 5 next to a customer number at the Work with Changed Customers Screen (MBSI).
CSR0583 DISPLAY Display Changed Customers 10/13/95 17:00:41 Mail Order Company
Customer # : 5117 PO Box? : N Delivery code : R BEFORE Address : NANCY FARIS 37383 S ARROYO VERDE DR
TUCSON AZ 857391266
PO Box? : N Delivery code : R AFTER Address : COLLEEN GRAY 2672 KINNICK RD A
VAIL CO 816574180
F3=Exit F12=Cancel |
The BEFORE information represents the customer's name and address prior to the update. The AFTER information represents the customer's current name and address, resulting from the update.
Field |
Description |
Customer # |
A number to identify a customer. The customer record must exist on the system for any address updates to be performed. Numeric, 9 positions; display-only, assigned by the system. |
PO box? |
This value indicates whether the address is a post office box. Valid values are Y or N. Alphanumeric, 1 position; display-only, updated by the system. |
Delivery code |
This value indicates whether the address is a business (B) or residence (R). This information is used by shippers who charge different rates for shipping a package to a business or home. Alphanumeric, 1 position; display-only, updated by the system. |
Address |
The customer's old and new addresses. |
Work with Unchanged Customers Screen (MBSF)
Purpose: Use this option to:
• review the unprocessed records in the MBS Work file
• remove a record from the file
• review the type of name and address change
• purge all records in the file
• process the records in the file; this option is necessary if you set Process immediately = N at the Load and Process Address Changes Screen (LMBS)
Selecting this option: Enter MBSF in the Fast path field at the top of any menu or select the Work with MBS Address Change File option from the menu.
CSR0584 DISPLAY Work with Unchgd Customers 10/10/95 12:54:16 Mail Order Company
Customer #
Type options, press Enter. 4=Delete 5=Display
Opt Customer Change Change Deliverable Number Status Type Address? 3524 NOT PROCESSED Family Move YES 3528 NOT PROCESSED Family Move YES 3534 NOT PROCESSED Individual Move YES 3536 NOT PROCESSED Family Move YES 3538 NOT PROCESSED Individual Move YES 3542 NOT PROCESSED Zip Code Change NO 3544 NOT PROCESSED Family Move YES +
F3=Exit F8=Purge F9=Process F12=Cancel F21=Print |
Field |
Description |
Customer # |
A number to identify a customer. The customer record must exist on the system for any address updates to be performed. Numeric, 9 positions; display-only, assigned by the system. |
Change status |
The status of the record, which may indicate reason that the customer name and address was not updated. Valid values are: • Not Processed • Open Orders Exist • Last Change Date Greater Than • Customer Does Not Exist Alphanumeric, 25 positions; display-only, updated by the system. |
Change type |
This value identifies the reason for the name and address change. Valid values are: • Zip Code Change • Family Move • Individual Move • Business Move
• LACS link (Rural Route conversion changes) • ACOA/ACS (Vendor proprietary change of address and address corrections) • Address Element Correction • Apartment Append Alphanumeric, 15 positions; display-only, updated by the system. |
Deliverable address |
This value indicates whether the address is a valid, deliverable address. Valid values are: • YES • NO If NO, the system changes the values in the Mail and Rent fields in the Sold To Customer file to N so that you do not send any more catalogs to the customer or sell the customer's address to other companies. Alphanumeric, 3 positions; display-only, updated by the system. |
Screen Option |
Procedure |
Remove a record from the workfile |
Enter 4 next to a record to delete it. |
Review the change |
Enter 5 next to a record to display the Work with Customer Changes Screen (Reviewing Unapplied Address Changes). |
Purge all records in the workfile after you process or review them |
Press F8. |
Process the updates, either after loading a tape without immediately processing it or after removing records with errors |
Press F9. |
Print a report of the unchanged customers that identifies the customer number, change condition, change type, whether it is a deliverable address, the address, the delivery code, and whether the address is a P.O. box |
Press F21 to print the Unchanged Customers Report. |
Work with Customer Changes Screen (Reviewing Unapplied Address Changes)
Purpose: Use this screen to review an unapplied address change.
How to display this screen: Enter 5 next to a customer number at the Work with Unchanged Customers Screen (MBSF).
CSR0588 DISPLAY Work with Customer Changes 10/13/95 16:48:28 Mail Order Company
Customer # : 6000
Change Status : Customer does not exist Change Type : Family Move Deliverable : YES PO Box? : N Delivery code : R
Address : PATRICIA CANDELARIA 4598 SPANISH DAGGER
LAS CRUCES NM 880119635
F3=Exit F12=Cancel |
Field |
Description |
Customer # |
A number to identify a customer. The customer record must exist on the system for any address updates to be performed. Numeric, 9 positions; display-only, assigned by the system. |
Change status |
The status of the record, which may indicate the reason that the customer address was not updated. Valid values are: • Not Processed • Open Orders Exist • Last Change Date Greater Than • Customer Does Not Exist Alphanumeric, 25 positions; display-only, updated by the system. |
Change type |
This value identifies the reason for the change. Valid values are: • Zip Code Change • Family Move • Individual Move • Business Move
• LACS link (Rural Route conversion changes) • ACOA/ACS (Vendor proprietary change of address and address corrections) • Address Element Correction • Apartment Append Alphanumeric, 15 positions; display-only, updated by the system. |
Deliverable |
This value indicates whether the address is a valid, deliverable address. Valid values are: • YES • NO If NO, the system changes the values in the Mail and Rent fields in the Sold To Customer file to N so that you do not send any more catalogs to the customer or sell the customer's address to other companies. Alphanumeric, 3 positions; display-only, updated by the system. |
PO box? |
This value indicates whether the address is a post office box. Valid values are Y or N. Alphanumeric, 1 position; display-only, updated by the system. |
Delivery code |
This value indicates whether the address is a business (B) or residence (R). This information is used by shippers who charge different rates for shipping a package to a business or home. Alphanumeric, 1 position; display-only, updated by the system. |
Address |
The customer's address BEFORE the address update. |
Purpose: Use this screen to process name and address updates.
How to display this screen: Press F9 at the Work with Unchanged Customers Screen (MBSF).
CSR0683 ENTER Process Changes 8/31/00 15:45:00 KAL Co.
Change Date . . . .
Source of Update . .
F3=Exit F12=Cancel |
Field |
Description |
Change Date |
The date when the changes become effective. The system compares this date against the change date in the Customer Sold To file. If the change date for the tape is later than the change date in the Sold To Customer file, the system applies the address change. If the change date for the tape is earlier than the change date in the Customer Sold To file, the system does not apply the address change; instead, the system creates a record in the MBS Address Change File for you to review. Numeric, 6 positions (MMDDYY format); required. |
Source of Update |
The file type of the tape from which the system uploads changes. Valid values are: ACS = A tape in the USPS ACS (address change service) format. The system converts the ACS file to MBS format to process the information. MBS = A tape in the MBS format. Alphanumeric, 4 positions; required. |
Copying the ACS File from CD to the iSeries
Purpose: Use the steps below to use FTP to copy an ACS file from a CD to the iSeries. After you complete these steps, you can use the Process Address Changes Screen (PACS) to process the address changes.
Before you start:
• Determine the IP address of the iSeries where you are running CWDirect.
• Note the Customer ID on the CD.
Step-by-step instructions:
1. Insert the CD in the CD-ROM drive.
2. Open a DOS window (Select Start > Programs > MS-DOS Prompt).
3. Change the current directory to the CD-ROM drive. For example, if D: identifies your CD-ROM drive, enter D:
C:\WINDOWS>D:
D:\> |
4. Find the name of the Address Change file by entering dir *.txt
D:\>dir *.txt
Volume in drive D is ACS DISK Volume Serial Number is AFE0-84F7 Directory of D:\
999999 ACS 130,845 07-29-02 8:35a PB999999.txt 1 file(s) 130,845 bytes 0 dir(s) 0 bytes free
D:\> |
5. The file name should correspond to your customer number. For example, if your customer number is 999999, the name of the file would be 999999.txt.
C:\WINDOWS>D:
D:\>dir *.txt
Volume in drive D is ACS DISK Volume Serial Number is AFE0-84F7 Directory of D:\
PB999999 ACS 130,845 07-29-02 8:35a PB999999.txt 1 file(s) 130,845 bytes 0 dir(s) 0 bytes free |
6. Start an FTP session by entering FTP.
D:\>ftp ftp> |
7. To FTP to the iSeries, enter open 123.40.50.6 where 123.40.50.6 represents the IP address of the iSeries.
D:\>ftp ftp> open 123.40.50.6 Connected to 123.40.50.6. 220-QTCP at CWIAS400. 220 Connection will close if idle more than 5 minutes. User (123.40.50.6:(none)): |
8. Enter your user ID.
User (152.85.60.1:(none)): ekaplan 331 Enter password. Password: |
9. Enter your password.
331 Enter password. Password: 230 EKAPLAN logged on. ftp> |
10. Change the current directory on the iSeries to the Data Base Library (A37).
ftp> cd cwmpdta 250 "CWMPDTA" is current library. ftp> |
11. To copy the file from the CD to the ACS Tape file (CSACST) in the Data Base Library, enter put D:\999999.txt csacst.csacst where D: represents your CD-ROM drive and 999999 represents your Customer ID.
250 "CWMPDTA" is current library. ftp> put D:\999999.txt csacst.csacst 200 PORT subcommand request successful. 150 Sending file to member CSACST in file CSACST in library CWM70QDTA. 250 File transfer completed successfully. ftp: 130845 bytes sent in 0.17Seconds 769.68Kbytes/sec. ftp> |
12. Wait until the FTP transmission is complete and then enter quit.
ftp> put D:\999999.txt csacst.csacst 200 PORT subcommand request successful. 150 Sending file to member CSACST in file CSACST in library CWMPDTA. 250 File transfer completed successfully. ftp: 130845 bytes sent in 0.17Seconds 769.68Kbytes/sec. ftp> quit |
13. Enter exit to close the MS-DOS window.
ftp> quit 221 QUIT subcommand received.
D:\> exit |
14. When you are done, use the Process Address Changes Screen (PACS) to process the address updates. See Process Overview for overview information.
| Chapter 144: Displaying More Options | Contents | SCVs | Search | Glossary | Reports | XML | Index | Changed Customers Report |
CSAPPD CWDirect 18.0 August 2015 OTN