When I export the data of an event, the Email, Place of Birth and Date of Birth are duplicates fields. Here’s a Screenshot
Please, can you help me solve this problem? I would also have another question: It’s possible to export data to excel and to have the registrant (primary) bold?
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.
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?
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.
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!
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
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.
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.
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
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.
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
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.
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
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.
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
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.
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.
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?
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.
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.
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.
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?
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.
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:
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
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:
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.
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.
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.
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. (Screenshot)
Please solve this problem. It is important to be able to export each and every event with the correct data
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.
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
The support post ‘Excel Error: duplicate fields’ 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.