1. jcsl
  2. RO CSVI
  3. Friday, 10 September 2021
  4.  Subscribe via email
I have the following problem when trying to run an import template for my website https://prodromosk5.sg-host.com/. I run through ssh with command : usr/local/php73/bin/php-cli /home/customer/www/prodromosk5.sg-host.com/public_html/administrator/components/com_csvi/helper/cron.php --key="gfXiQnLwngZQgufauwPaitC9" --template_id=1

See attached screenshot of error towards the end of the log file and also I attached the log file.
Attachments (2)
Accepted Answer Pending Moderation
Hello,
Things seem to be working OK :D ... and the isis template issue did not show. Probably something to do with the beta version. Now the processing finished and everything looks fine

Glad to know that import finished without any problem.

However can you explain why it says Products Incorrect: 7561

Looked into your site to see the incorrect message in log details page after import and it is that thumbnails are not generated for 7561 products. See attached screenshot.You need to change setting in import template as shown in the message to solve this error.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Things seem to be working OK :D ... and the isis template issue did not show. Probably something to do with the beta version. Now the processing finished and everything looks fine ... However can you explain why it says Products Incorrect: 7561

Use --help to see the help information
Processing started...
Template JCSL Import from XML
Processed 5572 lines
Total Result Status
Categories Added: 42
Category translations Updated: 42
Medias Added: 8952
Medias Updated: 10027
Product media relations Added: 8958
Product media relations Updated: 10021
Product prices Added: 2773
Product prices Updated: 2780
Product translations Updated: 5553
Products Added: 2772
Products Incorrect: 7561
Products Updated: 2781
Products Skipped: 19
Import has finished
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Since you have moved back to RO CSVI 7.20.0 version, there was an issue with combine rule when nodes are of same name. A patch file was sent to you in the post here. Please try import with the patch file and let me know on how it goes.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
No images are combined either !!:(
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Just to make sure everything works as it should. I exported templates from furnishop.cy ( these templates work fine there ) and on the same version of csvi.The rules show to be created correctly and the all csvi plugins are enabled.
I ran the template and see preview and the categories do not combine.

Please advise.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Import now runs without previous isis tempalte error.

Your import file keeps changing? In this import total products seems to be 5553 and the count was different in your previous posts.

It finishes ok but it does not create subdirectories ( it puts everything as fist level directory ) . It seems as if combine rule is not working ?

In import preview page, do you see the categories combined? If the rule does not work then import preview will not load the correct category_path. Also check if combine rule plugin is enabled. By default rules are disabled in RO CSVI on new installation.

Also it only imports very few products and gives the following output. Error log attached.
Products Skipped: 19
Products Added: 5508
Products Incorrect: 2248
Products Updated: 45

Log shows 5508 products are added and 45 products are updated. Checking the import on your site shows 19 products which are skipped does not have SKU in import file and hence skipped. The 2248 products which shows incorrect are because thumbnails were not created. The error for these incorrect product is copied from your site is pasted below. I see there are 5508 products in VirtueMart in your site. May i know what you mean by only few products are imported?


Cannot create thumbnail because the thumbnail is bigger than the maximum size set for creating thumbnails. The maximum width is set to 1300 and the maximum height is 1300 but the image has a width of 1499 and a height of 1500. To change these settings edit your import template and go to the Image tab and make sure the advanced button is clicked to show these options. You can change the Maximum width resize and the Maximum height resize.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Import now runs without previous isis tempalte error. It finishes ok but it does not create subdirectories ( it puts everything as fist level directory ) . It seems as if combine rule is not working ?
Also it only imports very few products and gives the following output. Error log attached.

Total Result Status
Categories Added: 115
Category translations Updated: 115
Medias Added: 5553
Product media relations Added: 5553
Product prices Updated: 45
Product prices Added: 5508
Product translations Updated: 5553
Products Skipped: 19
Products Added: 5508
Products Incorrect: 2248
Products Updated: 45
Import has finished
baseos | u98-seyse40c8bl0@c5761.sgvps.net:~/www/prodromosk5.sg-host.com/public_html$
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
Processed 5567 lines

Thank you for the import and debug log. The debug log shows same error but the number of lines imported was 5567 lines than last time with 5478 lines. I don't think there is any problem with import file or import but i am guessing that server is closing the connection after the long import time.

I have unistalled the beta version and installed the 7.2 version. Trying again to perform import... will let you know if this works ok.

Ok let us know on how that goes.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
I have unistalled the beta version and installed the 7.2 version. Trying again to perform import... will let you know if this works ok.
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
I got the same exact error... see error log and below the repsond from the ssh shell

baseos | u98-seyse40c8bl0@c5761.sgvps.net:~/www/prodromosk5.sg-host.com/public_html$ /usr/local/php73/bin/php-cli /home/customer/www/prodromosk5.sg-host.com/public_html/administrator/components/com_csvi/helper/cron.php --key="gfXiQnLwngZQgufauwPaitC9" --template_id=1
Use --help to see the help information
Processing started...
Template JCSL Import from XML
Processed 5567 lines
Total Result Status
Could not find template "isis".

error Log file is 120MB so I can not upload. Please login to my site and download it.
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
I have started the import ... will let you know as soon as It finishes and send you the log.
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
Processed 5478 lines

Import stops at 5478 lines so i was trying to find if there is any problem after 5478 lines in import file. I tried to run the part of import file with few records before and after line 5478 from XML and it seems to go without any issue. Can you please make the debug log entries as 6000 records and run the import again? That will get us details on import in the debug log. To increase the debug log entries, go to RO CSVI Templates page click on Options button on the right, on Site tab set Number of lines in log file field to 6000, save the configuration. Run the import and send me the debug log.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
and the error is towards the end.
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
No it takes about 4 hours to complete
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
Thank you for the template. I did start the import on my local test site using cron and in last few hours around 500 products are imported. Looks like it is going to take quite a lot of time in importing 5000+ products. As of now there is no error and import is still running. Is it the same file imported in previous RO CSVI version and takes less time?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Please find attached the backup of the template... note it has rules which can be found by login to the site ( credentials already sent ).
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,
1. Template runs well on same server but another website .. Only difference is the version of the csvi. In the configuration with the problem we are running the latest csvi configuration.

In such a case, can you please send us the template XML and import file to check? We will run the import on our test server with RO CSVI 8.0.0 version and see if we can reproduce the error. You can go to Templates list page, select the import template and click on Backup templates button to get backup of the template. You can post it here.

2. I have attached the server log in the previous post... Iam attaching once again.

Our messages overlapped. The log you posted is the access log but the real error is written to the servers error log. The access log has no details on errors and it only tell us which URL has been accessed with the status. If you can check the error log that would be helpful.

Question: If I install a previous version of csvi over the latest version will that work or do I need to un-install and install again ?

We recommend you to uninstall and install the needed RO CSVI version. Writing on top of latest version may create conflicts but before doing that send us the template and import file as requested and we can see if we can find the actual error.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hi Tharuna....

1. Template runs well on same server but another website .. Only difference is the version of the csvi. In the configuration with the problem we are running the latest csvi configuration.
2. I have attached the server log in the previous post... Iam attaching once again.

Question: If I install a previous version of csvi over the latest version will that work or do I need to un-install and install again ?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello,
Also please note that the same template runs well with older version of the csvi ( that is in another configuration of another website).

As you said the template runs on another configuration so there is something on this server which is stopping the import. Are you seeing this problem after RO CSVI Update?

I have ran the import for you, the process was not terminated and it ran for about 3 hours. In the end it returned the following error:

We understand there is an error on import but without the actual error it is difficult for us to help.

Since it is application related issue and no server errors or limitations were encountered in the process, my recommendation is to contact your website developer to resolve the application issue and then the import should be able to complete successfully.

The actual error will tell us if it is application related issue or server related issue. There should be details on what the actual error is in server error logs. If you can send us the error logs we can check for the error.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Sending you also server log on the relevant date that the template was run if you think that might help.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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