Community Support Forums

Re: Batch Import to Include Purchase Date or EOT?

2011-09-20T17:57:17-05:00

Statistics: Posted by Cristián Lávaque — September 20th, 2011, 5:57 pm

Re: Batch Import to Include Purchase Date or EOT?

2011-09-20T17:03:43-05:00

ohhh perfect. That makes sense thank you!
-grace

Statistics: Posted by bitofgrace — September 20th, 2011, 5:03 pm

Re: Batch Import to Include Purchase Date or EOT?

2011-09-20T16:56:07-05:00

You can export a CSV of your users and then just add all the new ones and re-import using that same file so you don't have to worry about the format. The date format is probably best as yyyy-mm-dd. WP Admin -> s2Member -> Import/Export

Statistics: Posted by Cristián Lávaque — September 20th, 2011, 4:56 pm

Re: Batch Import to Include Purchase Date or EOT?

2011-09-20T07:15:31-05:00

Woohooo! that's fantastic ... is their a particular format needed for the "Auto-EOT Date" header? Or is that exactly it already?

Statistics: Posted by bitofgrace — September 20th, 2011, 7:15 am

Re: Batch Import to Include Purchase Date or EOT?

2011-09-20T05:46:03-05:00

from the UI (EOT is there):

Additional extended information can also be included; even Custom Fields:
"ID","Username","Password","First Name","Last Name","Display Name","Email","Website","Level[0-9]+ or Role ID","Custom Capabilities","Registration Date ( mm/dd/yyyy )","First Payment Date ( mm/dd/yyyy )","Last Payment Date ( mm/dd/yyyy )","Auto-EOT Date ( mm/dd/yyyy )","Custom Value ( starts w/domain )","Paid Subscr. ID","Paid Subscr. Gateway","Custom Field ID #1","Custom Field Value #1","Custom Field ID #2","Custom Field Value #2", ...

Here is a full example with all fields filled in, including extended details; and two Custom Fields:
"","johnsmith22","mY!passwrD","John","Smith","John Smith","john.smith@example.com","http://www.example.com/","2","music,videos","12/31/2000","01/10/2001","12/31/2020","12/31/2021","www.example.com|123.357.125.654","I-2342934SSER243","paypal","interests","fishing,biking,computers","t_shirt_size","xx-large"

Statistics: Posted by BlogPiG — September 20th, 2011, 5:46 am

Batch Import to Include Purchase Date or EOT?

2011-09-15T16:21:22-05:00

I'll be doing a batch import of our customer list to pre-fill registrations on a new system
No problem importing user_email, user_login, last_name, first_name
but what i need is to somehow set an EOT date based on their purchase date.

Any way of doing this when I import? (the list we have is thousands deep - so its not an option to update by hand)

Ideal is to preset the EOT in my CSV before import and have it actually work once imported. Am i hoping too much?

-grace

Statistics: Posted by bitofgrace — September 15th, 2011, 4:21 pm