Where is it getting the reference and how can i change it? My database name is now DNN_89814 . . . I have uninstalled and reinstalled the User Import module a number of times, making sure to "delete files" in the hopes that it would "forget" that I once had a database named "Portal_89814". 

Error: Interactive User Import is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot open database "Portal_89814" requested by the login. The login failed. Login failed for user 'adk456_89814'. ---> System.Data.SqlClient.SqlException: Cannot open database "Portal_89814" requested by the login. The login failed. Login failed for user 'adk456_89814'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at.....

HI Andi, that's strange. Was there any error during the re-installation of IUI? Also, when are you getting this error? On step 1 of the "import process" where you choose a new CSV file to load or where? -- David

Hi David!

Below is the error i get on module installation (mentioned in another thread with DNN 5.1 version) End job reports the installation is successful message, however.

The error I pasted in the earlier message appears on the page I have inserted the module where the "import" section of the module should be. The export section appears to have no difficulties. I don't have an opportunity to do anything with the import - i see the error when i first get to the page.
-----------------------------
Error on installation:
Info Start Sql execution: 01.00.00.SqlDataProvider file
Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@CreatedByUserID', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- ADD DNN SCHEDULER ITEM execute AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',45,'m',60,'m',250,'',0,1,'DataSprings_UserImport', NULL
Info End Sql execution: 01.00.00.SqlDataProvider file

HI, can you go to Host / Schedule and see if you can see the UserImport scheduler installed there? If not:

you can create the Interactive User Import process manually. Go to Host / Schedule and create a new schedule. Then type in the following:

Full Class Name and Assembly: DataSprings.DNN.Modules.UserImport.UserImportProcess,DataSprings.DNN.Modules.UserImport

Object Dependencies: DataSprings_UserImport

Make sure to check "Schedule Enabled". For everything else, you can choose (time lapse,retry freq,schedule history) whatever you want. See if this fixes the issue. -- David

I did that after reading the original post. This problem does not appear to be related to the scheduling issue.

HI Andi, very strange indeed. Can you do me a favor? Un-install the IUI again. After un-installing, to be on the safe side, also go to HOST / SQL and type in:

drop table datasprings_userimport

make sure to check the "Execute as script" box.

Also go to Host / Schedule and verify the UserImport scheduler is also deleted.
And then re-install IUI again and see if it recognizes the new database, etc. -- David

Well, we fixed the wrong database problem . . . Totally recreated the site. I was getting antsy with so many different errors since switching to 5.1 anyway.

So we're up and running and the UI is installed, BUT!

I get this error in the log after it manages to import some of the records . . . how can that be?

AssemblyVersion: 5.1.0
PortalID: 0
PortalName: Adirondack Mountain Club
UserID: 1
UserName: host
ActiveTabID: 70
ActiveTabName: Import
RawURL: /portal/Tools/Import/tabid/70/windex/2/wid/1/Default.aspx
AbsoluteURL: /portal/Default.aspx
AbsoluteURLReferrer: http://adk.org/portal/Tools/Import/...fault.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.12) Gecko/2009070611 Firefox/3.0.12 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 1443eb98-5274-4e56-89fc-f681e2dc8ba2
InnerException: 'Sheet1$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling
StackTrace:
Message: System.Data.OleDb.OleDbException: 'Sheet1$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at DataSprings.DNN.Modules.UserImport.Business.UserImportController.ImportFile(String FileName, Byte[] FileContent, String SheetName)
Source:
Server Name: DEDI253

HI, can you make sure the extension on the file is: csv
thanks. -- David