Hey -- upgrading from 6.5 to 7.5.

Clearly all the URLs have changed.

My problem is that I'm trying to put in place 301 directs to the new canonical names to preserve the thousands of links in Google that I have to my forums.

The redirect scripts that come with the importer are unfortunately NOT canonical. They tack "/site_id/1" to the end of every post URL, which is different than the URLs produced within ubbthreads itself.

I've already dealt with enough nightmares and accidental penalties as a result of duplicate content and Google before in years past -- I don't want to start off showing Google thousands of URLs that aren't canonical and will quickly become duplicated by the non "/site_id/1" versions.

Does anyone know of a method outside of including 40,000 redirects in an .htaccess file that will allow me to redirect all my old showflat/showthreaded posts to the new CANONICAL URLs of format
"/newforum/ubbthreads.php/topics/545732"

Thanks

Just a follow up.. I think I've solved this problem.

I've modified the original template to query the new import table, look up the new post number, and then redirect 301 directly to the new URL, bypassing the site_id=1 thing.

You were quicker than me. By the time I figured out what you were trying to do, you got it figured out. Sounds like a nice solution for what you were looking for.