Tech Support > Microsoft Windows > Windows CRM > Swaping data from one field to another in Microsoft CRM
Swaping data from one field to another in Microsoft CRM
Posted by Kyaw Zay Ya on December 14th, 2006


Hi there,

Is there tools available out there to swap data from one field in CRM to
another?

e.g. data from Address_line1 need move to Address_line2 and data from
Address_line2 to Address_line1

Cheers
Kyaw


Posted by Sam - Inogic on December 15th, 2006


Hi Kyaw,

I am not sure about a pre packaged utility to do what you require but once
when we were migrating data from ACT to MS CRM and we encountered a similar
issue where we had to swap between two fields. We wrote a utility to take
care of this kind of situation. A SQL script may also do the same job.

Do you want to do it regularily or are you just looking at one time swap?
Depending on your answer, maybe we can package this component and make it
available to you for close to nothing! :-)

HTH,

Sam
_______________
Inogic
Innovative Logic
Innovative solutions for your SME ERP/CRM products
E-mail: crm@inogic.com
Web: www.inogic.com
--------------------------



"Kyaw Zay Ya" <kyaw.zayya@completesolutions.co.nz> wrote in message
news:u2x3PU8HHHA.3668@TK2MSFTNGP02.phx.gbl...


Posted by Kyaw Zay Ya on December 19th, 2006


Hi Sam,

It will be for one-off but i am open for regular use as well provided the
cost is arrrictive ofcourse :-)

I thought using SQL script on the crm database itself was out of the
question becasue Microsoft doesnot allow direct access to the MSCRM table.

If your tool allow awaping of any selected two fields provided (even between
picklist to a text field) would be nice.

Please let me know.

Cheers
Kyaw


"Sam - Inogic" <inogic@gmail.com> wrote in message
news:%23R8Wg$AIHHA.1240@TK2MSFTNGP03.phx.gbl...



Similar Posts