Import Functions List of Excel

Question

Hi Jan，

one of our customers would like to import the function list of Excel into medini analyze.

The specific import properties include Domain、ID、Name、Description.

Could you please provide a script to realize this purpose?

During the import process, it would be better if we could customize the attributes like importing requirements.

So, how to realize this by scripting?

Thank you for your support in advance.

medini_1047650437 · Answer

Hi Jan,

Thank you very much for the script, the problem has been solved.

Sincerely.

Qianqian

medini_1024169437 · Answer

Hi Qianqian,

attached a script that we have implemented a while back to import functions/activities/actions from Excel.

I think that should be a good starting point for you. Note that you need some libraries, but I am sure you know how to handle that part.

You can rmeove all stuff you don't need (Actions/Activities) and add more columns you want to import.

Feel free to repost your result, once you are done.

Happy Scripting

Jan