Error The Value is too Large for Field in Grant Import

When importing grants in the Grant Import using data coming from Gifts Online tool the error, The value is too large for the field occurs. This occurs for multiple fields in the import even if the csv file is mapped correctly to each field in the import. The errors also occur even after removing line and paragraph breaks in the csv file.
This issue is resolved in FIMS 14.62 which will be released in August of 2018.

Steps to Duplicate

1. Go to Gifts Online and export data out to Excel
2. Go to FIMS\File Maintenance\Grant Import
3. Select the csv file from Gifts Online
4. Map the columns in the CSV file to the appropriate fields in the grant import tool
5. Click on Import and see Error: The Value is too Large for Field for almost all of the fields in the import

Environment

 FIMS

Was this article helpful?