Hello,

I need to export the product catalogue in my ADempiere instance to an spread sheet format. The fields that I want to preserve are the Search Key - Description - UDM - Product Category. How can I fufill this need?

Regards,

Did you try over the java client the Product window, list all products in grid mode and then go to File->Export ?

Vassilis

Worked flawlessly. Thank you.

This is fantastic. Is there anyway that we can get the same functionality on web UI?

Is there anyway that we can get the same functionality on web UI?

You cannot do exactly the same in the webui, but there is an way to export that works in both UI.
if you open the Product window and click on the "Report" button (as opposed to the "Print" button - which will be greyed out by default anyway in the product window)…. but if you click the report button you will get a report with just the currently selected product.  BUT, now click on the magnifying glass to bring up the search window and click the OK with no entries to get a report of ALL product (or enter any selection that you wish if you would like to restrict the export).  Now that you have a report of all products, click on the export button.  The default type is PDF but just select xls - excel from dropdown to get a file in that format.

By default this report should be of all columns in the MProduct table but you could customise the report just like any other to get an export with just the fields, in just the order you wish.  Mixed with the product search this should allow you to easily create exports in an form for any subset of data you wish.

colin

hi Colin,
you have always nice hints in the sleeve…

Mario