Importing Goldmine data to BCM 2007 Steve[ at ]Gabilan 3/28/2007 12:18:01 PM I have tried exporting from Goldmine to XML and then importing to Excell 2007 (for later export to BCM) but Excell said there was a problem with the Schema file. Are there any other work arounds you can think of for this data transfer? -- Steve

Re: Importing Goldmine data to BCM 2007 "Mukesh Agarwal [MSFT]" <mukeshag[ at ]online.microsoft.com> 3/29/2007 1:22:44 AM Can you export from Goldmine to .CSV, Excel or Access? BCM will allow importing from these formats. -- Mukesh Agarwal [MSFT] Visit team blog at http://blogs.msdn.com/bcm This posting is provided "AS IS" with no warranties, and confers no rights "Steve[ at ]Gabilan" <SteveGabilan[ at ]discussions.microsoft.com> wrote in message news:0A6A6758-1953-4153-B38D-E14150531AC3[ at ]microsoft.com... [Quoted Text] >I have tried exporting from Goldmine to XML and then importing to Excell >2007 > (for later export to BCM) but Excell said there was a problem with the > Schema > file. Are there any other work arounds you can think of for this data > transfer? > -- > Steve

Re: Importing Goldmine data to BCM 2007 Steve[ at ]Gabilan 3/29/2007 3:20:01 AM no...only DBF, ASCII and SDF. I tried exporting to DBF and importing as a ACT dbf file but it said I must be running ACT which I don't have. Could I try synchronizing with my PDF and then uploading to BCM? I'll check into that. -- Steve "Mukesh Agarwal [MSFT]" wrote: [Quoted Text] > Can you export from Goldmine to .CSV, Excel or Access? BCM will allow > importing from these formats. > > -- > Mukesh Agarwal [MSFT] > Visit team blog at http://blogs.msdn.com/bcm > > This posting is provided "AS IS" with no warranties, and confers no rights > "Steve[ at ]Gabilan" <SteveGabilan[ at ]discussions.microsoft.com> wrote in message > news:0A6A6758-1953-4153-B38D-E14150531AC3[ at ]microsoft.com... > >I have tried exporting from Goldmine to XML and then importing to Excell > >2007 > > (for later export to BCM) but Excell said there was a problem with the > > Schema > > file. Are there any other work arounds you can think of for this data > > transfer? > > -- > > Steve > >

Re: Importing Goldmine data to BCM 2007 "Burcu Kinay [MSFT]" <bkinay[ at ]online.microsoft.com> 3/29/2007 6:10:47 AM Hi Steve, I don't own a Goldmine copy, but after some search, I learned ASCII format is very similar to csv (Comma Seperated Values). Can you export a ASCII Goldmine file and open it in Notepad? If you see something similar to this: First Name, Last Name,... etc John, Smith, ... Jane, Smith, ... then you can change the extension of ASCII file into csv and import it to BCM. I hope this helps! -- This posting is provided "AS IS" with no warranties, and confers no rights. "Steve[ at ]Gabilan" <SteveGabilan[ at ]discussions.microsoft.com> wrote in message news:8C168EBF-4C22-443D-BE1A-E7138B59DF94[ at ]microsoft.com... [Quoted Text] > no...only DBF, ASCII and SDF. I tried exporting to DBF and importing as a > ACT > dbf file but it said I must be running ACT which I don't have. Could I try > synchronizing with my PDF and then uploading to BCM? I'll check into that. > -- > Steve > > > "Mukesh Agarwal [MSFT]" wrote: > >> Can you export from Goldmine to .CSV, Excel or Access? BCM will allow >> importing from these formats. >> >> -- >> Mukesh Agarwal [MSFT] >> Visit team blog at http://blogs.msdn.com/bcm >> >> This posting is provided "AS IS" with no warranties, and confers no >> rights >> "Steve[ at ]Gabilan" <SteveGabilan[ at ]discussions.microsoft.com> wrote in message >> news:0A6A6758-1953-4153-B38D-E14150531AC3[ at ]microsoft.com... >> >I have tried exporting from Goldmine to XML and then importing to Excell >> >2007 >> > (for later export to BCM) but Excell said there was a problem with the >> > Schema >> > file. Are there any other work arounds you can think of for this data >> > transfer? >> > -- >> > Steve >> >>

