budibase icon indicating copy to clipboard operation
budibase copied to clipboard
Published 3 months ago • verified publisher icon Budibase

Cannot import into main Users table.

Open alscheuring opened this issue 3 years ago • 1 comments

Hosting

  • Self
    • Method: docker single image
    • Budibase Version: 1.2.4
    • App Version: 1.2.4

Describe the bug I get error messages when I try to import a CSV into the main users. table. "Error, please check the following emails: "

To Reproduce Steps to reproduce the behavior:

  1. Manage -> Users
  2. Click on Import Users
  3. Select CSV file (attached in this post)
  4. Error occurs.

Expected behavior System parses csv file and give the ok to proceed

Screenshots Attached.

App Export If possible - please attach an export of your budibase application for debugging/reproduction purposes.

Desktop (please complete the following information):

  • OS: OSX 12.4
  • Browser Chrome
  • Version 103.0.5060.134 (Official Build) (x86_64)

. Screen Shot 2022-08-05 at 11 40 38 AM Screen Shot 2022-08-05 at 11 40 11 AM Screen Shot 2022-08-05 at 11 40 08 AM fake-email-import.csv

alscheuring avatar Aug 05 '22 15:08 alscheuring

Imports appear to work on 1.3.12 if the file consists of email addresses separated by \r characters. The file must NOT end in a \r. This part of the behaviour may be related to #7398 ie.

[email protected]\[email protected] works (works.csv) works.csv

but

[email protected]\[email protected]\r does not work (fails.csv) fails.csv

Also adding additional comma separated fields appears to cause the import to fail (fails2.csv) fails2.csv

mauricedcastro avatar Sep 14 '22 00:09 mauricedcastro