Hello,
this is a repost as the previous coder was unable to complete this project.
We currently have an asp app that allows users to select a photo based on their specific login information. This selection is then stored in an access database for future use.
currently each login has its own folder created on our server which holds the photos which are displayed for the user to select from once logged in.
We would like the users to have the ability to not only select a photo with the currently working app, but also give them the ability to select a photo from another set of photos in a different location.
so we need...
1. an admin function which will 'publish' into the db these photos available to select from
2. added functionality where a user can select from these new sets of photos
3. additional admin functionality to process these selected photos.
I can easily walk you through our process online to give you a better idea.
if you want to see the current app you can go to
[login to view URL]
log in with order number "sample1" and last name "sample1"
(so not worry about first name)
------------------------------------------------
John
## Deliverables
Hello,
the actual photo selection portion is in asp
([login to view URL])
here is more detals to make it clearer
Hello,
To make things a little clearer.... here are more details.
Currently we have an app which works for posed photos. ie. we show up on a picture day and take posed
photographs of each player from each team. These are copied to our storage machines, each persons photos
are copied to their own folder and entries are
added to our access db. Users then are able to log in ,once logged in they are shown just their posed
photos and they can then select their favorite photos.
now, here is the new part we need.... we want to also take action photos and give the users the option
of selecting either their favorite posed photo OR an action photo.
we will go out and photograph action in a certain number of games. We will then take them back
to our office and copy them to our storage drives. Here is our folder structure:
sport->year_date->event_name->hires->game_name the actual hires photos are in here
sport->year_date->event_name->icon->game_name the actual thumbnail sized photos are in here
sport->year_date->event_name->image->game_name the actual larger low res photos are in here
the hires folder contains al the original hi resolution images
the icon folder contain thumbnail sized images - used for displaying
the image folder contains larger low res image - used when a user clicks on a thumbnail to view it larger
once we copy the 3 types of photos to our storage drive, we then need a way to 'publish' them.
We need a small app (placed on our office computers) which will allow us to select (already entered into
the access db from the posed photos) the sport, league name, and folder where the photos
exist (where the hires,image, and icon folders are) it will then step through each game and
enter them into an access table. I can show you the app we currently have which works similar
for the posed photos we take. We would like it to work similar.
once stored in the db. a user can then log in. Currently when they log in they see just their posed photos and they
are able to select their favorite photo. We want to give them the option to also go view the action
photos from a game we photographed and if they like one then select their favorite from there. So a link would
need to be added to the screen that they view their posed photos asking if they would like to view action photos.
A link would also need to be on the action photos viwing page as well asking if they would like to
go back to viewing their posed photos.
a user then select either the posed photo or action and their selection gets stored in the access db. this is already setup
as it works for the posed photos, we just need to now store the action photos IF they selected one.
We would also need to store the link/path to the action photo. Currently all posed photos are stored on an
external server. But becuase of the large number we may have of action, we will store the action photos
on our office storage machine which is accessible by an ip address.
the currently stored posed photos are stored in an access db with the following structure:
sport table
league table
team table
player table
Once the users selection is stored in the access db, we have an admin app which when run will
read the db of stored selections ( we tell it the sport, league, team), and copies each selected
photo to a new folder. We will need this modified to now check to see if an action photo was selected
and if so copy the photo from the 'other' location... where the action photos are stored
on our office storage drive (accessible by an ip address)
I can let you view my desktop as I show you currently how it all works, how the apps work,
the db structure, and the user interface.
thanks