Export Customer Info

  • Posts: 6
  • Thank you received: 0
  • Hikashop Essential
9 years 11 months ago #182156

-- 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!

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 11 months ago #182185

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.

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

  • Posts: 6
  • Thank you received: 0
  • Hikashop Essential
9 years 11 months ago #183056

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

Last edit: 9 years 11 months ago by JohnMichael.

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

  • Posts: 2143
  • Thank you received: 747
9 years 11 months ago #183060

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.

Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
Last edit: 9 years 11 months ago by lousyfool.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 11 months ago #183185

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).

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

Time to create page: 0.076 seconds
Powered by Kunena Forum