Re: Importing Goldmine data to BCM 2007 "Burcu Kinay [MSFT]" <bkinay[ at ]online.microsoft.com> 3/29/2007 8:06:47 PM In addition to that, you should export in Goldmine with checking "Export GoldMine filed names that has mappings as first record". -- This posting is provided "AS IS" with no warranties, and confers no rights. "Burcu Kinay [MSFT]" <bkinay[ at ]online.microsoft.com> wrote in message news:5FD7CB3C-F6F4-4BEA-A800-999E7AB187B5[ at ]microsoft.com... [Quoted Text] > Hi Steve, > > I don't own a Goldmine copy, but after some search, I learned ASCII format > is very similar to csv (Comma Seperated Values). Can you export a ASCII > Goldmine file and open it in Notepad? > If you see something similar to this: > > First Name, Last Name,... etc > John, Smith, ... > Jane, Smith, ... > > then you can change the extension of ASCII file into csv and import it to > BCM. > I hope this helps! > > -- > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > "Steve[ at ]Gabilan" <SteveGabilan[ at ]discussions.microsoft.com> wrote in message > news:8C168EBF-4C22-443D-BE1A-E7138B59DF94[ at ]microsoft.com... >> no...only DBF, ASCII and SDF. I tried exporting to DBF and importing as a >> ACT >> dbf file but it said I must be running ACT which I don't have. Could I >> try >> synchronizing with my PDF and then uploading to BCM? I'll check into >> that. >> -- >> Steve >> >> >> "Mukesh Agarwal [MSFT]" wrote: >> >>> Can you export from Goldmine to .CSV, Excel or Access? BCM will allow >>> importing from these formats. >>> >>> -- >>> Mukesh Agarwal [MSFT] >>> Visit team blog at http://blogs.msdn.com/bcm >>> >>> This posting is provided "AS IS" with no warranties, and confers no >>> rights >>> "Steve[ at ]Gabilan" <SteveGabilan[ at ]discussions.microsoft.com> wrote in >>> message >>> news:0A6A6758-1953-4153-B38D-E14150531AC3[ at ]microsoft.com... >>> >I have tried exporting from Goldmine to XML and then importing to >>> >Excell >>> >2007 >>> > (for later export to BCM) but Excell said there was a problem with the >>> > Schema >>> > file. Are there any other work arounds you can think of for this data >>> > transfer? >>> > -- >>> > Steve >>> >>> >

Re: Importing Goldmine data to BCM 2007 Ed Marmon <unlisted[ at ].com.com> 4/19/2007 5:58:09 PM Steve, I asked an unanswered question to this same effect. What they are suggesting, it seems, will not bring along your histories, etc. Unless you use XML export, but then I dont know how you would import xml properly in BCM to let histories come in under each contact... I would love an answer to this. Importing contacts themselves is easy, we need to know how to import associated histories What I did for conatcts was to just, from GM, do the outlook sync ( one way ) from GM over to outlook. I did the activities too. Then, after that was done, I just dragged the contacts from outlook to BCM and it ( very slowly ) converted them. But my histories are still in GM. =?Utf-8?B?U3RldmVAR2FiaWxhbg==?= <SteveGabilan[ at ]discussions.microsoft.com> wrote in news:0A6A6758-1953-4153-B38D-E14150531AC3[ at ]microsoft.com: [Quoted Text] > I have tried exporting from Goldmine to XML and then importing to > Excell 2007 (for later export to BCM) but Excell said there was a > problem with the Schema file. Are there any other work arounds you can > think of for this data transfer?

Re: Importing Goldmine data to BCM 2007 b.ontask[ at ]gmail.com 5/5/2007 1:18:45 AM I can get your data out of GoldMine pretty easily - each table uses the same primary key to notate which record the information applies to. Typically, when we move clients from one crm package to another we perform separate export/imports from each table to it's appropriate destination table in the new software. Are you able to import into the history or the calendar table in your new database? I'm also very curious why you are moving on. I've evaluated almost all the alternative software and have yet to find a product that compares to a properly configured GoldMine database. Even with the discontinuance of the dbase version support, this application will be around for many more years. There are hundreds of people who can support it technically.... send me a note on how to contact you and let's chat. There's several ways to acheive an export, my recommendation will depend on your skillset and what other software you have available (i.e. access). : ) B.ontask

