• bhavikm98

    (@bhavikm98)


    I’m trying to publish a database website, like IMDb or Metacritic. I have a big Excel spreadsheet with field names “GameTitle”, “Year”, “Genre”, “Score”, “LongDescription”, plus many more columns. I then have a thousand records (e.g. “Witcher”, “2015”, “RPG”, “80”, etc.).

    Similar to IMDb/Metacritic, I’ll need one “game page” template so that every game page is the same format, with the GameTitle as page heading and with all the related info about the title below. So, 1000 pages in the same format.

    But all the data (1000 records * 12+ columns) is already on my spreadsheet. What is the fastest way to create 1000 pages? It would be tedious to make one page > duplicate x1000 > replace each piece of info on the page manually x1000. I’m hoping there are plugins/tools/features to help with one or more of the following:

    1) Get a customisable template. If I edit the template later (e.g. change heading font), all 1000 pages get updated.
    2) Import the data quickly from my database to the page.
    3) Ideally, but not necessarily: if I update/delete a game record from the database, the game page should update/delete too. If I add a new game record, a new game page should appear.

    So far, I can upload my spreadsheet to mySQL via phpMyAdmin.

    Had no luck browsing WP plugins descriptions, YouTube, and Google – I could very well be searching with the wrong jargon or be overlooking a plugin. Surely, what I seek already exists and I just need signposting?! Any advice and recommendations are appreciated. Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • a2hostingrj

    (@a2hostingrj)

    2) Import the data quickly from my database to the page.

    Be aware that the data imported has to comply with how WordPress reads/stores data in the database.

    I would think it will take quite some time to properly import the data, unless you create a custom plugin that will display the data.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    I’d use the paid version of wpallimport (wpallimport.com). It can import anything.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to create a database website of 1000 pages quickly?’ is closed to new replies.