Support is online

Error on loading ICEcat index #8142

Open zifou opened this topic Thursday, 24 March 2016 · 26 replies
Author

Thank you, that did solve the problem. Now i am trying to import products using icecat, i've followed the steps that are mentionned on the tutoriel i've set up the username password and all necessary informations, but once i try to load the index files via the Maintenance tab i get the error mentionned on my screenshot, will you please tell me it's due to what?

Thank you,

Support

Hello,
Check the ICEcat index path, by default it is inside tmp/com_csvi, check if you already have ICECat files in it. If yes, try deleting them and do the import again.

Kind regards,

Tharuna

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

Author

i've deleted the file inside the folder but i'm still getting the same error.

Thank's in advance

Support

Hello,
Make sure your ICEcat username and password are correct. If you still see the error, try downloading files manually and place it in the folder specified in the ICECat indexes path and CSVI will load the index file from there. The file can be in the format of .zip, .gz or unpacked.

Kind regards,

Tharuna

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

Author

i can load these files from these url's : http://data.icecat.biz/export/freexml.int/FR/files.index.csv and http://data.icecat.biz/export/freexml.int/FR/supplier_mapping.xml ?

Support

Hello,

Yes you can once you are logged in. You can also start the update process in CSVI and it downloads the .gzip files, you can unpack them manually and upload them to the tmp/com_csvi folder. The files there have no extension. So the files are called icecat_index and icecat_supplier.

Kind regards,

RolandD

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

Author

Hello,

Thank's for you reply, i did that and now the categories and suppliers are imported but when i import a .xls file, the fields don't get updated knowing that when i do the search manually in icecat i get product details.

Can you help me?

Support

Hello,
Can you post your import file and debug log?

Kind regards,

Tharuna

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

Author

yes sure, in my file you'll find only one record since i'm just testing.

Support

Hello,
Can you also Go to settings tab >> ICEcat tab and post the screenshot of your ICEcat settings?

Kind regards,

Tharuna

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

Author

okey

  • icecat.png
Support

Hello,
Set the Use Full ICEcat in settings to No and try doing the import again.

Kind regards,

Tharuna

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

Author

Hello,

but i have access to the full icecat so i don't think it's gonna work.

Support

Hello,
Having a look at your debug log again, found that few debug log lines are missing which were added in new version. Can you update your Virtuemart addon to latest version and try importing?

Kind regards,

Tharuna

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

Author

hello,

Well my virtuemart is on date, you mean by addon an addon wich is approporiate to the CSVI component?

Support

Hello,

Yes, the CSVI VirtueMart Addon which you can find under Downloads -> CSVI Pro Extensions. Take the 6.5.5 version and there you can find the CSVI VirtueMart Addon.

Kind regards,

RolandD

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

Author

Hello,

i just updated the addon, but still i dont get product descriptions, i've attached the log file.

Support

Hello,
Please send your site administrator login details and also database details to tharuna@csvimproved.com. Would like to check on your site directly.

Kind regards,

Tharuna

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

Author

hello,

i've send you an email, did you receive it?

Support

Yes, i will check your site and post on what i find.

Kind regards,

Tharuna

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

Support

Hello,
Is your issue solved? I had sent an email asking for database login details and haven't got any reply yet.

Kind regards,

Tharuna

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

Author

Hello,

Yes, it was the icecat that was blocking the access. now i have access to products but not to all products on my catalogue. in addition to that today i wanted to test the import and it gave me this error message " Table vnkr_virtuemart_products_ has not been found. Check your database to see if the table exists " on my database schema the table is named vnkr_virtuemart_products.

Support

Hello,

now i have access to products but not to all products on my catalogue.

You can check the logs if CSVI can find your product. If the manufacturer and MPN are not found, ICEcat details won't be loaded.

on my database schema the table is named vnkr_virtuemart_products

It is not talking about the products main table but the table products language table. The message you see means that no language is chosen in your template. Edit your template and on the Options tab select the language for which you are importing.

Kind regards,

RolandD

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

Author

Hello,

okey but now when i try to access the component tab, i get a blank page ??

Support

Hello,

Blank means an error but you don't have error reporting turned on. Go to System -> Global configuration -> Server -> Error Reporting and set it to Maximum and save the settings.

Go to CSVI and see if it loads and what message you get.

Kind regards,

RolandD

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

Author

Hello,

I did what u've told me to do, and i get the errors that you can see on my screenshot

  • csvi_erro-2.png
Support

Hello,

Your installation is broken. Somehow Akeeba Strapper is no longer present on your system. Please install CSVI again (just over the existing one) to have Akeeba Strapper installed again. You should be able to see if it is installed by looking in the media folder where there is a folder named akeeba_strapper.

Kind regards,

RolandD

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

Log in to reply to this topic.