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
[SOLVED]FAQ articles migration from OTRS 3 to 5
Moderator: crythias
-
- Znuny newbie
- Posts: 90
- Joined: 11 Feb 2014, 17:24
- Znuny Version: 3.3.2
[SOLVED]FAQ articles migration from OTRS 3 to 5
Last edited by ThomasPL10 on 13 Feb 2017, 13:12, edited 1 time in total.
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: FAQ articles migration from OTRS 3 to 5
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.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny newbie
- Posts: 90
- Joined: 11 Feb 2014, 17:24
- Znuny Version: 3.3.2
Re: FAQ articles migration from OTRS 3 to 5
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
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
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: [SOLVED]FAQ articles migration from OTRS 3 to 5
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.
Upgrades may include database changes or code execution where data is transformed. If you dump and restore database tables you may loose some information.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny newbie
- Posts: 90
- Joined: 11 Feb 2014, 17:24
- Znuny Version: 3.3.2
Re: [SOLVED]FAQ articles migration from OTRS 3 to 5
Oh. I was not aware of simple upgrade option. That's good to know for future. Thank you for this info.