[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1081
  • Last Modified:

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!
0
herodaddy829
Asked:
herodaddy829
  • 5
  • 3
1 Solution
 
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
 
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now