rfcontreras Posted February 21, 2016 Share Posted February 21, 2016 Hi all! I was able to succesfully migrate joomla articles to Pages. I'm trying to split my articles in different databases, but I can find a way to move records between databases or an export/import feature. Any clue? Thanks in advance! Link to comment Share on other sites More sharing options...
MADMAN32395 Posted February 21, 2016 Share Posted February 21, 2016 use SQL and mess with the table directly? lol >backups are your friend if you start messing around in the database directly Link to comment Share on other sites More sharing options...
chilihead Posted February 21, 2016 Share Posted February 21, 2016 You can't because each database has/can have unique fields. You'd have to alter the db as stated. Link to comment Share on other sites More sharing options...
rfcontreras Posted February 21, 2016 Author Share Posted February 21, 2016 Thanks Madman32395, chilihead, I hope an import/export feature is on the roadmap...messing with the db is possible but not been able to do such a simple thing makes me wonder if I should move my joomla to Pages! Best Regards Link to comment Share on other sites More sharing options...
opentype Posted February 21, 2016 Share Posted February 21, 2016 Why do you want to split them across different databases anyway? That’s not how it is meant to work. Categories are the way to go to separate content items of the same type. Pages databases itself are meant to hold completely arbitrary sets of fields and are therefore usually incompatible by design. Link to comment Share on other sites More sharing options...
rfcontreras Posted February 22, 2016 Author Share Posted February 22, 2016 Hi Opentype, I have astronomy data, where some records are "articles" about events, and the other records are star catalog items, each dataset have different needs, the first set is business as usual, the other set have fields like "epoch, constellation, right ascension, declination" etc.. so they're suitable to be on a different database with different fields, but right now I have both type of records on the same db. Regards Link to comment Share on other sites More sharing options...
opentype Posted February 23, 2016 Share Posted February 23, 2016 I see. You should have no problem to set this up in Pages, even your star catalog with all those special fields. That’s what Pages can do best. Your problem is that you haven’t directly built all this on the IPS platform, but converted the data from another platform as one set of “articles”. You can only manually recreate the articles in another database or you have to move them in the MySQL database directly. Link to comment Share on other sites More sharing options...
rfcontreras Posted February 23, 2016 Author Share Posted February 23, 2016 Opentype, Thanks for you reply. It's easy as moving records thru phpmyadmin ? If you have some info about moving wih sql please let me know. Thanks in advance! Link to comment Share on other sites More sharing options...
opentype Posted February 23, 2016 Share Posted February 23, 2016 Depends on the specific fields and data. I built a Pages database a while ago this way: this Emoji list. I built the database and fields in the ACP as usual and created some test records to see the results in phpMyAdmin and exported the test data. I then prepared a CSV file with the actual data to exactly match the test data. Made another test import with just a few lines and when that worked imported all 1200 records at once via phpMyAdmin. So it works in principle. Not sure if it’s right for you though. You might ask a developer if you are not familiar enough with these types of MySQL operations. You could easily screw up your database if you make mistakes … Link to comment Share on other sites More sharing options...
rfcontreras Posted March 11, 2016 Author Share Posted March 11, 2016 Sorry for the delay in my response. Your example gave me some ideas. Thanks for sharing Regards Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.