CSV Import of customer ID with field type 'Number'

[hom]

Hey everybody,

I would like to import 'Accounts' via import function as administrator.
My Account have each a unique ID that should be imported.

Therefore I added to the entity type 'Account' a filed called 'customer ID' with the field type ' Number'. Because new Accounts should get 'customer ID's' automatically.

But when I try to map my 'unique ID's' from csv to the 'customer ID' it will be ignored.
Instead of setting/overwriting the 'customer ID' with my 'unique ID' the system counts up 'customer ID' by the value from the entity manager.

Does anyone can help my how I can:
1. Mapping my unique ID's via import and
2. Use the functionality of the field type 'Number'

Thanks a lot for helping
hom

[tanya]

Hello
Number field can not be set...
If you are sure, there are no number duplicates in your system and in imported file, you can change manually a field type to 'varchar', rebuild the system and import your accounts. After that change the type to number again, and modify nextNumber parameter to the last customer id +1. Rebuild again

[hom]

Hi Tanya

your solution sounds good to me, I just need some help with 'Rebuild'. How is this done?

Thanks
hom

[tanya]

Administration > Rebuild.
the definition of your field you can find in custom/Espo/Custom/Resources/metadata/entityDefs/Account.json

[hom]

Works perfect. Thanks a lot for your help!