|
|
|||||
Introducing PTWin32 |
We help a lot of
users import data into PTWin32 from all kinds of sources. Usually it’s some
form of parcel, owner, contractor, license, or permit data that comes from a
legacy system or another department like the Tax Assessor. There are many
formats used to exchange data between systems. One of the more popular is a form
of ASCII delimited text file that uses quotes and commas to indicate values and
fields. For example, a name and phone number might look like this: “ABC
Company”,”(123) 456-7890”. When we open this
file we use the quotes and commas to determine the structure of the data. If the
data itself contains any of the delimiting characters then this process is
thrown off. For example, a record like: “ABC, Inc.”,”(123) 456-7890”
might indicate that the comma between [ABC] and [Inc.] is the beginning of a new
field. This can also be a
problem with proper name fields that use nicknames like: “Charlie
“Yardbird” Parker”,”(123) 456-7890”. If it is your plan to
have us review your source data and you want to send it to us in an ASCII
quote-comma-quote format you must first ensure that there are no quotes or
commas in any of the field values you plan to send.
|
||||