Description of requirements/features: We are looking for a way of allowing a user to upload potentially thousands of images and documents and then cycle through each image/document and assign some details to that document which then get saved into MySQL.
Ideally the user should be able to upload a zip file containing all these documents/images and then the system opens and extracts the images. Each of the images should then be transferred to the correct directory and a record created in MySQL for the document - this should be done in the background without the user needing to stay on the screen etc. Once they are all processed the user should get an email to let them know the processing is completed.
The user should then be given an interface which allows them to cycle through all unallocated documents (i.e. where the user is blank) - where possible the interface should show a preview of the document and where it isn't possible then at least a link to view/download the document if needed
To make it slightly easier we also would like the script to try and "guess" the owner based on a naming convention - for example if the document uploaded is called letter.doc then there isn't much we can determine but if the document is called james_smith_letter.doc then the system should check if there is a user called james_smith and, if there is, then that user should be preselected from the user dropdown list.
The actual fields (other than user) are not really important so for the purposes of proving this works as long as you can display the image/document preview, the user dropdown (based on a lookup) and then one or two additional fields using lookups from other tables and simple text boxes then that will be fine
We have mentioned AJAX above as want this to be as seamless as possible - ideally we don't want the user to have to press lots of buttons etc and would like to keep page refreshes to a minimum especially if there are thousands of documents!
This needs to be written in standard PHP with no frameworks - you will need to build and prove this in your test environment and then we will upload. There is no access available to our systems or database etc.
Jason D.100% (58)
Jason's other projects
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Are you open to use another solution rather than PHP?
Considering the proposals received to this point, i was wondering if you have already shortlisted or identified someone to work with, or are still accepting proposals?
There are many details to be ironed out before the project can be completed, but nothing very big, but I do have a few questions before I can send a proposal:
1. is this part of an existing website or would it be a standalone product ?
2. you're mentioning users - would the website need a full users module (register / login / stats), or would those users come from a different source ? If you'll be needing a users module, would you also need a 'log in via ..' feature (as in - log in with facebook / google / etc..) ?
3.If this isn't part of an existing website, is the design of the website important, or is it going to function in a somewhat closed circle where practicality is more important than the aspect ? - I'm asking this because I'm no designer - I could use a generic theme to style the buttons / tabs / etc.. but beyond that I wouldn't be much help on that aspect.
The User interface is done already?
Can i see?
its not really clear what you are asking for Jason! in one part of your project, you talked about 'the images to be uploaded' which makes me assume that the files are images and then in another part you'v ementioned .doc files! could you please clarify exactly what the files are that the users upload? also, please explain in greater detail what you mean by this bit 'The user should then be given an interface which allows them to cycle through all unallocated documents (i.e. where the user is blank) - where possible the interface should show a preview of the document and where it isn't possible then at least a link to view/download the document if needed'