Categories
View Replies (5)

Resolved Problem when exporting from FastSeller

  1. alex_volhov
    alex_volhov
  2. RO CSVI
  3. Monday, 15 February 2016
  4.  Subscribe via email
Very much I ask to help to understand.
There was a problem when exporting from FastSeller.
CSVI of version 6.5.2, the CSVI base are updated (Maintenance-Maintenance, Maintenance-Update available fields) too.
Two absolutely identical templates of export for different types of goods are made.
But in export attempt one type of goods (old) is exported, the second (is recently added) - No.

Besides, I adjusted downloading of the file of export, it doesn't happen, it turns out to send to e-mail only.

The screenshot of a mistake is applied, a log file too. Text of a mistake:

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `kma33_fastseller_product_type_2`.`interior_watches_alarm` AS `interior_watches' at line 1 SQL=(SELECT , `kma33_fastseller_product_type_2`.`interior_watches_alarm` AS `interior_watches_alarm`, `kma33_fastseller_product_type_2`.`interior_watches_calendar` AS `interior_watches_calendar`, `kma33_fastseller_product_type_2`.`interior_watches_function` AS `interior_watches_function`, `kma33_fastseller_product_type_2`.`interior_watches_istochnik_energii` AS `interior_watches_istochnik_energii`, `kma33_fastseller_product_type_2`.`interior_watches_korpus_material` AS `interior_watches_korpus_material`, `kma33_fastseller_product_type_2`.`interior_watches_mayatnik` AS `interior_watches_mayatnik`, `kma33_fastseller_product_type_2`.`interior_watches_mechanizm` AS `interior_watches_mechanizm`, `kma33_fastseller_product_type_2`.`interior_watches_pogoda` AS `interior_watches_pogoda`, `kma33_fastseller_product_type_2`.`interior_watches_sposob_pokaza` AS `interior_watches_sposob_pokaza`, `kma33_fastseller_product_type_2`.`interior_watches_strana` AS `interior_watches_strana`, `kma33_fastseller_product_type_2`.`interior_watches_style` AS `interior_watches_style`, `kma33_fastseller_product_type_2`.`interior_watches_tsiferblat_tsvet` AS `interior_watches_tsiferblat_tsvet`, `kma33_fastseller_product_type_2`.`interior_watches_tsifri` AS `interior_watches_tsifri`, `kma33_fastseller_product_type_2`.`interior_watches_type` AS `interior_watches_type`, `kma33_fastseller_product_type_2`.`interior_watches_wood` AS `interior_watches_wood` FROM kma33_fastseller_product_type LEFT JOIN kma33_fastseller_product_product_type_xref ON kma33_fastseller_product_product_type_xref.product_type_id = kma33_fastseller_product_type.product_type_id LEFT JOIN kma33_virtuemart_products ON kma33_fastseller_product_product_type_xref.product_id = kma33_virtuemart_products.virtuemart_product_id LEFT JOIN kma33_fastseller_product_type_2 ON kma33_fastseller_product_type_2.product_id = kma33_virtuemart_products.virtuemart_product_id WHERE kma33_fastseller_product_type.product_type_id IN (2) )
0
Responses (5)
rolandd
rolandd
Accepted Answer Pending Moderation
Ah, that is clear. Some people need to run the export twice for some reason to get the file and after that it exports always. If that is not the case for you, can you check if you get any JavaScript errors?

The article Using Firebug to analyze problems will explain how to check this.
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. # 1
alex_volhov
alex_volhov
Accepted Answer Pending Moderation
On the contrary.
If I choose Source-Destination-Email file, the file comes to mail. Everything is great.
But if I choose Source-Destination-Download, there is no loading of the file via the browser. It is a problem.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Alex,

Glad to hear the export runs good now.

I am unclear as to what the other issue is you have with the export. Do you mean the export file is not send to you via email? If so, have you filled in all the fields on the Email tab? On the File tab did you set the export to Email?
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. # 3
alex_volhov
alex_volhov
Accepted Answer Pending Moderation
It's cool! Export happens without mistakes.
As for loading of the file of export on the computer, last time I adjusted at the same time and sending for e-mail, and loading of the file (as loading didn't happen).
For an example now I adjusted only loading of the file and I send you the log:
Attachments (1)
com_csvi.log.60.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Besides, I adjusted downloading of the file of export, it doesn't happen, it turns out to send to e-mail only.

The debug log says the file source is still in Send to email, Please try to change it to Download and try export, don't forget to save the template.

As of the error, Please try loading the attached patch file and run the export again.


patch_fastseller_2016-02-16.zip
Attachments (1)
patch_fastseller_2016-02-16.zip
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. # 5
  • Page :
  • 1


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