Johnsonsimon
Registered User.
- Local time
- Today, 21:36
- Joined
- May 5, 2012
- Messages
- 45
The company I freelance for (doing graphic design not databases lol) has asked me to build a database for an exhibition they are running with the following brief;
The people will register through the website. My current plan is just for a webform to submit the data to a newly set up email address and find some way to import this into the database, but I have yet to speak to the web guy, so it is possible we may be able to get the data in some form of CSV, or excel file etc...
Each registrant must be able to register themselves and an unlimited number (although last year the max was around 30 additional people) of additional attendees. We only need minimal details for the additional people such as [NAME] [JOB TITLE] [COMPANY NAME] [COMPANY TYPE], whereas the main registrant will supply full details for themselves/their company i.e address, phone, email etc..
So basically we do not want a FULL Main registrant record for every attendee, just for the main registrant (this is so that multiple mail shots are not sent to the same address in future)
The system will then need to be able to print out the badges (lables (we have zeebra lable printers)) for all attendees.
Currently I have set the tables up as follows;
tbl_Registration
REGID (Primary Key)
This table needs to contains the details of the main registrant, with their contact details, address, company details etc.
tbl_Attendees
BadgeNo (Primary Key)
REGID (Foreign Key)
Plus all the required fields.
This will need to contain both the main registrant and additional attendee details.
What I need to know is that will it be possible to somehow import the data, be that from an email, CSV or Excel file into Multiple tables in the way I have laid out above.
I await your knowledgable responses.
Thanks
Simon
The people will register through the website. My current plan is just for a webform to submit the data to a newly set up email address and find some way to import this into the database, but I have yet to speak to the web guy, so it is possible we may be able to get the data in some form of CSV, or excel file etc...
Each registrant must be able to register themselves and an unlimited number (although last year the max was around 30 additional people) of additional attendees. We only need minimal details for the additional people such as [NAME] [JOB TITLE] [COMPANY NAME] [COMPANY TYPE], whereas the main registrant will supply full details for themselves/their company i.e address, phone, email etc..
So basically we do not want a FULL Main registrant record for every attendee, just for the main registrant (this is so that multiple mail shots are not sent to the same address in future)
The system will then need to be able to print out the badges (lables (we have zeebra lable printers)) for all attendees.
Currently I have set the tables up as follows;
tbl_Registration
REGID (Primary Key)
This table needs to contains the details of the main registrant, with their contact details, address, company details etc.
tbl_Attendees
BadgeNo (Primary Key)
REGID (Foreign Key)
Plus all the required fields.
This will need to contain both the main registrant and additional attendee details.
What I need to know is that will it be possible to somehow import the data, be that from an email, CSV or Excel file into Multiple tables in the way I have laid out above.
I await your knowledgable responses.
Thanks
Simon