import: add a custom field as index to check duplicates

[analyst123]

Hello
I have some trouble with import feature customization in Sugar Community Edition 5.2.

I would like to use a custom field named 'partita_iva_c' created in Accounts module as index to check duplicates to import accounts records from external source (.csv files).

I have added the following line to the /modules/Accounts/vardef.php file in 'indices' => array section:

array('name' =>'idx_partita_iva', 'type' =>'index', 'fields'=>array('partita_iva_c')),

when I go to the Admin section and try to repair Sugar to update it with the new index I receive the following error message:

Executing repair query: Query Failed:ALTER TABLE accounts ADD INDEX idx_partita_iva (partita_iva_c)::MySQL error 1072: Key column 'partita_iva_c' doesn't exist in table

I guess it happens because 'partita_iva_c' is a custom field so it's not allocated in 'accounts' table.
May someone help me to find the solution ?
tks a lot

[andopes]

You can use DevToolKit to accomplish this feature.
The link to DevToolKit is in my signature.

Regards

[analyst123]

Andrè, thank you very much for your suggestion.
I have just installed devtoolkit 0.5 module.
May you tell me more about what I have to do?
tks a lot in advance
regards

[jernel22]

Hello, I am using the SugarOpenCloud hosted version of Sugar Express 5.2.0.
I am trying to create in import index on a custom field in the Customer Accounts Module.

Can you help me figure out how to do this from the hosted version, were I don't have access to the .php files?

Thank You

[oogway]

You can use DevToolKit to accomplish this feature.
The link to DevToolKit is in my signature.

Regards

Will DevTookKit work for Sugar6? in Cloud Counsel?

I need to be able to add an index on a custom field, so any help you could provide would be much appreciated.

Thank you,
Daniel

[manfredpw]

Will DevTookKit work for Sugar6? in Cloud Counsel?

I need to be able to add an index on a custom field, so any help you could provide would be much appreciated.

Thank you,
Daniel

I need the same function for Sugar6.

Anyone?

Tks.

[andopes]

I need the same function for Sugar6.

Anyone?

Tks.

Hi guys

Thanks for choosing DevToolKit

DevToolKit, as it is, work on 6.0 without big deal.

Cheers