Anyone know how to do either or both of these?
Cheers,
Rich
Export tickets to Excel and Quickbooks
Moderator: crythias
-
- Znuny newbie
- Posts: 18
- Joined: 21 Oct 2011, 05:54
- Znuny Version: 2.4
- Real Name: Richard
- Company: CBX
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Export tickets to Excel and Quickbooks
You can use the search function to save as csv.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Export tickets to Excel and Quickbooks
Is it possible to export also a tickets text of the message?
OTRS 3.0.4, FreeBSD, using not for IT but as a service desk only to effectively process customer's requests.
Re: Export tickets to Excel and Quickbooks
Please could you tell how to export to csv or xls a ticket's text we need to export all tickets in order to read them to analyze often questions?
OTRS 3.0.4, FreeBSD, using not for IT but as a service desk only to effectively process customer's requests.
Re: Export tickets to Excel and Quickbooks
you can print article text in CSV output of the search (you need to change in sysconfig setting for the search first) .
Or, better use SQL
Or, better use SQL
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Export tickets to Excel and Quickbooks
How? What do i need to change in sysconfig for export the whole tickets with the full text?jojo wrote:you can print article text in CSV output of the search (you need to change in sysconfig setting for the search first) .
Or, better use SQL
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Export tickets to Excel and Quickbooks
How would that work for you? The ticket may be 100+ articles long. Do you want attachments, too? How do you expect to fit that to a cell?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask