Dupicate Entrys on Import

[Miceal]

Why is there no index key for account name when importing accounts. this would prevent dupilcate accounts been entered. At the moment i cant prevent duplicate entries for accounts. when importing contacts it has first and last name as index keys so this prevents duplicates for contacts which is good but i cant understand why accounts doesnt have account name as an index key. Is there away of changing the code to fix this.

Sugar version 4.5.1b

[DannyFaak]

When i get you right the account 'name' should be the index key or?

An each account gets an id when it is copied into the db, so ...

[arikin]

SugarCRM is trying to protect you from the SQL
The DB table has its own index id. This should be unique for each row and is automatic.
The data you are importing can be sorted the way you want without thinking about the table's index.

You might consider using Studio to add a custom field for your data that will act as your unique id.
Example: account_customer_id
Just make sure that the "combine duplicates" option is disabled.

One note though... I am not quite sure if that field will get transfered in the next major upgrade to SugarCRM. Does someone know for sure?

[Miceal]

Is there anyway of having account 'name' as an index key.
in the import screen under the Verify duplicate entries against selected indexes header. I put the id field in the indexes used field and it doesnt prevent duplicate account names. All my accounts run on account name. i dont use account id. The values in the database under account id are 32434234bcvbdgkdsf ids. So if i could get account 'name ' into the indexes used field it would solve my problem.