|
Pixel Workshop
|
July 23, 2014 at 7:40 pm
Hello Support Friends!
I know I using a couple of Beta add-ons in this equation, but I’m hoping you can point me in the right direction to fix this issue. I imported a few thousand athletes for a race event using the Attendee Import plugin, and a handful of these athletes have switched to a different race since being imported and I used the Attendee Mover plugin to move them. In the admin area these athletes show in the correct events, they export in the correct events, and they appear correctly on the Edit Attendee page, but if you look at the Payment page, it shows a different event, and its not event the event she was originally imported into, its a completely different event, and the amount is wrong, its showing the cost of the event that’s listed on that page, and it doesn’t take into account previous payments that had beed made.
I hate to have them have to reregister from scratch, but each race has a different cost, and often they will owe money so the payment page is pretty important.
I’m perfectly comfortable going into the data in PHPMyAdmin and clean it up, I’m just not sure where to start.
Thanks for your help!
– ilana
Event Espresso version 3.1.36.5.P
WordPress version WPMU 3.9
Event Espresso – Attendee Import by Event Espresso version 0.1,
Event Espresso – Attendee Mover Tool by Event Espresso version 1.1.b,
Event Espresso – MailChimp Integration by version 1.2,
Event Espresso – Members Addon by Event Espresso version 1.9.8.p,
Event Espresso – Multi Event Registration by Seth Shoultes version 1.0.5.p,
Event Espresso – Permissions by Event Espresso version 1.5.4.1,
Event Espresso – Ticketing by Event Espresso version 2.1.p,
Event Espresso by Event Espresso version 3.1.36.5.P,
Google Analytics + by WPMU DEV version 3.1.2,
Gravity Forms Authorize.Net Add-On by rocketgenius version 1.5.4.3,
Gravity Forms Coupons Add-On by rocketgenius version 1.0.4,
PizazzWP GalleryPlus (Headway 3 Block) by Chris Howard version 1.7.4,
Headway Contact Block by HeadwayRocket version 1.6.1,
PizazzWP TabsPlus (Headway 3 Block) by Chris Howard version 1.5.7,
Utility Block by Headway Labs version 1.3.5,
Live Stream Widget by Paul Menard (Incsub) version 1.0.4.3,
RebelMouse Widget by Francisco Lavin version 1.5.6.4,
Uji Countdown Pro + 1.3 by WPmanage version 2.0,
Ultimate Branding by WPMU DEV version 1.7.2.1,
wpMandrill by Mandrill version 1.33
|
|
Dean
|
July 24, 2014 at 11:25 am
Hi,
That’s odd, I ran some tests and couldn’t replicate the issue.
If you wanted to you could modify them directly in the database in the events_attendee table, but you will need to be careful to get the data correct: http://take.ms/xfrC0
You may even need to change more.
Remember to BACK UP your database before attempting this.
In regards to the underlying issue, how many went wrong out of how many imported? Did you notice any correlation between these (e.g. are they from the same event?)?
|
|
Pixel Workshop
|
July 24, 2014 at 1:31 pm
Thanks, Dean. I looked through that table and its all correct, but when trying to untangle it without bothering you fine folks, I did look through all the ee tables and noticed that in the events_attendee_meta table this attendee only had one record associated with her registration ID…
https://www.dropbox.com/s/qekw07c1cy9nb6k/Screen%20Shot%202014-07-24%20at%202.58.19%20PM.png
…while it seem like the athletes that actually registered through ee have two
https://www.dropbox.com/s/qwyn9vt0jok3s76/Screen%20Shot%202014-07-24%20at%203.09.50%20PM.png
In fact, there are only 1474 rows in that table and there are over 3000 athletes registered, so clearly there is one for each. I’m not 100% sure what all the data in the meta_value column means, but I’m wondering if missing that data could be causing the problem.
I don’t know how many imported record went went wrong, because I’m only discovering it after sending out an email for athletes to update their information before we export it to go to the timers and medical staff. The case that I linked to earlier was someone who decided to switch from an individual to a relay team, which I have set up as two different events, and there’s an up charge for the additional teammates on a relay team, so she needs to pay the difference. Otherwise, most people probably won’t bother to look at their payment page because there’d be no reason to.
|
|
Josh
|
July 25, 2014 at 7:47 am
Hi Ilana,
Do you still need help with getting the payment records updated?
|
