Registrants List and csv export

  • vemeth
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 1 month ago #14571 by vemeth
Registrants List and csv export was created by vemeth
Solutions?

1) I try to export in csv, but exporting is on the same column without being delimited. I want to define each column to more easily work in Excell (exemple on the image posted) [img] www.homeandlearn.co.uk/php/images/excel.jpg [img/]
2) Registrants List is limited to 4 fields (name, surname, no. Of register and data) would like to see custom fields, no data registred and if the client paid (Paid / Not Paid)

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

More
12 years 1 month ago #14581 by ooppa20
Replied by ooppa20 on topic Re: Registrants List and csv export
I totally agree, that each field should be in each column. Waiting for solution too.

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

  • vemeth
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 1 month ago - 12 years 1 month ago #14586 by vemeth
Replied by vemeth on topic Re: Registrants List and csv export
nobody has a solution or idea?
Last edit: 12 years 1 month ago by vemeth.

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

More
12 years 1 month ago #14594 by Claudia
Replied by Claudia on topic Re: Registrants List and csv export
First save the export csv
Then you have to open Excel.
Choose Data -> Text File -> choose your file in the "open dialog"
the import assistant will appear: choose delimiter seperated list and possibly utf-8 as encoding
in the next step choose "," as the correct delimiter

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

  • vemeth
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 1 month ago #14626 by vemeth
Replied by vemeth on topic Re: Registrants List and csv export
Thanks for export to Excel.
I need to see Registrants List like this one.
It is possible to do so?
Attachments:

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

Moderators: Tuan Pham Ngoc