Eve For Enterprise    Eve Support Community    Forums  Hop To Forum Categories  OpenTopic  Hop To Forums  OpenTopic Assistance    How do we update thousands of users based on DOB?
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Groupee Newbie
Posted
We tried exporting the XML but the import said existing members would not be overwritten.

Do we need someone to fire off a SQL update directly on our membership database?

Or is there some way we can do it ourselves?

We want to put everyone in an "adult" category if 18 or over.

Thanks.
 
Posts: 11 | Location: Highland Park, NJ, USA | Registered: June 29, 2002Reply With QuoteEdit or Delete MessageReport This Post
Groupee
Posted Hide Post
Jeff:

Infopop might be able to run some SQL on your database to do such a task. I'd suggest filling out a support ticket.

https://www.infopop.com/q/q.php


Steven Benitez
Code Guru, Groupee Engineering
Groupee, Inc.
 
Posts: 3880 | Location: Seattle, WA | Registered: January 01, 2000Reply With QuoteEdit or Delete MessageReport This Post
Infopop Technology
Posted Hide Post
Correct we can do this for you, but you will need to submit a support ticket and there will be a charge.

-Barry
 
Posts: 945 | Location: Seattle, WA | Registered: August 05, 2002Reply With QuoteEdit or Delete MessageReport This Post
Groupee Newbie
Posted Hide Post
Hi Steven and Barry,

If we update the existing XML data to add those who are over 18 to the Adults group, would reimporting it then update the member list with the provided changes?

Thanks,
-Steven
 
Posts: 6 | Location: Charleston, SC, USA | Registered: January 04, 2003Reply With QuoteEdit or Delete MessageReport This Post
Infopop Technology
Posted Hide Post
I do not believe so.

-Barry
 
Posts: 945 | Location: Seattle, WA | Registered: August 05, 2002Reply With QuoteEdit or Delete MessageReport This Post
Eve Developer
Aspiring Monkey
Posted Hide Post
No, it will not. The XML import only works for adding new users, if there is already a user with that login it will skip that entry and move on.

Sorry, but we designed it as an importing feature, not updating. It tries to maintain existing data wherever possible.

Cheers,


Jonmark Weber
Developer
Groupee, Inc.
 
Posts: 1887 | Location: Seattle | Registered: November 10, 2000Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

Eve For Enterprise    Eve Support Community    Forums  Hop To Forum Categories  OpenTopic  Hop To Forums  OpenTopic Assistance    How do we update thousands of users based on DOB?