Import csv file of configuration items from command line

Moderator: crythias

Locked
sdombora
Znuny newbie
Posts: 16
Joined: 01 Jan 2012, 20:32
Znuny Version: 4.0.7
Real Name: Sándor Dombora
Company: Asyst Solutions

Import csv file of configuration items from command line

Post by sdombora »

Hi!

I can import configuration items csv file using the web interface of the system.
My question is ho to do it from command line?
I have searched the documentation and forums but I did not find any refernece I could use!
Can somebody give me a command line for this job?

Best regards
OTRS 3.0, OTRS-ITSM, Suse Linux 11.3
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Import csv file of configuration items from command line

Post by crythias »

I believe there's an importexport script in bin
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
sdombora
Znuny newbie
Posts: 16
Joined: 01 Jan 2012, 20:32
Znuny Version: 4.0.7
Real Name: Sándor Dombora
Company: Asyst Solutions

Re: Import csv file of configuration items from command line

Post by sdombora »

Thank you !

I found the following, which meets my expectations.

$OTRS_HOME/bin/otrs.ImportExport.pl -h
otrs.ImportExport.pl <Revision 1.4> - an import/export tool
Copyright (C) 2001-2013 xxx, http://otrs.org/

usage: otrs.ImportExport.pl -n <TemplateNumber> -a import|export [-i <SourceFile>] [-o <DestinationFile>]

examples:
otrs.ImportExport.pl -n 00004 -a import -i /tmp/import.csv
otrs.ImportExport.pl -n 00004 -a export -o /tmp/export.csv
OTRS 3.0, OTRS-ITSM, Suse Linux 11.3
Locked