R2011-199 AUTHORIZING EXECUTION OF SYSTEMS AGREEMENT

Home Browse Search

t y I e r Data Extraction and Transmission of Data As stated in the contract, the Client must supply data in ASCII file format with unpacked data fields. This terminology is sometimes considered confusing. The ASCII (pronounced as AS-key) is an abbreviation that represents the American Standard Code for Information Interchange. This standard was established in 1967 and still represents one of the most important standards in the computer industry. Since that time, some vendors have deviated from this standard. An example would be IBM's has a proprietary standard format abbreviated EBCDIC (pronounced EBB-see-dik). This is their current standard on the System36 and AS400. Vendors also use compression techniques in their data structures to pack numeric fields and dates. Since these techniques are not standard and vary from vendor to vendor, we are unable to process this information. In the simplest of terns the Client's data that is transmitted to The Tyler Technology system should be legible in a standard text processing program such as Windows textpad or wordpad. The characters that you view on screen should be the same characters that are on your computer keyboard. File Descriptions and layout The contract further states that the Client must supply sufficient file descriptions and layout information for the data. Sometimes file descriptions will be referenced as data definitions. Normally data files have one row after another. Each row represents a record or grouping of information. As an example, a vendor file would normally have a row for each vendor in the system. The rows then have to be broken down further into columns or fields. An example of a field in the vendor file could be vendor name. The file description provides the information needed to know exactly what position each field starts and stops in each row. In all cases, file descriptions are absolutely necessary for any type of conversion. Media Type Also outlined in the contract is the media type that the information can be transmitted to The Tyler Technology system. Unless the Client's existing system has a unix operating system, the most desirable media to transmit the data would be a cd. In situations where a writable cd is not available the Client can submit the information on a zip disk or 4mm tape. If a 4mm tape is used then the Client should transfer the information to the tape using the standard Windows backup software. The Client may also submit the data via email when the Client has a compression utility such as winzip and a fast and reliable Internet connection. When the Client's existing system has a unix operating system, the Client may use any of the methods mentioned above with the additional transmittal method of a 4mm tape with the maximum capacity of 4gb or a '/a inch tape with the maximum capacity of igb. The Client should include the Data Transmission Form with the media. If the Client is using email to transmit the data please include the information from the Data Transmittal Form in the email as text or an attachment. In situation where none of the above options are available to the Client, arrangements should be made with Tyler Technologies as to viable alternatives. These alternatives may involve additional fees. There are certain vendors that Tyler Technologies has had considerable conversion experience and has developed processes to extract the information from their proprietary data files. Other vendors store their data in Microsoft Access or Microsoft SQL Server database. It is possible in these situations that the Client can provide their existing data files in their current state without data extraction. In this scenario the Client would only be responsible for providing a backup of their current data. The first data extraction is for the sole purpose of developing the conversion software. This extraction should contain all the tables or files that are to be converted along with the appropriate Understanding the Conversion Process 2 of 4