roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Timothy J Schumacher <Tim.Schumac...@Colorado.EDU>
Subject Automatically schedule new entries?
Date Sun, 22 May 2011 21:32:04 GMT

I am using Roller 5.0.0, tomcat 7.0.6, mysql 5.1.46 and linux

I have a question about programatically scheduling new entries to be 
published at future times.  I looked at the weblogentry table that 
Roller created in mysql and it looks pretty straightforward to write sql 
scripts to add entries that have future publish times.  I think my main 
question is: are there other tables that would need to be modified to 
keep everything in sync or could I simply update the weblogentry table 
and have everything be ok?

The problem I am trying to solve is the following: I have lots of xml 
files that already contain content I want to publish at regular 
intervals in the future, say one new post per day.  I could use the user 
interface to manually schedule each one but it would be nice to be able 
to automate this by translating each file to an sql script and running 
that via the shell.  Then in Roller I could see all the posts and 
preview them to make sure they look correct.  If anyone has dealt with 
this I would love to hear ideas about how you solved it.


View raw message