Mailing-List: contact user-help@roller.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@roller.apache.org
Received-SPF: pass (nike.apache.org: domain of Tim.Schumacher@colorado.edu
 designates 128.138.128.233 as permitted sender)
Message-ID: <4DD980D4.5070901@colorado.edu>
Date: Sun, 22 May 2011 15:32:04 -0600
From: Timothy J Schumacher <Tim.Schumacher@Colorado.EDU>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
To: user@roller.apache.org
Subject: Automatically schedule new entries?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I am using Roller 5.0.0, tomcat 7.0.6, mysql 5.1.46 and linux 
2.6.26.6-79.fc9.i686.

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.

Thanks!
Tim