Export Customer Info

-- url of the page with the problem -- : greatconjunctionexpo.com
-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.4.35

Hi, We are using Hikashop Business for event registration and we need to export lists of attendees, with addresses and custom fields. I have been looking at the Reports options but nothing seems to fulfill our needs. Is there a way to export that information?

Thanks!

Hi,

You have an "export" button on the orders listing which will give you a CSV with all the data of all the orders, including the addresses and custom fields.

Thanks!

For some reason the export file is messed up when anyone puts a hard return in a cusom field text area. We are asking people to tell up a little bit about themselves and if they use multiple paragraphs the export file counts every return as a new row. Is there any ware to correct this other than editing every entry?

PM me for an example of the export file

JohnMichael wrote: I have attached an example of the export file

I am pretty sure it's NOT a good idea to put this file onto a public forum...

EDIT: Ok, the file has been removed. Good thing.

Hi,

That's probably because of your CSV reader.
HikaShop shouldn't have any problem with return lines, but CSV readers might not all support them.
Try to open the CSV with LibreOffice calc and it should display fine (it does on my end).