Jump to content

Best Way To Import Data To Pages

Songstuff
Songstuff
in Technical Problems

Featured Replies

Posted

Hi

I have about 10,000 rows of data, currently stored within an xl spreadsheet. I want to create a Pages database to host this data.

What is the best way to get this data into Pages? Last time I checked only the database structure could be exported and imported.

If there is no suitable solution, does anyone know if invision are planning on releasing a solution for this? Am I overlooking any options?

If not... then I think I will need to implement the database within other software and then call out to that  from within pages. Not ideal, but I need a solution.

Cheers

John

  • Insert one item in to your pages database.
  • Look at the cms_databases table in your site database and identify the database_id for your pages database.
  • Look at the cms_custom_database_X (where X = that database id) table and review the content, and how it is populated.
  • Take that structure and mirror it in your excel spreadsheet (titles etc)
  • Use the Import -> CSV functionality in phpmyadmin to import the csv file in to the table.

It's how I've populated over 100 years worth of football league tables in to a pages database - approximately 20,000 records.

    • Author

    Excellent! Many thanks Nathan. You're a star ^_^

    No worries - in the event that you are using categories, then you can cross check their ids in the cms_database_categories. The 'category_database_id' is your link to the database_id from earlier.

    • 3 months later...
    • Author

    Just wanted to get back to this... and say thank you Nathan. Your advice worked brilliantly. 10,000 records now in my pages database!

    Now I just need to sort out a search based upon the contents of one of some of the fields and it will be sorted. ^_^ The current search is close, but as it is a feature I think search on the page in question will look better...

    anyway, many thanks!

     

    • 4 years later...

    @Nathan Explosion I know this is a really old discussion, however even after all these years I just wanted to say thank you 🤗
    I have an XML dump with around 2.3 million lines of text I was trying to work out how to import to a new Pages database, your response above has helped 🙂

    Go to topic listing

    Recently Browsing 0

    • No registered users viewing this page.