April 1, 2016 in Technical Problems
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.
It's how I've populated over 100 years worth of football league tables in to a pages database - approximately 20,000 records.
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.
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 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 🙂
Started Thursday at 01:08 PM
Started 3 hours ago