Webforumz's RSS FeedRSS Webforumz RegistrationRegister Contact Webforumz StaffContact

Erm.. Databases and auto updates

This is a discussion on "Erm.. Databases and auto updates" within the Web Page Design section. This forum, and the thread "Erm.. Databases and auto updates are both part of the Design Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Design Your Website > Web Page Design

Notices




Reply
 
LinkBack Thread Tools
  #1  
Old Sep 15th, 2006, 14:24
New Member
Join Date: Sep 2006
Location: Manchester
Age: 26
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Erm.. Databases and auto updates

Hi

Please forgive me if I don't do a very good job of explaining this. I have quite basic html knowledge and no flash / asp / or dynamic html knowledge whatsoever so any help would be much appreciated.

I've been asked by my manager to design a website that will automatically update from an excel spreadsheet.

A spreadsheet is created every week by HR which shows a list of Duty managers, times working, contact numbers etc.

Is there a way that when this spreadsheet is created I can just copy the excel file to my web folder and the website will read from the file and automatically display the new information?

Thanks in advance
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old Sep 15th, 2006, 15:40
Elite Veteran
Join Date: Aug 2005
Location: That Place
Posts: 2,044
Blog Entries: 1
Thanks: 0
Thanked 37 Times in 37 Posts
Re: Erm.. Databases and auto updates

Easiest way I can think of is to export the spread sheet to a csv file and insert it into a MySQL database assuming the spreadsheet/database have the same structure it will work and only take a minute to perform. I use CocoaMySQL to do this and it works perfectly every time, PHPmyAdmin can probably do it too.
__________________

Last Blog Entry: Apps every Mac based web dev should consider (Jul 10th, 2008)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old Sep 18th, 2006, 05:06
Ryan Fait's Avatar
Elite Veteran
Join Date: May 2006
Location: Las Vegas
Posts: 3,787
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Erm.. Databases and auto updates

If you spend a little time (a few hours tops), you should manage to understand PHP with mySQL enough to acheive this. http://phpfreaks.com/ is an extremely helpful and active forum for poeple new to PHP (and they're almost all mySQL experts too).
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
erm, databases, auto, updates

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Databases? Apocalyptic Poet Classic ASP 1 Apr 23rd, 2008 13:24
Google index updates spinal007 Search Engine Optimization (SEO) 24 May 3rd, 2007 15:33
no databases in phpmyadmin Drgreenfingers Databases 1 Feb 4th, 2006 22:21


All times are GMT. The time now is 19:37.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8