Support

July 30, 2013 at 2:52 am

Screenshot primary registrant:

July 30, 2013 at 5:59 am

Hi Marco,

Do you have Roles and Permissions active? If so can you disable it and test the export to see if it changes?

The only way to get the bolded would be to modify the export function, which is a core file to pull the is_primary column from the database and highlight those.

July 30, 2013 at 7:18 am

Hi Dean,
No. I don’t have Roles and Permissions Addon installed
My configuration:
– Event Espresso v3.1.33.3.P
– User Integration v1.9.7.2
– Multiple Event Registration v1.0.4
– JSON API v2.0
URL: aicsturitalia.it
I tried to disable addons but the problem is still there.

Please, can you tell me in which file is there function to export all participants in excel format?

July 30, 2013 at 7:37 am

Hi,

OK, I can see the email duplication, but I cannot re-create the duplication of the custom questions. Can you advise what type of questions they are, if required and if admin only and also whether they have a custom question group or have been assigned to a default group.

The export is created via the includes/functions/export.php file.

July 30, 2013 at 7:50 am

I have two question groups:
“Campi primo partecipante” and “Campi successivi parteciapnti”.
All fields are required and public for all (not for Admin Only)
Screenshot

If you agree, I can give you the admin password so you can take a closer look
Let me know!

July 30, 2013 at 2:28 pm

It has been more than six hours and still I have not received a reply

Sidney Harrell

July 30, 2013 at 6:05 pm

I found the fix to the email question duplication, at least. Change line 339 of includes/function/export.php to:

$ignore = array('1'=>1, '2'=>2, '3'=>3);

This reply was modified 11 years, 4 months ago by Sidney Harrell.

July 31, 2013 at 1:04 am

Hi Sidney,
thanks for the reply.
I inserted your snippet into includes/function/export.php, but it solves only the email field. Fields place of birth and date of birth, are still duplicates.
Screenshot

July 31, 2013 at 4:40 am

Please, can you solve the mistake of duplicating data when you export the excel spreadsheet.

July 31, 2013 at 5:06 am

Is it possible to get your login details in order to look into this?

If so, please send them via https://eventespresso.com/send-login-details/

NOTE: login details need to be Admin level.

July 31, 2013 at 5:11 am

Yes, of course

July 31, 2013 at 5:21 am

Ok! I sent out my account information

July 31, 2013 at 5:34 am

Thank you. I can’t see anything wrong. I have now (not sure how) recreated it on my local server. I will add this to the developer ticket to look into. Right now I cannot give you a resolution right now, a developer will need to look at it. Please bear with us.

July 31, 2013 at 5:39 am

Ok! Thanks a lot.
I have already tested ee on my local server and the problem also exists in local.
Please try to fix this bug
It’s important for me

Regards

August 1, 2013 at 4:07 am

I have figured out where the problem is.
The fields duplication occurs when you add a group of questions to the secondary attendees. In fact, as long as the fields are the default (Last Name, First Name and e-mail) the problem of duplication does not occur.
I hope this will help you solve the problem.

Regards,
Marco

August 1, 2013 at 4:47 am

There is another bug.
I have noticed that if I export from the buttons “export all attendees information” or “export events date” (Screenshot), files are generated without the .xls extension.
But if I manually add the extension and open the file with excel, the data is correct. That is, there is no duplication of fields.
If instead I export by clicking the link “export” under the name of the event or by clicking the icon under “Actions”, the file is generated correctly (with the .xls extension) but the fields are duplicated

August 1, 2013 at 5:21 am

Hello Marco,

We are indeed looking into this issue, however whilst I know the issue is real, we are struggling to systematically recreate the issue.

The method you stated of adding the question groups to the additional attendee does not seem to force this issue.

Please bear with us whilst we continue to look into this.

Also please note that the files from the export buttons are all correctly exported with the xls extension. The files exported from the Action images are exported as csv files.

We have had no reports and cannot replicate extension-less files.

August 1, 2013 at 5:44 am

