I want to connect joomla articles to existing page builder pages so I can use the joomla blog view to display the articles in blog format.
I need it this way because I first need to import 420 page builder pages using the bulk import feature.
The current integration forces me to create 420 articles, one by one, then enter their page builder editor from the article itself and then import their page builder JSON export, save and exit and repeat.
Also, the page builder pages created by joomla articles do not appear in the page buider list of pages in the backend, so it forces to do everything from the joomla article manager which is even more clicks.
I understand I'm probably trying to do something new, so I understand that there isn't a current solution from the admin pannel. That's no problem.
But I'm just trying to figure out a workaround to get it done from the database. I'm already snooping around inside PHPmyAdmin. I have found a few tables that look interesting but I can't find where the joomla articles are linked to their corresponding page builder pages, so I can change their ID to link them to my imported pages.
Plus I would preferably like to do it in bulk, if you could provide a mysql command please. For example, if I imported 420 page builder pages and the first one had the ID 100 in page builder admin panel, then the query would create 420 joomla articles and link them in ascending order to the page builder articles with ID 100 through 520.
Or if you could explain what tables are involved, that would certainly nudge me forward. I have to deliver a site to a client in 2 days.