Categories
View Replies (3)

Resolved My import does not work what do I wrong?

  1. New
  1. mamboklaus
    mamboklaus
  2. RO CSVI
  3. Monday, 02 June 2025
  4.  Subscribe via email
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
Attachments (1)
Busnews2025.xlsx.zip
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. 2 days ago
  2. RO CSVI
  3. # 1
mamboklaus
mamboklaus
Accepted Answer Pending Moderation
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.
Attachments (1)
com_csvi.log.283.zip
  1. 2 days ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. 2 days ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


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