Resolved Export categories and articles

Hello,
Please post the export debug log to check. To get the debug log see How to collect debug information? document.

Thanks,
The file is attached.
Kind regards
Christian

Hello,
Can you see also the attempt for another export.
Kind regards,
Christian

Hello Christian,
You don't need to use custom template to export content and categories. We have few standard templates to run these exports. You can use Joomla content export template and Joomla categories export template for these exports. You can also install example templates which comes with RO CSVI installation for Joomla content and Joomla categories and run the export.

Let me know if that helps.

Thank you for your help.
For the export of categories, yhe error has changed. Now it is :
Column not found: 1054 Unknown column 'j3x_categories.attribs' in 'field list'
It seems that the error is not in the template, but in the J3 files.

Hello,
You are still using RO CSVI custom export template to export categories and have added attribs field which does not belong to Joomla categories table and so you see the error. Use RO CSVI example Joomla categories export template to run the export. To get the template

1. Go to RO CSVI Maintenance page
2. Select RO CSVI in first option and Install example templates in second option
3. You will see list of addons. In that select Joomla Categories and click on Continue button on top corner.
4. Example templates for Joomla categories are now installed.
5. Go to RO CSVI templates page and look for templates with name Example Joomla Categories Export Migrate or Example Joomla Category Export. Use one of these templates for Joomla categories export. You can modify these templates as per your need.

Let me know if that helps.

Thank you very much.
I tested Example Joomla Categories Export Migrate and Example Joomla Content Export Migrate.
I attached three files :
- CSVI_Example Joomla Category Export_4-12-2023_16.24.csv
You can see that I obtained all the records (582).

- CSVI_Example Joomla Categories Export Migrate_4-12-2023_16.32.csv
You can see that I obtained all the records (582).

- CSVI_Example Joomla Category Export_4-12-2023_16.22_177778626_177778629.csv
You can see that I obtained no records.

- CSVI_Example Joomla Categories Export Migrate_3-12-2023_22.16_177778626_177778629.csv
You can see that I asked the records from 177778626 to 177778629, but I obtained no records.

- CSVI_Example Joomla Content Export Migrate_3-12-2023_22.38_16274_16889.csv
You can see that I obtained the last 256 records and not the records from 16274 to 16889.

- CSVI_Example Joomla Content Export Migrate_3-12-2023_22.46_16274_16633.csv
You can see that I obtained the last 256 records (from 16633 to 16889) and not the records from 16274 to 16633.

What do you advise to me ?
Thanks

Hello,
Can you also post the debug log of these exports to check? To get the debug log see How to collect debug information? document.

Hello,
I complete. Here are the debug logs.
Kind regards

Hello,
Thank you for the debug logs.

- CSVI_Example Joomla Categories Export Migrate_3-12-2023_22.16_177778626_177778629.csv
You can see that I asked the records from 177778626 to 177778629, but I obtained no records.

When you set From and To records in export template they are used to limit the records in export. Like in this case you have set From as 177778626 and To as 177778629. In this case export will Skip first 177778626 records and gets the next 3 records (177778629 - 177778626). May be you do not have so many categories and so export gets no records? It is the count and not the IDs in this case.

- CSVI_Example Joomla Content Export Migrate_3-12-2023_22.38_16274_16889.csv
You can see that I obtained the last 256 records and not the records from 16274 to 16889.

Same here export skips first 16274 records and gets next 615 (16889-16274) records out of which you must be having only 256 records which is included in export.

- CSVI_Example Joomla Content Export Migrate_3-12-2023_22.46_16274_16633.csv
You can see that I obtained the last 256 records (from 16633 to 16889) and not the records from 16274 to 16633.

Same here too. It is the count with limit and not the IDs. You need to change From and To record based on count of records.

Hello,
It doesn't work or I would like to understand.

Concerning the categories I want export the four last records only, yhat's to say records 177778626, 177778627, 177778628 and 177778629, which are the last records created. When I put "from record : 177778626" and "To record : 177778628" or "To record : 177778629" the file generated is always empty.
Concerning the content, I need to export all the records after the March 3 2023. So I start from the record 16274 and I go to the last one, now the record 16895.
When I put "From record : 16274" and "To record : 16895" the file generated contain the 262 last records, and it starts at the record 16634, never before this record.
I made another test with these parameters "From record : 16274" and "To record : 16400". I got 126 records from record 16634 to record 16759 (16759-16634=126). It's totally incoherent.
I attached the files of last test.
Thanks for your help.
Kind regards

EUREKA !!!!
I had not understood what you wanted to say.
To pointing the record 16274, I have to put "From record : 15914" and to pointing the record 16895, I have to put "To record : 16536". There is a gap of 360.
I obtained this result by trial and error.
It's not quite right. This comes perhaps from the data base.
Thank you for your help.
Kind regards