Yes, it can be done. Do you want to just dump the images on a server and somebody with direct server access will fish through them, or do you want it all tracked in the DB with a CF interface? (Go DB/CF.)
I'm also assuming "index" means attach metadata, not initiate DB indexing. Your DB could look like: image (tracks the image) ---- imageId (pk) imageName newFlag editFlag displayFlag ladingId (fk) billingId (fk) prsnId (fk) prsn (tracks the people with access) ---- prsnId (pk) prsnName role (defines categories of people) ---- roleID (pk) roleName prsnRole (many to many join table) ---- prsnId (fk) roleId (fk) Somebody uploads an image (CFFILE to handle it). The newFlag is set. When someone logs on they can see what images are flagged as new. Views to the images are determined by the person's roleID. They select an image to edit and the editFlag is set to lock out others. They add metadata. The editFlag and newFlag are cleared and the displayFlag is set. Sounds pretty straightforward to me. It never is, but this is a start. If the process is a linear one, the image flags could be one statusFlag with a join table to look up the status levels. This would let you add more steps easily. The biggest problem I see is the "image files of all formats". If they aren't a basic web format it could be hard to display them without a transformation engine on the server. And even then, you may not get all types. What do you do with .fli files? And using a cffile without restricting the file types is asking for trouble. Cheers, Kevin Graeme > -----Original Message----- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 26, 2002 9:20 AM > To: CF-Community > Subject: OT: Site > > > I have someone that needs a site. > > Could this easily be done with CF. Has anyone had any experience > doing such a job? > What would you charge for something like this? > > It needs to be database driven (Access) > > Here is the scope: > > 1. Several people from PEI, NB, Vernon BC, Vancouver BC, Prince > Albert SK, and Vancouver Island will need the capability to > upload image files of all formats to a staging > area. > > 2. The customers� staff will login to the site and index the > images one at a time based on 3 criteria, Bill of Lading number, > Invoice number and customer name. > > 3. The indexing will move the image files to the main part of the > database (this part is read only � and print capable) > > 4. There should also be different interfaces for each category of > login. E.G. carriers, Customer, Owner, Administrator. > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
