• I’ve just imported a batch of entries from Movabletype. Some of them were assigned to a newly created author #2, the majority was assigned under newly created author #3. I’d rather switch them all to author number one (site admin). Is there a way to change their author en mass, or do I have to do it manualy, one entry at a time, in the database? I’ve done the manual way before, and I needn’t say it’s highly boring and inefficient.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You can run one big UPDATE query
    UPDATE wp_posts set post_author = ‘1’ where post_author = ‘3’;
    for example.
    the import-mt script has the functionality to “map” authors to solve this problem. Wasn’t that useful at all?

    Thread Starter Johanka

    (@johanka)

    No, it didn’t work for me. I’ve imported MT entries three times (on three different blogs) and every time it did exactly what I described above.

    Thread Starter Johanka

    (@johanka)

    The UPDATE query did the job for me, thanks! 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Mass edit entry author?’ is closed to new replies.