Resolved Import Skipped

Hello,
You have set Overwrite existing data option to No, so CSVI is skipping the record without updating the record. In your template settings on file tab set Overwrite existing data option to Yes and then try the import.

Thanks - just tried that but now getting an error:

Got error -1 from storage engine SQL=TRUNCATE TABLE `#__csvi_processed`

Just tried it again, and it's now saying:

Error

Table 'realsport_36.#__csvi_processed' doesn't exist SQL=TRUNCATE TABLE `#__csvi_processed`

Hello,
The error says that there is a missing CSVI table in your database. Go to phpmyadmin, select your database and on SQL tab paste the below query and click go. Don't forget to replace #_ with your table prefix.

CREATE TABLE IF NOT EXISTS `#__csvi_processed` (

  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,

  `ukey` VARCHAR(255) NULL DEFAULT NULL,

  `action` VARCHAR(50) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) CHARSET=utf8 COMMENT='Holds temporary identifiers';

Thanks - just done that. That's now fixed, but trying to import and it's saying it's completed but nothing is shown in K2 Items or database - any ideas please?

Log file attached

Hello,
You are having id field in your import file which is not needed. If there is an id field CSVI will only do an update to a record and wont insert if its a new one. The debug log shows this is an update query. Remove the id field and try the import. That should solve your issue.

Thanks - that's working now on importing the records!

The only thing it's not doing though is importing the images?

I've made sure that the images are in the media/k2/items/src/ folder and then referenced in the import csv

In fact, I've just tried it again, and it's appearing to delete the image within the media/k2/items/src/ folder when importing

Hello,
Can you send me your sample import file and debug log to check?

Thanks, both attached (CSV file only has one line, as this was for testing as there are over 8000 content articles to import!)

Hello,

CSVI looks for the original image name located in media/k2/items/src/. In your test file this becomes the file media/k2/items/src/1HCSFinals.jpg. First thing I notice is that there are capital letters, I assume the image file does have the capitals as well in your case.

Since K2 doesn't deal with the original name but turns it into an MD5 hash based on the ID of the item, the original images gets renamed to the MD5 hash for that particular item. K2 also creates a number of thumbnails of the image and those are placed in the folder media/k2/items/cache.

The image name itself is not stored in the database anywhere, so you won't find it there.

Are you sure the image is deleted and not renamed? Perhaps you can run the import with only that 1 image in the specific folder, so you can see whether or not it is still there afterwards.

I've just tried it again and the image is now showing! when viewing the K2 item (in the backend and the frontend) and it's been renamed from the media/k2/items/src/ folder and passed through to media/k2/items/cache folder.

So it's working for 1 import, when I've tried doing it on more than 1 import it fails though to create the images?

Hello,
We would need your import file and log file to help you with your issues. As Roland said in previous post it could be problem with your image names. Kindly check it or post the required information to check.