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.
Filling CI's DB from external sources
Moderator: crythias
-
- 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
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
- check the output (log) for output (success, error, information)
- 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
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
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