If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > Data Migration from Outlook BCM to Goldmine

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-08-08, 15:53
platinumvalley platinumvalley is offline
Registered User
 
Join Date: Nov 2008
Posts: 2
Data Migration from Outlook BCM to Goldmine

hello everyone,
since I am very new to sql i thought that the best thing to do is to ask the best ;-)
I ve got approx 1000 contact/company records in my business contact manager for ms outlook 2007. The database hasn't got sufficient functionality. So i decided to go for Goldmine 8.0.2 (FrontRange). I have both applications installed on my computer now.
Both databases have SQL Server 2005 engine. The structure of both databases is different even though they hold similar business data (contact and company names with contact numbers etc.).
How do i selectively migrate the data from bcm to goldmine? (i would like to transfer ALL of the bcm data into RELEVANT corresponding fields in goldmine).
Can i do it myself?
Alternatively does anyone offer this type of service? Thank you. DK.
Reply With Quote
  #2 (permalink)  
Old 11-09-08, 11:16
Thrasymachus Thrasymachus is offline
Button Pushing Slacker
 
Join Date: Nov 2004
Location: Arlington, VA
Posts: 6,988
I had not heard thatOutlook 2007 uses SQL Server.

I have not dealt with Goldmine in a decade but I bet if you fish around in the help file or the menus you will find a way to directly pul information from outlook or a way to export all of you contacts from outlook into a flat file that you an in turn import into goldmine.
__________________
software development is where smart people go to waste their lives
Reply With Quote
  #3 (permalink)  
Old 11-10-08, 16:12
platinumvalley platinumvalley is offline
Registered User
 
Join Date: Nov 2008
Posts: 2
There is an 'Import from Outlook' facility but very inaccurate. Data gets misplaced and omitted.
Furthermore, every account is linked to related contacts. Contacts are linked to logs and opportunities.
The standard facility does not copy data at every level of relationship.
Rather then manually, i would like to do it automatically by mapping fields from the old system onto the fields in the new system. Something like a program that would do the whole thing at a press of a button.
Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On