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.
Mass Add Items into Config Items ITSM 3 Beta 1 OTRS 3.0.5
Moderator: crythias
-
- 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.
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?

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?
-
- 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.
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
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: 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.
Ooo! That might work! I'll take a look.crythias wrote:I haven't tried it, but there is an ImportExport package associated with ITSM.
-
- 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.
Crythias, you rock. I'm pretty sure I can work with this.crythias wrote:I haven't tried it, but there is an ImportExport package associated with ITSM.