PHP-SecureArea

CSV Import

Importing users ....

You may want to import existing users into PHPSecureArea. This can be done by entering them into a csv file and importing them through the admin pages.

You can import the user details with a given password, or if you leave the password blank, PHPSecuerArea will automatically create a new password for you.

You may also optionally define the expire date for the user. You can then use the cron job to control the manual users.

Once imported the users become 'Manual' users and they will be able to access the selected secure area using the password.

The fields that you may import are :

Email address Mandatory  
Password Optional If left blank PHPSecureArea will automatically create the password
Expire date Optional The date the subscription will expire in the format yyyy-mm-dd, for example 2010-08-02 is 2nd of August 2010.
name Optional  
Telephone Optional  
Mobile Optional  
Address line 1 Optional  
Address line 2 Optional  
City Optional  
State Optional  
Country Optional  
Post code Optional  


Example of csv file with minimum entries :

emailaddress1, , , , , , , , , , ,
emailaddress2, , , , , , , , , , ,
emailaddress2, , , , , , , , , , ,

Example file : click here

 

Example of csv file with password for each user :

emailaddress1, password1, , , , , , , , , ,
emailaddress2, password2, , , , , , , , , ,
emailaddress3, password3, , , , , , , , , ,

Example file : click here

 

Example of csv file with all fields :

emailaddress1, password1, expiredate1, name1, telephone1, mobile1, address_line1_1, address_line2_1, city1, state1, country1, zip_post_code1
emailaddress2, password2, expiredate2, name2, telephone2, mobile2, address_line1_2, address_line2_2, city2, state2, country2, zip_post_code2
emailaddress3, password3, expiredate3, name3, telephone3, mobile3, address_line1_3, address_line2_3, city3, state3, country3, zip_post_code3

Example file : click here

Notes

  • The csv import only creates new users, it does not update existing users so if the email address is already found in the tblusers table, the import will ignore that email address and not import it.

  • You should make sure that all fields have been entered in the csv file or blank entries.

  • If you get any errors and want to re-create the users again, first delete the users from the Manage Users display in the PHP-SecureArea admin pages, and then check if the email address / password has been created in the htpasswd file. If they have been created, delete those entries as well. Then re-import the users. You have to delete the users because the import does not update users only creates new ones.

Find out more

Pricing :
PHP-SecureArea costs $65 U.S. Dollars. Click here to go to the purchase page for further details.

Demo : To view an on-line demo illustrating the admin pages, click here.
You may also buy a 3-days subscription for $0.01 to a test area to see how the system works.

Enquiries : If you have any questions about the product, go to the contacts page by clicking here.