You are here

README.txt in User Import 7.3

********************************************************************
                     D R U P A L    M O D U L E
********************************************************************
Name: User Import Module
Author: Robert Castelo <www.codepositive.com>
Drupal: 7.x
********************************************************************
DESCRIPTION:

Import users into Drupal from a CSV-file (Comma Separated File).

Features include:

* Creates an account for each user.
* Match CSV columns to user fields.
* Can optionally use the file's first row to map CSV data to user fields.
* Option to create Usernames based on data from file, e.g. "John" + "Smith" => "JohnSmith".
* Usernames can be made of abbreviated data from file, e.g. "Jane" + "Doe" => "JDoe".
* Option to create random, human readable, usernames.
* Option to import passwords.
* Option to create random passwords for each user.
* Can set user roles.
* Option to send welcome email, with account details to each new user.
* Can set each user's contact form to enabled.
* Test mode option to check for errors.
* Processing can be triggered by cron or manually by an administrator.
* Can stagger number of users imported, so that not too many emails are sent at one time.
* Multiple files can be imported/tested at the same time.
* Option to make new accounts immediately active, or inactive until user logs in.
* Use CSV-file already uploaded through FTP (useful for large imports).
* Designed to be massively scalable.

** Supported CSV File Formats **

The following settings are necessary when saving a CSV-file which will be used for the import.

File needs to be saved as "Character Set: Unicode (UTF-8)".

Field delimiter: ,
- can be configured as something else, a comma is the default though.

Text delimiter: "
- if there's an option to quote all text cells, enable it.

If file import fails with "File copy failed: source file does not exist." try
setting the file extension to .txt.


** IMPORTANT **

- Note that Date fields are not yet supported, however, there is a patch, see:
  https://www.drupal.org/project/user_import/issues/2149721.

- Note that passwords can only be imported as plain text, and will be converted to MD5 by Drupal.

- Note that if your data contains a backslash before the column separator it may not get imported as expected:
  "123","abc\","def"
  The second field will be imported as: abc","def
  This has been fixed in PHP 5.3


********************************************************************
PREREQUISITES:

  Must have customised user fields already entered
  if data is to be imported into user entity.


********************************************************************
INSTALLATION:

Note: It is assumed that you have Drupal up and running.  Be sure to
check the Drupal web site if you need assistance.

1. Place the entire user_import directory into your Drupal directory:
   sites/all/modules/.


2. Enable the user_import modules by navigating to:

   administer > modules

  Click the 'Save configuration' button at the bottom to commit your
  changes.

3. IMPORTANT - Navigate to:
    admin/config/media/file-system 

    Set the 'Private file system path' field.



********************************************************************
CONFIGURATION:

Configuration for User Import:

'People'
-- 'Import'
-- 'Configure' (admin/people/user_import/configure)

* Uploads Directory

   This option provides a directory where files can be uploaded, and then selected when setting up 
   an import. The uploads directory will be in your Private files directory:

   [path to private files]/user_import/uploads/selectable

* Automated Imports

   If this is set then each import template will have the option to create a matching directory which 
   will be scanned for any files that have been uploaded to it, and when a file is found it will 
   automatically be used to create new user accounts. Directories are scanned during cron runs.

   Scanned directories will be in:

   [path to private files]/user_import/uploads/[name of directory]



********************************************************************
USAGE


 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  For more detailed instructions (with pictures) please go to the
  documentation pages for this module:

  https://www.drupal.org/docs/7/modules/user-import
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -


1. To set permissions of who can import users into the site, navigate to:

'People'
-- 'Permissions'
-- 'User Import'
-- 'Import users' (admin/people/permissions)

2. To import users, navigate to:

'People'
-- 'Import'
-- 'New Import' (admin/people/user_import/add)

* Note that Drupal may require its caches to be flushed before the User Import menu options appear.

3. Press the 'browse' button to select a file to import,
    or select a file already added through FTP.

5. Click on Next.

6. Use the "Use Different CSV File" fieldset to remove and add a different CSV-file.

7. Under Field Match you should see the various columns from your user fields.

