Append Data

 

Append Data allows data to be appended to ASCII and delimited files. The file must contain either the 10-digit phone number, or the area code and exchange -- referred to as the NPA-NXX (area code plus exchanges). North American phone numbers begin with the format NPA-NXX, where NPA is the three-digit Numbering Plan Area (area code) and NXX identifies the central office exchange allocated within the NPAs.

 

  1. On the Utilities menu, click Append Data.

 

 

An Append Data -- Input Parameters Selection dialog box opens.

 

 

  1. Click Browse to locate the file, which will be either an ASCII or a delimited file.

 

  1. If an ASCII file is selected, the file name populates the Please Select Sample File box. This locates the 10-digit phone number or the NPA-NXX, which is the area code and exchange.

 

If the file contains the NPA-NXX, click Phone Starting Position .

See below.

 

 

Phone Starting Position changes to NPA-NXX Starting Position .

 

 

  1. If the location is not in the first column, which is populated by default, the Append Data -- Input Parameters Selection dialog box appears, but Phone Starting Position and Field Number is empty.

 

 

Click on a phone number. These boxes automatically populate.

 

 

Click Next .

 

  1. If a delimited file is selected, the file populates the dialog box, but the phone number must be manually located.

 

  1. The first column populates by default. If the phone number is not located in the first column, the dialog box may look like this:

 

 

The Phone Starting Position and Field Number boxes are empty. Click the phone number. The boxes populate.

 

 

Click Next .

 

An Append Data -- Select Fields to Append dialog box opens.

 

 

  1. Decide which fields to append by selecting the check boxes next to the Field Name. The order in which the fields will be appended is shown in the Order column.

 

 

If the order is incorrect, clear the check boxes and select the fields in the correct order.

 

Click Next . An Append Data -- Set Output Parameters dialog box opens.

 

 

  1. Click Save As to name and save the file. If changes are needed, click Back to go back and make the changes. If changes are not needed, click Append .

 

  1. To end the process, click Stop Process to stop the Store to Database process.

 

 

If processing is stopped, a message confirms the cancellation.

 

  1. When the append is done, a message says how many records were appended.