Hello,
I'm trying to figure out how to migrate with an ETL software GM database to MCRM 2011 database.
Into MCRM, it's clear, I have a field for everything (from/to/c.c/b.b.c) but in Goldmine... can't figure out where everything is stored...
With this SQL query I can retrieve the sender and the recipient (I think):
SELECT ch.*, c1.PHONE1, mb.RFC822 FROM CONTHIST ch INNER JOIN CONTACT1 c1 ON ch.ACCOUNTNO=c1.ACCOUNTNO
INNER JOIN MAILBOX mb on ch.recid=mb.LINKRECID where ch.RECTYPE='MI'
But, I look everywhere in GM 5.5 DB and really waste my time: where are the c.c & b.b.c stored? Or do I retrieve them to map them after to MCRM?
Also, their in in the mailbox table a RFC822 row containing headers+messages+footers, when I migrate them, I get in MCRM the yhole content, sometimes in HTML, sometimes as text and sometimes everything sticking toghether?
Where IS the message format (text/html/...) stored ?
Thank you if someone could explain me how all this e-mails are managed, I'm lost.
Thank you and have a nice day!
I'm trying to figure out how to migrate with an ETL software GM database to MCRM 2011 database.
Into MCRM, it's clear, I have a field for everything (from/to/c.c/b.b.c) but in Goldmine... can't figure out where everything is stored...
With this SQL query I can retrieve the sender and the recipient (I think):
SELECT ch.*, c1.PHONE1, mb.RFC822 FROM CONTHIST ch INNER JOIN CONTACT1 c1 ON ch.ACCOUNTNO=c1.ACCOUNTNO
INNER JOIN MAILBOX mb on ch.recid=mb.LINKRECID where ch.RECTYPE='MI'
But, I look everywhere in GM 5.5 DB and really waste my time: where are the c.c & b.b.c stored? Or do I retrieve them to map them after to MCRM?
Also, their in in the mailbox table a RFC822 row containing headers+messages+footers, when I migrate them, I get in MCRM the yhole content, sometimes in HTML, sometimes as text and sometimes everything sticking toghether?
Where IS the message format (text/html/...) stored ?
Thank you if someone could explain me how all this e-mails are managed, I'm lost.
Thank you and have a nice day!