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@gmail.com To: mediawiki-l@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@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l