Mass update expiration dates via CVS import or other method

  • Aathman
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 7 months ago #149009 by Aathman
I need to update many user's subscriptions (extend). I tried export CSV file, updating, and importing again but that doesn't seem to update current records. Is there a way to batch or mass-update this without clicking into each subscription, and without going directly into the database?

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #149014 by Tuan Pham Ngoc
The easiest way would be run an SQL command to update the data if all subscribers you want to update have same expiration date.
The following user(s) said Thank You: Aathman

Please Log in or Create an account to join the conversation.

  • Aathman
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 7 months ago #149149 by Aathman
Thanks. I used "Regular Labs - DB Replacer" to do it, and then later mucked around in SQL just to verify.

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #149150 by Tuan Pham Ngoc
OK, great. I'm glad you had it sorted

Tuan

Please Log in or Create an account to join the conversation.