Imported Articles not displayed

More
1 year 5 months ago #7631 by World Exotic Travel
I imported articles from a Joomla 3.10.3 DB to a Joomla 4.1.0 DB.
The articles successfully imported to the DB (imported articles.jpg) but are not displayed within the app. Only the original articles that already existed are there.(native articles).

I ran Repair Tables with no effect.
Attachments:

Please Log in to join the conversation.

More
1 year 5 months ago #7634 by Daniel
Did you also choose any column for "stage_id" while importing the articles using vData Import Joomla Profile?
Since Joomla 4, you have to set another field "stage_id" of "#__workflow_association" table for Joomla Articles?

Please Log in to join the conversation.

More
1 year 5 months ago #7635 by World Exotic Travel
I didn't see anything like this in the documentation. I don't quite get it. I manually set the stage_id in workflow_associations of one of the imported articles, and it still doesn't show. Please provide detailed steps on how to import. Thanks

Please Log in to join the conversation.

More
1 year 5 months ago #7636 by Daniel
Hi,
Please create a support ticket and share the admin & FTP login credentials in it.
We'll check it thoroughly.

Please Log in to join the conversation.

More
1 year 3 months ago #7648 by seppi
Since WDM support seems not to answer this in public, here's what I found out:

This is a problem with the new workflow feature in joomla 4. If you import j3 data with the vData articles import profile (still not updated, obviously), the imported articles aren't assigned to a Joomla 4 workflow and aren't displayed after the import.

before you do the import, you can create two more fields in your joomla 3 data csv source file, for example «workflow» (value: com.content.articles) and «stage» (value: 1). Then, in the vData import profile you can then assign those two fields under the «workflow section» accordingly.

If you already did the import and can't see the articles in the backend, you can update the workflow_associations table as follows:

UPDATE `yourprefix_workflow_associations` SET `extension` = 'com_content.article' WHERE `yourprefix_workflow_associations`.`item_id` > 1007 AND `yourprefix_workflow_associations`.`extension` = '1';

instead of my ID «1007« set the ID of the first imported (and hidden) articles, so you update all articles with a higher ID.

This did the trick for me. Good luck.

Seppi

Please Log in to join the conversation.

Cron Job Starts