8. For each CSV-column select a Drupal field to map.

9. Under username select '--', if the field is not to be used to generate the username, or select '1' - '4'
    for the order to use the field in generating username.

    Example: 'Lastname' and 'Firstname' are fields to be used as username.  So under the username
    selection chose '1' for 'Firstname' and '2' for 'Lastname', and the username generated will be in
    the form 'FirstnameLastname'.

10. Under Options you should see Ignore First Line ( use if the first row are labels ),

    Contact, and Send Email.  Select whichever is appropiate.

11. Under Role Assign select the roles the imported users will be assigned.  This setting will only appear if your role has the permission "User import assign roles".

12. Under Email Message, you can override the default message sent to new users. Leave blank to use the default message.

13. Under Update Existing Users, you can set whether existing users matching ones from the CSV-file will be updated, replaced or added.

12. Under Save Settings, you can save your settings for use on future imports.

13. Click "Test" to do an import without committing changes to the database.  Fix any errors that are generated.

14. Click "Import" to complete the import.



********************************************************************
AUTHOR CONTACT

- Report Bugs/Request Features:
   https://www.drupal.org/project/user_import

- Commission New Features:
   https://www.drupal.org/u/robert-castelo

- Want To Say Thank You:
   http://www.amazon.com/gp/registry/O6JKRQEQ774F


********************************************************************
ACKNOWLEDGEMENT

- I looked at a script by David McIntosh (neofactor.com) before coding this module.
- Documentation help Steve (spatz4000)
- patch by mfredrickson
- patch by idealso
- code from Nedjo Rogers


********************************************************************
SPONSORS

File

