User import and expiration dates

16 replies [Last post]

Mon, 08/09/2010 - 02:24

tumbledown

Offline

Joined: 08/06/2010

Status:

Answered

Hi,

Is there a way to import start and expiration date fields in a csv into Membership Suite?

I have been using the User Import module and following your tutorial and it works really well - but I can't see any way to match up start and expiration date fields with the ones in Membership Suite.

I am importing already paid up members from a previous system (nothing to do with Drupal) and obviously need to include their membership's expiration date.

Thanks,

Mike

Mon, 08/09/2010 - 12:32

Leighton Whiting

Offline

Joined: 06/02/2009

Mike, I will have to add

Mike,
I will have to add support for populating the expiration and start dates from User Import fields. What format are your expiration and start dates stored as?

Sincerely,
Leighton Whiting

Tue, 08/10/2010 - 00:27

tumbledown

Offline

Joined: 08/06/2010

dates

Hi Leighton,

Fantastic support - thank you.

I'm not certain what you mean by format. They are in the following yyyy-mm-dd

Is that what you mean?

Thanks again,

Mike

Tue, 08/10/2010 - 08:57

Leighton Whiting

Offline

Joined: 06/02/2009

That's what I meant. I'll

That's what I meant. I'll have to make a field that users the php function strtotime() to calculate the expiration and start dates. I'll see what I can do and get this in the next release.

Sincerely,
Leighton Whiting

Tue, 08/10/2010 - 14:22

tumbledown

Offline

Joined: 08/06/2010

Thanks but any idea when that

Thanks but any idea when that would be?

BEST,

Mike

Mon, 08/23/2010 - 23:44

tumbledown

Offline

Joined: 08/06/2010

Any update?

Hi Leighton,

I also sent you an email about this a few days ago but I guesss you didn't get it.

Can you give me any idea when the next release will be? I am using Membership Suite on a client's site and I can't keep them waiting much longer.

I'd be really grateful if you could just let me know. If it can't be done quickly, then at least I know and can come up with some kind of alternative.

Thanks,

Mike

Tue, 08/24/2010 - 16:53

Leighton Whiting

Offline

Joined: 06/02/2009

Tumbledown, It was just

Tumbledown,
It was just released, version 6.12. Let me know how it works out :)

Sincerely,
Leighton Whiting

Wed, 09/29/2010 - 10:02

weirean

Offline

Joined: 03/23/2010

When importing memberships,

When importing memberships, what format do the dates in the csv file need to be? I have successfully imported data to assign the memberships but the dates are all set as 1 Jan 1970.

Wed, 09/29/2010 - 14:41

weirean

Offline

Joined: 03/23/2010

After some research and

After some research and experimentation, I am still unable to import an expiration date. I have a csv file that I a importing with user import module. I have tried the date format as a 10 digit timestamp, and as a date formatted in sevaral ways, but it is always imported as 1 Jan 1970.

MS uses the timestamp format in the db but is the code used with the user import looking for a date in a different format?

Tue, 11/02/2010 - 18:53

Leighton Whiting

Offline

Joined: 06/02/2009

Sorry for the delay on this.

Sorry for the delay on this. I've been corresponding with various people through email and have gotten the problem fixed. This will be released in the version tonight.

Sincerely,
Leighton Whiting

Mon, 03/14/2011 - 06:21

#10

Fred Smith

Offline

Joined: 01/08/2011

csv file configuration for this?

Hi, I'm importing in users from an old system at this time.

This is exactly the function I need, but it is unclear from this thread how you would set up dates in the csv file. Can you help?

Mon, 03/14/2011 - 08:56

#11

Leighton Whiting

Offline

Joined: 06/02/2009

The dates get passed through

The dates get passed through php's strtotime() function, so it needs to conform to one of their (many) supported formats. See here for details: http://php.net/manual/en/function.strtotime.php

If it's legible to you, it should be legible to strtotime().

Sincerely,
Leighton Whiting

Tue, 03/15/2011 - 00:53

#12

Fred Smith

Offline

Joined: 01/08/2011

Problem Solved

I set the dates up as M"-"DD"-"y aka Mar-14-2011, for example, and that worked.

Mon, 04/25/2011 - 23:44

#13

Fred Smith

Offline

Joined: 01/08/2011

Problem not solved like I thought

It looked like it imported the expiration dates in while using the User Import module, but when you look at List Memberships, the expiration date is set to expire 1 year from when I imported the members. It's not using the expiration date I imported in.

Is there any way to fix this besides manually changing the expiration dates - there are hundreds of them...

Wed, 11/30/2011 - 15:20

#14

PCIA

Offline

Joined: 07/18/2011

Greetings, I am not clear on

Greetings,

I am not clear on how to use this function but it sounds like just what I need to import some 1,000 members into our new MS system.

I need to import them in batches, by expiration date of their membership from our old system. But when I import them now as tests the start date of their membership is the date of import.

So how do I tell MS/Import that I want to start the membership relative to a date in the csv file (in the column 'start date', in the format:

4/15/10 12:00 AM

Thanks for any advice -

Todd Vogel

Wed, 11/30/2011 - 15:31

#15

PCIA

Offline

Joined: 07/18/2011

Duh, that would be with the provided Drupl field "start date"

I'm a professional at confusing myself - I thought the 'start date' field in Field Matching was a field I created.

But just in case anyone else got stuck with this:

(Field matching is pretty straight forward)

On my csv there's a column for 'membership start date'

Match that with Drupal/MS's provided field "start date'

I told Excel to format my date as:

4/15/10 12:00 AM

Works fine. I'm so excited I almost pulled my pants off over my head!

Wed, 11/30/2011 - 16:40

#16

Leighton Whiting

Offline

Joined: 06/02/2009

Glad to hear you got it

Glad to hear you got it working, and thanks for sharing the clarification.

Sincerely,

Leighton Whiting

Support

Your Cart

Twitter Feed

Random FAQs

Helpful Information

Tools I Use