Only first entry gets imported

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cityroler
    Junior Member
    • Nov 2017
    • 6

    Only first entry gets imported

    Hello,

    I have a problem when importing csv-files. Every time I do this, only the first row gets imported as a new account (see picture). I tried it with several different settings now but it's not working at all to import more than 1 row.
    Is this a known bug or is there anything I did wrong?


    cityroler
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hello
    Could you attach Step 2 page?
    And it will be great, if you share your csv in Private Message, if it is possible
    Last edited by tanya; 11-07-2017, 01:42 PM.

    Comment

    • cityroler
      Junior Member
      • Nov 2017
      • 6

      #3
      Hi tanya
      Since I converted the csv to dummy data, I can also share it here.

      The last two columns with
      Code:
      ["..."]
      should get imported into multi-enum fields.

      I hope you can help me.
      Attached Files

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        in your rows break with '\r' symbol
        needs '\r\n' or '\n'

        Comment

        • cityroler
          Junior Member
          • Nov 2017
          • 6

          #5
          This has the same result
          Last edited by cityroler; 11-08-2017, 01:14 PM.

          Comment

          • tanya
            Senior Member
            • Jun 2014
            • 4308

            #6
            Hello
            application/Espo/Services/Import.php
            replace $contents = str_replace("\r\n", "\n", $contents); to $contents = str_replace(["\r\n", "\r"], "\n", $contents);

            Comment

            • cityroler
              Junior Member
              • Nov 2017
              • 6

              #7
              Hi,
              I could solve the problem. There was a missing row break in the last row.

              Thanks a lot! :-)

              Comment

              Working...