import users

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This thread is closed to new posts. You must sign in to post in the forums.

10/7/2015 3:50:00 AM

mari

Total Posts 47

View Posts

import users

Hi!

I ought to import arount 3000 users in mojoportal MSSQL DB. I dowloaded the DB locally, then I imported the fields that I had (name, email, password, datecreated, firstname and lastname) in mp_users table. I then filled the fields that were empy such as SiteID, SiteGuid, and others with no problems. In order to fill the UserGuid field I used the SQL function NewID(). I uploaded the SQL DB again on my Azure installation, and I ca list all the Users in MemberList.aspx but when I press Profile the Setup starts and I got the following error:

Esecuzione script mojoportal-core - 2.2.1.9 - 00:00:00.2358639
System.Data.SqlClient.SqlException (0x80131904): Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) ClientConnectionId:1b240daa-f743-4a82-ac3e-41064533ed6c Error Number:15248,State:1,Class:11 - 00:00:00.3921503

Any suggestion?

Thanks in advance

Mari

10/7/2015 3:29:23 PM

mari

Total Posts 47

View Posts

Re: import users

Hi!

I found a solution. Perhaps it is a workaround, but it works!

I restored locally a backup of the original DB. I imported in a new table the records with the few fields I had. Then I appended the records to dbo.mp_users. created the records in dbo.mp_useroles and dbo.mp_userlocations. Only after that I deleted the new table and transferred the DB on Azure, where I completed the missing fields.

Now it works.

Mari

You must sign in to post in the forums. This thread is closed to new posts.