Help with bulk user import

Hi,

I have an excel spreadsheet with about 600 users and a ton of user_meta fields. One of those fields is the date that they joined our organization (through pen and paper, not through S2 member or any other online means).

That date is stored in this format: 03/17/2011

I’m going to format this data for import via phpMyAdmin.

Two Questions:

1. S2 member stores the reg date as a UNIX timestamp, correct?

2. What the hell does this mean:

“a:2:{s:5:”level”;s:10:”1330902986″;s:6:”level4″;s:10:”1330902986″;}”

It’s the content of the meta_value row with the meta_key of “wp_s2member_paid_registration_times”.

It looks like an array that has been stored as a string? The longer numbers look like UNIX timestamps?

What does the rest of it mean? What should we use as default values for the rest of it as we import?

Also, in general, is there an easier way to do this?