Data Conversion Services
Estimate
Request Return
Data
conversion services include:
 Custom
Database Manipulation Data
Conversion Between Applications
Programming
Services
Recover Data From Legacy Applications
Translate
Cobol Formats
Custom Reports
Data Conversion
Services - Other
Duplication, mail merge, phone area code updates, mailing list merge /
purge and more.
File Structuring
Services
Convert data from other sources to meet your in-house requirements.
Custom Database
Conversion
We will structure your database to your exacting
requirements.
Many companies have very specific requirements for the structure of their
data. We will add,
drop, combine, split and re-format fields to meet your
exact needs.
Database options include:
Add New Fields
Pad Fields With Specific Information
Combine Fields
Split Fields
Change Case
Re-format Date and Numeric Fields
Translate Packed Decimal
Process Variable Record File Formats
Transfer Binary Data into Text
Relational Databases
Software
Formats
We offer a wide selection of text and software
formats.
Access
Act!
Dbase
Excel
Filemaker Pro
FoxPro
Lotus
Fixed Format (Flat File - SDF)
Delimited Format
Word
WordPerfect
And Many Others
Delimiting
Explained
Data is often stored in fixed field format. For example, the First Name field
may allow up
to 20 characters. The first name "John" would be followed
by 16 spaces to fill it out to the
length of 20. This method causes all First
Names, Address, Cities etc. to begin in a certain
position within each record.
An application using this data can "grab" the first 20 characters
of
the record as the "First Name" field, then grab the next character as
the "Middle Initial"
field, then 30 characters for the "Last
Name" field and so on.
Delimiting is a means of file compression. Data stored in fixed length fields
contains many
spaces. Removing these spaces makes the file significantly
smaller. Delimiting basically
removes the trailing spaces from each field and
replaces them with a delimiting character
such as a comma, tab or pipe symbol.
In order for the program reading in the delimited file
to know where each new
field begins a delimiting character is placed between fields. The
delimiting
character is normally meant to be a character that would not typically be part
of
the data within each field. When the application scans the file, it knows
when it encounters
the delimiting character that a new field has begun. Since
commas are often part on the data
(123 main St., Suite 100) quotes are often
used to "encapsulate" each field ("123 Main St.,
Suite
100"). This way, the scanning application knows that the comma between the
encapsulaters is part of the data and not a new field beginning.
Any character can be used to delimit a file, however most applications which
import
delimited files look for commas, tabs or pipe characters.
We can delimit your file using any character
you request.
Comma-quote delimited:
"123 Main Street","My
City","CA","99999"
Comma delimited:
123 Main Street,My City,CA,99999
Tab delimited: (* represents the tab character)
123 Main Street*My City*CA*99999
Pipe delimited:
123 Main Street|My City|CA|99999
Top
of Page
File
Structuring Options
We offer a wide array of options allowing us
to re-structure data
from other
sources to meet your exact in-house requirements.
Key Benefits
Data is ready to upload directly into your system without further handling.
Free up MIS / IT staff for other important tasks.
Saves time and
expense.
Capabilities
At Data Conversion Resource we specialize in converting outsource data into specific field
requirements.
Once we have set up your format (s), we can convert your incoming data into
your exact requirements.
We can output the data into a large variety of software and media
formats.
Date and Numeric Fields
We convert date & numeric fields to meet your specifications. This includes
translating
packed decimal.
Splitting or Combining Fields
We split or combine fields (City, State ZIP - Last Name, First Middle etc...)
into
separate database columns.
Binary to Text
Expand binary (Yes/No - 0/1) demographic information into descriptive text.
Other
Insert or remove fields - record counters - pad information, etc...
Top
of Page
Other
Data Conversion Services
We offer programming services to meet your individual situation.
Data
Analysis
Custom
Reporting
Project
Management Mail
Merge / Purge
Top
of Page
|
