Thread: Cannot update SubscriptionExpiresOn through WSI

Hi

Just hoping someone could tell me if the SubscriptionExpiresOn field in the customer table can be updated through WSI as I cannot get it to work and when I check the Master file it is not in there.

We have a trade only website and registration is done in our back office system as we do not show prices and have now added a download section as a topic so need this to be secure and only available to registered customers.

Thanks in advance

Phil

Yep. That's not something you can update via WSI, but if you have the source I can tell you where/what to add to enable it.

In WSI.cs, from hlpCustomerUpdate() method add:

Code:

Separator = AddXmlFieldToSQLFieldDateTime("SubscriptionExpiresOn", "SubscriptionExpiresOn", node, sql, Separator, System.DateTime.Now.AddMinutes(-1));

Thanks for this, we have source so i will try what you suggested.
thanks
phil

Worked great, thanks for your help

phil

np. I'm glad it worked.