|
|
|
|
Let's get started locating your debtors. There are three easy steps to follow to start
locating debtors in your database:
Step 1: Upload Your Input File.
It is very important that you format your data properly prior to uploading it to DebtorCollect.com.
The data must be uploaded in a DebtorCollect.com standard format as seen below:
| CustomerRecordID
|
1
|
25
|
25
|
User Record Key (data optional)
|
|
FirstName
|
26
|
30
|
55
|
First Name
|
|
LastName
|
56
|
30
|
85
|
Last name
|
|
Address
|
86
|
60
|
145
|
Address
|
|
City
|
146
|
28
|
173
|
City
|
|
State
|
174
|
2
|
175
|
State
|
|
ZipCode
|
176
|
5
|
180
|
Zip Code
|
|
UserPhone
|
181
|
14
|
194
|
UserPhone (data optional)
|
You can upload files in 1 of 3 different file formats.
Fixed Length Text:
Data may be uploaded in a fixed length format (.txt file).
Fixed length means that the individual field columns are always the same length in each uploaded
record. This length is prescribed by the information contained in the standard layout. All fields
are padded with blanks or zeros to ensure fixed lengths. This also includes fields for which you
do not have data!
(Fixed Length Format Sample)
Comma Separated Values:
You may also upload the standard data in a comma separated format (.csv files).
Comma separated files have each field separated by a comma. The comma becomes the delimiter between
columns and negates the necessity to have a fixed length. If you do not have data for an individual
column you must still include a comma (123,45,678 -> 123,,678).
(Comma-Separated Values Format Sample)
Microsoft Excel:
Data may also be uploaded in an Microsoft Excel spreadsheet format (.xls files). The upload
process will accept a spreadsheet with the data in a sheet name of either Sheet1 which
is the default sheet name for new Excel sheets, or RawInput like the example. No other
sheet names will be accepted. You can find the sheet name by looking at the left tab at
the bottom of your workbook. Excel sheets must contain a column for each field that is
required. The first row of the spreadsheet contains the column names of the individual
fields. If the field in that column has no data then leave it blank.
(Excel File Format Sample)
You should name your submitted files in a meaningful fashion to ensure that you are able to
remember the name when attempting to locate the end processing results.
Step 2: Review Quality Control Results.
Most errors occur in the initial submission of the data file.
You might not have your data formatted properly. Column lengths could be incorrectly
formatted or commas may have been left out of comma separated input for missing columns.
This would cause input data to be inserted into the incorrect column which might result
in invalid states or zip codes. There are many similar types of common errors. DebtorCollect.com
will perform an initial evaluation of your uploaded data. Our Quality Control Process will
evaluate the suitability of your data, count the results, and flag any records that are
in error. You will have to review the initial quality control results prior to authorizing
the application to continue processing your data.
Step 3: Download Your Ordered Files.
You can access the download site by either following the link in the order completion e-mail
or by logging into the application and entering the "Download" area. Your download area will only
Summary:
For a more in-depth explanation of the formatting requirements,
click here.
Input Format Requirements
For a detailed explanation of our Quality Control Process,
click here.
Quality Control Process
|
|
| |