|
Samantha
|
April 7, 2016 at 3:19 pm
Upgrade seemed to go fine, and I can do an export of the registrants, and all the questions and answers show up there correctly, however if I edit an event, the check box that requires the questions is not checked ( SO I Need a way to mass check this on for all events—all events require the same question group)
AND (most importantly) if I edit a registrant, their questions are not coming up. I tried to go into one an event and set the check box to “on” for that group and saved the event, and looked at the registrant again, and the questions still do not come up.
|
|
Josh
|
April 7, 2016 at 3:27 pm
Hi there,
Were these some of the events you imported into EE3? After you imported them, did you assign the question group to those events through the UI or some other means?
|
|
Samantha
|
April 7, 2016 at 9:00 pm
I think that might be the problem, I just realized in V3, I was able to assign all the questions to the default group (the required one) so by default in v3 they were all included in that group. So when I went into an event, the questions all showed. In V3 I went in and checked a few events and registrants, and the signup form, to make sure everything looked okay. In v4, the default questions like address, phone, etc. aren’t even available in the default group to select on. It seems like the questions are divided up differently in v4? I think that this might have gotten mucked up because of how I had them setup in v3.
I’m looking at wp_esp_event_question_group and it seems like I might be able to add records here to reset things? I will have to play a bit to see how it’s setup.
I’m not sure if I may need to reset some questions from that default group….would there be any issue with resetting through wp_esp_question_group_question ? I remember seeing from the demo that the question groups were locked down in v4 and I might have messed them up by having my questions in the default one in v3. I think I just need to readjust these? Are those the only two tables I would need to touch? Thank you!
|
|
Samantha
|
April 8, 2016 at 10:00 am
Ok I installed a separate test vanilla install, and I see that in v4 the address fields are locked into the address group. On my v3 install, I had these in the “main” default group (I had only one question group–the required one–and to this I had added all the default questions plus my custom ones). I think this might be the problem…because v4 locks out the address questions from being added to the main.
I changed the groups in the database to put the address fields back into the address group in v4 and that seems to have fixed it, however none of my info is popping in when someone registers (not even the address info).
|
|
Josh
|
April 8, 2016 at 2:52 pm
I’m not exactly sure how you ended up with only one group in EE3, there should be at least two groups after the installation script runs. Did you delete the Address Group after EE3 was installed? There should be one group for Personal Information (group ID 1), which has the First Name, Last Name, and Email questions. Then there’s one for the Address Information (group ID 2) with has Address, City, State, Zip.
You may need to move those address questions into the address group in EE3, and if you have any non-system questions (i.e. any new questions you add) those can be assigned to the Personal Information group. Then, if you have any non-system questions, the answers to those questions will need to be imported into EE3’s _events_answers table before you migrate the data to EE4.
|
|
Samantha
|
April 9, 2016 at 11:55 am
I did this on a vanilla setup with an event that I entered into V3, questions I setup manually in E3 and added to the personal info group. I upgraded and can verify that the associations do not work. When I bring up a registration, it says this There were no custom questions asked for this registration. However I can see the data in the ee4 tables. Since I’m not sure what it’s supposed to look like when it’s working properly, I can’t really tell what is wrong. I will try later on to setup ee4 from scratch and add the same stuff directly to ee4 and compare the data to the test converted ee4 data……BUT…..honestly…….it’s been three weeks of this, meanwhile the client is dead in the water and I’m about out of patience. I’ve imported the data correctly into v3. EVERYTHING WORKS EXACTLY AS EXPECTED (AKA PERFECTLY) in v3…..it’s only converting to v4 that’s not working. I can verify this both on my live data as well as two tests of the vanilla setup.
I’m sending screen shots.
I also noticed that if you set phone to the personal group, it does not come over properly. It has to be set to contacts otherwise a record is NOT created for it in wp_esp_answer.
The other thing that is different (that I mentioned in earlier posts from looking at my live data conversion) is that in the wp_esp_event_question_group there are extra records that are not created when you just install v4 and create the exact same event with same properties and register with the same account. the v4 converted version adds extra data for each record. It is also attached to the email that I”m sending.
I HAVE TO MOVE FORWARD with this. I don’t care about paying for support at this point, I have a v3 install that works absolutely perfect, and a v4 conversion from that install that does not. I will pay for the support for someone to take a a look at this v3 data to make sure that it is indeed in the proper shape and state for a successful conversion, and then I will run the conversion and have you check it to see the resulting problems. Or you can help me here, I don’t care, but I need this working. Please!! “)
|
|
Josh
|
April 11, 2016 at 10:15 am
Hi there,
For this part of your question where you mentioned:
The other thing that is different (that I mentioned in earlier posts from looking at my live data conversion) is that in the wp_esp_event_question_group there are extra records that are not created when you just install v4 and create the exact same event with same properties and register with the same account. the v4 converted version adds extra data for each record. It is also attached to the email that I”m sending.
Then you followed up in the email with a screenshot of the database table and mentioned:
If I create an event in a vanilla v4 installation with questions, and register someone, these zero value records are not created. It’s only when I import from v3 to v4, and then I get two records for each question group for each event, one set to 1 and one set to 0
You will also see a record in wp_esp_event_question_group that has 0 for EQG_primary when you edit an event and check any of the boxes next to question groups in the Questions For Additional Registrants box.
For the part where you’re having trouble understanding what the data is supposed to look like when it’s working properly, the best way forward is set up a test site and where you can add the questions into the Registration form editor, then assign the question groups to an event, then do a test registration. Then you’ll have something to compare to your imported data.
|
|
Samantha
|
April 11, 2016 at 1:34 pm
So in other words, you’re not going to help with the primary question, which is why is it saying that the registrant has no questions for that event?
I figured it out on my own. The import incorrectly (as indicated above) set a 1 to question group 1 and a 0 for question group 2 for each event. I changed this in the database to 1 for each question group since I’m requiring both the primary and address info for all events, and the data I imported is setup that way. That has resolved the issue with the questions not showing up for the registrants.
Now……I’m trying to get it to bring these fields into the registration, and yes i’m using the filter that you gave me from the custom coding area.
It’s not bringing it over for me 🙁 I’m not sure if it’s a problem with the primary attendee? That seems to be the main thing it checks to determine if it should pull the info in.
|
|
Samantha
|
April 11, 2016 at 1:42 pm
I’m literally losing my mind, it’s been three weeks of this and I still can’t allow anyone to do anything in the system because the info isn’t sticking to an account and they would have to re-enter it every time they register someone (we work primarily with low income or non-english speakers and the majority of our registrations are done by staff, not the attendee). I can’t put this burden on them, especially when the data is already there.
|
|
Josh
|
April 11, 2016 at 1:43 pm
Have you tried the suggestion to set up a test site, where you can add the questions into the Registration form editor, then assign the question groups to an event, then do a test registration?
This way you’ll be able to see how the data is supposed to look like in the database.
|
|
Samantha
|
April 11, 2016 at 6:46 pm
Wow. So what would have been nice is if you had TOLD ME that if I’m logged in as an admin, the fields are not brought over. Are you going to give me three days of my life back?
Might be a bug? Maybe it’s supposed to work that way? *shrug*
|
|
Josh
|
April 12, 2016 at 8:27 am
Hi there,
The fields should have been brought over, and they normally do. In this case though, the data was imported and it seems like there’s something missing from the EE3 data. Otherwise it would have migrated.
So no, it’s not supposed to this way. While it might be a bug, we haven’t seen this happen on migrations from EE3 to EE4 where the data was added through the UI.
If you can send us a database dump of the EE3 data before it was migrated, we can check for missing data and advise where to make corrections before running another migration to EE4.
|
|
Samantha
|
April 12, 2016 at 10:07 am
When I said “bring over” my language was probably confusing in the context of what we talked about previously.
In this case, I’m referring to the address fields and questions “carrying forward” on a new registration where there was info from a previous registration, using your custom scripts. What I found is that this does not work if you’re logged in as admin, but logged in as a normal user, they work as expected. I’m not sure if this is a bug or intended to work that way.
————
I have more to post but I need to gather more details before I do. (to be continued…)
|
|
Josh
|
April 12, 2016 at 11:24 am
If you’re logged in as admin it will only carry forward the admin’s contact records, not someone else’s.
|
|
Samantha
|
April 12, 2016 at 2:32 pm
Why on earth would I want it to carry forward someone else’s? Of course it won’t do that. That does not take away from the fact that it *does not* carry forward an admin’s info. I have a imported/converted install, and a vanilla install and I can replicate the behavior on both.
|
|
Josh
|
April 12, 2016 at 5:47 pm
When you’re logged in as the admin, are you making the registration on the front end? It should autofill the information from your last registration if you’re on the front end.
|
|
Samantha
|
April 13, 2016 at 2:46 pm
For me, there is a gaping chasm between “should” and “does” but I’ve moved on to other stuff, I need to customize the site at this point and this is nothing that we need to worry about anyway…we were only testing, there aren’t any situations where I would need to register myself and if I ever did, I would just use my plain user account.
|
|
Josh
|
April 13, 2016 at 2:51 pm
Thanks for the feedback. We’re here to help if you decide you want to look into that any further.
|
