Add Users via CSV file

[Matt Leach]

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, 2010 by Guest
spelling

[mr_vodka]

You could always import w/ update matching records.

[Matt Leach]

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.

[David Jondreau]

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.

[IdealData]

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.