Wow! Thank you. We will give it a try.
----- Original Message -----
From: "Wayne Chung (-,RAL,ESC)"
From your post, it seem like you want to directly import the FAQ from 2.0.6 to a new installation of otrs 2.4.3. Although, I've not tried it the following should work assuming you're using linux. Do make backups and try on a test server first :)
1) Otrs 2.1.X no longer includes the FAQ module as standard but a separate module. However, the database upgrade script from 2.0.X to 2.1.X still alter some of the faq_* tables. Download otrs.2.1.8.tar.gz and extract it. Next run the DBUpdate script to upgrade the database to 2.1. cat /opt/otrs/scripts/DBUpdate-to-2.1.mysql.sql | mysql -p -f -u root otrs 2) Once the database is updated to 2.1, mysqldump all the faq_* tables from the database (There should be 8 faq_* tables): mysqldump -u root -p otrs faq_attachment > faq_attachment.sql mysqldump -u root -p otrs faq_category > faq_category.sql etc 3) Next check the charset of your dumped sql files. In Otrs 2.4.3 your database will most likely be using utf8. If you see DEFAULT CHARSET=latin1 in the faq_*.sql then you will need to convert each of the sql files: /opt/otrs/scripts/tools/charset-convert.pl -s latin1 -d utf8 -f faq_attachment.sql /opt/otrs/scripts/tools/charset-convert.pl -s latin1 -d utf8 -f faq_category.sql etc After converting the files, do a string replacement on each sql file to change the charset to utf8: sed -i 's/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8/' faq_attachment.sql sed -i 's/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8/' faq_category.sql etc 4) Next import the sql files to otrs 2.4.3 (This assumes you don't already have the faq module already installed on 2.4.3 else it will delete all your existing faq in 2.4.3) mysql -u root -p otrs < faq_attachment.sql mysql -u root -p otrs < faq_attachment.sql etc. 5) There is a known bug when upgrading from 2.0.x to 2.3.x with the FAQ module (http://bugs.otrs.org/show_bug.cgi?id=3626). You will need to fix this by using the 2 queries: mysql -u root -p mysql>ALTER TABLE faq_item ADD approved SMALLINT default '1' NOT NULL AFTER category_id; mysql>ALTER TABLE faq_attachment ADD inlineattachment SMALLINT default '0' NOT NULL AFTER content; 6) Next, install the faq module: Go to [Admin]->[Package Manager]. Under Online Repository click Update. Click Install for the FAQ package. 7) Once the faq module is installed, Go to [Admin]->[Users<->Groups] and set permissions for users in the faq and faq_admin groups. Logout of otrs and and log back in as a user with faq_admin permission. Click FAQ button, then Category. For each FAQ category, you will need to add in a comment and select the groups you want permission to view the category(use shift to select multiple groups). Once that is done, you should have the faq working in 2.4.3. Regards, Wayne Chung -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Calderwood Brigitte Sent: 10 September 2009 16:21 To: otrs@otrs.org Cc: Schoenberger Mark Subject: [otrs] Importing/Exporting FAQs Hello, Has anyone figured out how to import FAQs from an older version of OTRS, v:2.0.6 into OTRS v:2.4.3?? Any help would be appreciated. Thanks! -- Calderwood HDI Certified Support Center Manager ______________________________ Helpdesk Manager LESD Technology Department calderwood@lesd.k12.az.us 623.547.1509 http://www.lesd.k12.az.us/webpages/itdepartment/ "It has become appallingly obvious that our technology has exceeded our humanity." Albert Einstein "We commit to deliver 'best-in-class' technology solutions and support to attain excellence of the District Community by being a customer-focused, highly skilled, and agile Technology Department." --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ -- Scanned by iCritical. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ -- Brigitte Calderwood HDI Certified Support Center Manager ______________________________ Helpdesk Manager LESD Technology Department calderwood@lesd.k12.az.us 623.547.1509 http://www.lesd.k12.az.us/webpages/itdepartment/ "It has become appallingly obvious that our technology has exceeded our humanity." Albert Einstein "We commit to deliver 'best-in-class' technology solutions and support to attain excellence of the District Community by being a customer-focused, highly skilled, and agile Technology Department."