Skip to content
+1-888-319-3663

COMMUNITY FORUM

Bug during excel import with String and DateTime

Flo asked 5 years ago
Howdy,We updated to SmartConnect 2016 recently. The change from 2014 to 2016 brought a lot of new bugs and problems but we managed to solve most of them one by one.I made a map for journal entries. Running from the map itself in SmartConnect, it works well. But running from the Excel 2013 plug-in, it constantly throws this error.
Failed to convert parameter value from a String to a DateTime.

Googling, I found that a thread giving a solution: http://www.eonesolutions.com/discussion/failed-to-convert-string-to-date/This said, it\’s not a good solution on long term. We are uploading so many things throught SmartConnect, we cannot start to bother our users to format their date to a text (you can be sure lot of them will forget and poke us because they have an error). Is this a known bug? Is it planned to be fixed any time soon?�Thanks for help and have a good day all!�Regards
Flo replied 5 years ago

Formatting is weird!!! O_o Here is the link again: http://www.eonesolutions.com/discussion/failed-to-convert-string-to-date/

Answers
Lorren Zemke Staff answered 5 years ago
Flo,
Here is a blog article on writing a calculated field so the date is handled correctly when coming from either the add-in or when running directly from smartconnect user interface.
 
http://www.eonesolutions.com/blog-post/tech-tuesday-smartconnect-addin-office-2013-integration-fails-on-date-fields/
 
Lorren

If you would like to submit an answer or comment, please sign in to the eOne portal.