CSV Export, Excel Problem

  • Resolved Phinick

    (@phinick)


    13 years, 1 month ago

    Hey 🙂 !

    I am currently strugling with the CSV export of the events manager.

    I am on following version:

    Events Manager 5.3.9
    Events Manager PRO 2.2.5

    Every time I make an export, the structure looks like that (viewed in notepad++):

    Veranstaltung : Leppner Almtrophy | 10 Jahre Jubiläum
    Wo – Gemeindeplatz Irschen
    Wann : 16/06/2013 – 09:00 – 16:00
    Reservierungen exportiert am Do 25 Apr 2013 12:08
    “Buchungsid”,”Nachname”,”Vorname”,”Geschlecht”,”Geburtsjahr”,”Mannschaft”,”Klasse”
    63,”Philipp Benedikt”,Philipp,m,1986,”Team Awesome”,Walker
    64,”Philipp Benedikt”,Melanie,w,1993,”Team Pussy”,Walker
    65,Geiler,Peter,m,1666,”Geiler Hengste”,Walker

    The Problem I am having about that?

    I am searching a way to modify that output.

    The data being seperated by an “,” instead of an “;” –
    doesn’t make Excel to view the data in a proper way:

    http://tinypic.com/r/am9v8h/4

    I am now searching for a way, to change that way of behavior in one of the php files.
    (in addition, I would also like to get rid of all the additional information like:
    “Veranstaltung : Leppner Almtrophy | 10 Jahre Jubiläum”…)

    I am 99% sure to need to fix it in this file:

    …/events-manager-pro/add-ons/bookings-form.php

    …somewhere around here:

    /*
    * ———————————————————-
    * Booking Table and CSV Export
    * ———————————————————-
    */

    I just can’t find a way to get it work.

    Any help on this, would be more than welcome.

    Thank you guys.

    All the best,
    Philipp

    http://ww.wp.xz.cn/extend/plugins/events-manager/

Viewing 5 replies - 1 through 5 (of 5 total)
  • agelonwl

    (@angelonwl)

    13 years, 1 month ago

    hi,

    seems to work fine on my test site and opening the csv using excel; can you try the following using excel

    – click ‘DATA Tab’
    – click ‘From Text’
    – open the csv file and change delimiter (if necessary)

    Thread Starter Phinick

    (@phinick)

    13 years, 1 month ago

    Thank you for your quick reply.

    Seems to work again if I change the delimiter within excel to comma.

    Must be a problem with the German Office Package that it won’t work from scratch. (I tried it on some more german versions, everywhere the same issue)

    The thing is – I was able to change that “, ” / “; ” issue about one year ago somewhere in one of the plugins php files. I just can’t find it any more within the newer version – probably the structure changed due an update.

    Why I still want to change some code if the excel delimiter workaround works as well 🙂 ?

    I would just love that everyone who opens the csv (with a german excel), doesn’t have to change anything within excel first to make it work.

    Thank you for your help so far – maybe we could find a better solution for this issue.

    Thank you,
    Philipp

    agelonwl

    (@angelonwl)

    13 years, 1 month ago

    hi,

    I found your previous post in pro forum and you edited em-actions.php and now it’s in lines 619 and 623

    e.g. fputcsv($handle, $row, ";");

    Thread Starter Phinick

    (@phinick)

    13 years, 1 month ago

    Haha thank you 🙂 !

    I just couldn’t login to my pro account any more because my license is already expired!

    Haha…what a workflow 😀

    I knew I posted somewhere the solution.

    I will give it a try 🙂

    Thread Starter Phinick

    (@phinick)

    13 years, 1 month ago

    Worked perfectly!

    Thanks for heading me to my “own” lost workflow 🙂

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘CSV Export, Excel Problem’ is closed to new replies.