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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.