Tests:

Adding a new member with a temporary password, does result in a member with a temporary password

A member with a temporary password will be told they need to change their password after logging in

A member with a temporary password will be taken to where to change their password after logging in

Bulk adding via CSV members with temporary password enabled, does result in members with temporary passwords

Implemented. I'm leaving this tracker issue open, as this has been implemented in a branch which will need merging into v10.

Implementation is attached above, under "attached files".

One nice thing about this functionality is it could also be used to force members to change their passwords. If you change the 'm_password_compat_scheme' field for a member row from "" to "temporary", they'll be forced to change upon their next login.
This could be done quite easily in Commandr, e.g.:

echo temporary > /members/bob/m_password_compat_scheme

Zip updated so as to not force password changes when using SU.

merged into v10