Filling CI's DB from external sources

Moderator: crythias

Post Reply
gatoman
Znuny newbie
Posts: 1
Joined: 05 Dec 2014, 21:51
Znuny Version: OTRS V4
Real Name: Eduardo Carranza
Company: helpro

Filling CI's DB from external sources

Post by gatoman »

I've read in some early posts that the only way for doing this is by the use of the "import csv files " facility.
I wonder if there is any way, in version 4, to enter this data using any language or some conectors because I wish I have some control mechanism for data integrity and even return a notification respect of any failure.
Do you think it will be possible for ITSM's v4 have this feature?
thank you in advance for your response.
Wolfgangf
Znuny ninja
Posts: 1029
Joined: 13 Apr 2009, 12:26
Znuny Version: 6.0.13
Real Name: Wolfgang Fürtbauer
Company: PBS Logitek GmbH
Location: Pinsdorf

Re: Filling CI's DB from external sources

Post by Wolfgangf »

For the time being, you could deal the well know mechanisms
- Import CSV files into via the Import / Export Module
e.g. put a command in your cron tab like

Code: Select all

/opt/otrs/bin/otrs.ImportExport.pl -n 0000<anumber> -a import -i <somefile>.csv
- check the output (log) for output (success, error, information)

Code: Select all

Read File <somefile>.csv.
Import in process...

Import of 55 ITSMConfigItem records: 0 failed, 55 succeeded
Import of 55 ITSMConfigItem records: 55 Skipped
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
Post Reply