Resolved Issue with date format

Hello,
Created your issue as new topic as the other topic was set to resolved.

Can you tell us the RO CSVI version you have? Also tell us export details, which export operation you are using?

I exported from Joomla 3 (RO CSVI 8.11.2) using the Joomla Content Export template.
I'm importing to Joomla 5 (RO CSVI 8.11.2) using the Joomla Content Import template.

I did some data clean-up in the CSV file between export and import and imported the CSV into a Google Sheet. Then I exported back to a CSV and did some custom delimiter find-and-replaces prior to importing.

My dates look this in the import CSV:
20/05/2016 23:01:53
08/04/2024 20:14:48

Hello,
In RO CSVI template fields page you can set date format to Y-m-d H:i:s for created field. See attached screenshot. Did you try that?

Hello,
In RO CSVI template fields page you can set date format to Y-m-d H:i:s for created field. See attached screenshot. Did you try that?

Yes, on the Export settings. But my issue is with an import template. I was able to change the format of my imported dates in the spreadsheet to get it to work.

Now, however, I'm getting this error when trying to open some of the imported articles:
"htmlspecialchars(): Argument #1 ($string) must be of type string, array given"

It's only on pages that used a complex page builder using JSON. Some of those pages, not all.

UPDATE: I figured out why this is happening, but not how to fix it yet.

I am importing content into custom fields. Every article that shows this error has more than one row in the database for one particular custom field. Maybe this was due to the length of the content? I don't know why CSVI would create two entries for one field for one article, but this seems to be the common denominator.

The easy fix for this would be to delete these duplicate rows and fix them manually -- but the fields_values table has no unique ID per row, so they cannot be edited this way.

Hello,

I am importing content into custom fields. Every article that shows this error has more than one row in the database for one particular custom field. Maybe this was due to the length of the content? I don't know why CSVI would create two entries for one field for one article, but this seems to be the common denominator.

May I know the custom field type you are using in import? Also post import debug log and import file you use so I can check. To get the debug log see How to collect debug information? document.

It was the "|" as separator that split the incoming value into two records instead of one, which causes the article edit page to return an error. I found all three of them in database and fixed them there.

I tried changing beforehand the separator settings in the import template to use special characters that are more uncommon, but that didn't work, the data still split on the three pipes in my CSV.

Hello,
Can you post your import file to check? Also send us a screenshot on the issue. With the given details we cannot see the issue or understand the issue to give any solution for it.