Emaze Auction: Import users

The #ListGetAt(fieldOrder,count1)# field is repeated. Please re-enter the values.

Whoa! You are trying to import #numFields# fields per record. The file contains #userLength# records, but #listLength# fields, leaving #userMod# extra record(s). Users will not be imported until this problem is fixed.

SELECT username FROM Member Username #username# already taken. User not added.
INSERT INTO Member ( username, password, firstName, lastName, email, organization, phone, creditCardNumber, creditCardExpiration, creditCardName, address, address2, city, state, zipCode, country, billingAddress, billingAddress2, billingCity, billingState, billingZipCode, billingCountry, userStatus) VALUES ( '#username#', '#password#', '#firstName#', '#lastName#', '#email#', '#organization#', '#phone#', '#creditCardNumber#', '#creditCardExpiration#', '#creditCardName#', '#address#', '#address2#', '#city#', '#state#', '#zipCode#', '#country#', '#billingAddress#', '#billingAddress2#', '#billingCity#', '#billingState#', '#billingZipCode#', '#billingCountry#', 1)

Users successfully added to the system.


Import Users

You can import users via a comma-delimited text file. The text file may contain the following fields: username, password, first name, last name, and email. Please note that if you try to import too many users at a time, Cold Fusion may time out. If this happens, either change the timeout setting in the Cold Fusion Administrator or import fewer users at a time.

Path to file:

Field order: The fields can be in any order, but you must declare below what that order is. The file must contain at least one field. You may not choose a field more than once. Please note that if the username is included in the list, the system will only add those records which have unique usernames. The system will return a list of users which were not added.

1:   12:
2: 13:
3: 14:
4: 15:
5: 16:
6: 17:
7: 18:
8: 19:
9: 20:
10: 21:
11: 22:

Check here if the first line of the file contains the field names.
(The import script will ignore this line.)