Removing Configuration Items that are not in CSV File
Hi List, I'm playing around with OTRS::ITSM ConfigItem Module. Import is working perfectly for a initial Import. Now I want to import regularly from another Database which CIs are available. If a CI is deleted in the "Leading" Database it should be deleted in the OTRS::ITSM DB or shout set to "Inactive" for a minimum. Can anybody give me a hint where to start over? Regards Christian Mit freundlichen Gruessen Christian Mies Consultant Systemmanagement Tel: +49 (661) 103-874 (-333) Fax: +49 (661) 103-17874 (-334) mailto:Christian.Mies@it-novum.com it-novum GmbH . Edelzeller Strasse 44 . 36043 Fulda . http://www.it-novum.com Handelsregister Amtsgericht Fulda, HRB 1934 . Geschaftsfuhrer: Michael Kienle . Sitz der Gesellschaft: Fulda Der Inhalt dieser E-Mail ist vertraulich. Wenn Sie nicht der eigentliche Empfaenger sein sollten, informieren Sie bitte sofort den Absender oder vernichten umgehend diese Mail. Jegliche unerlaubte Vervielfaeltigung oder Weiterleitung dieser Mail ist strengstens verboten. This e-mail may contain confidential and/or priviledged information. If you are not the intended recepient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of material in this e-mail is strictly forbidden.
Hmmmm, maybe just for the import set ALL items on status 'review required' (or inactive) and in (or with) the import have the field status 'Active'? Will need to 'replace' when importing. Later you can run a query that Dropping the database before loading also has the desired effect but it a bit drastic. gr, Frans
-----Original Message----- From: itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org] On Behalf Of Mies, Christian Sent: woensdag 13 mei 2009 14:48 To: itsm@otrs.org Subject: [itsm] Removing Configuration Items that are not in CSV File
Hi List, I'm playing around with OTRS::ITSM ConfigItem Module. Import is working perfectly for a initial Import. Now I want to import regularly from another Database which CIs are available. If a CI is deleted in the "Leading" Database it should be deleted in the OTRS::ITSM DB or shout set to "Inactive" for a minimum. Can anybody give me a hint where to start over?
Regards Christian Mit freundlichen Gruessen
Christian Mies Consultant Systemmanagement
Tel: +49 (661) 103-874 (-333) Fax: +49 (661) 103-17874 (-334) mailto:Christian.Mies@it-novum.com
it-novum GmbH . Edelzeller Strasse 44 . 36043 Fulda . http://www.it- novum.com Handelsregister Amtsgericht Fulda, HRB 1934 . Geschaftsfuhrer: Michael Kienle . Sitz der Gesellschaft: Fulda
Der Inhalt dieser E-Mail ist vertraulich. Wenn Sie nicht der eigentliche Empfaenger sein sollten, informieren Sie bitte sofort den Absender oder vernichten umgehend diese Mail. Jegliche unerlaubte Vervielfaeltigung oder Weiterleitung dieser Mail ist strengstens verboten. This e-mail may contain confidential and/or priviledged information. If you are not the intended recepient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of material in this e-mail is strictly forbidden.
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Similar idea: Create a field with the 'last scan date' or so, populate it
with your CSV import. Now you can search for CI's that have not been updated
in a while and take actions based on that value.
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl
On Wed, May 13, 2009 at 16:42, Frans Stekelenburg
Hmmmm, maybe just for the import set ALL items on status 'review required' (or inactive) and in (or with) the import have the field status 'Active'? Will need to 'replace' when importing.
Later you can run a query that
Dropping the database before loading also has the desired effect but it a bit drastic.
gr, Frans
-----Original Message----- From: itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org] On Behalf Of Mies, Christian Sent: woensdag 13 mei 2009 14:48 To: itsm@otrs.org Subject: [itsm] Removing Configuration Items that are not in CSV File
Hi List, I'm playing around with OTRS::ITSM ConfigItem Module. Import is working perfectly for a initial Import. Now I want to import regularly from another Database which CIs are available. If a CI is deleted in the "Leading" Database it should be deleted in the OTRS::ITSM DB or shout set to "Inactive" for a minimum. Can anybody give me a hint where to start over?
Regards Christian Mit freundlichen Gruessen
Christian Mies Consultant Systemmanagement
Tel: +49 (661) 103-874 (-333) Fax: +49 (661) 103-17874 (-334) mailto:Christian.Mies@it-novum.com
it-novum GmbH . Edelzeller Strasse 44 . 36043 Fulda . http://www.it- novum.com Handelsregister Amtsgericht Fulda, HRB 1934 . Geschaftsfuhrer: Michael Kienle . Sitz der Gesellschaft: Fulda
Der Inhalt dieser E-Mail ist vertraulich. Wenn Sie nicht der eigentliche Empfaenger sein sollten, informieren Sie bitte sofort den Absender oder vernichten umgehend diese Mail. Jegliche unerlaubte Vervielfaeltigung oder Weiterleitung dieser Mail ist strengstens verboten. This e-mail may contain confidential and/or priviledged information. If you are not the intended recepient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of material in this e-mail is strictly forbidden.
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
participants (3)
-
Frans Stekelenburg -
Michiel Beijen -
Mies, Christian