Categories
View Replies (22)

Resolved Export VM Costum Fields

  1. krt
    krt
  2. RO CSVI
  3. Tuesday, 03 February 2015
  4.  Subscribe via email
Hi RolandD

CSVI Pro 5.2 in Joomla 3.3.6 (Virtuemart 3.0.2) PHP 5.4.32.

I made my template for export VM orders. Now i like to have in my CSV File the custom files. How i do it?

I have add the product_attribute field; now i have this warning in the CSV File:
<b>Warning</b>: Invalid argument supplied for foreach() in <b>../../../administrator/components/com_csvi/models/com_virtuemart/export/orderexport.php</b> on line <b>597</b><br />
0
Responses (22)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The product_attribute is the correct field. Have a look at the patch I posted. Apply this patch to your system and if it doesn't work, post a screenshot of how your product_attribute looks like in the database.
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
krt
krt
Accepted Answer Pending Moderation
ok i have tried:

here the Warning in the CSV:

<b>Warning</b>: Invalid argument supplied for foreach() in <b>/../../../administrator/components/com_csvi/models/com_virtuemart/export/orderexport.php</b> on line <b>607</b><br />
Attachments (1)
screenshoot.jpg screenshoot.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Not a screenshot of the error, but a screenshot of your database with the product_attribute field, so we can check how your data is stored.
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
krt
krt
Accepted Answer Pending Moderation
Hope ok
Attachments (1)
db_2015-02-03.jpg db_2015-02-03.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

That does not show the content of the product_attribute field. On that page, click on Anzeigen and find the column product_attribute and make a screenshot of that. So we can see what is actually in that field.
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. # 5
krt
krt
Accepted Answer Pending Moderation
...mmmm i just found the colum costomfield_value in the tabel jos_virtuemart_product_customfields.
Attachments (1)
db_2015-02-04.jpg db_2015-02-04.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
That is another field, not used by the order export. Any custom options are stored in the product_attribute field when the customer places the order.
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. # 7
krt
krt
Accepted Answer Pending Moderation
..so is it not possible to export the option from the order?


ok i found the tabel: jos_virtuemart_order_items
Attachments (1)
costum_fields-1.png costum_fields-1.png
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
..so is it not possible to export the option from the order?
I can't answer that because I still have not seen a screenshot from your database showing me the product_attribute field. If you can post here the exact value that is in that field, then I can give you an answer.
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. # 9
krt
krt
Accepted Answer Pending Moderation
here it is
Attachments (2)
db2.jpg db2.jpg
vm.jpg vm.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 10
rolandd
rolandd
Accepted Answer Pending Moderation
That screenshot says a lot, there are product_attribute entries that are essentially empty. It only has the [] value in it. Attached is a patch you can load and see if the order export runs without error.
Attachments (1)
patch_orderexport_20150204.zip
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. # 11
krt
krt
Accepted Answer Pending Moderation
no warning but empty. Thanks for your help
Attachments (1)
leer.jpg leer.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 12
rolandd
rolandd
Accepted Answer Pending Moderation
Well that is a step forward, that it no longer errors out. Can you post your debug log so I can see what happened 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. # 13
krt
krt
Accepted Answer Pending Moderation
mmm ok i have the "Joomla!-Debug-Konsole" after i have klicked on Process to export my csv, i get a lot of information in the "Datenbankabfrage" how can i post it for you?

in the exported csv, i get this warning:

<b>Warning</b>: mysqli_result::fetch_object(): Couldn't fetch mysqli_result in <b>/../../../administrator/components/com_csvi/helpers/csvidb.php</b> on line <b>32</b><br />
  1. more than a month ago
  2. RO CSVI
  3. # 14
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Not the Joomla Debug but the CSVI debug log as explained at the top under
Where to get the debug information?

A tutorial (http://www.csvimproved.com/frequently-asked-questions/390-how-to-collect-debug-information) has been written to help you collect your debug information.
. This is a zipfile you can download from the Log details.
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. # 15
krt
krt
Accepted Answer Pending Moderation
I set the Collect debug information to "YES": After the Import or Export, click on Show Panel. But where is the "Show Panel" to download the zip file in Joomla 3?
  1. more than a month ago
  2. RO CSVI
  3. # 16
rolandd
rolandd
Accepted Answer Pending Moderation
But where is the "Show Panel" to download the zip file in Joomla 3?
Go to Logs and open the details of your last export. There is a Download log link. Do you see that?
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. # 17
krt
krt
Accepted Answer Pending Moderation
here it is ;)
Attachments (1)
com_csvi.log.1423064795.zip
  1. more than a month ago
  2. RO CSVI
  3. # 18
krt
krt
Accepted Answer Pending Moderation
in my export csv Field name "product_price_total" is the cent Price not die Euro? 10880 instead of 108.80!
Attachments (1)
product_price.jpg product_price.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 19
rolandd
rolandd
Accepted Answer Pending Moderation
"product_price_total" is the cent Price not die Euro? 10880 instead of 108.80!

That is because you haven't set any price decimals in the template.

As for the empty field, that product_attribute is a crazy field !! Attached is a patch that will deal with your export. You can load this patch file and you should be good to go.
Attachments (1)
patch_product_attribute_20150204.zip
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. # 20
  • Page :
  • 1
  • 2


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