Doesn't work Automatic action "Import XLS/XLSX products"
Good afternoon,
I set up the automatic action "Import XLS / XLSX products", the action works, but nothing happens - there is also no information about the result in logging.
https://owwa.crm-onebox.com/admin/auto/action/hour/edit/
The goal is to pull the url and id of the product from the site into the products.
Tell me what am I doing wrong? How to achieve the goal in another way?
Original question is available on version: ru
I set up the automatic action "Import XLS / XLSX products", the action works, but nothing happens - there is also no information about the result in logging.
https://owwa.crm-onebox.com/admin/auto/action/hour/edit/
The goal is to pull the url and id of the product from the site into the products.
Tell me what am I doing wrong? How to achieve the goal in another way?
Answers:
If you click on the "Check file exists" button, you will get an error that the file does not exist or is empty.
If you now go to the specified path /var/files/1/ab__product_feed_export/ - there is no specified file there - there are only files:
ab__pfe_4_googleowwa.csv
ab__pfe_5_owwaerc.xml
ab__pfe_6_owwafacebook.csv
ab__pfe_7_oneboxurls.csv
ab__pfe_7_test.csv
cs_cart_onebox_cs.xml
If you now go to the specified path /var/files/1/ab__product_feed_export/ - there is no specified file there - there are only files:
ab__pfe_4_googleowwa.csv
ab__pfe_5_owwaerc.xml
ab__pfe_6_owwafacebook.csv
ab__pfe_7_oneboxurls.csv
ab__pfe_7_test.csv
cs_cart_onebox_cs.xml
20.11.2020, 17:34
Original comment available on version: ru
Maxim, the file is generated once per hour and onebox takes it from the folder when the script is launched (screen in attachment). The question is why the fields specified in the action are not recorded and there is no information in the logs?
20.11.2020, 21:01
Original comment available on version: ru
Andrey wrote:
The question is why the fields specified in the action are not recorded and there is no information in the logs?
In order for me to provide an answer to this question, I needed to see the file on FTP and parse its contents. There was no file - which I pointed out to you.
Now I have disabled the deletion of the source file - as soon as it is unloaded, I will analyze it and give you an answer.
23.11.2020, 14:33
Original comment available on version: ru
Andrey wrote:
Maxim, the file is already available.
You have some problem with the file - it is not readable by PHP.
But if you save it in the editor (I tried it through LibreOffice), it becomes readable and parses it.
If this file is uploaded by some third-party software - I recommend that you contact its developers, maybe there are some problems in uploading - that the file is supposedly XLSX, but in fact it is not.
23.11.2020, 15:38
Original comment available on version: ru
Maxim, yes, the file is generated through a Python script, the openpyxl library. Tell me, is there a log somewhere to see this error so that I don’t bother you every time I update the file?
23.11.2020, 15:43
Original comment available on version: ru
Andrey wrote:
Maxim, yes, the file is generated through a Python script, the openpyxl library. Tell me, is there a log somewhere to see this error so that I don’t bother you every time I update the file?
This is a third party php class for reading XLSXReader - as far as I can see it does not log data.
My answer was given to you based on attempts to read your file and the resaved one.
24.11.2020, 14:30
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
