Error: Error importing the finder file: Unable to import file from the server. The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.

When importing a Finder File, a user may receive Error:  'Error importing the finder file: Unable to import file from the server. The given value of type String from the data source cannot be converted to type nvarchar of the specified target column'. 
This is generally caused by either bad data, invalid characters, or formatting of the file.

When presented with this error, review the Finder File for the following : 
  • Unclosed quotes. Quotes are used to allow commas inside of a string in a .csv file. Unclosed quotes will cause the import process to look for the next matching quote ( " or ' ) and insert everything between them into a field, resulting in the error.
  • Extra spaces in the file. Too many trailing or leading spaces can overflow the maximum character column values in the temp table that is used by the finder file import process (4000 characters per field).
  • Invalid characters in the Finder File.

Environment

 3.0.516.42
 4.0.131

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.