Get a 2 week timetable into Outlook/Google Calendar etc

[NotSoFast]

Folks,

 

I've just finished (well, it seems to work anyway) a little site that allows a teacher or a student to type in their timetable and get back a csv file of all their lessons for the year so they can import it into Outlook, Google calendar or whatever. It's something I end up fudging every year in Excel so I thought I'd have a proper go at it as I've been learning PHP, MySQL and Javascript.

 

It's pretty easy to break at the moment, but if I spend too much more time on it this week I'll be in trouble with 'er indoors.

 

If you use it, please let me know if you find any bugs or problems, and feel free to tell staff and students at your school if you think they might want to use it. The address is www.timetableconverter.site40.net

 

Oh, and if anyone can see why the jquery corners aren't being applied to the footer div I would love to know!

 

Cheers,

 

Simon

[EduTech]

This looks interesting.. i'll mention it to some of our staff see if they would find it useful.. if so i will let you know there feedback.!

 

Er.. dont know if it is just me.. but dont seem to work in IE7.. although works fine with FF 3

 

Might just be me though.

 

I'll be in touch

 

James.

[PEO]

Hi,

 

Nothing happens when you click on 'Step 1' it just takes you to the top of the home page.

Edited August 26, 2008 by PEO
IE7 user here too

[kmount]

Works fine for me in FF3, mind you when you click on Step1 whilst it does drag you back to the top, it expands the menu.

 

Looks clever indeed.

[EduTech]

Hi,

 

Nothing happens when you click on 'Step 1' it just takes you to the top of the home page.

 

Yh only seems to happen in IE7.. on FF and other Browser's it works sound.

 

sorry to pick a fault already i never ment too..

[NotSoFast]

Thanks for all your comments guys. Good old IE7 eh? I made the mistake of assuming it was fine since it looked ok.

 

I'll do some playing later on and let you know how I get on.

 

Simon

[kmount]

I can see this being quite useful...

[MPorter]

Really nice. Looks good in FF3 and safari. Thanks.

[EduTech]

sorry just added my thanks forgot to earlier haha!

 

Anyhow yh i think this is going to be great, sent to out head of ICT see what she thinks and i am sure she will pass it around and get u some good feedback

 

James.

[Edu-IT]

Could not connect to MySQL: Access denied for user 'root'@'localhost' (using password: YES)

[NotSoFast]

Hmm...

 

In trying to fix the IE problem I seem to have messed up the basic functionality.

 

I'll let you know when I think it's solved! Until then, it may not be the best idea to pass on the link...

 

Simon

[EduTech]

already passed on lol

 

Dam me for rushing ...

 

i am sure u will fix it

 

James.

[kmount]

Could not connect to MySQL: Access denied for user 'root'@'localhost' (using password: YES)

 

Really wouldn't advise root connections to sql on a public facing site.

[NotSoFast]

@kmount

 

Good point - another little thing I missed...

 

[NotSoFast]

Actually, on checking the connection script I'm not using root, just the username supplied by the hosting firm. I don't seem to have priviledges to create new users or databases either, so I think it's just the way they handle MYSQL.

[NotSoFast]

Right - I've been through it and I can't find the problem. It seems IE doesn't like something in my Javascript, so feel free to play "spot the silly mistake" if you've got some time to kill...

 

I have got the $%£%"%^$ thing up and running again, with caveats...

 

As is the way with these things, once I'd broken it (at around 11:30 last night) I noticed one or two other things:

 

I never planned (initially) on actually putting this live on the web, so I didn't consider that more than one person might be accessing the page at the same time. I'm pretty sure there's a straightforward solution to this in that I can assign a username to each person's week pattern and timetable then build the final query to only include their data (at present the tables are emptied before new data is added).

 

At one stage in the development I had it set up so the first day in the year became the Monday before the date selected (if it wasn't already a Monday). This makes the date pattern display properly with accurate "Week Commencing" dates. At some point I've lost that code (and forgotten how to do it!).

 

None of these 3 bugs prevent it from working completely, so I've left the site live at present with a warning at the top. Feel free to pass it on (to Firefox users!) - the worst that can happen is that they waste 5 minutes because someone else is using it at the same time.

 

I will sort this out, but with the start of term approaching I can't see it being quick. I'll post once it's working, and in the meantime if there are javascript/Jquery or PHP gurus who'd like to give me a hand, I'd be happy to share the source.

 

Thanks,

 

Simon