|
Scott Biddle
|
January 12, 2016 at 8:58 am
I have been using EE3 for the last year. I have created numerous events and have not had a problem with Numbers reading the excel docs. The last time I donwloaded one would have been in June.
When I open the excel doc, each registrant is individually inputed as rows, but the info they enter is all in one column. There is no way to sort through the entries without going through all of them line by line.
Just to check to see if it was a Numbers issue, I had someone send me an excel sheet to open, and it worked fine. Also, others can open the excel sheet in Excel and it works.
I am just not sure what has changed in the formatting to make it do this.
|
|
Lorenzo Orlando Caum
|
January 12, 2016 at 9:34 am
Hi Scott,
I took a look at at Excel export from one of our testing sites and I was able to open it in Numbers.
Are you on the latest version of Event Espresso 3?
https://eventespresso.com/wiki/change-log/
Can you see the contents of this file including the headings?
http://cl.ly/0X3n2E090Q2i
—
Lorenzo
|
|
Scott Biddle
|
January 12, 2016 at 9:53 am
I am using the latest version of EE3. The link you sent me did not open up correctly.
|
|
Scott Biddle
|
January 12, 2016 at 9:58 am
It is happening on both OS and iOS.
|
|
Lorenzo Orlando Caum
|
January 12, 2016 at 11:56 am
Try this link so it downloads to your computer: http://cl.ly/0X3n2E090Q2i/download/dec-18th-2016-01-12-0929.xls
I clicked the link that you shared and Cloudapp attempted to render it but it looked broken.
I’m also using Numbers (http://cl.ly/2S2S2Q1r3E3V) and I can open the file and view the contents.
—
Lorenzo
|
|
Scott Biddle
|
January 12, 2016 at 1:18 pm
That is the version of Numbers I am using as well.
This is how it looks for me.
screen shot
|
|
Scott Biddle
|
January 26, 2016 at 10:48 am
I am able to open it, but it only has one column. It is happening in both Mac OS and iOS.
|
|
Scott Biddle
|
January 26, 2016 at 10:49 am
I also went back and downloaded an excel sheet from this past summer that worked then, and it downloaded it wrong this time as well.
|
|
Lorenzo Orlando Caum
|
January 27, 2016 at 2:40 pm
Hi Scott,
I had a look at changes to the export system for Event Espresso 3 and there haven’t been any recent changes. I swapped in an export file from older versions of Event Espresso 3 and I saw the same issue.
However, when I opened in Excel, Google Sheets, and Zoho sheet the file opened fine.
The export system in Event Espresso 4 uses CSV files an opens fine in Numbers along with the platforms mentioned above.
Are you using recurring events or mobile apps for check-in for Event Espresso 3?
—
Lorenzo
|
|
Scott Biddle
|
January 27, 2016 at 3:16 pm
I am not sure what you are asking. I do have mobile app, and everyone comes up fine on it.
I downloaded Excel onto my iPad, and yet I cannot open the file in it. A window pops up that says, “Excel can’t open this workbook”.
I also tried opening in Google Sheets on my iPad and it says, “ERROR, Can’t open this file”.
I was able to open it when I downloaded it onto my computer and uploaded it to Google Drive, and open with Sheets on there, and it worked fine. All collumns were available.
I am a bit baffled.
|
|
Tony
|
January 28, 2016 at 5:09 am
Hi Scott,
Can you please email one of the excel files you have to support[at]eventespresso.com so I can take a look.
Not that if you could download a fresh copy, zip it up and send it over without actually opening it first that would be helpful. This is to make sure that no other applications change the format of the file so I can see exactly what is output from EE itself. Excel can sometimes be really ‘helpful’ and fix formats on the fly.
|
|
Tony
|
February 2, 2016 at 2:22 pm
Hi Scott,
Thank you for sending over the file.
The XLS file is formatted correctly, for me it opens up fine within MS Excel (I’m a windows user)
Can you try downloading the CSV attendee list and open that in numbers?
You can do that within the ‘actions’ section for each event – http://take.ms/CuKdT
The main differenct between the two is that the XLS file uses tabs to separate the values, the CSV uses commas, numbers should be able to understand both but it seems to be struggling.
|
|
Scott Biddle
|
February 2, 2016 at 2:39 pm
The CSV is an .exe file, which does not open in iOS.
I just can’t figure out what has changed. I was able to open XLS file on both iOS and OS in Numbers. It just isn’t making any sense. Something changed between the end of June ’15 and December ’15.
|
|
Tony
|
February 2, 2016 at 2:57 pm
CSV files should not be downloading as exe files, that may be a clue as to a bigger problem.
Do you have any security plugins installed? I’d try something like WordFence and run a scan on your site, see if it find anything suspicious.
For the downloads to suddenly stop working and files downloading as completely wrong mine types I’d say there is something more going on within your site that should be at least checked out.
|
|
Scott Biddle
|
February 3, 2016 at 9:10 am
A computer friend of mine did some research and found out that Safari is somehow changing the way that it downloads the files. I don’t understand it, but he wrote some new code into ours. This is what he did, and it made it possible to download the CSV file into Numbers. It did not fix the XLS problem of downloading with only 1 column instead of all individually, the way it is suppose to be.
To correct .exe file extension being added to .csv files from Espresso and preventing opening on Mac/iOS because of Safari’s handling of file types I edited:
/wp-content/plugins/event-espresso/includes/functions/export.php
line 136, changed content type from ‘application/x-msdownload’ to:
header(“Content-type: text/csv”);
line 448, changed content type from ‘application/x-msdownload’ to:
header(“Content-type: text/csv”);
|
|
Josh
|
February 3, 2016 at 9:44 am
It turns out that’s a pluggable function so you can copy it to /wp-content/uploads/espresso/ and it will load from there.
|
