Need a volunteer for Propellerpowered site.
Oldbitcollector (Jeff)
Posts: 8,091
It's been almost 8 years since I've written a stitch of PERL code, so I'm pretty rusty. I'm also working 12 hour days between the expo and the business I already run. So I need a volunteer coder.
Propellerpowered.com is run on a linux machine hosted by GATOR.
I need to replace the page design in:
http://www.propellerpowered.com/propellergaming
to something which pulls the same data from a flat database.
I'm thinking comma delimited file that could be exported from Excel.
The ability to add fields for various board binaries would be a big plus,
as well as additional links to documentation at will.
Has anyone spotted a program which would be suited to the task, or
be willing to step forward to volunteer?
OBC
Propellerpowered.com is run on a linux machine hosted by GATOR.
I need to replace the page design in:
http://www.propellerpowered.com/propellergaming
to something which pulls the same data from a flat database.
I'm thinking comma delimited file that could be exported from Excel.
The ability to add fields for various board binaries would be a big plus,
as well as additional links to documentation at will.
Has anyone spotted a program which would be suited to the task, or
be willing to step forward to volunteer?
OBC
Comments
- Why a flat db?
No 'real' db available at Gator?
- How is the data looks like? comma separated already?
- for adding files: a kind of cms system?
I don't know if there is a program for it, but it's easy to create one. Maybe php? (if supported)
MySQL is a pain to get running and all sorts of security holes to plug.
But if you have that running, then easy for MS Access database (and I would assume Excel) to act as a front end and transfer data, do queries, etc. via ODBC.
The tables in Access can also be just linked tables which live on MySQL.
And the best part is you can create a query in Access, the click on SQL View and there is your basic SQL code for Perl scripts (with a bit of modification of course).
FYI - pair.com (ISP) has UNIX servers and MySQL/Perl/Telnet/FTP, etc.
Will you please clarify / elaborate on these points
- Do you have like a linux virtual machine where you can get a bash prompt as root?
- Looks like your blog is running on Wordpress correct?
- And you have admin privliges on the wordpress blog?
Once the conversion is done would/can you manage/administer this aspect of your site by some means as yet to be devised or implemented? That is if I can find the right combination of plugins/widgets for wordpress you could manage the projects from wordpress. This is where I'm not totally clear on your desire. You don't need to continue using the flat file once the conversion is complete right?
By no means am I an expert on wordpress, I have implemented Google analytics and addsense among other advanced configurations. I run www.rodaw.com (review or delete at will) on a linux virtual machine at vps.net. See this post http://www.rodaw.com/category/projects/ as an example of a single blog post that contains words, pictures resources used and download of source code for the propeller and a pc. Just look at the post not the actual project. :-)
I've also installed a forum engine that links to wordpress that might be more suitable. It's available but not much in the forum other than some testing in a C# thread when I initally installed it. (I happend to be in a C# class at the time)
There are other plugins for wordpress such as picture galleries and MUCH MUCH more. So perhaps if I can understand a little more of what you're trying to accomplish I may be able to assist with currently available plugins etc.
Yes I will consider volunteering to implement the solution. However once implemented the recuring maintenance is yours, like adding new projects and such right?
My blog post mentioned above was written offline with MS Live Writer. You'll note that when you click on the pictures you are taken to larger versions. I only had to insert the picture in my offline Live writer, size it and the rest is automated. You could setup a catagory in wordpress and keep all the projects under that catagory. An example of the catagory is on my site ... nerding projects .... It's a lot easier to do bloging offline where you can take your time, sleep on it, look for refrences and such.
Another way might be to do it with a wiki. I have MediaWiki (wikipedia runs on MediaWiki) implemented on Rodaw as well. See: http://rodaw.com/wiki/index.php?title=Rodaw
rodaw - jeffa
Looks like Jeffa is willing to help. If you do need extra help let me know.
As Jeffa said, there is likely a Wordpress plugin that could be used or modified for your needs. If not, that dosen't sound like it would be that difficult to implement. I would think you would be able to use PHP or Ruby if you can use Perl on your hosting.
--trodoss
However, I'm half considering using a Propeller board to serve the page reading the details from SD. I need to do some research and see if the Propeller can handle the load. Somehow it just seems appropriate.
OBC