Categories
View Replies (8)

Resolved Export and inport content categories

  1. jjnxpct
    jjnxpct
  2. RO CSVI
  3. Thursday, 28 April 2022
  4.  Subscribe via email
I am trying to export content categories from a J3 website to a J4 website. I created an export template using these fields:
id,access,alias,level,lft,rgt,title

I created an import template on the J4 website. But after inporting the files the categories are not added. The preview does show the records OK. There is also a message telling me 8 records have been processed. There are no error messages. But when I go to the category list I do not see the imported categories.

Am I missing something?

Kind regards,
Jip
0
Accepted Answer
jjnxpct
jjnxpct
Accepted Answer Pending Moderation
Oops, sorry. I missed your comment about removing the id field. I have deleted the id filed and after that the import was succesfull. Thanks!:D
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Jip,
I created an export template using these fields:
id,access,alias,level,lft,rgt,title

You need to remove id field and add category_path and extension field along with other needed fields in Joomla categories export. Try the import in Joomla4 site with these fields. If you still have problem with import then please post import debug log to check. To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
jjnxpct
jjnxpct
Accepted Answer Pending Moderation
Hi Tharuna, thanks for getting back to me on this. I have added category_path and extension to the export. But noiw I run into a different error:

Field 'modified_time' doesn't have a default value

There is no modified_time field in the export file. But even when I do add that I still get this error.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Jip,
Glad to know that your issues are solved.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
jjnxpct
jjnxpct
Accepted Answer Pending Moderation
Attached: This is the category export file I used to import the categories.
Attachments (1)
categorieen.csv
  1. more than a month ago
  2. RO CSVI
  3. # 4
jjnxpct
jjnxpct
Accepted Answer Pending Moderation
And this is the screen after I try the article import.
Attachments (1)
2022-04-29_10-32-23.png 2022-04-29_10-32-23.png
  1. more than a month ago
  2. RO CSVI
  3. # 5
jjnxpct
jjnxpct
Accepted Answer Pending Moderation
On the import template: Do I need to create any template fields?

Edit: I found this in the documentation:

2. Since the export file has column headers which are of Joomla content table there is no need to add template fields. You can run the import directly with the export file.

So no need to set up temlate fields. Correct?
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Yes no need to add template fields as column headers in export file as same as database fields.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!