Support is online

My import does not work what do I wrong? #83586

Resolved Locked mamboklaus opened this topic Monday, 02 June 2025 · 4 replies
Author

Hi, sorry, me again.
I was able to create an export from some articles from https://asiantrucker.com
to import the file to https://buses.kfuchs.eu
The file looks well, and the import seems ok, but I cannot find ay imported content.
How can I check where is my mistake?

you can find enclose a zip from my excel export file

Can you please help again?

Thanks Klaus

Support

Hi Klaus,

Your file looks fine to me as well. Please post the debug log as requested under Looking for a useful answer? here: https://rolandd.com/support/forums/ro-csvi

The debug log will tell us what is going on with the import.

Let me know how it goes.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

ahhh!
Incorrect Failure Not added. Error: Incorrect datetime value: '11/01/2025' for column buses_new.rlmia_content.publish_up at row 1

the attached log is the log from the export....

What do I have to do to arrange the date format?

Thanks.

Support

Hi Klaus,

Oh yes, the date time. Something that is easily overlooked. So the problem is that your export file contains the publish_up date in the format of day/month/year. However databases require dates to be in the format of year/month/date. Since you exported this from the other site, the easiest is to edit the publish_up field on the site where you export this file and set the Date format to Y-m-d H:i:s. After saving the change, run the export and the date should have the correct format for importing.

Let me know how it goes.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

ahhhhh - Wonderfuil, it works now. always learn something new:-)
Thanks

This topic is locked. New replies are not possible.

Log in to reply to this topic.