README.txt
View source
  1. ********************************************************************
  2. D R U P A L M O D U L E
  3. ********************************************************************
  4. Name: User Import Module
  5. Author: Robert Castelo
  6. Drupal: 7.x
  7. ********************************************************************
  8. DESCRIPTION:
  9. Import users into Drupal from a CSV-file (Comma Separated File).
  10. Features include:
  11. * Creates an account for each user.
  12. * Match CSV columns to user fields.
  13. * Can optionally use the file's first row to map CSV data to user fields.
  14. * Option to create Usernames based on data from file, e.g. "John" + "Smith" => "JohnSmith".
  15. * Usernames can be made of abbreviated data from file, e.g. "Jane" + "Doe" => "JDoe".
  16. * Option to create random, human readable, usernames.
  17. * Option to import passwords.
  18. * Option to create random passwords for each user.
  19. * Can set user roles.
  20. * Option to send welcome email, with account details to each new user.
  21. * Can set each user's contact form to enabled.
  22. * Test mode option to check for errors.
  23. * Processing can be triggered by cron or manually by an administrator.
  24. * Can stagger number of users imported, so that not too many emails are sent at one time.
  25. * Multiple files can be imported/tested at the same time.
  26. * Option to make new accounts immediately active, or inactive until user logs in.
  27. * Use CSV-file already uploaded through FTP (useful for large imports).
  28. * Designed to be massively scalable.
  29. ** Supported CSV File Formats **
  30. The following settings are necessary when saving a CSV-file which will be used for the import.
  31. File needs to be saved as "Character Set: Unicode (UTF-8)".
  32. Field delimiter: ,
  33. - can be configured as something else, a comma is the default though.
  34. Text delimiter: "
  35. - if there's an option to quote all text cells, enable it.
  36. If file import fails with "File copy failed: source file does not exist." try
  37. setting the file extension to .txt.
  38. ** IMPORTANT **
  39. - Note that Date fields are not yet supported, however, there is a patch, see:
  40. https://www.drupal.org/project/user_import/issues/2149721.
  41. - Note that passwords can only be imported as plain text, and will be converted to MD5 by Drupal.
  42. - Note that if your data contains a backslash before the column separator it may not get imported as expected:
  43. "123","abc\","def"
  44. The second field will be imported as: abc","def
  45. This has been fixed in PHP 5.3
  46. ********************************************************************
  47. PREREQUISITES:
  48. Must have customised user fields already entered
  49. if data is to be imported into user entity.
  50. ********************************************************************
  51. INSTALLATION:
  52. Note: It is assumed that you have Drupal up and running. Be sure to
  53. check the Drupal web site if you need assistance.
  54. 1. Place the entire user_import directory into your Drupal directory:
  55. sites/all/modules/.
  56. 2. Enable the user_import modules by navigating to:
  57. administer > modules
  58. Click the 'Save configuration' button at the bottom to commit your
  59. changes.
  60. 3. IMPORTANT - Navigate to:
  61. admin/config/media/file-system
  62. Set the 'Private file system path' field.
  63. ********************************************************************
  64. CONFIGURATION:
  65. Configuration for User Import:
  66. 'People'
  67. -- 'Import'
  68. -- 'Configure' (admin/people/user_import/configure)
  69. * Uploads Directory
  70. This option provides a directory where files can be uploaded, and then selected when setting up
  71. an import. The uploads directory will be in your Private files directory:
  72. [path to private files]/user_import/uploads/selectable
  73. * Automated Imports
  74. If this is set then each import template will have the option to create a matching directory which
  75. will be scanned for any files that have been uploaded to it, and when a file is found it will
  76. automatically be used to create new user accounts. Directories are scanned during cron runs.
  77. Scanned directories will be in:
  78. [path to private files]/user_import/uploads/[name of directory]
  79. ********************************************************************
  80. USAGE
  81. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  82. For more detailed instructions (with pictures) please go to the
  83. documentation pages for this module:
  84. https://www.drupal.org/docs/7/modules/user-import
  85. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  86. 1. To set permissions of who can import users into the site, navigate to:
  87. 'People'
  88. -- 'Permissions'
  89. -- 'User Import'
  90. -- 'Import users' (admin/people/permissions)
  91. 2. To import users, navigate to:
  92. 'People'
  93. -- 'Import'
  94. -- 'New Import' (admin/people/user_import/add)
  95. * Note that Drupal may require its caches to be flushed before the User Import menu options appear.
  96. 3. Press the 'browse' button to select a file to import,
  97. or select a file already added through FTP.
  98. 5. Click on Next.
  99. 6. Use the "Use Different CSV File" fieldset to remove and add a different CSV-file.
  100. 7. Under Field Match you should see the various columns from your user fields.
  101. 8. For each CSV-column select a Drupal field to map.
  102. 9. Under username select '--', if the field is not to be used to generate the username, or select '1' - '4'
  103. for the order to use the field in generating username.
  104. Example: 'Lastname' and 'Firstname' are fields to be used as username. So under the username
  105. selection chose '1' for 'Firstname' and '2' for 'Lastname', and the username generated will be in
  106. the form 'FirstnameLastname'.
  107. 10. Under Options you should see Ignore First Line ( use if the first row are labels ),
  108. Contact, and Send Email. Select whichever is appropiate.
  109. 11. Under Role Assign select the roles the imported users will be assigned. This setting will only appear if your role has the permission "User import assign roles".
  110. 12. Under Email Message, you can override the default message sent to new users. Leave blank to use the default message.
  111. 13. Under Update Existing Users, you can set whether existing users matching ones from the CSV-file will be updated, replaced or added.
  112. 12. Under Save Settings, you can save your settings for use on future imports.
  113. 13. Click "Test" to do an import without committing changes to the database. Fix any errors that are generated.
  114. 14. Click "Import" to complete the import.
  115. ********************************************************************
  116. AUTHOR CONTACT
  117. - Report Bugs/Request Features:
  118. https://www.drupal.org/project/user_import
  119. - Commission New Features:
  120. https://www.drupal.org/u/robert-castelo
  121. - Want To Say Thank You:
  122. http://www.amazon.com/gp/registry/O6JKRQEQ774F
  123. ********************************************************************
  124. ACKNOWLEDGEMENT
  125. - I looked at a script by David McIntosh (neofactor.com) before coding this module.
  126. - Documentation help Steve (spatz4000)
  127. - patch by mfredrickson
  128. - patch by idealso
  129. - code from Nedjo Rogers
  130. ********************************************************************
  131. SPONSORS