link the doc/excel file instead if creating web pages
We are property company and we need to update the interest rate which send by respective bank regulary, to save time, would it be ok for me to just add those document/excel files in the Link instead of updating it on the Web Pages, it is really time consuming.??? It is a normal practice???
/me would just a rename® the newest just a rrivedfromthebank® xls to say for example...
n' thennn in the page??? have the 'link' going to ...<a href="todays.xls">for just a uptodate® rates click here</a>
n' thattt way??? you just a have® to rename the 'file' n' upload it...vs having to just a change® the link in the page alll the time...
'cept doing its /mes way??? there are just a two® drawbacks...
1...the newest ...todays.xls... file would just a overwrite® the older one currently on site...
2... just a depending® on howww the viewer has their 'view xls pages' properties set??? theyyyd either a...just a view® it in the prog...orrr b...theyyyd just a haveto® download the page n' thennn open it...
sooo ifin' youre reallly wanting to give those newest rates the fastest/easiest way??? you should continue to just a change® the numbers/rates on the page itself vs having the viewer just a click® here to get the rates...
That's essentially what you're doing every time you change any page on your site.
If you don't want to lose the old one, I'd recommend creating a folder named "old" and copy each previous-day's file into that before saving the new one into the directory. Go into the old folder and change the name of it to whatever the date was if you want an archive.
Or just change the name on it before you copy the new one in.
Is this information already available in a database? If not I'd make one, and then just generate an Excel file on the fly... check out this post, it has a number of solutions to easily creating an Excel file on the fly from database information:
Guess I need to explain my problem again.
Actually my problem is very simple.
Due to the format of my excel file is not fixed and too complicated, so I can't do it as database driven page. (I know there have ways to do it, but i have no idea).
The excel file which contain the bank interest rate for buying properties are sent by banker to our sale person, and our sale person will upload the files via administration directory, the files will be replaced. If I want to present it on web page format, then I need to manually create the page and change the figure whenever there has changes.
I create Link for user to access to the file as below:
<font face="Arial, Helvetica, sans-serif" size="2"><a href="pid/pidef.xls" target="_blank">End Financier</a></font>
attched herewith the sample of my excel file
My concern is, can I do like that, is it consider a normal practise??
I really don’t understand what you’re trying to do. If you want to display the content of 1 or more cells from your excel file OR you want to display the whole workbook (that change overtime in that excel-file), then just check out the help-function in excel (contains a whole list of helpfiles on webpublishing). You can create a sheet in excel that contains only these data (that refers to data on other sheets, using a function), and display this sheet.
Of coarse this means that you need to get the excel-file updated somehow (still not clear how you’re doing that). You could do this by creating a (second), interactive, webpage (with user restrictions, so that only you can change the data in the spreadsheet. The spreadsheet will be updated, the data to display will be updated, and the users get an updated value in their browser.
I don’t think it’s good practice (but then, I don’t like spreadsheets). I’d focus on the way you get the new data, and to automatically process it. Should be easy. Storing this data in a txt or xml file and then just displaying this (using FSO) in your webpage.
I think the issue is that charon does not have access to the data other than the excel file that gets uploaded daily. It is not in a database, nor can the people that provide it be convinced to make it accessible to a database....right?
Ultimately, if the user only wants to do it one way, that's pretty much the way it has to be done.
If that's the case, I see no problem with just replacing the old files in the directory with the new one.
Having said that, I would suggest as a long-term solution to see if you can maybe provide some sort of data entry page to allow them to enter the information in, and it would be stored in a database--if that's possible.
I would totally agree with that - but first I would check to see if they could just send you a file you can easily parse (i.e. XML, .csv, etc.), and you could use some of the techniques above so all that would need to happen is someone uploads the file, or whatever, and your page is automatically updated.
Almost any company will easily be able to provide this, I would think especially a bank.
Former ASP Forum Moderator - I'm back!
If you can teach yourself how to learn, you can learn anything. ;)