Hey,
I am setting up ITSM for inventory management with my company. I am trying to import the old inventory list as a CSV file through the import/export manager. I create a template using
Object: ITSMConfigItem
Format:CSV
valid
Used column separator as comma with UTF-8 Charset
Then added my columns in order for mapping elements and used number as my Identifier.
It keeps failing with errors such as "General catalog lookup of'Dell' failed!" "Can't import entity 1: Could not prepare the input!"
or something like Invalid input.
The failures seem to be on items that are being pulled from a list in the general catalog.
How am i supposed to define these on the csv import? does anyone have examples or walk through on importing ?
Thanks
ITSM CMDB Import Issues
Moderator: crythias
-
- Administrator
- Posts: 4251
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: ITSM CMDB Import Issues
Hi,
You have to add such value prior the import to the GeneralCatalog.
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 4
- Joined: 06 May 2020, 20:29
- Znuny Version: 6.0.24
- Real Name: Casey Easton
Re: ITSM CMDB Import Issues
Hi Roy,
I already have added the appropriate class needed to the general catalog. Then I also added each item to each class as defined. Then I try to import, i set each mapped item to the appropriate column of my excel sheet then i export to csv.
It does not want to upload, it seems as if it is not finding it. Is there a special way to call out the item from the list in general catalog?
I already have added the appropriate class needed to the general catalog. Then I also added each item to each class as defined. Then I try to import, i set each mapped item to the appropriate column of my excel sheet then i export to csv.
It does not want to upload, it seems as if it is not finding it. Is there a special way to call out the item from the list in general catalog?
-
- Administrator
- Posts: 4251
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: ITSM CMDB Import Issues
Hi,
The easiest way is to show us your
- CI class definition and
- the GeneralCatalog classes which are used in the class
- Roy
The easiest way is to show us your
- CI class definition and
- the GeneralCatalog classes which are used in the class
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 4
- Joined: 06 May 2020, 20:29
- Znuny Version: 6.0.24
- Real Name: Casey Easton
Re: ITSM CMDB Import Issues
Hey so sorry,
Thanks for help I figured it out, I had a field in mapping so it through everything off by 1. I deleted that mapping element now it is all lined up.
Thanks for help I figured it out, I had a field in mapping so it through everything off by 1. I deleted that mapping element now it is all lined up.