Hi, good morning guys.
In years past I have used with great satisfaction CSVI with VM 1.x and 2.x VM, but with VM 3.x I'm going crazy.
In particular I have some difficulty to add fields in the export template.
Now I have the necessity to export media from virtuemart with produtc sku, but when add "product_sku" in default template "Example VirtueMart Media export" CSV is generated without the field product_sku.
Someone can help me to solve this problem?
I added the field "file_url" in default template "Example VirtueMart Product export", but nothing, the CSVI is generated without the "file_url".
My necessity is a template with two fields:
product_sku
file_url
I'm really frustrated. Someone can help me to solve this problem?
My system:
Joomla! 3.4.3
Virtuemart 3.0.9
CSVI Pro 6.3
Regards, Alex
Hello Alex,
First you may need to check, did you install the VirtueMart add-on for CSVI 6.3? It sounds like it but just double checking.
Post your debug log for me to see what happens during the export.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland. Yes i have installed VirtueMart add-on for CSVI 6.3 (i attach files).
This is the log:
Details
Date 2015-10-27 14:35:50 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 49 lines
2015-10-27 14:35:50 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2015-10-27 14:35:50 0 [QUERY] SELECT csvi_log_id FROM bonnie_csvi_logs ORDER BY csvi_log_id
2015-10-27 14:35:52 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2015-10-27 14:35:52 0 [QUERY] SELECT csvi_log_id FROM bonnie_csvi_logs ORDER BY csvi_log_id
2015-10-27 14:35:52 0 [DEBUG] Found field product_sku but this field is not supported. Ignoring this field.
2015-10-27 14:35:52 0 [QUERY] SELECT csvi_rule_id FROM bonnie_csvi_templatefields_rules WHERE csvi_templatefield_id = 709 ORDER BY csvi_templatefields_rule_id
2015-10-27 14:35:52 0 [DEBUG] CSVI Pro Version: 6.3.0
2015-10-27 14:35:52 0 [DEBUG] Joomla! version: 3.4.3
2015-10-27 14:35:52 0 [DEBUG] PHP version: 5.5.29
2015-10-27 14:35:52 0 [DEBUG] =========================
2015-10-27 14:35:52 0 [DEBUG] action: export
2015-10-27 14:35:52 0 [DEBUG] component: com_virtuemart
2015-10-27 14:35:52 0 [DEBUG] operation: media
2015-10-27 14:35:52 0 [DEBUG] localpath: /home/gsmfastunlock/public_html
2015-10-27 14:35:52 0 [DEBUG] ftphost:
2015-10-27 14:35:52 0 [DEBUG] ftpport:
2015-10-27 14:35:52 0 [DEBUG] ftproot:
2015-10-27 14:35:52 0 [DEBUG] ftpfile:
2015-10-27 14:35:52 0 [DEBUG] export_email_subject:
2015-10-27 14:35:52 0 [DEBUG] export_email_body:
2015-10-27 14:35:52 0 [DEBUG] export_filename: media_export.csv
2015-10-27 14:35:52 0 [DEBUG] export_file: csv
2015-10-27 14:35:52 0 [DEBUG] field_delimiter: ,
2015-10-27 14:35:52 0 [DEBUG] text_enclosure: "
2015-10-27 14:35:52 0 [DEBUG] include_column_headers: Yes
2015-10-27 14:35:52 0 [DEBUG] signature: No
2015-10-27 14:35:52 0 [DEBUG] publish_state:
2015-10-27 14:35:52 0 [DEBUG] recordstart:
2015-10-27 14:35:52 0 [DEBUG] recordend:
2015-10-27 14:35:52 0 [DEBUG] export_date_format: d/m/Y H:i:s
2015-10-27 14:35:52 0 [DEBUG] export_price_format_decimal: 2
2015-10-27 14:35:52 0 [DEBUG] export_price_format_decsep: .
2015-10-27 14:35:52 0 [DEBUG] export_price_format_thousep:
2015-10-27 14:35:52 0 [DEBUG] header:
2015-10-27 14:35:52 0 [DEBUG] body:
2015-10-27 14:35:52 0 [DEBUG] footer:
2015-10-27 14:35:52 0 [DEBUG] groupbyfields:
2015-10-27 14:35:52 0 [DEBUG] sortfields:
2015-10-27 14:35:52 0 [DEBUG] use_system_limits: No
2015-10-27 14:35:52 0 [DEBUG] max_execution_time:
2015-10-27 14:35:52 0 [DEBUG] memory_limit:
2015-10-27 14:35:52 0 [DEBUG] =========================
2015-10-27 14:35:52 0 [DEBUG] Export field: file_url
2015-10-27 14:35:52 0 [DEBUG] Export field: published
2015-10-27 14:35:53 0 [DEBUG] Export query
SELECT file_url,
published
FROM #__virtuemart_medias
LEFT JOIN #__virtuemart_product_medias ON #__virtuemart_product_medias.virtuemart_media_id = #__virtuemart_medias.virtuemart_media_id
Hello,
Something is wrong in your template setup. The template action is a media export and not a product export. Go to Templates -> Template and edit this template. Under Operation set Export -> VirtueMart -> Product. Save your template and then run your export. You should get your fields.
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.