Assets - Set a default value when importing

Question

Hi,

I've looked in to this before but hopefully someone has figured out a way to do this in the meantime.

I have several imports going in to the same objectType and would like to be able to specify during the import what the source is.

In a CSV I can of course add a value as a column but I don't see a way to do this with for example an LDAP Import. Is there a way to either generate an attribute on the fly or set a default value somehow during/after import?

Admin _RKI · Answer

The function to specify "Default" values for imports is essential. Since with imports it cannot be ensured that e.g. a status is passed. Thus, no attributes can be set as "mandatory field", which should actually be treated as such. Because the import does not allow this! :-(

PD Sheehan · Answer

Yeah, I'd second this.

If you have a csv import, include a dummy column.

If you have a database import, include a simliar dummy column in the sql selector.

Anything else left empty, can be assumed to be an LDAP import.

If you have 2 separate ldap imports and you want to identify ldap1 vs ldap2, then you'll need to use automation to fill in the empty data source attribute with an appropriate value based on some existing data differentiator  (maybe the distinguished name containing some keyword hopefully different for ldap1 vs ldap2)

Melo_45tw58 · Answer

Hi @Dirk Ronsmans ,

"Is there a way to either generate an attribute on the fly or set a default value somehow during/after import?"

Using Asset automation, you can set default values on existing attributes.

e.g. When object created, if email ends with @mycompany (email domain) add "mycompany" to attribute Organization.

You'd need to define those before the import, and also, there is a limitation of 1 event and three pairs of conditions. Depending on your case, you may need more than one rule.

https://confluence.atlassian.com/servicemanagementserver/configuring-assets-automation-rules-1044784502.html

I hope that helps.

Thanks,

Melo