Znuny Open Source Ticketsystem

Hey, Take a look into the database. If the attachments are stored in DB (default), you should be able to get everything you need with a couple of SELECT statements. Start with otrs.ticket and work your way into the connected tables. — Emin Thank you! I'll see what I can find via digging. Is there a...

So you should think about the requirements first and get used to the terms used in OTRS. You'd like to get all the *ticket*s from your OTRS. A ticket is just a "container" for the communication about one topic. Think about it like this thread. You started the thread "Exporting Ticket...

Hi, Most of the time it is a script getting data out of system A and insert into system B. It always depends on the API and requirements of which data is needed. - Roy Yeah, that's what confuses me. I'm not too sure how to go about everything. I just know I'm going to need to get all our existing t...

What kind of custom development? Were you ever able to actually do it? I'm not even sure how to start. I figured it'd be more difficult than just saving tickets as csv files.

Hello, We're looking to migrate away from OTRS. Is there a way I can export all our existing tickets to a .csv file to use for importing into a new system? We have a lot of tickets. It seems we've been using OTRS since around 2010. I would also appreciate any advice if anyone else has ever gone thro...

Nevermind, I figured it out How did you solvedd it? - Roy I'd like to preface this by saying I am new when it comes to actually configuring OTRS and linux in general... I didn't have the stats configured properly. I was using the pre-set ones and didn't notice they weren't configured to actually qu...

Nevermind, I figured it out

Hi, I'm breaking this into it's own post. I recently figured out how to access my Stats tab in OTRS thanks to some users here. I'm a newbie, forgive me. Now, the issue is when I try to run any of the pre-made stats in OTRS, I get this error "Backend ERROR: OTRS-CGI-10 Perl: 5.26.1 OS: linux Tim...

That depends on what you've changed. Did you (or the persons prior to you) delete all statics by hand? It could be the impact of an corrupt update. It could also indicate a permission problem. It's hard to guess. — Emin To be honest with you, I am not sure what the previous employees did. They didn...

yes, thats what statistics are for Thank you. Apparently the team members that came before my manager and I somehow found a way to add Reports, but it was lost during upgrades. Anyway, I'm getting these errors now when trying to "run" any of the pre-made statistic reports in OTRS "Ba...

Reports is a function which was developed for the Business Solution and never had been in the Community Edition. Only statistics was and is available. Odd. My manager swears he used Reports last year and we've only ever used Community edition. I wasn't at my company at the time so I can't confirm. ...

did you read and understand what ZZZ and myself wrote? Yes, and I apologize if I made it sound like I'm missing your point. I think you were both under the impression I couldn't see the Reports tab (which includes Reports and Statistics) at all in navigation. My original issue was although I could ...

You're talking about statistics which is and always was part of the base code. That looks like a misconfiguration and could be caused by a wrongly performed update. That would also explain why you don't see the menu bar in the navigation. Do you have RW permissions on stats? You should at least see...

[quote=jojo post_id=169119 time=1593115935 user_id=354] Reports (as part of the Reports tab) is only available in the commercial version. Statistics, which is also part can be used in the CE based on your permissions [/quote] Are you sure? We've always used the CE version and we used the Reports fun...

Hey, Nope, it's still available. Check your permissions. — Emin I'm really hoping the case is I'm just missing something like permissions. I can see the "Reports" tab in my OTRS 6.0.28, but when I navigate to it and click on "Reports", I get a popup that says "This feature ...

Hey, Nope, it's still available. Check your permissions. — Emin I'm really hoping the case is I'm just missing something like permissions. I can see the "Reports" tab in my OTRS 6.0.28, but when I navigate to it and click on "Reports", I get a popup that says "This feature ...

Hello. We use OTRS community edition. Currently we are on 6.0.28. We need to use the reports/statistics tab, but I noticed today when navigating to it that is part of the Business Solutions. Does anyone know if this functionality was lost between OTRS 5 and 6, or if it was lost in a minor upgrade in...