Hi Dean,
under the column “Actions” I also have the icon to export to excel
Screenshot
I beg you to look into my site so you will notice that if you try to export from the buttons (see the screenshot of the previous post) is the generated file with no extension.
I sent the new data to access the site at your colleague Sidney

Let me know if you need anything else

August 1, 2013 at 6:10 am

Sure thing, can you resend login details please?

https://eventespresso.com/send-login-details/

August 1, 2013 at 6:14 am

Ok! Password sent

August 1, 2013 at 6:24 am

Hi,

This screenshot http://d.pr/i/D0GN is the downloads from the 4 export options on the Event Overview page (the two action image buttons and the 2 export buttons below the overview).

As you can see they all have the correct extensions, 3 xls and 1 csv.

August 1, 2013 at 6:39 am

OK Dean! You are right.
I checked on all other browsers: on safari, opera and chrome everything works properly. The problem occurs only with Firefox. You know what could be the reason. I am a mac user

August 1, 2013 at 6:42 am

I double checked it with FireFox and no issues, but I am running a Windows computer. Sidney might have a Mac, so he may be able to double check that from his end as well.

August 1, 2013 at 6:55 am

Ok! Thank you so much for your time

August 2, 2013 at 12:14 pm

Do you have got to check with a mac and firefox browser if the exported file from buttons (Screenshot) is generated without .xls extension?

I still have this problem!

August 6, 2013 at 8:11 am

I’m still waiting for an answer. I will propose again the question: when I export the data from buttons (Screenshot), the files are generated without .xls extension. This occurs only with the firefox browser on mac.

In addition, you should solve the problem with the duplication of fields in the excel sheet because this is a mistake of the plugin.
I need to export the data in the correct way

Garth

Support Staff

August 6, 2013 at 8:23 pm

Hi Marco,

I’ve been able to export the file with .xls extensions in both Chrome and Firefox: http://www.screencast.com/t/S4RrhSdQkS

Does this happen when you download other excel files from other sources?

Are there any other users experiencing this issue?

August 7, 2013 at 1:41 am

Ok! But there remains the problem of the duplication of the fields when I export the information to Excel.
The data export to excel is an important function of the plugin but if it does not work in the right way is useless.
You have to solve me this problem that there is a long time in your plugin. Let me know if you need the password to access my site.

August 7, 2013 at 2:15 am

However, to answer your question: Does this happen when you download other excel files from other sources?
NO. This happens only on the Plugin and only with firefox browser.

August 7, 2013 at 2:38 am

Here’s a Screenshot.
Why the link “export” under the event works and instead the buttons don’t work?

August 7, 2013 at 2:40 am

Hello Marco,

We are still looking into the duplicate fields issue. Please bear with us, as it is not an easily reproducible bug which means we have to narrow down how it is occurring before we can fix it.

I cannot give you a time-scale in relation to it being fixed.

Regarding the file extension, thanks for your clarification. What version of Firefox are you using?

August 7, 2013 at 3:07 am

Hi Dean,
I have updated to the latest version right now: firefox 23.0
But the problem remains. I want to remind you that I am a mac user and that this strange behavior only occurs with firefox browser.

With regard to the duplication of fields in excel: browsing your forum I have seen that this is a problem that there is a long time in EE.
Now, I have some deadlines with my clients. So it would be appropriate if someone of your team solve this problem to me since it is a bug of the plugin.
I have purchased a business license and the plugin must work 100%.
The proper export of the fields is a feature too important for me and for my client.

So, I’m waiting for your answer.

Regards

August 7, 2013 at 9:18 am

I’m still waiting for someone to give me a concrete answer

August 7, 2013 at 4:04 pm

Support Staff

Hi Marco,

We have not been able to reproduce this issue on any of our testing environments. Until we are able to we will not be able to fix it. This may be an issue with your local environment, specifically with your version of excel not being able import the file the same way from Firefox as it does from the other browsers.

August 8, 2013 at 1:55 am

