
CSV Import of customer ID with field type 'Number'
Collapse
X
-
Administration > Rebuild.
the definition of your field you can find in custom/Espo/Custom/Resources/metadata/entityDefs/Account.jsonLeave a comment:
-
Hi Tanya
your solution sounds good to me, I just need some help with 'Rebuild'. How is this done?
Thanks
homLeave a comment:
-
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 againLeave a comment:
-
CSV Import of customer ID with field type 'Number'
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
homTags: None
Leave a comment: