Export data structure

  • Posts: 115
  • Thank you received: 3
  • Hikashop Business
5 months 3 weeks ago #325976

-- HikaShop version -- : 4.3.0

Now if I export order data with mass action I have all data from one purchase in one row. So if customer buy 1 product, there is one product column. If buys 2 products, there is two product columns. So I never know how many columns will be.
What I need is this structure:



Is this posible?

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 72791
  • Thank you received: 11102
  • MODERATOR
5 months 3 weeks ago #325985

Hi,

There is no such option in the mass action system.

Please Log in or Create an account to join the conversation.

  • Posts: 115
  • Thank you received: 3
  • Hikashop Business
5 months 5 days ago #327125

Is there any known extension to achive this?

Please Log in or Create an account to join the conversation.

  • Posts: 2050
  • Thank you received: 691
  • Hikashop Business
5 months 5 days ago #327127

Hi,

If you don't want to "mess" with it directly in phpMyAdmin (e.g. by creating a MySQL view for it), there are numerous tools on the JED for extraction and export of data from the database.
I'm using Plotalot ( extensions.joomla.org/extension/plotalot/ ) for such and other cases, as it can not only create charts and infographics but also tables incl CSV export.
However, for all of these extensions knowledge of MySQL is required for writing the database queries.

The following user(s) said Thank You: nicolas

Please Log in or Create an account to join the conversation.

Time to create page: 0.061 seconds
Powered by Kunena Forum