CSV Import of customer ID with field type 'Number'

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • hom
    replied
    Works perfect. Thanks a lot for your help!

    Leave a comment:


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

    Leave a comment:


  • hom
    replied
    Hi Tanya

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

    Thanks
    hom

    Leave a comment:


  • tanya
    replied
    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

    Leave a comment:


  • hom
    started a topic CSV Import of customer ID with field type 'Number'

    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
    hom
Working...