Announcement

Collapse
No announcement yet.

3 import problems

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    3 import problems

    Espo 8.1.1

    1. Long lines in the import file are truncated and do not appear in step 2. In the first step, the fields are displayed but not filled with values
    2. If the separator "," is specified and the text field also contains "," then the import falls apart. The field is escaped with double quotes.
    3. Fields with names of three or more parts are not automatically filled in (field name: field_three_part FieldThreePart)

    Screenshots and example file are attached.
    Attached Files
    Tags: None
  • #2
    > 2. If the separator "," is specified and the text field also contains "," then the import falls apart. The field is escaped with double quotes.

    Could not reproduce. File attached.

    > 3. Fields with names of three or more parts are not automatically filled in (field name: field_three_part FieldThreePart)
    ​
    Could not reproduce. The same file.
    Attached Files
    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

    • #3
      Better to split issues if there are really multiple. I suspect there's only one issue (1) that needs investigation.
      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

      • yuri
        #3.1
        yuri commented
        02-13-2024, 11:47 AM
        Editing a comment
        I tried long lines on my CSV, and it worked fine. I suspect your particular CSV needs investigation. Maybe some characters causing the problem.
    • #4
      I try 2 problem files on two different instalations - 8.1.1, 8.1.4 and all have decribed problems. May be affected by Windows system settings?

      Comment

      • dimyy
        #4.1
        dimyy commented
        02-13-2024, 12:01 PM
        Editing a comment
        Also try on 7.5.5 - the same result
    • #5
      I mean that the (1) issue might have caused (2) and (3) issue.
      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

      • #6
        I tried to generate a very similar long string, and it worked for me. I suspect some characters causing parsing issue. Need to figure out what exactly.
        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

        • #7
          Reproduced from your file. The key parameter is length. Critical cut-off - 16kb
          Attached Files

          Comment

          • #8
            Indeed. We have a limitation when parsing CSV on the frontend. First 2 lines should be less than 16KB. I'll fix it in the next hotfix.
            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.
            • Likes 1

            Comment

            • #9
              Temporary workaround: Add a few dummy lines in the beginning, that you will remove after import.
              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

              • #10
                Important is absolute position from file begining. I swap two fields - in first case all ok, in second case - error
                Attached Files

                Comment

                • #11
                  the problem with compound names persists
                  Attached Files

                  Comment

                  • #12
                    OK. I'll look. I even didn't know we have such an ability for underscore fields. It works only for 1 underscore.
                    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

                    • #13
                      not a big problem - just not neat. If it weren’t for the previous one, I wouldn’t even be writing (не аккуратненько :-) )

                      Comment

                      Previous template Next
                      Working...
                      X