- see footer for list info -<
Hi Nick.
I did this initially. The idea of creating the fields on the report
dynamically from the spreadsheet seemed like a good idea until I hit spaces
in the file names or weird characters or someone just doing a typo. It
caused me a real headache tying up the dynamic stuff with what was in the
query ... I could have spent some time on getting it right but deadlines had
to be met so I dropped this idea. I might re-visit it again.
The thing that prompted all this is I have just done the data for the
OCTOBER standards fund which will be live today I hope. However the whole
thing kicks off again next year in Late March ready for April. I am looking
at finding a better way to do this application.
Regards - Paul
From: "Nick Tong - TalkWebSolutions.co.uk" <[EMAIL PROTECTED]>
Reply-To: Coldfusion Development <[email protected]>
To: "Coldfusion Development" <[email protected]>
Subject: Re: [CF-Dev] A better way - You comments welcome.
Date: Mon, 30 Oct 2006 11:57:18 +0000
- see footer for list info -<
Sounds like a need for an API ;). What other ways do they supply the data?
One this you could do it loop over the database columns and dynamically
create you tables/layout this way? The problem with this could be that
your
column names arn't very user friendly. But you can code around this.
HTH.
On 30/10/06, Paul Swingewood <[EMAIL PROTECTED]> wrote:
>- see footer for list info -<
I have an application that displays school budget information every year.
The appication provides information on S52 and standards fund budgets.
http://www.bgfl.org/services/budget/default.htm
Select Schools a-z and then select a school ... You'll get the idea from
there ....
So,
The data for this system is provided each year on an excel spreadsheet.
There are approx 500 schools and boat loads of columns ......
I upload this information to an SQL database table (there is a table for
nuresery, primary, secondary and special) each of the reports for these
schools have a different layout. So I make a template for each and then
display the data. There is also a different layout for each again for an
excel view that can be downloaded. (I had to do this as the HTML differs
in
'colspans' etc for the EXCEL view) - Thats a real pain doing it twice
.....
So all works well. Then next year comes along and the grants have
completely
changed. The view is different the excel column names are different and so
the templates are different. (AGhhh) multiply this by four years (So far)
and you start to see how much of a pain this app is.
As always I get the data the day it has to go live ... Which means a real
late night getting everything transferred and re-writing the template each
time ...
Also every few months the Standards Fund changes .....
I am looking for ideas to automate this?
I am going to DEVCON and would love to talk to anyone who is interested in
this app. Its a real pain and I know there must be a MUCH better way of
doing it if my CF skills were bettter.
Is anyone else working for an LEA that provides this info ... (DFES
directive)? - How do you do it ?
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
-<
--
Nick Tong
web: http://talkwebsolutions.co.uk
blog: http://succor.co.uk
short urls: http://wapurl.co.uk
green link: http://wapurl.co.uk/?4Z2YDLX
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
