Support

Home Forums Event Espresso Premium Customize exported CSV

Customize exported CSV

Posted: March 14, 2017 at 6:58 am


faeger

March 14, 2017 at 6:58 am

Hi there

Is there a way to export event-details to XLS? The CSV-file doesn’t serve any good for our event administrators, as there are no columns and the information isn’t displayed for overview-purposes… (I’m not shure if that’s proper english btw :))

I already saw, that I can customize the data that is being exported when adding a few lines to functions.php – but I still am struggling with the fact that the CSV isn’t really readable…

I’m thankful for any advice!
Cheers
Philip


Seth Shoultes

  • Support Staff

March 14, 2017 at 8:14 am

Hey there,

CSV is a file format that can be viewed using Excel, Google Docs, Open Office, etc.

For Excel 2013:

  1. Open Blank Workbook.
  2. Go to DATA tab.
  3. Click button From Text in the General External Data section.
  4. Select your CSV file.
  5. Follow the Text Import Wizard. (in step 2, select the delimiter of your text)

Hope that helps. Please let us know if you have further questions.


faeger

March 14, 2017 at 11:16 am

Hi Seth

Thanks for your answer – I’m aware of those possibilities… the problem is, that our event admins aren’t… We have event admins who just want to click and download a viewable file with no additional step to take…

Do you see my point? Is there a way to customize the export-function in terms of this?

Cheers
Philip


Lorenzo Orlando Caum

  • Support Staff

March 14, 2017 at 12:49 pm

Hi Philip,

The system cannot be changed to create an XLS file. We have tested the Registration CSV system and it opens in Excel, Numbers, Google Sheets, and Zoho Sheets.

If they are having a display issue, then I would try to find out what is causing that and then share some steps on how their workflow can be adjusted so they can view the file correctly.


Lorenzo


faeger

March 14, 2017 at 4:59 pm

Hi Lorenzo

Okay… thanks for the clarification!

Cheers
Philip

The support post ‘Customize exported CSV’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  faeger 2 years, 4 months ago ago

Topic Tags

Notifications

This topic is:
pending
Do NOT follow this link or you will be banned from the site!