Has anyone imported basic mysql tables into IPS (no CMS)

[The Old Man]

I realise the converter works with full forums and CMS's like Wordpress, but I was wondering if anyone has used it or has a suggestion (RSS import, manual copy/paste or MySQL table import, manual front-end recreation) for an old-school situation where a website has a simple news article MySQL table and HTML articles were inserted/pasted directly via phpMyAdmin, pulled from a mysql table into the pages of the front end website, used in RSS feeds etc.

This is the actual InnoDB table used for news articles, it has about 450 rows:

Many thanks.

Edited September 21, 2020 by The Old Man

[CoffeeCake]

What you're looking for is an ETL (extract-transform-load) tool. You can either create a custom one in php with the IPS converters as a starting point, or do the work in a third party tool that does ETL. You're wanting to extract the data out of your custom table, transform it into the format that IPS expects, and then write to the IPS database.

Please do this in a testing or development environment and make backups of your backups before backing up your backup before proceeding 🙂

[The Old Man]

Thanks Paul, yes I've done it (same situation) into Wordpress before, but not IPS.

There's also about 130 non-news articles, but similarly structure tables.

Edited September 18, 2020 by The Old Man

[bfarber]

Typically I'd recommend writing a new converter routine. We do this routinely for enterprise clients converting to us when they have a custom (or previously unsupported) system.