import duplicates configuration items

Moderator: crythias

Post Reply
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 duplicates configuration items

Post by sdombora »

I have created an import/export configuration without CI NUMBER, but I have AssetTag which is uique.
I have checked the AssetTag Key as Identifier.
I have exported the configuration items -> new file. Then kept the lines I need.
I have imported back the file, and I noticed that the imported configuration items are duplicated insted of update.

How to make import/export update the config items lines instead of duplicating them?

I also have a command line log like following:
-----------------------------------------------------
/opt/otrs/bin/otrs.ImportExport.pl -n 000003 -a import -i CMDB_EXPORT_4.csv
Read File CMDB_EXPORT_4.csv.
Import in process...
ERROR: OTRS-ImportExport-10 Perl: 5.14.2 OS: linux Time: Thu Jan 23 15:13:00 2014

Message: ImportError at line 3, ErrorCode: 2012 'EOF - End of data in parsing input stream'

Traceback (17034):
Module: Kernel::System::ImportExport::FormatBackend::CSV::ImportDataGet (v1.29) Line: 340
Module: Kernel::System::ImportExport::Import (v1.44) Line: 2188
Module: /opt/otrs/bin/otrs.ImportExport.pl (v1.4) Line: 128


Import of 1 ITSMConfigItem records: 0 failed, 1 succeeded
Import of 1 ITSMConfigItem records: 1 Created

-----------------------------------------------------
ImportError at line 3, - I have 2 lines in the file, I also checked with 3 lines then it shifts forward it says line 4.

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

Re: import duplicates configuration items

Post by crythias »

I believe you have a record termination issue or are applying a different quantity of columns than are expected.
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 duplicates configuration items

Post by sdombora »

I managed to soleve the duplicates issues, but the error still pops up when the script eaches end of the input files
OTRS 3.0, OTRS-ITSM, Suse Linux 11.3
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: import duplicates configuration items

Post by nedmaj »

I got the same problem here. ImportExport is duplicating some files.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
rkrisher
Znuny newbie
Posts: 2
Joined: 23 Sep 2015, 17:47
Znuny Version: 3.0.22
Real Name: Robin
Company: Krisher

Re: import duplicates configuration items

Post by rkrisher »

To anyone out searching for the answer I finally figured something out at least. The identifier on the import can not start with a number 0. You can not use the CONFIGITEM# as your identifier. once I created a uniqueID and started it with the Alphabet, I was able to get the record to update instead of creating a new one.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: import duplicates configuration items

Post by jojo »

ConfigItem# works like a charm on my systems
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Post Reply