Import data from CSV file fails

Moderator: crythias

Locked
artur4
Znuny newbie
Posts: 8
Joined: 21 Feb 2011, 17:19
Znuny Version: 3.0.5

Import data from CSV file fails

Post by artur4 »

Hi,

I'm new in OTRS and I'm trying to import data from CSV file (OCS inventory) via web interface. For this purpose I've updated fields on the template according to the CSV source. However the following error message appears in the log:

Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Can't import entity 12: Error when adding the new config item version.
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Need DeplStateID!
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Can't import entity 11: Error when adding the new config item version.
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Need DeplStateID!
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Can't import entity 10: Error when adding the new config item version.
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Need DeplStateID!
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Can't import entity 9: Error when adding the new config item version.
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Need DeplStateID!
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Can't import entity 8: Error when adding the new config item version.
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Need DeplStateID!
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Can't import entity 7: Error when adding the new config item version.
Mon Feb 21 09:29:23 2011 error OTRS-CGI-10 Need DeplStateID!



Any help will be very appreciated.

Thank you very much,
Art
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Import data from CSV file fails

Post by jojo »

There is no or a mispelled Deployment State in your import file or in the import definition
"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
artur4
Znuny newbie
Posts: 8
Joined: 21 Feb 2011, 17:19
Znuny Version: 3.0.5

Re: Import data from CSV file fails

Post by artur4 »

Thank you very much. It worked.
Another question. Is there any way to prevent duplicated entries, based on some criteria, like name or serial number?
If an item exists, it should update existing entry rather then add another one.

Thanks you,
Locked