Espo doesn't show content of column from imported CSV

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Stagnettii
    Junior Member
    • Aug 2015
    • 6

    Espo doesn't show content of column from imported CSV

    Hey there,

    i'm new here and just started working with EspoCRM. I hope this Problem belongs in here.

    i've got a problem with importing accounts in EspoCRM. I created a new field "Shopsysteme" where you can select one more shopsystem which the company is dealing with (e.g. Magento, Shopware). When importing my .csv document with all information, Espo only imports all other information. There is no Problem with the fields "name" or "adress".

    I even exported one account where i put in a shopsystem manually via the account formular - when importing the exact same .csv it didn't show the shop system either.

    Did anyone else had trouble with this?

    Thanks for any help!

    Laura
  • yuri
    Member
    • Mar 2014
    • 8440

    #2
    Hi

    I just tried to reproduce.

    1. Created new enum field 'test' for Account with few options.
    2. Created csv with test column
    3. Imported with proper specified mapping.

    All worked fine. You can attach your csv here. Did you create enum field?
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • gribs
      Senior Member
      • May 2015
      • 104

      #3
      Originally posted by Stagnettii
      Hey there,

      i'm new here and just started working with EspoCRM. I hope this Problem belongs in here.

      i've got a problem with importing accounts in EspoCRM. I created a new field "Shopsysteme" where you can select one more shopsystem which the company is dealing with (e.g. Magento, Shopware). When importing my .csv document with all information, Espo only imports all other information. There is no Problem with the fields "name" or "adress".

      I even exported one account where i put in a shopsystem manually via the account formular - when importing the exact same .csv it didn't show the shop system either.

      Did anyone else had trouble with this?

      Thanks for any help!

      Laura

      Hi, I have this trouble too with multi enum fields importation

      Comment

      • Stagnettii
        Junior Member
        • Aug 2015
        • 6

        #4
        Hey there,

        it wasn't an enum field it was an array field. Because i need to be able to select more than one option. I figured out that it works, when i put the content of the specific column in the .csv like this: ["content"].

        Laura

        Comment

        • gribs
          Senior Member
          • May 2015
          • 104

          #5
          Originally posted by Stagnettii
          Hey there,

          it wasn't an enum field it was an array field. Because i need to be able to select more than one option. I figured out that it works, when i put the content of the specific column in the .csv like this: ["content"].

          Laura

          This bug affects Array And multi enum fields imports

          Comment

          • rodrigocoelho
            Active Community Member
            • Jun 2016
            • 296

            #6
            Hi, I tried using ["email1@domain.com","email2@domain.com"] for importing multiple emails, but it doesn't work. Any idea please?

            Comment

            • yuri
              Member
              • Mar 2014
              • 8440

              #7
              Maybe quotes should be backslashed? \"

              Last edited by yuri; 06-15-2016, 07:36 AM.
              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

              Comment

              • rodrigocoelho
                Active Community Member
                • Jun 2016
                • 296

                #8
                Originally posted by yurikuzn
                Maybe quotes should be backslashed? "
                ["email1@domain.com","email2@domain.com"]
                This way???

                What about the other " used to defining text on CSV??

                "[\"email1@domain.com\",\"email2@domain.com\"]"
                Last edited by rodrigocoelho; 06-15-2016, 12:42 PM.

                Comment

                • yuri
                  Member
                  • Mar 2014
                  • 8440

                  #9
                  Yes. This way.
                  If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                  Comment

                  • rodrigocoelho
                    Active Community Member
                    • Jun 2016
                    • 296

                    #10
                    Just tried with backslash and it didn't work.

                    Comment

                    • loi.tra
                      Junior Member
                      • Jan 2022
                      • 1

                      #11
                      Backslash and quotes
                      Code:
                      \"
                      doesn't work

                      Double quotes
                      Code:
                      ""
                      works to me.

                      Let me know whether this works for you as well.

                      example:
                      Code:
                      "[""Talent Agency"",""Advertiser - Automotive"",""Vendor - Signatory Services""]"

                      Comment

                      Working...