[SOLVED] Building an OTRS Sample Database

[vmoreno]

Hello folks,

I work for a company that is on the process of choosing a ticket system for a big outsourcing project. Our client has some contract demands, which includes the adoption of a ticket system capable of generating it´s own reports. Also, they have some layouts already defined.

We found OTRS and we like the functionalities of the software. One thing remaining is to test it for reports and try (if we can) generate reports from their layouts. We need something like 3 or 2 months of sample data.

I need a (fast) way of generating this amount of data inside OTRS. Trying to insert data from dbms didn´t workout really well. Maybe i dont have yet the knowledge needed of the database model, i couldn´t fool otrs ticket dates. I found another way by changing the OS system date, but that gives me a lot of work, since i have to create tickets and then change the system date.

So, asking the experts here. Wich technique would you choose to build a sample database and how to do it.

I am using OTRS appliance 1.0.6 with ITSM.

[crythias]

look at otrs/bin/otrs.FillDB.pl

[vmoreno]

Really helpfull, thanks.