|
Janis
|
July 16, 2013 at 3:31 am
Hi
I used your attendee import facility to import 1500 attendees to varing events and all worked great. I used the ‘Answers’ column when creating my csv and I noticed when looking at the data directly in the tables that my answers to the address questions were in the events_answer table but not in the address fields in the events_attendee table.
Will I mess anything up in terms of how EE functions if I use my own sql query to update the fields in events_attendee with the address info from events_answer?
Secondly I had some attendees that I added manually to a couple of events so when I go to my dashboard these come up under ‘my events’ as I am linked to them in events_member_rel. These attendees are actually in my users table in wordpress and I would like them to be able to see these events when they go to their ‘my events’. I have created records in events_member_rel to link the correct eventid, userid and attendeeid.
Will it then mess anything up if I delete the records in events_member_rel linking me, the administrator, with these events and attendees, or should I leave those records there as well? Thanks in advance.
|
|
Seth Shoultes
|
July 16, 2013 at 12:30 pm
Re: “Will I mess anything up in terms of how EE functions if I use my own sql query to update the fields in events_attendee with the address info from events_answer?”
You should be okay doing that. As long as you don’t change the id’s associated with those answers.
Re: “Will it then mess anything up if I delete the records in events_member_rel linking me, the administrator, with these events and attendees, or should I leave those records there as well? Thanks in advance.”
That should be fine.
Just be sure you create a back up of those records and tables before doing any work. That way if something goes wrong, you can restore that data.
|
|
Janis
|
July 17, 2013 at 4:33 am
Thank you.
|
|
Josh
|
July 17, 2013 at 7:36 am
I added a ticket in our issue tracker to build a solution that:
1) Does not record the user_id for the admin in events_member_rel when adding registrations via the admin.
2) Adds an input when Members is active that lets you enter a user ID when adding an attendee via the admin.
|
