Pai Memberships Pro Import OK but no membership assigned

I have created a csv file with the following information:


The CSV plugin does not show any error messages and claims the import was OK. But when I check the user in WordPress -> All Users there is no membership level assigned. Also under members in PMPRO the transaction does not appear.

The only data that’s imported is the name,email,username and userrole. I am using PMPRO and their suggested CSV Import plugin.

What am I doing wrong?