Hi
Why do you want to go that path of doing something which I believe will be risky and tricky both?
I understand the intent can be here to save time as you need to create 20 classes, but from my personal experience in project I would strongly suggest to create it manually and loading of data you can automate the way you want.
Just to be aware based on what attributes your classes are supposed to have may be you can create a Parent class and then keep on extending the child classes when you create from that particular Parent class.
This will save time and you do not have to create field manually and creation of Table(class) will not take more than few minutes.
For example: Look at the parent class as Hardware and computer being Child . So similarly you can create your child classes and extend from a parent class.
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
Hi Alex,
As mentioned above, I know creating 20 custom classes is a pain, but I would like to mention again please do it manually as we are talking about creating Tables (Sub Class) and load CMDB related data and should not be the thing to take risk on.
Still since you are looking for loading it using excel sheet, I will give you the approach which will work but I will strongly recommend again to create it manually only.
Reason being there is an OOB BR named" Table Field Validation" which does not allow creation of table record using import set and will throw an error.
Alternative way if you still want to do it is by unchecking the Run Business Rule flag as unchecked in your transform map and that will let you create using import set functionality.
Create an Excel sheet like below
Now create a Transform Map and uncheck the BR as shown in Red below:
below are field maps to be created :
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
Well, before I checked your answer I succeeded to create classes from excel. And it worked for me with this options.
Anyway, Shloke thanks a lot for advices and help.
