Link to home
Create AccountLog in
Avatar of hahb200
hahb200

asked on

Goldmine to Outlook...grrrr

I have a customer who currently uses Goldmine 6.7 (GM) as a CRM and wants to transfer all contacts to Outlook 2007(MO-07).  I have run into countless issues and will try to describe a few. I exported GM data into both .xls files and .dbf files. MO-07 does not like these files...in some of the fields data was dropped completely in the transfer and in other MO-07 decided it only need half the data in the column and would get rid of the rest. In other cases it dropped information in a column completely and added info from another column, yes all by itself. So...I've manipulated the data somewhat, dividing columns before the transfer to ensure that all the data gets there somehow. The only thing I can figure is that GM builds its database differently and applies different rules to fields, and MO-07 because it doesn't recognize certain rules or data types applies what it thinks should happen as a rule for the data. So....taking a step backward, I installed MO-03 and tried the GM transfer that way, still no luck-but more data did come in. Does anyone have any insight on this issue, it would be GREATLY appreciated. Let me know if more details are needed, it's one of those things where I don't know where to start in explaining the problems because there are so many.
Is there any way I can construct an Outlook DB from scratch? Thanks ya'll!
Avatar of hahb200
hahb200

ASKER

Any ideas would be great. Even if your not sure, I would love to try any and all suggestions. Thanks folks
I'd probably try exporting GoldMine as .csv files. Then when importing into Outlook, be very sure to map the fields between the csv file and Outlook. Excel has field size limitations (256 characters - I think) and I would suspect that your dbf files are also limited in size. They may be truncating because one of programs "picked" the wrong data type for the data.

That's my two cents.

Dawn Crosier
Word MVP
If it were me I'd get the data into Access.  I'd expect Outlook to interact very well with a jet backend database.  So if the data is in SQL Server, DTS the data to Access. If dbf, link to Access and copy\paste the tables.  Once the data is in Access I'd expect data transfers to run smoothly.

Avatar of hahb200

ASKER

I felt the same way about access, but when I exported my data from goldmine to access.....that's when the "reorganization" of the data occurred. In the export, for example, it dropped individuals names and put the address in that field. I'm pretty sure all the problems are stemming from how goldmine builds and holds its data. I also tried the csv files and no luck. I've tried it all, I was hoping some who was an expert with goldmine had had this problem and knew how to deal with it. I've tried exporting to multiple file types and each one brings it's own set of issues, but all the issues share the fact that fields are unexplainably getting split and filled with data from completely unrelated columns. Another example, in one of the export files the street address (1000 Road Ave) was dropped and replaced with the town and state. There's no pattern to any of it that I can see....but please keep the suggestions coming....it will probably be something soooo simple that will work. Thanks all!!
I'll give it a shot and get back to you.  Are you using Goldmine with a dBase or MSSQL backend?

Oh, and one more thing.  Are you importing just primary contacts or are you importing additional contacts as well?
Avatar of hahb200

ASKER

What do I need to do to find out what sort of backend Goldmine is using? This is on a customers computer and I have never used the program, and after this I don't think I will ever suggest anyone using it. My customer needs ALL the data from Goldmine including contacts, notes about those contacts and all other info. So, I would say additional contacts, I'm trying to move his whole bcm info from GM to Outlook 2007. I tried to use Outlook 2003 as an intermediate program, since Goldmine and Outlook 2003 were made at the same time and may recognize each better, if that makes sense. But still, no luck...thanks for your time and comments!!
Sounds to me like he's on dBase version, if its 1 license it has to be dbase.  Otherwise search for the file gm.ini, in the [Goldmine] section of the gm.ini you'll see contactdir.  If the contactdir says MSSQL: XXX: dbo you're dealing with SQL Server.  If the contactdir has a path (e.g. c:\program files) than you're dealing with dBase.  
Avatar of hahb200

ASKER

oh...dbase for sure.
Avatar of hahb200

ASKER

So looking harder at Goldmine (this customer is my first exposure) there's a synchronize option. The problem with this option is that he has Outlook 2007, and the sync program wants Outlook 2000 or less. Does anyone know if I could find a sample download of these somewhere, just to get the data out of Goldmine?
ASKER CERTIFIED SOLUTION
Avatar of TommyTupa
TommyTupa

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of hahb200

ASKER

Thanks Tupa for all you help. We tried syncing, and he doesn't have an old enough copy of Microsoft Office to reinstall to get the sync to work with Goldmine. As far as contacting frontrange, I'm not impressed with them at all. The charged my customer 60 bucks for a 5 minute phone call that they didn't even answer the question we gave them....very frustrating. They're dropping support for this product, and they mean that literally. I think he has pretty much given up, I've talked to all sorts of folks and there's just no pretty way to do this. Thanks again....
Avatar of hahb200

ASKER

Thanks again for trying, at least I can tell the guy it's not just me. I awarded the points because of your diligence. I've been the same way with this puzzler, but I think I have to accept being stumped and move on. Thanks again, see you on here later....I'm sure of it!
I agree with your comments about FrontRange.  They used to have one great resource (Jason),  then promoted him to heat product manager.  Since then Frontrage correspondence has been useless... from sales through to support.  I still suggest you post to formums.frontrange.com.  They are not affiliated with Frontrange.