Validation Error: A field cannot exceed a certain number of characters

QuickBooks Desktop (Pro, Premier or Enterprise) > Transaction Pro Importer
If you receive an error that your field length is too long after hitting next on the mapping screen please review the information below.

Overriding field lengths in Transaction Pro Importer 5.0

TPI maintains a data dictionary file (FIELDS.TPI) located in the program folder which provides the program information on field lengths and types. This information is used to set validation criteria for how long a field should be and whether it is a numeric or date type field. This file can be edited using notepad or any text editor. This enables the user to define the lengths of a field based on their specific data requirements.

In this file a text field is stored with the transaction type, field name and length – Example:

Invoice,Customer,41

In this file a date field is stored with the field name and the letter D – Example:

Transaction Date,D

In this file a number field is stored with the field name and the letter N – Example:

Price,N

WARNING: EDITING THE FIELDS.TPI FILE IS DONE AT YOUR OWN RISK. WE HAVE SET THE VALUES IN THIS FILE TO MATCH THE MAXIMUM LENGTHS OF FIELDS WITHIN QUICKBOOKS.

Why would I modify values in this file?

Let’s say you use customers and jobs within your QuickBooks file. The maximum length of the customer file is 41, as represented in the fields.tpi file. But if you have a customer with the length of say 35 characters and a job of say 10 characters you will have exceeded the length in this file. In this case you can modify the file to change the customer field length from 41 to 83. 41 + 41 +1 for the colon separator.

Modifying a field length in fields.tpi:

By default this file is located in c:\Program Files\01 Transaction Pro Importer 5.0\ (Windows 64 bit users will find the file in c:\Program Files (x86)\01 Transaction Pro Importer 5.0\

Open the file with Windows Notepad. Windows 7 and Vista users must open Notepad with elevated Administrator permissions to edit this file. Before starting notepad, right click and choose "Run as Administrator"

Scroll down until you find the field that you want to change, e.g. Invoice,Customer.

Modify the field length to the value you want, e.g. 83 characters would support a customer:job two level hierarchy.

Save the file.

 


 

Add Feedback