1. jcsl
  2. RO CSVI
  3. Friday, 22 October 2021
  4.  Subscribe via email
Two issues

1. Please check url to see problem and advise accordingly. https://www.loom.com/share/0763147281f949e0950e591fa48fc781
2. When I try to load file from url it says it can not load file.... see url https://www.pakoworld.com/?route=extension/feed/csxml_feed&token=MTQ3MDNMUDI0Mw==&lang=el. Can you check from your local configuration if you can load file with rocsvi. Note that in browser it loads but due to the fact that it is a big file it takes more than a minute to load. Maybe server blocks it since it takes too long. Is there a way to download it locally and then take it from there automatically ?
Accepted Answer Pending Moderation
Hello,
1. Please check url to see problem and advise accordingly. https://www.loom.com/share/0763147281f949e0950e591fa48fc781

Thank you for the recording. It does explain on the issue but we do not know what is causing the problem of not reading the node values. Please send the sample of XML file and template XML to check. To get your template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select import template and download the XML file. Post the XML file.

2. When I try to load file from url it says it can not load file.... see url https://www.pakoworld.com/?route=extension/feed/csxml_feed&token=MTQ3MDNMUDI0Mw==&lang=el. Can you check from your local configuration if you can load file with rocsvi. Note that in browser it loads but due to the fact that it is a big file it takes more than a minute to load. Maybe server blocks it since it takes too long. Is there a way to download it locally and then take it from there automatically ?

Yes i see the same error when testing in my local site. In the browser the file takes quite sometime to load. When importing from URL, RO CSVI first downloads the file to tmp folder at location /tmp/com_csvi/ under folder with time and random as name something like /tmp/com_csvi/3218513032(for example). Please check the latest folder in this location to see if the file is actually downloaded.
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
1. Please find attached the files
2. The file is not dowloaded in the folder.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
1. Please find attached the files

Thank you for sending the files. In the import XML, the text on top "This XML file does not appear to have any style information associated with it. The document tree is shown below." is throwing errors and so the values are not loaded. Delete the text, save the file and check the import.

2. The file is not dowloaded in the folder.

With a post request to the URL i am getting error "SSL certificate problem: certificate has expired". We have a document explaining to solve this error here. Please check.
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
Thank you Tharuna.

1. Can you please further explain what to do ... Not sure I understood. What do you mean by "he text on top "This XML file does not appear to have any style information associated with it." where do I see that?What do you mean by "Delete the text, save the file and check the import."
2.How can I show the SSL issue to my hosting company ? Is the SSL issue with my hosting or with the hosting of the remote feed?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

1. Can you please further explain what to do ... Not sure I understood. What do you mean by "he text on top "This XML file does not appear to have any style information associated with it." where do I see that?What do you mean by "Delete the text, save the file and check the import."
Do not worry about that. The text Tharuna is talking about is a default text shown by the browser, you cannot delete that. Instead I want to ask you to do the following:

  1. Go to RO CSVI -> Analyzer
  2. Load your file in the Analyzer
  3. Run the Analyzer on your file
  4. Let us know what the analyzer shows you. That should help you to understand hope RO CSVI reads your XML file.

2.How can I show the SSL issue to my hosting company ? Is the SSL issue with my hosting or with the hosting of the remote feed?
The issue is with your hosting company because your server wants to send a request to the remote feed but this fails because your server cannot identify the remote feed because of the expired SSL. Please see the document Tharuna linked and perhaps give that link to your hosting provider, they need to update the certificate chain on the server.
Kind regards,

RolandD

=========================
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. # 5
Accepted Answer Pending Moderation
Thank you Ronald

1. I put the xml file in analyser and in Record Name I put product and press analyse... but nothing happens.

2. I will ask them to check the certificate . but How do I see the problem you saw with the certificate ... that is what I wanted to know in order to show them that there is a problem with the certificate.
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Concerning 2 above Ronald... siteground says that according to the error log the issue on ssl should be with http://www.pakoworld.com not furnishopcy.com. Can you please confirm that before I contact the company that gives the remote xml feed ?

2021-10-24 10:52:31 0 [DEBUG] Opening socket to ssl://http://www.pakoworld.com at port 443
2021-10-24 10:52:31 0 [DEBUG] HTTP response:HTTP/1.1 404 Not Found

2021-10-24 10:52:31 0 [DEBUG] Opening socket to ssl://http://www.pakoworld.com at port 443
2021-10-24 10:52:32 0 [DEBUG] HTTP response:HTTP/1.1 404 Not Found
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,

The messages you posted in your last reply are not related to the SSL problem. They just mean the image does not exist at pakoworld.com and that is an issue of the remote system.

1. I put the xml file in analyser and in Record Name I put product and press analyse... but nothing happens.
The XML feed is 17 MB and I think your server does not allow to upload such large files if you say nothing happens. You can check the upload size by going to Extensions -> Manage -> Install. Below the upload button you will see Maximum upload size: See if that is higher than 17MB, if not you need to increase your upload size in your server configuration.
Kind regards,

RolandD

=========================
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
Hello,
2. I will ask them to check the certificate . but How do I see the problem you saw with the certificate ... that is what I wanted to know in order to show them that there is a problem with the certificate.

In import template settings on Source tab, set Retrieve method as POST and click on Test URL button to see the SSL certificate expired problem. See attached screenshot. If you save the template with these settings and run the import, you can see the same error.
Attachments (2)
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. # 9
Accepted Answer Pending Moderation
Dear Ronald... the maximum upload size is 256 M and so that should not pose a problem.

Also I checked with a sample file I created with only one product in it and it still gives same error.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
1. I put the xml file in analyser and in Record Name I put product and press analyse... but nothing happens.

There is no problem in loading the attached file in Analyser in our local site. Please check the attached screenshot. Can you turn on error reporting and check if you see any error? To turn on the error reporting, go to System -> Global Configuration and on the Server tab set the option Error Reporting to Development and check the file on Analyser. Post a screenshot on what you see.
Attachments (2)
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. # 11
Accepted Answer Pending Moderation
Please find in server details login credentials to the site. I have enabled error reporting but still it gives no error. I put record name = product... is that correct ?
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
The file you sent to us, i guess you copied it from the browser. When you do that it adds the first line with plain text. See attached screenshot. If you use the file with this text, analyser does not show any records. After loading the XML file URL on the browser, right click and do save as. Download the file as XML and check that file with Analyser. You should see records with analyser. See screenshots attached.
Attachments (2)
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. # 13
Accepted Answer Pending Moderation
Thank you Tharuna... very helpful:D !
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Concerning the SSL certificate problem... the remote company from which we are trying to load the feed said that they dealt with the issue and should be fine. However when I try to load the file and test the url it says " The given URL cannot be found. " . To reproduce issue just test url before pressing preview in template "JCSL STOCK Import from XML PAKOWORLD copy"
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello,

The reason you get this message is because it takes a really long time to load the URL, RO CSVI does not wait for that. That is why you see the message that the URL cannot be found. See here the timing output of the request

time_namelookup: 0.022679s
time_connect: 0.092043s
time_appconnect: 0.247267s
time_pretransfer: 0.247382s
time_redirect: 0.000000s
time_starttransfer: 49.758753s
----------
time_total: 50.752508s
As you can see, the total request takes almost 51 seconds. Your server may timeout before the request even completes.
Kind regards,

RolandD

=========================
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. # 16
  • Page :
  • 1


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