ZIP Code Import

You can use the ZIP Code Import page to create and queue a batch that imports ZIP code data and replaces the data in the Anthology Student with the data in the file.

When you import a file, any existing ZIP codes are removed and replaced with the ZIP codes in the imported file.

Use the History tab to review the status of all the batches, review the results of specific batches, and manage the batches.

Prerequisites

You must have:

Common - Processes - View authorization

Contact Manager - Processes - ZIP Code Import authorization

Because existing ZIP codes are removed when a file is imported, Anthology recommends that you back up your ZIP code data before you import the new ZIP codes. The existing ZIP codes are located in the SyZipCode table in the Anthology Student database. (You can use the same location to view the new ZIP codes after they are imported. )

You must have a comma-separated value (CSV) file that contains the ZIP codes with a .csv extension. For example, you can import a file from http://www.zipcodedownload.com.

The file must be in the format specified in the table.

Order Required in the CSV file		Requirements for the Data		Additional Information
Sl. No.	Column Name	Data Type	Max. Length	Example	Details (If Any)
1	CountryName	String	10 characters	USA	Same as the country code.
2	PostalCode	String	14 characters	601	—
3	PostalType	String	2 characters	S	Values are: U = UNIQUE M = MILITARY P = PO BOX S = STANDARD
4	CityName	String	150 characters	Adjuntas	—
5	CityType	String	2 characters	D	Values are: D = Default A = Acceptable N = Not Acceptable
6	CountyName	String	150 characters	Adjuntas	—
7	CountyFIPS	Integer Number	Not applicable	72001	—
8	ProvinceName	String	150 characters	Puerto Rico	—
9	ProvinceAbbr	String	4 characters	PR	—
10	StateFIPS	String	4 characters	72	—
11	MSACode	String	8 characters	0	—
12	AreaCode	String	50 characters	787/939	—
13	TimeZone	String	50 characters	Atlantic	—
14	UTC	String	8 characters	-4	—
15	DST	String	1 character	N	Daylight Savings Time flag N = No Y = Yes
16	Latitude	Decimal number	Not applicable	18.16595	—
17	Longitude	Decimal number	Not applicable	-66.723627	—

Access Method

Select the Processes tile > locate Contact Manager > select ZIP Code Import.

Procedure to Create a Batch to Import ZIP Codes

Process Tab

Use the Process tab to filter the data and queue the batch job.

Select the Choose File button.
In the dialog, select the file and select the Open button.

Anthology Student displays the name of the file in the File To Import field.
Select the Queue ZIP Code Import button and confirm you want to overwrite the existing ZIP codes.
In the Queue Batch dialog, review or change the name of the batch and select the Queue button.

Anthology Student processes the batch and overwrites the ZIP codes with the ZIP codes in the file. The ZIP codes are then available to select in the lists for ZIP codes in Anthology Student.

When the batch completes, Anthology Student displays the results on the History tab so that you can review the results and verify that the ZIP codes were imported.

History Tab

Use the History tab to review the results of manually queued jobs.

Batches on this tab are available for 28 days by default. Anthology Student removes them after 28 days. If you need to keep the information for a batch, use the Export ( Export button ) button on the toolbar.

Review the status and values for the batches in the list.

Duration The amount of time it took to process the job or batch.

Name The name of the item (e.g., data set, batch, job, process, task, person, organization, entity, file).

Started The date and time when the first job within the batch started executing.

Status A status of Preparing indicates that the jobs in the batch are still being created or are waiting on the system resources required to create them. Started indicates that the batch has been started. (At least one job in the batch is Enqueued, Processing, Succeeded, or Deleted.) Succeeded indicates all jobs in the batch have been executed, and ALL job statuses are Succeeded. Completed indicates all jobs in the batch have been executed; some jobs may be in the Succeeded status, but at least one of the jobs is in the Deleted status. Awaiting indicates the batch is awaiting the completion of a dependent job or batch. Deleted indicates that the batch has been canceled.

Submitted By The name of the staff member who submitted the background job or batch for processing.

Select the name of the batch in the list. Anthology Student displays the details for the job in the Job Results list.

Review the values in the list.

Job Created The date and time when the job was added to the background job queue.

Job Result Indicates the processing result for the job. If it was successfully processed, it displays Passed or Succeeded. Otherwise, it displays the reason why it was not processed.

Job Started The date and time when the job was pulled from the queue and started executing. The start time for a job will be the same time or later than the start time for the batch.

Job Status The status of the job. Enqueued indicates the job is in the queue waiting to be executed. Scheduled indicates the job is scheduled to run at a future time. Processing indicates the job is running. Succeeded indicates the job was completed with no errors. Deleted indicates the job was completed with errors.

Number of ZIP Codes The total number of ZIP codes that were imported into the Anthology Student database and are available to select in the lists that contain ZIP codes.