5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Can this be done?

by digichik
4 replies
I'm building a website for a family member, I okay with design and marketing; however, he wants to be able to update info on his computer and automatically have the information change a chart on his website. I don't see how it can be done, but then again I'm not a programmer. This is probably a shining example of why one should not work for family members. I'm using Wordpress to build the site.

This is what he asked to have done:

"One page will be for our housing stats page and needs to have MS Excel charts posted on it that can be updated, by updating the underlying MS Excel spreadsheets. The page currently has static charts that are just cut and pasted in. I want to be able to just update the excel spreadsheet and have the charts displayed on the page be automatically updated."
  • Profile picture of the author ericbryant
    You could do this with Microsoft tools like Sharepoint. Or you could do it with an auto-FTP program that autouploads the XLS files to the website on a set interval. I've used WS_FTP_Pro from Ipswitch to do this in the past. Then all you have to do is set up the website to post the sheets, and every so often they refresh (update) in the background. You can do it once a day or once an hour or whatever you want.

    Hope this helps!

    Eric
    Signature
    www.CoreZero.com
    - Social Media Marketing Strategy & Consulting
    - Custom Wordpress Website Design & Blogs
    - Wordpress Speed Demon? Click Here!
    - Live the life you love... now!
    {{ DiscussionBoard.errors[5083977].message }}
  • Profile picture of the author eminc
    For synchronization, you can use a SFTP setup from the local computer, where it will sync the local directory contents (from your home PC) to the server, every x hour/minutes/seconds.

    I think the best thing that can solve the purpose is Google Chart APIs (Google Chart Tools - Google Code). It can create a chart's code for you. With some programming, you can fetch the data using a Google spreadsheet. This way, you can update the Google spreadsheet whenever you are making the changes, and it will automatically reflect on the chart. So you don't have to worry about synchronization of the excel file everytime.


    Mohit
    Signature

    The best way to predict future is to create it ― Abraham Lincoln

    {{ DiscussionBoard.errors[5095581].message }}
  • Profile picture of the author PacMan99
    I think it can be done..
    {{ DiscussionBoard.errors[5097697].message }}
  • Profile picture of the author Iain Key
    Yes Google Chart is really easy to use, even for non-coders
    {{ DiscussionBoard.errors[5113171].message }}

Trending Topics