Hi Rolandd,
i can't export data from virtuemart. The log is attachet in this posting. the csv file is empty,
only the headers without any data.
Hello,
That is a very short debug log and export file. What kind of export are you doing? Can you post the screenshot of your template settings?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Here are my settings. i want to export my products.
Hello,
I see in your settings that you have set the language to Turkish and I wonder if the products are actually stored in the Turkish language tables or in English. Do you get any products if you change the language to English?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
i get no products even with english or german... the output is always the same
It seems your export stops loading the multi variant fields. Are you using any multi variant fields? Which VirtueMart version are you using?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
you are right, a have one product with multi variant in my shop.
i am using Joomla 3.4.1 and VM 3.0.8
Ok, then we are on the right track. In your ramifications, do your values have the = symbol included?
Are you running CSVI 6 beta 5?
Let me know those 2 answers and I should be able to provide you a patch.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
No i dont have this sign.
Yes i am using beta 5
I have fixed some issues with the product export as I was able to reproduce your error. Attached is a patch file you can load and after that try the export again.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
the patch didn't change anything. The result page is attached.
After doing the export i get the same result.
Can you post the new debug log after you loaded the patch? There are no errors on the screen when doing the export?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
there is no error.
Can you send me Joomla and FTP access to the site? I will check what is going on.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
i send you the login informations via pm.
thanks in advance!
Hello,
The problem has been identified, you had your database connection set to mysql but this should be mysqli. After changing that the export gives output.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Rolandd,
i get now following error can you help? İ've copied my import template, changed it to export and now i get this.
Error
Unknown column 'skip' in 'field list' SQL=SELECT `skip`, `y5xg6_virtuemart_calcs`.`virtuemart_calc_id`, `y5xg6_virtuemart_calcs`.`published` FROM y5xg6_virtuemart_calcs LEFT JOIN `y5xg6_virtuemart_calc_categories` ON `y5xg6_virtuemart_calc_categories`.`virtuemart_calc_id` = `y5xg6_virtuemart_calcs`.`virtuemart_calc_id` LEFT JOIN `y5xg6_virtuemart_calc_countries` ON `y5xg6_virtuemart_calc_countries`.`virtuemart_calc_id` = `y5xg6_virtuemart_calcs`.`virtuemart_calc_id` LEFT JOIN `y5xg6_virtuemart_calc_shoppergroups` ON `y5xg6_virtuemart_calc_shoppergroups`.`virtuemart_calc_id` = `y5xg6_virtuemart_calcs`.`virtuemart_calc_id` LEFT JOIN `y5xg6_virtuemart_calc_states` ON `y5xg6_virtuemart_calc_states`.`virtuemart_calc_id` = `y5xg6_virtuemart_calcs`.`virtuemart_calc_id` LEFT JOIN `y5xg6_virtuemart_currencies` ON `y5xg6_virtuemart_currencies`.`virtuemart_currency_id` = `y5xg6_virtuemart_calcs`.`calc_currency` WHERE y5xg6_virtuemart_calcs.published = 1
Hello,
İ've copied my import template, changed it to export and now i get this.
That is to be expected because you didn't check which fields you can use for export. The skip field is not available in export and has no use in export. So you will need to remove that field. If you did all fields, there will be more issues to be expected.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland
I'm experiencing a similar problem when attempting to export.
Unknown column 'skip' in 'field list' SQL=SELECT `skip`, `published` FROM
I'm not sure what you mean by "The skip field is not available in export and has no use in export." It does make sense, but I don't see any fields called "skip" under the template fields.
See attached.
Hello,
As for the skip field, I am going to fix it by just ignoring it all together. As for now, this can happen when you create a template with fields and later change the type of template which doesn't support certain fields.
If you remove all the fields from your template and then add them again, do you still get the skip issue?
I'm not sure what you mean by "The skip field is not available in export and has no use in export." It does make sense, but I don't see any fields called "skip" under the template fields.
You don't see the skip field in export because it doesn't exist, it is an internal name CSVI uses for unknown fields.
How does a skip field make sense? You are not going to add a field and then not export it?
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.