[SOLVED]FAQ articles migration from OTRS 3 to 5

[ThomasPL10]

Hello all

Curently I'm preparing for migration of my OTRS from version 3.3.9 to the OTRS 5.

However after upgrade I will have to reinstall FAQ package and it will clear my all FAQ articles. Is there some friedly way to export/import the FAQ articles?

Thank you in advance for any hints.

Thomas

[reneeb]

As long as you do not uninstall the FAQ addon and you upgrade your FAQ addon after the OTRS upgrade, the FAQ articles should still be available.

[ThomasPL10]

I had to uninstall the FAQ package after upgrade from OTRS 3.3.9 to OTRS 5 according to information that current version of FAQ package is not compatible with OTRS 5. However here is how I resolved this case.

1. Took ONLY DATA dump (no structure) of faq module tables from SQL DB(tables with faq_...) from backup of my OTRS 3
2. In OTRS5 in faq_item table I removed new column I removed "content_type" column which was not present in OTRS 3 FAQ
3. I uploaded the data from my dump taken before (looking after foreign key. So form most independent table to most dependent)
4. I added back "content_type" column into to the faq_item table with its default value "text/html" for each row.
5. Works fine

[reneeb]

Generally you should *not* uninstall addons. If FAQ 3.3.x is incompatible with OTRS, upgrade the addon. You can do it either via web gui (Admin -> PackageManager -> select repository of free OTRS addons, update directory -> upgrade addon) or via console (Download new version of addon -> perl bin/otrs.Console.pl Maint::Package::Upgrade Addon-x.x.x.opm).

Upgrades may include database changes or code execution where data is transformed. If you dump and restore database tables you may loose some information.

[ThomasPL10]

Oh. I was not aware of simple upgrade option. That's good to know for future. Thank you for this info.