I am new - so I am not sure where this goes

[Tybarv24]

I am working on an .asp document with mulitple fields and drop-downs, etc. I was wondering if anyone has had problems with .asp and the database that it creates? I will be creating a user admin page to access this database and also, there will be file uploading as part of this web based document submission.

I was just curious if anyone had tips, suggestions, on this type of paperless document.

[buntine]

I'm not sure I follow. Have you started this project and run into a specific problem? Or are you simply curious about any considerations?

Regards.

[Tybarv24]

Yes. I have started this .asp form document. I am having problems getting it to

1) I tested the form and it seems that the data is not going into the database because I am not getting my confirmation.asp file. Not sure if it is the amount data or server handling.

2) I am working on putting validations on the fields - would that conflict with trying to write the items to the database (mdb) backend. Since I have not really worked with a real database backend I am not sure what the normals are.

3) Not sure the length of fields may have conflict because there are textareas and dropdown choices for user to select. It may be the way it is coded. But it seems to be working when I use html/csv file types.

4) Also, not sure if having spaces where a user can upload a file is an issue with this document.


I was just curious on generalities and tips of .asp that I may be missing.

[minority]

i am currently woring on a qms quality managment system which is similar if not same.

The problems i have found is mainly due to asp poor inability to do uploading as it has large overheads.

i aint experienced much more problems unless you are doing this as an intranet then permissions are always an annoying thing especially if its a domain.

Nearly completed mine except for a few admin pages (edit which department sees what doc type, add new doc type etc)

Currently working hard on a non conformance system which is doing my head in at moment.

[Tybarv24]

That may be the inline problem - this is part of an intranet system of tracking documents and forms. They want the form to be the main focus for the user to fill out and the uploading fields a part of this.

As well, a backdoor admin page to retrieve any files that may have been uploaded through the form and a nicely formatted database reports both from the form and the calc.

Also, automatic calc of columns and report generation based of what is input into the database.

I thought .asp type of setup would work the same as html/csv web based form and found that problems are really annoying and conflict with overall scope of this project and deadlines.

Just thought someone had gone through similar frustrations with .asp type of setup. Any tips/advice is most welcome.

[minority]

what type of security are you planning on using sessions.

I am currently using session based with the user basically automatically logging in through there username for xp this just means that they dont need another username and password to remember lol but means you got to get all the permissions correct and vpn just is a pain in the arse.

hmm i done csv before.
My system currently uploads any type of document up to 10mb. user inputs department, file to upload file type (if file type has a sub category then it shows) and version.
This is all then upload to a upload folder. and is read for use.
If there is a possibility of loads of similar documents and a need to prevent users from using the old docs then i would implement an archive system. As users will always go for something they prefer rather than what is the newest edition.

On my new system i will be requiring stistics of number of tickets open from x day to today say number for each department each user etc. so if you are requiring similar we can always contribute to each others work lol more than willing to help.

[Tybarv24]

It is just going to be an html page with username and password for those sessions. I think what you are suggesting is miles above what I am trying to do.

Basically, what I am doing is taking a paper form and making it web enabled so that the same information a user would enter is the same information that they would place into a paper form.

They are uploading supplemental information as word documents and pdfs within this form.

As well, there are columns that need to be automatically calc as part of the backend into a database.

This database and the upload folder will attach to an html page which will connect to a html style username and password page.

I have never really used .asp or databases in this fashion before. So, I am working on it in the event it needs to go to Oracle later down the road now instead of later when the actual document system is online.

It may be easier, just to use the html/csv system for web based form then copy into Excel.

But the goal is less manual entry and more automatically receiving the data from the database that has already been filled in by the user through their web based form.

I know I keep repeating myself - but that is how frustated this seems to me right now.