Bulk User Imports Tutorial

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
1/17/2012 5:21:50 AM
Gravatar
Total Posts 40

Bulk User Imports Tutorial

I have about 3700 users I need import, and set up as approved, authenticated users. There are some custom profile settings that would also need to be set. I saw a thread about possibly using a CSV file to do this, but I didn't see an example of how to go about it? Also, I've already added about 100 or so by hand, and email addresses are unique to each user, so I'll also want to check if they exist before I import them.

Is there a video or tutorial post on the site that shows the best way to do this?

1/17/2012 5:43:42 AM
Gravatar
Total Posts 18439

Re: Bulk User Imports Tutorial

no we have nothing pre-built nor any guidance for importing data form other sources. People have done it before but the logic will vasry of course depending on the source of data. There are various tools available that can be used to enable querying one data source and inserting it into a table in another data source.

1/17/2012 6:21:42 AM
Gravatar
Total Posts 40

Re: Bulk User Imports Tutorial

Any recommendations for one that works with MySql?

1/17/2012 6:29:30 AM
Gravatar
Total Posts 18439

Re: Bulk User Imports Tutorial

I can tell you that back in 2004 I migrated a site from Rainbow Portal MS SQL to mojoPortal MySql using SqlYog Enterprise version. I was able to make an odbc connection to MS SQL and write a query and insert rows into MySql. The free version of SqlYog did not support this but the Enterprise version was not too expensive. It might also be possible using Aqua Data Studio, I haven't used it in a few years but it supports multiple db platforms.

1/17/2012 8:35:03 AM
Gravatar
Total Posts 533
feet planted firmly on the ground

Re: Bulk User Imports Tutorial

If you have it MS Access is great for this because it can connect to virtually anything, from csv, dbf etc to server databases that have ODBC drivers. I've recently used this to migrate users into a SQL database on Arvixe.

1/17/2012 10:44:53 AM
Gravatar
Total Posts 2210

Re: Bulk User Imports Tutorial

The MySQL Workbench is a very nice tool for administering MySQL and migrating data. Also the Microsoft SQL Server Migration Assistant for MySQL is very helpful.

 

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