Where In The Database is The Link Between A Joomla Article And It's Page Builder Page? - Question | JoomShaper

Where In The Database is The Link Between A Joomla Article And It's Page Builder Page?

DA

David Anthony

SP Page Builder 10 months ago

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.

0
4 Answers
Pavel
Pavel
Accepted Answer
10 months ago #178827

I can't find where the joomla articles are linked to their corresponding page builder pages

Hi. I'm afraid there is no such connection, since there is no Page Builder Pages corresponding to articles. Articles can be edited using SPPB Article Editor. This is not the same as SPPB Page creator/editor. In fact, this is just an editor like TinyMCE and it does not create separate SP pages. It works inside Joomla articles just stylizing them. Therefore, unfortunately you will have to do all the work manually, editing articles one by one.

I have to deliver a site to a client in 2 days

I think you must explain this to your client and take an additional week for work.

0
DA
David Anthony
Accepted Answer
10 months ago #178842

Thanks for your time and willingness to help me.

In any event, I figured it out. It just takes a couple minutes in the database. I can write the solution when I've delivered the work if anyone needs it.

You just have to change a couple values to bind old pages to new articles.

0
Pavel
Pavel
Accepted Answer
10 months ago #178853

I can write the solution when I've delivered the work if anyone needs it.

It would be interesting

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 10 months ago #178891

Hello David Anthony

No easy connection. I have tried to find the way. There are 3 tables associated in my findings: content, sppagebuilder, assets. But I could find the solution. I would love to know your tricks and expand my knowledge. Please share it with us in your convenient time in this thread. You can also mark as solved after posting your soluiton.

Best regards

0