Import FMEDA from excel to medini

Question

Hi,

I would like to import FMEDA from excel to Medini. Below is the screenshot from the mapping of the columns and the screenshot from the original FMEDA.

Could you please provide support?

Thanks and kind regards,

Nebojša

medini_1027718341 · Answer

Hi Krasimira,

Ich habe Skript getestet, ein bisschen modifiziert und fast alles läuft.

Was noch fehlt ist „localEffect“ variable (aus dem Skript) in der Spalte „Effect
on Systemlevel” (user_comment) reinzubringen.

Geänderte Skript ist im Anhang.

Könntest du bitte Skript nachschauen und helfen wenn du Zeit hast?

Danke und Gruß

Nebojša

medini_1028038066 · Answer

Dear Nebo,

please find attached an example close to your needs. Please note that you need to check the starting line and the order of the columns once again.

Best regards,

Krasimira

medini_1024169437 · Answer

Nebojša,

importing an FMEDA worksheet from Excel is not a simple task as FMEDA/DC worksheets are complex in Excel but also in medini.

Have you some scripting experience? Maybe you start with simple Excel import scripts and import column G-L into the system model. There a few import scripts here in the forum as for example https://medini.freshdesk.com/support/discussions/topics/1000093547 or even https://medini.freshdesk.com/support/discussions/topics/1000094437

Happy Scripting

Jan