Imported Articles not displayed
- World Exotic Travel
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
1 year 5 months ago #7631
by World Exotic Travel
Imported Articles not displayed was created 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.
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.
Please Log in to join the conversation.
1 year 5 months ago #7634
by Daniel
Replied by Daniel on topic Imported Articles not displayed
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?
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.
- World Exotic Travel
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
1 year 5 months ago #7635
by World Exotic Travel
Replied by World Exotic Travel on topic Imported Articles not displayed
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.
1 year 5 months ago #7636
by Daniel
Replied by Daniel on topic Imported Articles not displayed
Hi,
Please create a support ticket and share the admin & FTP login credentials in it.
We'll check it thoroughly.
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.
1 year 3 months ago #7648
by seppi
Replied by seppi on topic Imported Articles not displayed
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
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.