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 <frans.stekelenburg@netdialog.eu> wrote:
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/