On Tue, 13 May 2008 10:45:24 +0800 syareefdol wrote:

1) Before OTRS system use for our company, I'm using OCS-ng which is open source for our inventory and tracking system of equipment. Here the trick; how can I extract all data inside OCS-ng and push it to all in OTRS/ITSM system?? I've been thinking this lately but serious no idea for this moment. It would be great if this can be done which using OTRS system as our core system in company.

This is a question belonging into the "developer" mailing list. We have spent some resources on a similar project, where we decided against using the OCS DB as the direct data provider. We used the GLPI database instead which is much richer, provides comprehensive data access and allows for additional (e.g. accounting) data to be stored with the configuration items. Unfortunately, OTRS::ITSM uses embedded complex perl-style data strucrures (blasphemically called XML by the developer) within single database fields in an absolutely braindead way and in violation of all guidelines of good database design. This means that a simple transformation of view will not do the trick, so we are using a Perl script to do a quick & dirty one-way import of some skeleton parameters of a CI and provide a link to the GLPI web page of the CI in the "description" field of the ConfigItem. Works for us, but is far from being pretty. -- Denis Jedig syneticon networks GbR http://syneticon.net/service/