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 />
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
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 />
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
Hope ok
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
...mmmm i just found the colum costomfield_value in the tabel jos_virtuemart_product_customfields.
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
..so is it not possible to export the option from the order?
ok i found the tabel: jos_virtuemart_order_items
..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
here it is
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
no warning but empty. Thanks for your help
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
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 />
Hello,
Not the Joomla Debug but the CSVI debug log as explained at the top under
Where to get the debug information?
A tutorial (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
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?
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
here it is ;)
in my export csv Field name "product_price_total" is the cent Price not die Euro? 10880 instead of 108.80!
"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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks a lot for this patch, now i have the attributes :)
Where i have to set the decimals? Not in VM?
Where i have to set the decimals? Not in VM?
In CSVI in your template on the File tab (the first tab) on the right side it says Price format. That is where you can set the decimals.
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.