Import users and payment history from spreadsheet

I am helping an organization set up aMember PRO to assist with managing their membership. Their current membership is stored manually in a spreadsheet. I understand how to import basic user information by using a csv view of their members, but I have a couple of questions about how to get their past and current status into aMember.

1. They currently do not have passwords setup for any kind of online access. Can we initialize all of them to a special password state, that will require them to create a password the first time the member needs to access aMember, to either edit their profile or add/renew subscription?
2. How do we import past payments into the aMember database from the CSV file? How do we set their status to either Active or Expired? If they are Active, how do we set the expiration date? We would like that to be one year from the last payment received.

Thank you

Have you looked at the documentation.... importing users (including subscriptions) and emailing passwords to imported users. Should all be there.

Thank you - I had read the first reference. That looks like I can only set an initial subscription. I could not see how I would import, say, previous payments and time periods. Some members may have a 2 year history, others 5 years, still others 8 years, etc. Do we lose all this data when we import? This organization wants to keep it all together.

Not using the standard import, depends on what you want captured. You could create a field 'Member Since' and set that if you just want to know how long they had been a member. Importing a full payment profile would require coding something custom unless the aMember guys have something they have already cooked up.

If you want me to have a look at doing some code you will need to raise a ticket over at JLogica.

I understand how to add a custom field, but how would I tie the "Member Since" date to the Expiration Date for the subscription I set them to? They have a few hundred members who will all have different expiration dates and we want the automated expiration notices sent out when the time comes.
Thanks again...