I have an old news CGI script that writes its content to a flat file text database. I'd like to be able to convert data from the file to an XML file as an RSS 2.0 feed.
Content in the database file looks similar to this...
date|:|author|:|email|:|time|:|title|:|byline|:|random 10 digit identifier|:|content
To convert to rss thinking the time and date may need to be combined to create pubDate
title would become title
content would become description
and title with hyphens and .html would become link
Currently, my rss feed is a static .xml file that I update manually. I want new the file to be able to be updated either by script (cron) or similar. OK to be .php since I can 301 to the nex format.
Any scripts out there capable of doing this? Would like to use existing script if available.
This project may require some changes to the cgi script creating the content in the database in order for data to match up for RSS. Particularly I am thinking about the time and date format being converted to a standard pubdate format.
I am attaching the cgi script and data file.
Motivated to have someone get this done this weekend!