Support

Home Forums Event Espresso Premium Excel Error: duplicate fields

Excel Error: duplicate fields

Posted: July 30, 2013 at 2:49 am

Viewing 52 reply threads


Marco Genovese

July 30, 2013 at 2:49 am

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?

Thanks in advance, regards


Marco Genovese

July 30, 2013 at 2:52 am

Screenshot primary registrant:


Dean

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.


Marco Genovese

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?


Dean

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.


Marco Genovese

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!


Marco Genovese

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);


Marco Genovese

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


Marco Genovese

July 31, 2013 at 4:40 am

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


Dean

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.


Marco Genovese

July 31, 2013 at 5:11 am

Yes, of course


Marco Genovese

July 31, 2013 at 5:21 am

Ok! I sent out my account information


Dean

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.


Marco Genovese

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


Marco Genovese

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


Marco Genovese

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


Dean

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.


Marco Genovese

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


Dean

August 1, 2013 at 6:10 am

Sure thing, can you resend login details please?

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


Marco Genovese

August 1, 2013 at 6:14 am

Ok! Password sent


Dean

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.


Marco Genovese

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


Dean

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.


Marco Genovese

August 1, 2013 at 6:55 am

Ok! Thank you so much for your time


Marco Genovese

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!


Marco Genovese

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?


Marco Genovese

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.


Marco Genovese

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.


Marco Genovese

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?


Dean

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?


Marco Genovese

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


Marco Genovese

August 7, 2013 at 9:18 am

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


Josh

  • Support Staff

August 7, 2013 at 4:04 pm

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.


Marco Genovese

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.


Marco Genovese

August 8, 2013 at 1:56 am

Screenshot


Josh

  • Support Staff

August 8, 2013 at 8:05 am

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


Marco Genovese

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.


Josh

  • Support Staff

August 8, 2013 at 10:53 am

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?


Marco Genovese

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


Josh

  • Support Staff

August 8, 2013 at 2:59 pm

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


Marco Genovese

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


Marco Genovese

August 12, 2013 at 4:57 am

OK! Access data sent


Josh

  • Support Staff

August 12, 2013 at 8:51 am

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;


Marco Genovese

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!


Josh

  • Support Staff

August 13, 2013 at 1:03 pm

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.


Marco Genovese

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.


Marco Genovese

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


Marco Genovese

August 14, 2013 at 9:04 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. (Screenshot)

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


Josh

  • Support Staff

August 14, 2013 at 12:54 pm

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.


Marco Genovese

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


Josh

  • Support Staff

August 16, 2013 at 10:06 am

I’m afraid that’s not possible because the CSV format does not allow for formatting:

http://stackoverflow.com/a/12931887

Viewing 52 reply threads

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.

Event Espresso