- Re: Data Migration - relationship between Annotation and Contact
- Posted by John O'Donnell on August 19th, 2003
Aaron
I have not tried the data migration framework yet so cannot help you however
I know that a number of partners are using a tool from scribe which as built
in support for migrating data from act.
of course there is a price but if it saves you hours of work it may be worth
it
check it out at
www.scribesoft.com
"Aaron Ackerman" <no@spam.com> wrote in message
news:O6qoUXmZDHA.2336@TK2MSFTNGP09.phx.gbl...
- Posted by Aaron Ackerman on August 19th, 2003
If you have not used it and cannot provide any USEFUL info to my
problem...PLEASE DO NOT POST!!!
"John O'Donnell" <csharpconsulting@hotmail.com> wrote in message
news:eipPl2mZDHA.2580@TK2MSFTNGP09.phx.gbl...
- Posted by Aaron Ackerman on August 19th, 2003
Hey why didn't I think of that???
You wouldn't happen to work for scribe would you?
Oh and do you happen to have a spare grand so I can buy a copy...hmmmmm?
"John O'Donnell" <csharpconsulting@hotmail.com> wrote in message
news:eipPl2mZDHA.2580@TK2MSFTNGP09.phx.gbl...
- Posted by TC on August 20th, 2003
Why not just print out everything from ACT and then key it
in to MS CRM? That should cost less than a grand.
- Posted by Jim Budde on August 21st, 2003
Aaron,
Hopefully this is of some more help. According to the Excel sheets that are part of the migration framework, this is how the cdfAnnotation schema works (hopefully this gets formatted nicely, if not, my apologies):
CDF Attribute Re-quired Relation-ship Default Microsoft CRM Values
AnnotationId Yes
ObjectTypeCode** Yes
ObjectTypeCodeName* Fax (136)
Phone Call (137)
Task (134)
E-mail (138)
Letter (141)
Appointment (142)
Lead (4)
Opportunity (3)
Account (1)
Contact (2)
Competitor (123)
Product (1024)
Quote (1084)
Order (1088)
Invoice (1090)
Incident (112)
ObjectId Yes Yes
I've done this before with the cdfActivity table and you'll need to set the ObjectID = the appropriate value in the CDF database given the type of relationship required. Make sure you have dependant rows in the CDF database otherwise the migration will fail when it tries to correlate an annotation to a non-existant entity.
HTH,
-Jim
"Aaron Ackerman" <no@spam.com> wrote in message news:OUV$NE0ZDHA.2572@TK2MSFTNGP09.phx.gbl...