Re: Importing Goldmine data to BCM 2007 "Lon Orenstein" <Lon[ at ]pinpointtools.com> 5/5/2007 1:00:46 PM b.ontask: Didn't Goldmine just announce they're discontinuing the Standard version and told people they had to upgrade to their new version? ACT! did the same thing with 6.0 version and that's why the refugees show up in this group... Curious Lon, Thanks. ___________________________________________________________ Lon Orenstein pinpointtools, llc Lon[ at ]pinpointtools.com Author of Outlook 2007 Business Contact Manager For Dummies Author of the eBook: Moving from ACT! to Business Contact Manager 800.238.0560 x6104 Toll Free (U.S. only) +1 214.905.0401 x6104 www.pinpointtools.com <b.ontask[ at ]gmail.com> wrote in message news:1178327925.044918.249290[ at ]y80g2000hsf.googlegroups.com... [Quoted Text] >I can get your data out of GoldMine pretty easily - each table uses > the same primary key to notate which record the information applies > to. Typically, when we move clients from one crm package to another > we perform separate export/imports from each table to it's appropriate > destination table in the new software. > > Are you able to import into the history or the calendar table in your > new database? > > I'm also very curious why you are moving on. I've evaluated almost > all the alternative software and have yet to find a product that > compares to a properly configured GoldMine database. Even with the > discontinuance of the dbase version support, this application will be > around for many more years. There are hundreds of people who can > support it technically.... > > send me a note on how to contact you and let's chat. There's several > ways to acheive an export, my recommendation will depend on your > skillset and what other software you have available (i.e. access). > > : ) > > B.ontask >

Re: Importing Goldmine data to BCM 2007 Luther <enowning[ at ]gmail.com> 5/7/2007 6:42:08 PM On May 5, 6:00 am, "Lon Orenstein" <L...[ at ]pinpointtools.com> wrote: [Quoted Text] > b.ontask: > > Didn't Goldmine just announce they're discontinuing the Standard version and > told people they had to upgrade to their new version? ACT! did the same > thing with 6.0 version and that's why the refugees show up in this group... > > Curious Lon, > Thanks. > > ___________________________________________________________ > Lon Orenstein > pinpointtools, llc > L...[ at ]pinpointtools.com > Author of Outlook 2007 Business Contact Manager For Dummies > Author of the eBook: Moving from ACT! to Business Contact Manager > 800.238.0560 x6104 Toll Free (U.S. only) +1 214.905.0401 x6104www.pinpointtools.com > > <b.ont...[ at ]gmail.com> wrote in message > > news:1178327925.044918.249290[ at ]y80g2000hsf.googlegroups.com... > > > > >I can get your data out of GoldMine pretty easily - each table uses > > the same primary key to notate which record the information applies > > to. Typically, when we move clients from one crm package to another > > we perform separate export/imports from each table to it's appropriate > > destination table in the new software. > > > Are you able to import into the history or the calendar table in your > > new database? > > > I'm also very curious why you are moving on. I've evaluated almost > > all the alternative software and have yet to find a product that > > compares to a properly configured GoldMine database. Even with the > > discontinuance of the dbase version support, this application will be > > around for many more years. There are hundreds of people who can > > support it technically.... > > > send me a note on how to contact you and let's chat. There's several > > ways to acheive an export, my recommendation will depend on your > > skillset and what other software you have available (i.e. access). > > > : ) > > > B.ontask- Hide quoted text - > > - Show quoted text - The BCM import utility is extensible. Microsoft released documentation a few years ago. Someone has to write a DLL to convert Goldmine data into XML, drop the DLL in a BCM folder, and then the utility will be able to import Goldmine databases. If enough BCM users want to import from Goldmine, I expect this is a business opportunity for a Goldmine specialist.