Support

August 3, 2012 at 3:16 pm

Do you have a recent backup of the database that you can restore to?

August 3, 2012 at 3:20 pm

If this started happening out of nowhere, then you might try reverting to the previous backup of the database.

August 3, 2012 at 3:29 pm

Have you tried opening one of these up in another spreadsheet app?

Which version number of Event Espresso is installed?

August 6, 2012 at 9:55 am

Start with the re-saving the question groups and events.

August 6, 2012 at 12:35 pm

Were the questions re-saved too? If so, please send WordPress admin level log in credentials via the contact form on this page: https://eventespresso.com/contact/

Select the “I am sending login info as requested” department form.

August 6, 2012 at 5:55 pm

The issue is that you have duplicate questions in your questions group(s). To make things more confusing, it looks like you have added questions that are duplicates of some of the existing system questions. I couldn’t tell you, for example, which “Zip” question is used in the Personal Information group in this screenshot, since you’ve added your own in addition to the default Zip question.

link

All events require all questions in the Personal Information group, so all of your events will have the questions in the top box in the screenshot above. The event in question also has an additional question group with many of the same questions that are asked in the Personal Information group:

link

Since you are using both question groups in that event (Personal Information + Convention) in that one event, there are 3 questions that you are asking three times — once in the personal information question group and twice in your Convention question group.

They are not displaying three times in the actual registration form because at least two sets of those City/State/Zip questions are coming from the default system questions. I’m not entirely sure why the reports are displaying data in the wrong columns, but I suspect it has to do with the duplicate questions you are asking and that they all have the same name.

There is no way to “fix” the data that’s already been submitted for the attendees you have now. However, you should be able to resolve the issue for any new attendees by removing the multiple instances of the same information.

First off you’ll need to delete the custom questions you created for questions that already exist as default system questions (indicated by a lock on the Questions screen). Screenshot of the default system questions below:

Once you’ve deleted the duplicate questions, you should be in better shape, but you may want (or need) to adjust your Personal Information question group if you want the address information to be requested of all attendees in all events.

Then you will need to go into your Convention question group and make sure that none of the questions you are asking there are the same questions you are asking in the Personal information group.

Even after you do all that, the exports might be so bungled by having the wrong information to start with that future exports for that event might still be borked, however, it should work without too much error. The major issue I foresee is that you’ll likely lose data from the export for information that was being stored in the wrong column, so you should probably do an export before you try to do this so you have a copy of the information (albeit with the bad header row). Then again, everything might magically work after going through the above steps, but I’d prepare for the worst (that way you can be pleasantly surprised if things happen to work out).

• This reply was modified 11 years, 8 months ago by  Chris Reynolds. Reason: changed some information about default system questions

August 6, 2012 at 6:00 pm

No worries. It was definitely an odd side effect that could be easily overlooked if you didn’t know what to look for in terms of probable cause.

August 6, 2012 at 7:11 pm

I think it would be best to create new questions for these, and then assign them to this specific group.

August 6, 2012 at 7:35 pm

What do you mean by won’t be different?

The idea is to remove all duplicates. Then when you create the new questions (not make more duplicates) be sure to name them accordingly so the same questions do not get assigned twice (to two different groups).