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.
import duplicates configuration items
Moderator: crythias
-
- 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
OTRS 3.0, OTRS-ITSM, Suse Linux 11.3
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: import duplicates configuration items
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
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
-
- 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
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
-
- 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
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
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
-
- 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
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.
Re: import duplicates configuration items
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com