Announcement

Collapse
No announcement yet.

Espo doesn't show content of column from imported CSV

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

  • 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

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

    Comment


    • #3
      Originally posted by Stagnettii View Post
      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


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


        • #5
          Originally posted by Stagnettii View Post
          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


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

            Comment


            • #7
              Maybe quotes should be backslashed? \"

              Last edited by yuri; 06-15-2016, 07:36 AM.

              Comment


              • #8
                Originally posted by yurikuzn View Post
                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


                • #9
                  Yes. This way.

                  Comment


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

                    Comment


                    • #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...
                      X