[SOLVED] How to export translated notifications from DB

[alfar]

Hi,

I need to export from DB all translated email, notifications, escalations ... etc.
Is there any simple way to do it, like saving the Sys configuration to file ???

Need some help in this.

Best regards
Tom

[crythias]

How would you want that formatted?

[alfar]

I need to export it from existing database, then i will install OTRS from scratch, and import those translations.
So i need some kind of mysql, perl script to eksport and import translations.

Charset = UTF-8

[crythias]

I don't know what you consider a "translation", ... and I don't know what difference a fresh install of OTRS is going to do, but you can mysqldump and mysql import the sql again.

[alfar]

I have translated from english to polish all email content of notifications, escalations = translations. If there was a translation i have customized it for my OTRS installation.

Let's just say that i have customized my OTRS and i need to export this changes to a file, script, sth which will give my the ability to import it to another OTRS instance.

Why do i need to export it, and why i cannot use mysqldump ??
Because there is an error in my otrs config, which i cannot eliminate http://forums.otrs.org/viewtopic.php?f=81&t=9494, that's why i have installed it from scratch. I have already tried to restore the database and i did got the same error

[crythias]

What version are you installing from scratch?

[alfar]

3.0.8 from tar.gz file.

[crythias]

You'll need to convert your data from 2.4, (there's a readme for that) and copy the translation files, though I can't guarantee (don't know for certain) that the language files are drop-in replacements.

[alfar]

Hmm, maybe a should tell You the whole story

First OTRS 2.4.9 on windows
Backup of database and config file (through eksport settings option)

Install on Ubuntu 2.4.9
Restore database and config file - it was working fine, until
Upgrade to 3.0.6 then i had problems with The ERROR NEED MODULE thing...
I did the upgrade with manual, and it worked fine exept updating information about Agents (i get The ERROR NEED MODULE)

That's why i need to install from scratch, but i don't know why should i do the upgrade from 2.4 again ??

You said "copy the translation files" where can i find them ??

[crythias]

assuming you translated through Kernel/Language/....

[alfar]

I have translated through GUI - Administration - Agent Notifications - there i have translated all
pl::Agent::AddNote
pl::Agent::Escalation
...

I cant see it in file pl.pm

[jojo]

Translations for Notifications are stored in the database.

[alfar]

Is there any way to export those translations and import to new instance of otrs ??

BTW there should be an option to export all translations in one file and import from file.

[jojo]

Just read the MySQL Admin Book. To export this table (or contents from it) and import it via SQL is simple

[alfar]

Thank's for help.
I installed phpmyadmin where the otrs database is installed and exported to SQL file 4 tables: signature, salutation, notification, auto_response then i used import function in phpmyadmin to another database.