Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2006-11-16 13:41:20

Ray
Member
Registered: 2004-03-02
Posts: 150

Managing Authors...

Scenario.
Online magazine. Many articles, many different writers. Think alistapart style mag. Published bi-monthly with 14 articles for each issue.

All the old content is now sitting in a fresh textpattern install. We now have to go through each article by hand to clean up old code, strip out unnecessary tags, fix image paths, make sure headings are correct etc. We only want to lay our hands on these articles once. There’s a ton of work here… many articles!

We’re now faced with finding a solution for “What do we do with the authors? Specifically the authors of the older articles… the archives.”

If we want to provide a drill down mechanism for readers to search by author then we have to get all these older authors in the db. In order to do this means a couple extra, heavy lifting, steps. We’ll have to manually add each of those 200+ older writers as an author with basic privs in the admin panel. This isn’t a problem but when it’s multiplied by several hundred authors across several thousand articles it becomes a major TIME issue.

There’s no way around it. If we want the authors name associated with their article/s then we have to and add all those authors as staff writers (or whatever) and then go back and change the author name later. Bah! Just thinking about it depresses me.

So… how do we get a bunch of authors of old content into the DB without busting our backs and adding a month of Sundays worth of work?

Offline

#2 2006-11-16 14:46:47

wet
Developer Emeritus
From: Schoerfling, Austria
Registered: 2005-06-06
Posts: 3,323
Website Mastodon

Re: Managing Authors...

A proper SQL statement populating the txp_users table from a textfile could reduce your workload significantly.

Offline

Board footer

Powered by FluxBB