The data is being imported with active as a lower case y. If I manually activate it and then deactivate it it turns to an n.
When imported it looks like just a y in phpMyAdmin but neither the green check nor the red x show in ISPConfig3 so it's being seen as something else. Character encoding? Just a thought.