Hi Josh,
I can assure you that the problem is not my testing environment. To make you understand, here again the screenshot. If it were as you say, even the export from the link below the name of the event should not work and instead it work. The problem of the extension occurs only when I export from the buttons (always see the screenshot).
It seems obvious then that the problem is in the function that is called when you export from the buttons.

August 8, 2013 at 1:56 am

Screenshot

August 8, 2013 at 8:05 am

Support Staff

If you take the export that’s doubled and open it in another application other than excel, do the columns duplicate?

August 8, 2013 at 8:38 am

I have installed open office for mac and open .xls file from there.
The fields are always duplicates.

August 8, 2013 at 10:53 am

Support Staff

Do you have any extensions installed for Firefox? Can you re-send FTP and admin credentials you sent earlier so that someone on the dev team can investigate the issue on your server environment?

August 8, 2013 at 12:41 pm

I have installed Firebug and Web Developer Components on Firefox.
I have already tried to deactivate but everything remains unchanged: the fields are always duplicated when I export a single event or the list od attendee and the files from the buttons (Export all attendee information and Export all event data) are generated without .xls extension.

I noticed something else: If I manually add the extension to the generated files (Screenshot) and open them on excel, these are the only export correctly without duplicate fields.
I hope that this will help to resolve the problem.

Soon I send access data

August 8, 2013 at 2:59 pm

Support Staff

Here is a link to a support thread from mozilla.org that might help with the issue you’re having with Firefox not adding the file extension when you try to export:

http://support.mozilla.org/en-US/questions/892056

August 12, 2013 at 4:52 am

Hi Josh,
I tried to delete the file suggested in the thread but the problem is not resolved. I’m sending the data to access the site and the data access ftp.

Please, solve the problem of the extension of the files and the problem of the duplication of fields

Regards

August 12, 2013 at 4:57 am

OK! Access data sent

August 12, 2013 at 8:51 am

Support Staff

Hi Marco,

One of the developers looked into this on his end and found that it’s an issue with the Italian translation. The reason the .xls extension wasn’t getting added onto the exported file was the traslation of “all-events” was “Tutti gli Event” (Note the spaces instead of dashes separating the words in the file name).

We are testing a fix that involves programmatically replacing the spaces with dashes which you can apply to your copy of event-espresso/includes/functions/export.php on line 130:

You can change this line:

$filename = $filename . "-" . $today;

to:

$filename = str_replace(" ","-",$filename) . "-" . $today;

August 13, 2013 at 3:06 am

Hi Josh,

Wow! Thank you very much.
However, in addition to the 130 line, I have also entered your code at line 403.
Now the export works properly!
The only problem that remains is the duplication of fields in the excel file.
I hope you solve this as soon as possible.

Thank you again!

August 13, 2013 at 1:03 pm

Support Staff

Hi Marco,

One of the developers and I both logged into your site and downloaded the excel exports and found no duplicated fields. I’m afraid there isn’t a problem to solve here.

August 14, 2013 at 4:57 am

Hi Josh,
I’m sorry to contradict you but the problem exists. The only export that works properly is the one that exports all events. (Look Screenshot)
But, if I try to export a single event or the list of attendees of a single event, the place of birth and date of birth fields are duplicated.

August 14, 2013 at 4:57 am

Look Screenshot

Please solve this problem. It is important to be able to export each and every event with the correct data

August 14, 2013 at 9:04 am

Please solve this problem. It is important to be able to export each and every event with the correct data

August 14, 2013 at 12:54 pm

Support Staff

Hi Marco,

It looks like the column names are duplicated, the fields are not duplicated. I’ll update the ticket in the codebase so one of the developers will know.

In the meantime, I think you can work around this issue be creating a unique set of questions for the place of birth and date of birth form fields. The new set can get assigned to the question group for the Additional Attendees.

August 15, 2013 at 5:00 am

Hi Josh,
Thank you very much! I seem to have solved the problem by following your tip.
I have another question: is it possible to format the file export.php in such a way as to have only the rows of the primary attendees in bold?
It is a difficult thing to achieve in php? Could you tell me which part of code should I change to get this result?

Thanks in advance and congratulations for the great support