Does ImportUsersX work on revo 2.3.1

Anyone used ImportUsersX on Revo 2.3.1?

Does it work with extended fields?

2.3 is 99% backwards compatible with 2.2, so if it worked there the odds are good it works in 2.3 as well. I don't see anything about 2.3 in the repo https://github.com/ackwa/ImportUsersX/issues

Where are you importing the users from? I have various bits of code for importing users.

Thanks Mark / Bob - Will be a CSV file, but it will contain extended fields - Bob, will your scripts work for this?

I do have one around here somewhere that I used to import a CSV user file for a client, but it would almost certainly have to be rewritten to handle the data in your file, especially the extended fields. It's also full of weird cruft because the CSV file I was dealing with had many problems and anomalies and the client wanted to convert user categories to a new structure.

Quote from: BobRay at Nov 14, 2014, 12:45 PM

I do have one around here somewhere that I used to import a CSV user file for a client, but it would almost certainly have to be rewritten to handle the data in your file, especially the extended fields. It's also full of weird cruft because the CSV file I was dealing with had many problems and anomalies and the client wanted to convert user categories to a new structure.

OK, no worries Bob - anyone know if ImportUsersX works with extended fields?

It might be overkill, but have you considered an ETL tool (maybe something like: http://www.cloveretl.com/products/community-edition)? This could potentially handle the extended fields directly, or worse case you could import into a temporary table and write your own cross-loader. Disclaimer: I have not tried this myself.

The code to handle it is pretty simple. PHP has a function (fgetcsv()) that will read each line of a CSV file into a PHP array. You just loop through the file, and for each line, create a user, set the fields one-by-one from that array and save the user. You need a separate array for the extended fields, but as long as you know where they are in the array, that's easy also.