I would like to import 100's of accounts at one time, the problem is I need all of the custom fields not just the four available fields in the import tool. Is there a way to add the custome fields when using the admin import tool?
Thanks.
For more in-depth importing of custom fields its best to use a tool such as PHP MyAdmin where you can import all fields in the DB.
Are you familiar with the PHP MyAdmin tool?
i2
Yes, thank you.
I just have 300 members and 26 fields, so that is a lot of work to build an SQL insert into for every member. I found a few excel - to SQL converters. Have you used anything like this?
What you should do is:
1) Create your fields
2) Create a user in the system
3) go to PHP MyAdmin --> users table --> Export --> CSV style
You'll then see the format it needs to be in.
Get your existing data into that format.
Then
4) PHP MyAdmin --> users table --> Import --> CSV Format --> Select the file you have all your imports in, in the format from step #3