How can I import contacts from a database into suitecrm?

💬 General Discussion
1

Myt SuiteCRM (latest version) is connected to MySQL (it created the database). But my case is that I want suiteCRM to show as contacts all the users (people with an account on my web) that I have in a different database in the same MySQL.

Would it be possible do that without manually entering each contact (there are a +10k users)?.

2

There is no easy way to accomplish what you want. Now. Here are some suggestions (I haven’t tried any of them):

  1. Export your contacts to a csv file and import them into SuiteCRM. You will need to create relationship to accounts later on. (Or you can create a logic hook on save to add the relationship based on a unique field accounts)

  2. Crete a process_record logichook to connect to your other DB from a logichook and fill local search based on your conditions and update local field or create contact using beans.

  3. Create a special script to import your contacts into your SuiteCRM DB…

Hope it gives you some ideas.

Thanks,

AlxGr