Arra User Import Export Documentation

1. The user export panel:

The default export properties (no setting is made and the export button is pressed from the "Simple User Export" field or from the export button from the top right side of the page. Both buttons have the same function, so it doesn't matter on which one you click):

• - the file format (for the file exported) is .csv;
• - the default columns are: name, username si email;
• - the default separator is comma (,);
• - there is no ordering made for this feature (the data is exported just like provided from the sql);
• - if there is nothing checked at "User Type", then all the user types will be exported;
• - if "Send mail" is not checked for the Super Administrator user type and if there is no email address entered below, there won't be any email sent with the exported file Export using advanced settings:

Important: if the user has an older version of php (< v 5.2.0) or the zlib library isn't installed on the server he won't be able to export using the zip feature (because we are using a class that was supported in the later versions).

• - you can filter the export using the advanced settings (only the fields checked will be taken into consideration for the export
• - also the fields checked from the "Simple User Export" will be taken into consideration);
• - if doesn't matter on which of the two export buttons you will press, they act the same
• - if the file format for the export is .csv, .txt or .html then the following options will be available:

* the user fields checked for the export
* specific types of the users (if nothing is checked, then all user types will be exported)
* the separator chosen for the export (just for .csv and .txt and not for .html)
* ordering based on a specific field, ascending or descending (only if selected)
* emails with a copy of the exported file can be sent to both Super Administrator type users and/or to emails speficied by the user
* the .sql and .zip files will include both the creation of the tables (_core_acl_aro_groups; _users; _core_acl_aro; _core_acl_groups_aro_map) and the inserts of the records in each table

2. The user import panel:

The .csv and .txt file format import

• - the most important options will be the ones checked in “CSV/TXT Import options”;
• - the separator which is chosen from the options must be the same as the one present in the import file;
• - if the option “Overwrite entire data (all fields) from imported file for existing users” is checked the rest of the settings below regarding the overwrite options will be ignored and all data for existing users can be overwritten (if there are users that correspond with those from the database);

* if “Overwrite usertype for existing users” is set to "yes" this option will allow the type from the existing users to be overwritten. If the new user type does not exist in the database (in the table “core_acl_aro_groups”), it will be added and its "gid" (group id) will be added to the user. It's really important that the user type column from the import file is not empty.
* if "overwrite password for existing users" is set to yes then the passwords for the existing users can be overwritten from the import file. Note: if the option "Given passwords are already encrypted" is set to yes, then the new password will be updated in the database just as it is; if this option is set to "no", then the password given from the import file will be encoded and updated into the database.
* If the options “Overwrite email for existing users” and “Overwrite block option to existing users” are checked, these options will act the same as any overwrite option: the values for the fields of the existing users will be replaced with the new values from the import file. All these overwrite settings are just for the existing users (users that are already in the database). For the new entries there are other options that will matter, such as the option to generate password, encrypt password, set default usertype or "Insert default usertype if none set";
* the option “Send emails to new users (that don't exist in the database) after import” is checked by default. This will send an email to each of the new users with their unencrypted password (if an unencrypted password is set in the import file - if the password is already encrypted from the import file the password won't be sent) and their user type. The email will be sent to the address specified in the import file. If the option isn't checked no email will be sent.
* for new users it is important that the following 3 fields be included into the import file: name, username, email. The values for the rest of the fields will be either added from the import file or generated by the system automatically (a random password can be generated or a default password can be set; also, you can insert a default user type - if not the 'Registered' user type will be inserted);
* all these options above will be saved after the import is made, so that the user doesn't have to select them again next time for his import;

The .sql and .zip file format import

• - the user has the possibility to create a backup of all the user tables from the database (the creation of the tables and the insertion of records for the following tables: _users, _core_acl_aro, _core_acl_aro_groups, _core_acl_groups_aro_map). The backup will be an archived sql file.
• - before making an .sql of .zip import the current tables must be emptied (no records should remain in the tables, but the table structure should not be deleted as well). In these tables only the Super Administrators will remain, so that these users can successfully login to the administrator.
• - when the import is made (by pressing the import button for this file format of the import button located on the top right side of the page), the Super Administrator users are remembered with their properties, the tables are completely truncated, the records are inserted and then the initial Super Administrators are re-entered into the database.Before the Super Administrators are re-entered into the database, the system checks to see if their ids already exist into the database (new ids will be generated) or if their username or email already exist into the database (maybe they were already created with the import). If an error occurs for this import feature, the tables will be truncated and only the initial Super Administrators will be kept into the database.
• - no option set for the .csv and .txt will be taken into consideration for this type of import

3. The "Users statistics" and the "About" panel: - The statistics for the existing users (users from the database) are displayed - You can check to see what version you have installed under "About" and what is the latest version of the component - If the extension "php_curl" is not installed on the server a message will be displayed, letting the user know that a connection could not be established