Categories
View Replies (3)

Resolved Product SKU do not show in Media Export

  1. gsmfastunlock
    gsmfastunlock
  2. RO CSVI
  3. Tuesday, 27 October 2015
  4.  Subscribe via email
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
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
gsmfastunlock
gsmfastunlock
Accepted Answer Pending Moderation
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`
Attachments (2)
csvierror1.jpg csvierror1.jpg
csvierror2.jpg csvierror2.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


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