Custom Export

I have need of a custom export defined herein.

Ideally, the export would be launched from a button in the Joomla Admin backend, and placed next to the button that launches the Invoice.

My export needs to include only a few fields from the jos_hikashop_order_product table, namely the order_product_code and order_product_name fields. But, it would be nice to be able to configure which fields from the order are needed for the custom export. This custom export is basically the product list portion from the Shipping Invoice that is already available from within the order.

The selection for the export is the particular order record that the user is in.

The export should contain a row for each product in the order.

The export will be used by a spreadsheet program in order to merge to labels so that we have a label for each product in the order.

Is this export/feature something that you could add to the product? Or a custom piece of work that you could give me a quote on?

Thank you,
Marcy

Thanks for your quick response. Placement a button isn't really that critical, only that a button be available to launch the export from within the order.

The fields we need are the product code and the product description for each item in the order.

Thx again!

Just a plain csv file with the two fields. We'll be using it to merge with a ms word template. I'll try to send a file layout in a bit

Hello how are you?

In the "Order" CSV export it's clearly obvious the information in not understandable. I only need 2 columns "Name and Email". How can this be configured? I attached a file showing what our export looks like.

• The columns are not deleting
• The same information is repeated in all
• The Export does not include the persons first and last name

I guess I'm doing it wrong. I'll check it out.

"The columns are not deleting" - make sure you save the file before editing. If it is not saved it wil be read only.

I just opened the file and all looks good. Try using "Open Office Calc" program. It is much better for working with csv files. And when you open it, select the correct seperator (: or ,) and correct delimiter ( " )

Open Office : www.openoffice.org/

sambob wrote: "The columns are not deleting" - make sure you save the file before editing. If it is not saved it wil be read only.

I just opened the file and all looks good. Try using "Open Office Calc" program. It is much better for working with csv files. And when you open it, select the correct seperator (: or ,) and correct delimiter ( " )

Open Office : www.openoffice.org/

It was the first trick I learned...

I now use OpenOffice for import and export, but use excel for data manipulation/generation, including auto generation for meta descriptions & titles.

Once you get the hang of csv import/export, the whole world of Hika opens up.

I guess my point is that a user should not have to go through that. The CSV presentation should be very simple for everyone to read or configure the columns. I guess Hikashop is leaving that part of the work to us. It just seems incomplete for such a good product.

It kinda the same for any cvs import/export content (Hika, virtu, Joomla, even myphpadmin)

Eveyone is at different levels and that is where forums come in... we learn and then pass it onto others.

For me a good product comes down to not only the functionality of the product but how easy it is to get assistance. Hikashop does both pretty well.

True, functionality is important. I guess that the CSV files from other components are laid out in a readable format.

Yep, that is the beauty of CSV.

Hello,

I have your bussinesoption and everything is working fine. However our company wants to use a different sending method. For this we need a csv. file send with each invoice. Or another option would be to get another e-mail with the orders in a cvs. file after the order is confirmed.

I would prefure the last option. Now i know you can download a cvs.file in the backend yourself. However we want this to go automatic after each order, and that this will be e-mailed to us. Is this possible? What do we need to do for this?

Hello Jerome, Thanks for your anwser, I took a look at the massaction and i read this:

Actions

Export a CSV file : You can export the elements in a CSV or XLS file. Besides, you can define or not a path for this file. When a path is set, the file will automatically be saved in the specified folder. If you let the path empty, it will display the browser download bos to let you select an action, display, or save.

So imagine i make a massaction for exporting a CVS file for each product that is orderd that day. Is it possible to send this file by adding a special code in the path?