GM 5.5 where are stored e-mails senders/recipients AND c.c & b.b.c related contact e-mails!

[sn1b]

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!

 

[DJHunt]

The entire message is stored in RFC822. If it was an HTML message when received or sent then that is what is stored in the RFC822 field. If it was received or sent as Plain Text then that is what is stored in the RFC822 field.

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US

 

[sn1b]

Thank you,

So, for a clean data migration to MCRM, I will not be able to get what I want.

Strange to store everything in bulk in a single field...

Do you know anyway what I could try to do to retrieve data I need like c.c, b.b.c fields, message type and so on?

Something should exist like reading with a script into the field and extract what I want but don't know where to begin to do that...

Thank you anyway,

Sb.

 

[DJHunt]

That was the E-mail Standard in those days. Proper use of your SQL Query should allow you to cull out the information that you need.

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US

 

[goner]

My tool, Compliance for GoldMine, will export your GoldMine e-mail, in full, with attachments and all, to an Outlook PST file. From there, I'm sure MSCRM can pull e-mail in from Outlook.

More info (product manual, etc.) available here:

http://www.castellcomputers.com/?page_id=100

Doug Castell
Castell Computers

http://www.castellcomputers.com