Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 15 of 15
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Posts
    317
    Thanks
    0
    Thanked 0 Times in 0 Posts

    link the doc/excel file instead if creating web pages

    hi,

    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???


    Please advice!

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't quite understand the situation.
    But my moto is : "code once, run forever". I almost never update the webpages content.

    I don't quite see why you shouldn't create a databasedriven webpage that displays the new data. How do you receive the data and where/how do you store them?
    (I'd set up some fully automatic proces)

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Posts
    676
    Thanks
    1
    Thanked 0 Times in 0 Posts
    cha...
    /me would just a rename® the newest just a rrivedfromthebank® xls to say for example...
    todays.xls

    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...

    just a suggestion® or two...goodluck...:O)))

  • #4
    Regular Coder
    Join Date
    Sep 2002
    Location
    Bugaha, NE
    Posts
    330
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't see one problem with that whatsoever.

    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.

  • #5
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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:

    http://www.codingforums.com/showthre...ght=excel+file
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #6
    Regular Coder
    Join Date
    Jun 2002
    Posts
    317
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hi,

    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??

    Please advice!
    Attached Thumbnails Attached Thumbnails link the doc/excel file instead if creating web pages-untitled-1.jpg  

  • #7
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

    But maybe I’m completely off.

  • #8
    Regular Coder
    Join Date
    Sep 2002
    Location
    Bugaha, NE
    Posts
    330
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  • #9
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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. ;)

  • #10
    Regular Coder
    Join Date
    Jun 2002
    Posts
    317
    Thanks
    0
    Thanked 0 Times in 0 Posts

    access and have a look!

    Thanks whammy and BigDaddy....

    For better understanding, may be your can access to my site and have a look.
    you access to http://www.setiahomes.com/contact.asp?#endfi

    and click on any od the link under the End Financier.

    This time sure you all 100% understand what I'm trying to say.

    The excel files will be upload by our Banker/Sales Person (if the bank send the file to them), and the old file will be replace.

    Thanks so much for your time.

  • #11
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I see... can't you just have them upload the file with the same filename each time, which will overwrite the existing file?

    Then you don't have to update anything.
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #12
    Regular Coder
    Join Date
    Sep 2002
    Location
    Bugaha, NE
    Posts
    330
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Lol....yeah, I think that was the question.

  • #13
    Regular Coder
    Join Date
    Jun 2002
    Posts
    676
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Originally posted by whammy
    I see... can't you just have them upload the file with the same filename each time, which will overwrite the existing file?

    Then you don't have to update anything.
    just a ^5s® there wha...n' couldnt have just a said® it betterer /meself...hehehe...ohhh waittt../me rereads her just a first® post...:O))) .../me did /me did /me did...lol...

  • #14
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    not everyone can read justamese
    I am the luckiest man in the world

  • #15
    Regular Coder
    Join Date
    Jun 2002
    Posts
    317
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hi, whammy,

    yup, first i will check if the file exist by compare thier name, if yes, the the old file will replace...how is it?? OK or Not???)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •