Losing crlf when importing data back to SQL from Dynamics CRM
Are you sure they aren’t carried over? I ask because I recently tested just this and what I found was that the fields in my CRM are only just LF chars – no CRLF – and that it DID go to SQL with that same LF chars.
In my test then on the SQL side, the application I was using expected to see CRLF and not just “LF” and so it wouldn’t display the line as a “new line” due to that.
But that is just a difference of how the application expects to see the data and not an issue with SmartConnect itself.
You are right about CRM only uses [LF]. I changed the code on my front end application to replace all LF with CRLF.
If you would like to submit an answer or comment, please sign in to the eOne portal.