Hello,

I'm working on a migration project which requires me to move 800 blogs and 40,000 entries from Movable Type to Wordpress. I need a way to retrieve all the permalinks generated by Movable Type in order for me to make link redirections. The end result I am expecting should be a table like this.

mt_entry_id | mt_entry_link

note: mt_entry_link can be a many to one relationship to mt_entry_id

I tried using the following MT template to generate the code.
<MTBlog>
<MTEntries>
<$MTEntryID$> | <$MTEntryLink$>
</MTEntries>
</MTBlog>

This approach wasn't successful because it didn't return all the entries.

I wonder if there's any alternative ways to do it. It'd be nice if I can do this through the database.