I am looking for someone to build a website that will allow me to send broadcast SMS messages to a number of users at once. The application will need to maintain contact information for each user so that I can easily retrieve the information later.
I should then be able to easily select a list of users that I would like to send an SMS to, provide the message to be sent and then send the message to the users. The message will then be sent to each user immediately. Any failed messages will appear on a screen labelled "Failed Messages" which will provide the details of each failed message.
At any time, I need to be able to select a contact and see every message that I have sent to that person and whether it was successful or failed.
I should also be able to create "contact groups", which allow me to create a list of contacts and provide that list with a name. I will then need to be able to send messages to that group, simply by selecting the name of the group when sending SMS messages.
The system should allow me to upload a list of contacts in a CSV file format. This CSV file will contain the fields below:
- first name (mandatory)
- middle name
- last name (mandatory)
- date of birth
- email address
- mobile telephone number (mandatory)
When I upload a CSV file in this format, the users will be stored in the contact list if the mobile number doesn't already exist in the contacts list. If the number does exist, the details will be updated with those contained in the file. Any optional fields which are left blank will be stored as blank in the contacts list. If any mandatory fields are empty, the file will not upload and the details of all errors in the file will be provided on the upload screen.
The system needs to be able to send messages to Australian mobile numbers using a provider where the text messages are no more than 10 cents per message.
The application needs to be developed entirely in Ruby on Rails. The appearance of the application needs to be visually appealing, so some HTML and CSS design will be required.