Improper/incomplete import

Created on 18 October 2023, about 1 year ago
Updated 19 October 2023, about 1 year ago

The Drupal 7 User System view lists both name and email in the same column. The CSV export has a blank first column (which must be removed) and the email column has no label. For email import to work, the Email column must be named "mail" and must be lowercase; uppercase won't work; it just imports the name into the email field.

Additionally, Active status, Roles, Member for and Last access aren't imported at all, regardless of upper/lower case.

Thanks for looking into this! (I wanted to attach a file, but the system won't accept .csv files.)

πŸ’¬ Support request
Status

Closed: works as designed

Version

2.0

Component

Miscellaneous

Created by

πŸ‡ΊπŸ‡ΈUnited States bcobin

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @bcobin
  • πŸ‡ΊπŸ‡ΈUnited States bcobin
  • Status changed to Postponed: needs info about 1 year ago
  • πŸ‡³πŸ‡΄Norway gisle Norway

    It is unclear what the problem is. Need steps to reproduce the problem.

  • πŸ‡ΊπŸ‡ΈUnited States bcobin

    I'm attaching a renamed .csv file - if you change the suffix, I think it should work. (Upload of .csv files is disallowed.)

    It's just one record - you'll note that name and email are the only two fields that import successfully. Hope this helps!

  • Status changed to Closed: works as designed about 1 year ago
  • πŸ‡³πŸ‡΄Norway gisle Norway

    First: Whatever the Drupal 7 User System view lists is inconsequential to this module. It expects you to create a well-formed CSV-file, and if the Drupal 7 User System view is not up to the task, you need to fix it yourself.

    Second: From the the project's README.md, when talking about the structure of the CSV and how to name the imported fields in the CSV-file:

    The fields name and mail are defined by core. To look up custom fields in the user profile and their machine names, navigate to Manage Β» Configuration Β» People Β» Account settings Β» Manage fields.

    None of there are fields that can be found if you navigate to that page:

    • active
    • status
    • roles
    • member for
    • last access

    If something is not listed on that page, they're not fields in the user entity, but something else, and outside the scope of what this module is supposed to do.

    Third: There's a newline in the "roles" field in your CSV-file. The value can't be imported because "roles" isn't a field, but if it has been a field, the newline would have stopped it from working.

    To sum up: Except name and mail, the data you're trying to import can't be imported by this module. This is not a bug, but a documented limitation in the module's scope.You need to find another way to import this data.

  • πŸ‡ΊπŸ‡ΈUnited States bcobin

    Thank you very much for the module, the work you've done here and for the quick response! In my case, there are only 60 users to import, so it's a manageable task for me to update each as needed.

    Thanks again for your help - greatly appreciated and I'm hoping this will help others as well!

Production build 0.71.5 2024