CMDB import

[Gunjan]

Hi,

I am successfully able to test import functionality of CMDB. Now my requirement is :

1) After importing the config items in the OTRS, let's say an agent make some change in a field(for e.g. Development State, Incident State etc) of a config item and successfully submitted the changes.

2) Now I want to do that when the next time CSV export file is imported in the system containing that config item, the field that was changed from UI, should not be updated.

Is it possible to do so?

Regards,
Gunjan

[crythias]

Change need to be made at source origin of data. The import is on purpose clobbering data. Although, it will/should only clobber data for fields that match the import.

[Gunjan]

If I remove a field from Import/Export Template and Now I try to import data from a CSV file that contains the removed field also. It does not import data now. Is there a possibility that when data is imported, data which header lines are matched with the template, should be imported only??

Regards,
Gunjan

[crythias]

It does not import data now.

How is this indicated? That is, does it silently run the import and do nothing to the database (and also no logs saying unsuccessful?)? Does it refuse to import prior to run import ("Not enough fields!") Does it instead error out during run?

[Gunjan]

after importing, it is giving as failed : 1 and no changes has been made to database in that case.

[Gunjan]

Can I implement the solution for my requirement as follow:

After importing, if user changes any field like status fields in OTRS CMDB frontend, then that field should be deleted from the template behind that config item, but now the issue is that when we import the csv file, It does not ignore that field and gives us an error. Can we do some implemetation to ignore that field in csv?

Regards,
Gunjan

[crythias]

I believe this will require some development. My feeling is that importable entries should be readonly on the front end and properly adjusted at the source.