Hi,
I didn't see anything on the faq of an easy way to do this but here is my
situation:
I would like to import users from another sql database into the mysql
database for one of my wiki sites.
I already have the query that grabs the usernames/password in a txt file
from the sql database, but I'm not sure how to properly insert them into the
wiki db as normal users or sysops. Ideally only a few of these users will
have sysop permissions and the rest will be regular users.
Also when a password is changed in the sql db, I will need to change it in
the wiki db(will have to code the condition that compares passwords of
course). When a user is deactivated in the sql db(another condition I will
have to code to check to see if that user exists in the wiki user table) I
would like to scramble that users password since you can't simply delete a
user. I would also like to automate this process on a nightly basis.
Is this at all possible? We can definitely code this if it is possible since
we have a couple of developers in house.
Thanks in advance for any assistance.
-Isaac
----- Original Message -----
From: "HumanCell .org" <humancell(a)gmail.com>
To: <mediawiki-l(a)Wikimedia.org>
Sent: Thursday, December 08, 2005 3:56 PM
Subject: [Mediawiki-l] importing public databases into mediawiki
I'd like to import a public database into my mediawiki, where each
*row* of the database corresponds to a new article.
Here's a simple example to clarify:
ID Name Height Weight
Row1 fred 150 100
Row2 bill 210 55
After importing this DB I'd have two new articles (title: fred and bill)
- the fred article has an infobox with parameters 150 and 100
- the bill article has an infobox with parameters 210 and 55
My databases have thousands of entries...so an automated approach is
necessary. Has this been done before? Anyone got any ideas?
Thanks.
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l