Hi guys,
I’ve read that the PHP community ia one of the best around so here goes…!
I run a a live music venue in the UK, and also put on concerts/tours independently across the country. Without wanting to get too bogged down in what that entails, a large proportion of my time is spent relaying what is essentially the same information in different templates to different parties:
-My Press List
-Online Ticket Vendors
-The bands / Tour managers involved
-My website
-Social Networking Sites
-My mailing list
With a work flow of something like:
-Details are confirmed
-Advance this info to bands/those involved on the night
-Announce the show to press and ticket sites so it is publicised and on sale
-Add to our website’s listings
-Create Facebook Event etc
-Send to mailing list (usually organised by genre)
As I say, this is mostly the same information just in different orders, with a different focus each time. Detals like location, price, date, web links, etc.
So I’d like to create an online form where I create a show as an entity (record in a database I suppose) with ALL info, and i can send the right/relavent info in the right order to each party, and create Facebook events etc with the click of a button. No typing, copying and pasting, etc. It will literally save me hours a week.
So… Before I start I would be very grateful for any advice on:
-Whether it’s easily achievable or not
-Overall structure, what kind of files are needed/sensible and in what order?
-Any 3rd party tools that I should use?
-Any existing systems that I could/should be basing it on?
(Regarding the last two - I have read in some places that it would be not only more time consuming, but also inferior to create it all from scratch when there are so many tools out there that have various functions perfected… e.g. mailing list database/services)
Any help is greatly appreciated!
Loki
UK