Schedule content availability

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

Re: [cidvalue] Schedule content availability

By Donna - February 18, 2010

Hi there!

Yup, that's easy to do, and is built into CMS Builder. Check out this page for more information on "special fields":

http://www.interactivetools.com/docs/cmsbuilder/special_fieldnames.html

Specifically, you'd be using a publishDate and a removeDate field, and CMS Builder will automatically hide any content that doesn't fit within those dates. :)

I hope this helps!
Donna

--
support@interactivetools.com

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