As the first stage of this project we have several business documents that we want to convert to Google docs so they can be shared around the office.
We also require that the Customer Job Form can be made in to webform for clients to input their own data and submit completed document to our client liaison.
These individual docs will need to have some fields automatically updated from the other documents.
The Library Database will also be required to output relevant details to enable easy programming of a page on our website for our Band of the Day listings. So it's possible that an HTML template for our website Band of the Day pages are also required. Links to the current band of the day pages can be seen here: [url removed, login to view]
Documents to be converted to Google Doc format include:
1/ Library Database of CDs/Dvd/Videos in MS Access format - Containing Artist/Title/ tracks/Format/ Catalogue number etc etc. It is envisaged some extra data fields will be added to the current Access Document
Ability to add thumbnails of artwork or links to Associated artwork files and other info seen as additions to the work.
2/ Customer Job Form in Excel format. - Containing Name. Artist, Title, Job due date and job details covering CD/DVD/Bluray and USB manufacturing procedures. Job progress info. Music details to be added include Album Name, Artist, Song Titles, genre etc. Extra data fields will need to be added such as Song titles (expandable list due to varying number of songs per CD) Twitter, Facebook or other contact details, Artwork thumbnail link.
This job form will need to update relevant fields in Library Database - Document (1)
Updating of job progress fields by our suppliers is also required.
Client access to certain fields for online job tracking progress or an App for client job progress is envisaged as part of this work in the future. The Job Progress App should be compatible with Smartphone or Email/SMS
3/ General Job Tracking Form is a cut down version of the Customer Job Form (2) and sits on our reception computer as an Excel spreadsheet - This is used for daily job tracking in a simplified [url removed, login to view] Job Number/ Date in / Date out / Name/ Job details/ qty/ job contact / job complete assigned.
It is envisaged that this work will require updates and revisions as it is implemented in our business, not all of these elements will be required straight away. for example the App can be introduced later when the system is running.
However I think it's important that the scope of the project is understood so all the items can be taken in to account for future work.
The initial scope of work should include converting the current documents (Access/ Excel files ) to Google Doc format and implementing the "sync" capability. And include the library database to web html files and also the Client online data job form.
I've included the current Job forms as attached file. I can upload Access Database if required.
This is a complicated project to describe so please ask questions if I havent explained the scope very well.
I've just added a word doc project doc to show diagram of job scope and how the various Google Forms will need to link
I have uploaded Job Progress Form and Access Library Database documents so that the relevant data fields can be seen.
This currently completes the data that needs to be converted to various Google Docs and have the necessary datafields automatically update
If you have further questions please email