Re: export with SQL querie(s)
Stéphane Pouyllau <[email protected]>
| Newsgroups | gmane.comp.otrs.user |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> 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 --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs