3 import problems

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dimyy
    Active Community Member
    • Jun 2018
    • 569
    #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
    • yuri
      Member
      • Mar 2014
      • 8547
      #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

        • yuri
          Member
          • Mar 2014
          • 8547
          #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.
            • dimyy
              Active Community Member
              • Jun 2018
              • 569
              #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
                • yuri
                  Member
                  • Mar 2014
                  • 8547
                  #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

                    • yuri
                      Member
                      • Mar 2014
                      • 8547
                      #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

                        • dimyy
                          Active Community Member
                          • Jun 2018
                          • 569
                          #7
                          Reproduced from your file. The key parameter is length. Critical cut-off - 16kb
                          Attached Files

                            Comment

                            • yuri
                              Member
                              • Mar 2014
                              • 8547
                              #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.

                                Comment

                                • yuri
                                  Member
                                  • Mar 2014
                                  • 8547
                                  #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

                                    • dimyy
                                      Active Community Member
                                      • Jun 2018
                                      • 569
                                      #10
                                      Important is absolute position from file begining. I swap two fields - in first case all ok, in second case - error
                                      Attached Files

                                        Comment

                                        • dimyy
                                          Active Community Member
                                          • Jun 2018
                                          • 569
                                          #11
                                          the problem with compound names persists
                                          Attached Files

                                            Comment

                                            • yuri
                                              Member
                                              • Mar 2014
                                              • 8547
                                              #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

                                                • dimyy
                                                  Active Community Member
                                                  • Jun 2018
                                                  • 569
                                                  #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...