Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 10 of 10

Thread: CMS

  1. #1
    Junior Member
    Join Date
    Jul 2012
    Posts
    2
    Member #
    32156
    Hey guys

    I've excel files with state's data, What system do i use to create websites like http://www.creditunionsonline.com/, the goal here to auto create html files by state, city, company name etc.

    Thanks
    H

  2.  

  3. #2
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,485
    Member #
    425
    Liked
    2783 times
    If there is a CMS that will do what you want, it's Joomla. But I'm not sure that they can import Excel spreadsheets.
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)

  4. #3
    Senior Member Webzarus's Avatar
    Join Date
    May 2011
    Location
    South Carolina Coast
    Posts
    3,322
    Member #
    27709
    Liked
    770 times
    If you're looking at the spreadsheet data and expecting a point and click create a website with a page for each data set .... Sorry to say, but not going to happen ...

    Now depending on how the data is actually entered... You might be better off... Exporting the data into a DB like MySQL or SQL ... Then creating a template and a series of queries that will pull the data into the template...

    But all of that is dependant on the data and it's structure.

    Excel at one time had a function to "export" as HTML... But the interlinking of page sets was abysmal at best... And downright a major pain to manage...

  5. #4
    Junior Member SimplyWebsites's Avatar
    Join Date
    Jul 2012
    Location
    Leicester
    Posts
    27
    Member #
    32160
    This is a job for a database. You could of course generate hundreds of html webpages and then publish these to your website. This could be done using a simple script however a Database solution would be much more efficient.

    I highly recommend looking at MySQL as this is a very fast and powerful SQL Database which work great with PHP.

  6. #5
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,485
    Member #
    425
    Liked
    2783 times
    I think based on the question and the fact that she said "CMS", she had already come to that conclusion...she was going to need some sort of a database to organize it and a CMS of some sort to display it. So we should probably move past that.
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)

  7. #6
    Junior Member SimplyWebsites's Avatar
    Join Date
    Jul 2012
    Location
    Leicester
    Posts
    27
    Member #
    32160
    I don't think you are going to get an out of the box solution that does exactly what you need without a bit of coding.

  8. #7
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,485
    Member #
    425
    Liked
    2783 times
    Neither do I. The data may not be formatted correctly (it's hard to say without seeing it) and the fields may not be standard.
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)

  9. #8
    Junior Member
    Join Date
    Jul 2012
    Posts
    2
    Member #
    32156
    Quote Originally Posted by SimplyWebsites, post: 238394
    This is a job for a database. You could of course generate hundreds of html webpages and then publish these to your website. This could be done using a simple script however a Database solution would be much more efficient.

    I highly recommend looking at MySQL as this is a very fast and powerful SQL Database which work great with PHP.
    Simply

    Which scipt would you reccommend?

    Thanks
    H

  10. #9
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,485
    Member #
    425
    Liked
    2783 times
    I don't think you are going to get an out of the box solution that does exactly what you need without a bit of coding.
    I think that what he means is what we've been trying to tell you...there probably isn't one. The data is too specific for "standard CMSes" (which are far more limited than they give themselves credit for) and the fields you have defined will likely be specific to the sites you have in mind.

    For example, the data I might want to list doctors might be very different than the data I might want to list auto mechanics...they're different industries and should be treated as such.
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)

  11. #10
    Senior Member Webzarus's Avatar
    Join Date
    May 2011
    Location
    South Carolina Coast
    Posts
    3,322
    Member #
    27709
    Liked
    770 times
    If I had the data already, I'd import it into a MySQL DB, use either php or asp to generate the views and navigation I wanted... If there was going to be other content I'd probably embed my views and navigation in joomla or Wordpress.... If not a whole lot of other content, then I'd just add another table to the MySQL DB and build out a template system to incorporate both.

    As previously mentioned, it's doubtful you'll find something oh of the box that can do what you want.


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 10:47 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com