Songstuff Posted April 1, 2016 Share Posted April 1, 2016 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 Link to comment Share on other sites More sharing options...
Nathan Explosion Posted April 1, 2016 Share Posted April 1, 2016 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. The Old Man, Hunter Lyons, opentype and 6 others 8 1 Link to comment Share on other sites More sharing options...
Songstuff Posted April 1, 2016 Author Share Posted April 1, 2016 Excellent! Many thanks Nathan. You're a star Link to comment Share on other sites More sharing options...
Nathan Explosion Posted April 1, 2016 Share Posted April 1, 2016 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. Songstuff 1 Link to comment Share on other sites More sharing options...
Songstuff Posted July 3, 2016 Author Share Posted July 3, 2016 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! Nathan Explosion 1 Link to comment Share on other sites More sharing options...
jaeitee Posted September 5, 2020 Share Posted September 5, 2020 @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 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts