Exporting from Contsupp database

[Goldmine]

How do you export fields from the Contsupp database into excel?. When I am in the export Wizard it appears that the only fields available for export are from Contact1 and Contact2.

Thanks for your help,
jason

 

[RobColborne]

Hi

You are correct in thinking that the import / export wizard does only contact1 and contact2.

There is a solution, providing you are running GoldMine 5.x, and that is to write SQL queries that can be exported to Excel.

You will find SQL queries under the Lookup Menu of GoldMine(if not check your user security options).

Here you can write SQL Select statements to export data, you do need to know SQL a little, as well as the structure of GoldMine.

Here is an example, albeit crude, to give you a list of your Additional Contacts

Select * from contsupp where rectype = 'C'

The results are displayed, and you can simple right mouse click, select Output To > Excel

You can use this method to export from other areas of the database such as cal and conthist.

Hope this helps
Robert Colborne

http://www.prior-analytics.com

Experts in GoldMine

 

[Robcowboy]

There is also an excellent product called Goldbox that will allow you to selectively export/import goldmine data

http://www.redstonesoftbase.com