PTWin User Tips / System Administration 
|
The
Do-It-Yourselfer
Importation Issues
Doing your own data conversion
|
Tip #: 2.1.29 |
| Ver(s):PTWin32, V2, V1 |
Many PTWin jurisdictions choose to use
Black Bear Systems, Inc. to import Parcel and Owner information into PTWin from another
source like the Tax Assessor. But some PTWin users decide to bring their Parcel and Owner
information into PTWin on their own. To aid in this we provide the Importing Parcel
Records topic in both the PTWin User Manual and the PTWin Help File. Here you will find
the field layouts for the database tables in question.
The difficulty of self-importation is different in every case depending on the layout of
the source files. Basically you have to get the field layout in the source files to match
the layout in the PTWin database tables. This is usually done through a succession of
queries that manipulate the source data bringing it closer and closer to the PTWin layout
with each query.
The manipulation of the source data is usually carried out using Paradox for Windows for
Workgroups, which is the native format for PTWin database tables, but other database
products like Microsoft Access can also be used to massage the data. Many of the alternate
database packages can save their work in various Paradox formats, but this does not mean
you can simply plop the new tables into PTWin and have them work. There are secondary
indices and field definition incompatibilities that keep the new tables from functioning.
Assuming you have matched the PTWin field layouts exactly we will be happy to move your
data into valid PTWin database tables and create all the secondary files necessary. Give
us a call or email us the finished files in some form we can read and we will fix them and
email them back to you!
Return to System Administration menu
