Goldmine 5.5 Email Distribution List Export

Does anyone know how to export a email distribution list from Goldmine or perhaps what tables within the dbase structure they reside?

Thanks!
herodaddy829Asked:
Who is Participating?
 
stevengraffCommented:
Ah! Thanks for repeating/clarifying your question.

The actual distribution lists are stored in the mailbox table, mailbox.dbf (memo field in mailbox.dbt)

0
 
stevengraffCommented:
Tools | Import/Export Wizard | Export Contact Records

then, choose your options, i.e. Export to a New File, DBF file, then choose the company, contact, email address as the fields you want to export.

Email addresses are stored in the contsupp table (i.e. contsupp.dbf)
0
 
herodaddy829Author Commented:
Thanks Steven however what I was trying to export was the email addresses used in specific Goldmine Distribution lists, rather than a set of contacts to make a distribution list in another program.

In short I have reps who are using these lists to email out to their prospects and clients however this early of a version of GM does not handle CAN-Spam compliance very well.  

I am trying to get these lists out so I can use a compliant  third party opt-in email blast company.

Thanks again!
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
herodaddy829Author Commented:
Thank you do you have any suggestions for a decent file viewer/exporter?
0
 
stevengraffCommented:
See if you can find the br7 utility from redstonesoftbase.com. Also, it's possible you could make some progress with Access. Be sure to work from an off-line copy of the files, so as not to risk damage to your production data.
0
 
herodaddy829Author Commented:
Ok I have tried both DBFViewer 2000 and the BR7 Utility and I found the groups within the database however the memo field you reference is encrypted for the groups.  See below:

CA6013039084$.`>SHLynCA6013039162#;/)VHJoA

Do you know of a way to reverse engineer this?

Thanks!
0
 
stevengraffCommented:
Not exactly. It's not really encryption. I've never done what you're trying to do, but I can tell you that the codes you're seeing correspond to the accountno field of the contact record; just get rid of that leading C, and you'll see that the balance of the string is the accountno. Link this to the contact1 table.
0
 
stevengraffCommented:
herodaddy829, have you had any luck with this?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.