PyroCMS mySQL data table conversion

I have an offline database of users for a business. This contains all the usual info: ID, name, surname, title, email, membesrhip card number; but no password (this data has only be used offline to make membership cards to date)

I need to convert this dataset into tables formatted to work with PryoCMS's mySQL tables default_users and default_profiles table. They are joined using the existing ID.

At the same time I need to create random new passwords for each entry in SHA1 format, and an assoicted SALT entry that PryoCMS requires. These can be anything random as the users will never see them. They're just required by the new table structure; but users will be asked to reset password on login - creating their own new passsword - using the existing recvoery process.

Some fields will also need to be converted. E.g Date of birth from DATE to INT format; Last updated from TIMESTAMP to INT format (unix timestamp again). Some other fields need to be merged to create an extra field - e.g. Display Name from Name and Surname

In total the existing DB members table has about 15 fields, the 2 new ones have 10 fields and 15 respectively.

Looking for a very fast turnaround; and no margin for error.