Import users

[nickrth]

Hi there, I’m trying to import users but am having some trouble.

I’ve setup the csv with the columns as per the zzzzsys_user table, separated with ‘,’, and sequential number 1-n in the first column. When I do the import in the Nubuilder Transfer screen, I select comma separated and it seems to import fine, but then I look at the table in PHPMyAdmin, and it’s imported the whole line from the csv into the first field.

Any ideas what I might be doing wrong? Thank you.

[kev1n]

Hi,

It took me a little longer to address the matter, but I've now had the opportunity to investigate the issue. I've identified several potential problems that might arise during the CSV import process. These include the use of an outdated import template, the absence of MySQL load permissions, and so on.

I've taken the initiative to enhance the user import code for greater resilience. To ensure everything functions smoothly, it's crucial to perform a two-step update:

1. Make sure you're using the latest version available on Github. This applies to both the relevant files and the database itself.

2. Incorporate the latest import template, which can be found under misc/user_import_template.csv.

I hope this will solve the issue.

[nickrth]

Thanks Kevin!

I ended up being able to create a procedure to do the import I needed, but I'll certainly do an update and make use of the enhanced built-in import for the next batch of users.