Hi,
For example In my CRM, I changed the field length of Country from 100 to 50.
Now in CRM, I will be able to enter only 50 letters in that field.
Now, through Scribe or SSIS if I import a 100 character word, would that country accept that or will it give error?
Please advise.
Thanks
*This post is locked for comments
[quote][/quote]
Hi Wouter,
If I set the option to truncate and from the crm UI it accepts only 50 and thought Scribe if there is a 100 character field would it accept?
Thanks
You will not get an error since Scribe will truncate the field. In your step order flow (if you would use multiple steps) this is also not considered as a failure.
So yes, it will accept the first 50 characters and drop the other 50.
Of course I am under the impression you are utilizing the Scribe CRM adapter for your integration which you should be using.
Note: Do not create an odbc connection to do direct updates in a crm sql db :) . (Well, you can do what you want of course, but I would strongly suggest not to do so. )
Yes CRM SQL table updating is unsupported, but when you are inserting record using SSIS / Scribe all data is inserted using CRM service or you can say using CRM business logic.
In CRM business logic attribute field is 50, thats why it will throw error.
Hi Wouter,
If I set the option to truncate and from the crm UI it accepts only 50 and thought Scribe if there is a 100 character field would it accept?
Thanks
Hi Mahadeo,
Correct me if I am wrong.
Since editing the CRM Sql table is unsupported, I am assuming still the the field length for Country would be 100 but when entering it from CRM UI it gives error.
It is some what confusing to understand the CRM sql concepts.
Hi,
That depends on your DTS in Scribe.
If you use the adapter and set the options to truncate, you will not receive an error.
On the other hand you can set your mapping field to LEFT(Sxx,50) you will not see an error.
(Same as the truncate option, but limited to one field here.)
In the event you just do a straight forward mapping, you will receive an error.
Regards,
Wouter
You will get error if character word is more than 50.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (