Re: [otrs] export with SQL querie(s)

Hello, I want just (into OTRS Admin > SQL Box) to have a SQL query to export in CSV or Excel all tickets with, ticket by ticket all « Articles » (by No.). Best, S

Le 14 déc. 2016 à 10:13, Susan Dittmar a écrit :

Hi Stéphane!

Am 14.12.2016 um 09:13 schrieb Stéphane Pouyllau:

...

I think is a « classic » question but I want to export all items of all tickets to CSV file. What’s the SQL query ? Is there a guideline or an OTRS SQL queries « almanac » ?

I vaguely remember CSV export capabilities of SQL, though I'm not sure whether those commands are SQL standard or brand-specific extensions. Before I go on a hunt for those, some questions.

What database backend (which database server software) do you use?

Do you need to group information by ticket?

What do you want to archieve? Do you want to have some kind of human-readable backup? In that case, is CSV necessary or would another human-readable format work for you?

Susan --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

-- Stéphane POUYLLAU Ingénieur de recherche CNRS Directeur technique d'Huma-Num http://www.huma-num.fr http://humanum.hypotheses.org Twitter : http://twitter.com/spouyllau Blog perso : http://blog.stephanepouyllau.org