Resolved Division by Zero Error When Importing Articles with Gallery Custom Field Values

Hello Mangesh Mane,
I setup ACF gallery field as in your screenshot and see import stores JSON value without any problem. I don't see division by zero error. One issue I have is that missing image and that is because I don't have images saved at the given location. See attached screenshot. I did import of articles having value for multiple-images-gallery field. By default debug log has details of first 20 records. Since you are importing 95 records we will increase the log records to 95 so we get details of all records in debug log. That way we can see which article is breaking the import. To do that go to RO CSVI Config page go to Site tab and change Number of lines in log file field to 100 and save the config. Run import and send me latest import file to check.

If I disable the subform/gallery custom field plugin, the article import completes successfully, but custom field data is not saved.

I guess you are talking about Fields - ACF Gallery plugin.

Hello,
I got your screenshots of the field setup. I will look into it and get back with my findings.

Hello Mangesh Mane,

I have attached a screenshot showing the exact field configuration.

Screenshot is missing in your reply. Can you please post it? I will setup field in my test site and run import with your import file and check.

Please find screenshot of multiple-images-gallery field setup page

Hello Tharuna,

Thank you for your response.

As requested, I am sharing the gallery field setup details along with the import file and debug log.

Environment

Joomla: 6.0.2

PHP: 8.4

Server: WAMP (Windows)

RO CSVI: Latest version installed

Gallery Custom Field Setup

The field is created under:

Content → Articles → Fields

Field Name: multiple-images-gallery

Field Type: Gallery/Subform (TF Gallery Manager / ACF Gallery field)

Assigned to: Articles

Field Group: School Calendar

I have attached a screenshot showing the exact field configuration.

Import File

I am importing custom field values separately after importing articles.

The CSV contains:

alias (criteria)

category_path (criteria)

multiple-images-gallery (gallery JSON data)

Example value:

{"items":{"1":{"alt":"","source":"","image":"media\\tfgallerymanager\\tmp\\22nd_Eduleaders_Summit_original.jpeg","thumbnail":"media\\tfgallerymanager\\tmp\\22nd_Eduleaders_Summit_thumb.jpeg","caption":"","tags":""}}}


The full import file is attached.

Issue

When importing the gallery JSON field values with the gallery/subform plugin enabled, the import fails with:

Division by zero error

If I disable the subform/gallery custom field plugin, the article import completes successfully, but custom field data is not saved.

This suggests the error occurs during processing of the gallery/subform field JSON data.

Attachments

Gallery custom field setup screenshot

Import CSV file

RO CSVI debug log (as per documentation)

Please let me know if the JSON format needs any adjustment or if additional configuration is required for TF Gallery Manager / ACF gallery fields.

Thank you for your support.

Kind regards,
Mangesh Mane

Hello,

Is RO CSVI supposed to support importing gallery/subform custom fields (ACF/TF Gallery Manager)?

If you are import JSON format of Gallery field as a individual column in import file then it should import in RO CSVI.

Disabling the subform/gallery custom field plugin allows article import to complete, but then custom field data is missing.

Can you share a screenshot on how you have gallery field set up? Also post import file and import debug log to check. To get the debug log see How to collect debug information? document.