Mass Add Items into Config Items ITSM 3 Beta 1 OTRS 3.0.5

Moderator: crythias

Locked
n0manarmy
Znuny newbie
Posts: 14
Joined: 08 Jun 2010, 21:53
Znuny Version: 2.47
Location: Baltimore, MD
Contact:

Mass Add Items into Config Items ITSM 3 Beta 1 OTRS 3.0.5

Post by n0manarmy »

Anyone have any suggestions for adding multiple items in to the Config Item section of ITSM 3 Beta 1? I was hoping I could export our inventory, which we have in a mysql database, and then massage it to import back in to OTRS 3.0.5 ITSM 3 Beta 1. Unfortunately it appears that ITSM stores the information as a blob?

Has anyone else had luck with this? We have over a 1000 items that I'd prefer not to enter by hand.
n0manarmy
Znuny newbie
Posts: 14
Joined: 08 Jun 2010, 21:53
Znuny Version: 2.47
Location: Baltimore, MD
Contact:

Re: Mass Add Items into Config Items ITSM 3 Beta 1 OTRS 3.0.

Post by n0manarmy »

I'm guessing not much help is coming to this thread :)

Anyone have any idea where the information for Config Items is stored in the database? If its stored in ConfigItems_Definitions, any thoughts on how to modify the blob?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Mass Add Items into Config Items ITSM 3 Beta 1 OTRS 3.0.

Post by crythias »

I haven't tried it, but there is an ImportExport package associated with ITSM.
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
n0manarmy
Znuny newbie
Posts: 14
Joined: 08 Jun 2010, 21:53
Znuny Version: 2.47
Location: Baltimore, MD
Contact:

Re: Mass Add Items into Config Items ITSM 3 Beta 1 OTRS 3.0.

Post by n0manarmy »

crythias wrote:I haven't tried it, but there is an ImportExport package associated with ITSM.
Ooo! That might work! I'll take a look.
n0manarmy
Znuny newbie
Posts: 14
Joined: 08 Jun 2010, 21:53
Znuny Version: 2.47
Location: Baltimore, MD
Contact:

Re: Mass Add Items into Config Items ITSM 3 Beta 1 OTRS 3.0.

Post by n0manarmy »

crythias wrote:I haven't tried it, but there is an ImportExport package associated with ITSM.
Crythias, you rock. I'm pretty sure I can work with this.
Locked