Sugar Import?

[Danielg42]

I was wondering if there is a way to make sugar import and replace, rather than import and create duplicates of things.
We have a database that occasionally needs to be syncronised with sugar and everytime I import the data, sugar creates a bunch of new duplicate accounts.

[dstrickler]

Version 4.5 of Sugar (will be released very soon) has some de-dupe functions in it that may help. You can test a copy online so you can simulate your imports. I can't remember the URL, but I'm sure its in the Forum somewhere...

[Danielg42]

Is there anyway to get this functunalitiy in sugar 4.2.1b?

[alevesque]

My solution is to check everythiong in Ms Access before doing the import.

I have sugarcrm 4.2.1b with MySQL.

i link my SugarCRM database (with odbc driver) and my new_to_import data to access and run a Query.

This allow me to see if account name are matching (or if a few typo need to be corrected).

I then export this matching data with the matching id from my sugracrm account. The SQL query read like this:

SELECT accounts.id, new_to_import.*
FROM accounts INNER JOIN new_to_import ON accounts.name = new_to_import.ACCOUNT
ORDER BY accounts.id DESC;


finally, i create a query showing all new_to_import data but only matching sugarcrm data. I then filter on account id is null.
I then export this unmatchnig data (without account id) to complete the procedure.
the sql for this is the following:

SELECT new_to_import.*
FROM accounts RIGHT JOIN new_to_import ON accounts.name = new_to_import.ACCOUNT
WHERE (((accounts.id) Is Null))
ORDER BY accounts.id DESC;

At the end i have 2 files ready for import : match.txt and unmatch.txt

a build-in function would be easier but in my case this got the job done.
Hope this help.

[caiomsouza]

Hello Everybody,

I am also having this same problem.

I was wondering If someone already have some scripts or even a access database or mysql database to share with the community.

I would like to import dates to accounts and contacts and do not have the duplicate problem.

Best Regards,

Caio Moreno de Souza

[siotha]

oops i have the same problem but, i'm not as DB savvy.

I'm an admin in my sugar account and want to use the basic import button to update accounts. Help?