I was unable to find any posts / documentation in regards to automatically adding users so i figured i would throw this out there to see if it is a possibility.

The current database i am working with allows members of the organization to register for access to the database. I have a form on the website that the user fills out which then saves the results to a csv file on my webserver and alos emails me a copy of the submitted form.

Lately ive been adding 20+ users per day manually. Is it a possibility to have FileMaker read in the CSV file and add a user based on the fields in the file?

The CSV's structure is as follows:

Name

Email

Ret. Date

Password

I would use the email for the username.

Thanks

Edited March 12, 201015 yr by Guest
spelling

You could always import w/ update matching records.

Im not sure that will do what im looking for.

That would create a record for the user. Each user already has a record.

What i am trying to do is create a user account so that the person can login to the database, not an actual record.

You'll want to import the file into an "Accounts" table, then loop through the records, using the Add Account[] script step.

You need to figure out how to link the User record to the Accounts record and I wouldn't recommend storing the password.

I wonder if there is a limit to the number of accounts FM will handle. At the present 20+ per day you will soon have a lot of accounts.