Announcement

Collapse
No announcement yet.

CSV Import of customer ID with field type 'Number'

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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

    Comment


    • #3
      Hi Tanya

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

      Thanks
      hom

      Comment


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

        Comment


        • #5
          Works perfect. Thanks a lot for your help!

          Comment

          Working...
          X