ITSM CMDB Import Issues

Moderator: crythias

Locked
ceaston
Znuny newbie
Posts: 4
Joined: 06 May 2020, 20:29
Znuny Version: 6.0.24
Real Name: Casey Easton

ITSM CMDB Import Issues

Post by ceaston »

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
root
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

Post by root »

ceaston wrote: 06 May 2020, 21:02
How am i supposed to define these on the csv import?
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 ?
ceaston
Znuny newbie
Posts: 4
Joined: 06 May 2020, 20:29
Znuny Version: 6.0.24
Real Name: Casey Easton

Re: ITSM CMDB Import Issues

Post by ceaston »

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?
root
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

Post by root »

Hi,

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 ?
ceaston
Znuny newbie
Posts: 4
Joined: 06 May 2020, 20:29
Znuny Version: 6.0.24
Real Name: Casey Easton

Re: ITSM CMDB Import Issues

Post by ceaston »

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.
Locked