You got the DotNetNuke site up and running.  Congratulation.  The next step is to setup users to access the portal.  You currently have an existing backoffice database (ex. HR, or Workflow, etc.) that have all the user accounts in it and you need a way to setup these acounts in the DotNetNuke website.

WorkConctrol-UserImport enables you to mass import user accounts into DotNetNuke.  The module can import account data from popular sources such as MS SQL, mySQL, Oracle, MS Access, Excel, DB2, etc. via OLEDB connection.  For a list of support data sources and how to connect to them, visit our connection string page.

How does it work?

In the module Settings page, you can specify the Connection String and a SQL statement to select user accounts from an OLEDB data sources into the staging table "WC_UI_UserImport".  From the staging table, the accounts can be reviewed and selectively imported into DotNetNuke

Feature Highlights

• Extensive support for variety of data sources such as Excel, Text, MS Access, MS SQL, Oracle, Sybase, DB2
• No change to DotNetNuke Core program
• Flexible, friendly user interface to allow import of new accounts or update of existing accounts
• To be imported accounts can be exported to Microsoft Excel for off-line update and then upload to the site for mas import/update
• Specified role names in the import file can be created automatically for user assignment at time of import
• Users can be assigned to an existing role in DotNetNuke
• If the password is not specifed in the import file, it can be set to a default value or random
• Multiple OLEDB datasource support - each module instance can be setup to point to an OLEDB datasource to extract data into the staging table.  One module instance can be setup to query the Excel and another instance setup to query MS SQL and another setup to query Oracle, etc.