Schedule content availability

10 posts by 5 authors in: Forums > CMS Builder
Last Post: February 25, 2010   (RSS)

By cidvalue - February 18, 2010

Hi everyone, I'm new to this forum and a newbie to CMS Builder.
I would like to build a site where some pages are made available on a certain predetermined schedule or set of dates. Is this possible with CMS Builder?

For example, the content on page x (such as an article) would be made available for an end user to access and read only from xyz date to xyz date. After the expiration date, the content would be automatically disabled from access without admin intervention.

Thanks!

Re: [Donna] Schedule content availability

By cidvalue - February 18, 2010

Thanks Donna! I'll give it a shot.

Regards.

Re: [Donna] Schedule content availability

By gkornbluth - February 22, 2010

Hi Donna,

Since we can now specify a custom date or strtotime value in date fields, how would I specify a removeDate that is say 4 weeks from the publish date (which I've set to the current date).

Sorry but I looked at the strtotime examples at http://php.net/manual/en/function.strtotime.php#function.strtotime.examples and I'm totally confused.

Thanks,

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

Re: [gkornbluth] Schedule content availability

By Chris - February 23, 2010

Hi Jerry,

You can use "+4 weeks".

I hope this helps! :)
All the best,
Chris

Re: [chris] Schedule content availability

By gkornbluth - February 24, 2010

Thanks Chris,

I'm still a bit confused and could use some more of your expert your guidance.

I've created a section that has:

1) A publishDate field (set to current date)
2) A removeDate field (set to "custom date" and with only "+4 weeks" entered in the field as suggested (no double quotes). The preview date under the field shows as 4 weeks from the current date as expected)
3) A neverRemove field that is unchecked)

When I create a record, the publishDate shows as today's date as it should, and the removeDate and neverRemove fields are blank.

Unless I manually set a removeDate or check the neverRemove box, the record won't show in the list viewer.

What am I missing?

Thanks,

Jerry
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

Re: [gkornbluth] Schedule content availability

By Dave - February 24, 2010

Hi Jerry,

Can you try creating a new test section and reproducing that issue? If you can reproduce it please feel free to send CMS & FTP login details to dave@interactivetools.com and I'll take a look.

Note: Email, don't post login details to the forum.

Thanks!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Schedule content availability

By gkornbluth - February 24, 2010 - edited: February 24, 2010

Problem solved.

Dumb but true

It only works on newly created records. Of course it won't update existing records which must be revised manually.

I knew that...

I must have been testing it on existing records but I don't think so.

Anyway, it's working...


Sorry to spin our collective wheels.

Jerry
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

Re: [gkornbluth] Schedule content availability

By Dave - February 24, 2010

No problem! :)

If you wanted to update the old records you could do that with this command in the MySQL Console:

UPDATE cms_section SET removeDate = NOW() + INTERVAL 4 week WHERE removeDate = "0000-00-00 00:00:00"

Hope that helps! :)
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Schedule content availability

By gkornbluth - February 25, 2010

It certainly does.

You certainly are an amazing fountain of knowledge.

Best,

Jerry
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php