Inbound File Requirements

In order to process your database properly, we will need to have your information configured in the proper format.

Please follow the append data formatting instructions below...

Inbound File Format

Field Delimiter: Comma Delimited, Tab Delimited or Fixed Field.
Field Format: ASCII Text
Field Layout: Required. Include the maximum field lengths for each field.

Sample Incoming File Layout must be included when file transferred.
(This is just a sample your file does not have to look exactly like this.)

File Name: xyz_company_append_01012002
Quantity: 1,000,000
Format: Comma Delimited
Record Length: 127

• Field Name Format Length
  
• FNAME VarChar 20
  
• LNAME varchar 20
  
• ADDR varchar 50
  
• CITY varchar 25
  
• STATE CHAR 02
  
• ZIP CHAR 05
  
• ZIP4 CHAR 04
  
• LF CHAR 01

Once the data has been formatted per the requirements above, it can be uploaded via FTP to our append site. A UserID and Password will be emailed to you by your Account Executive.

Please send a confirmation email to your Account Executive when the upload has been completed, and the number of records that have been uploaded.

We take a great deal of pride in handling our clients' data. As a result, any deviation from these guidelines must be approved prior to uploading of the data. We request that prior to a new client uploading their data, that a sample data sheet and a layout or data dictionary be sent to your Account Executive.

This sample data sheet should include 5-10 individual records, with all possible fields represented.