goldmine conversion issues

[gdurham]

Hello all,
I am currently converting contacts from goldmine 6.5 (dbase) to sugarcrm. I am running into a problem that people may have an idea as to fix. I have the data importing however in goldmine a contact field has both the first and last name and then another field for last name. I have tried to make last name not required however on importing it still requires it even after creating an extension for contacts and putting a modified vardefs file into it. It doesn't however require it if you create a contact from scratch. So it is partially working. I have also done a quick repair. An idea I had and I have been looking everywhere for it is to not show the last name in the list. When I import contacts it looks like this in the list: bob smith smith. This is because firstname has both the first and last name and then it is concatenating the last name onto the end. Is there a way to remove this functionality and have both the first and last name listed in the firstname field. i.e. fullname? Also is it possible to add to the search function a % sign so that it will search the entire field. I guess I just need to be pointed to the files I need to edit. I have no problem getting in there and doing it. Just a point in the right direction would be immensely helpful. Thank you so much for your time.

Thanks,
Gregory Durham

[SergeiLo]

Hello Gregory,

At Apatar (open source data migration ETL tool) we have completed a number of data migration projects from Goldmine to SugarCRM for our customers and migrated not only contacts, but also accounts, history, emails, notes etc. Apatar can help you to resolve your issue. We did the following:
1. Mapping CONTACT filed from CONTACT1 table to the first_name in SugarCRM. As mediator between these fields we used RegExp function like

(.*?)[\s].*

This function helps to choose the first name before first space. You will have: CONTACT -> RegExp -> first_name

2. Mapping CONTACT filed from CONTACT1 table to the last_name in SugarCRM. Mediators here RegExp function with

.*?[\s](.*)

inside it, then Replace with function where you indicate if input value is null or empty (just leave it blank) replace with, for example as unknown or choose option within this function to "Treat null as empty string", thus if you do not have last name in GoldMine, Apatar will tell SugarCRM that you do not have a last name and SugarCRM will not require it.
Mapping example: CONTACT -> RegExp -> Replace with -> last_name

Other variants also possible. Try it.

Regards,
Sergei

[gdurham]

Thanks alot for getting back to me, I was wondering when it imports the contacts will sugar auto assign a id to it.

Thanks,
Greg

[SergeiLo]

Thanks alot for getting back to me, I was wondering when it imports the contacts will sugar auto assign a id to it.

Thanks,
Greg

Yes, SugarCRM will auto assign IDs to your records. If you have any issues, feel free to contact me directly via email and I will provide you with a datamap sample and some tips.

Regards,
Sergei
sergei.l at apatar.com