Sarah
|
| Posted: 02/07/2002, 5:10 PM |
|
I am designer that would like to be able to do some programming. I am working for a trucking company designing a web site. They want to be able to scan and upload bill of lading documents and have thier customers log on and view their companies documents and print them out. I have been trying to design this and I'm afraid I've made it to complicated. any suggetions of how to design this? The biggest problem I've had is determining how to have customers log in and then be given access to only their companies records and not see other companies records. I would greatly appreciate any help anyone could give!
|
|
|
 |
Andrew B
|
| Posted: 02/07/2002, 8:35 PM |
|
To give the access :
When a customer logs in, you place their CompanyID into the session like so :
Session("CmpID") = Dlookup("tUsers", "CompanyID", "where...")
You can use the examples already in the login form's file to fill in the blanks.
In the documents table you have a companyID as well, linking that doc. to a custom company. When they go to look at their documents, you present them in a grid form that
a. draws from the tDocuments table
b. Has an input parameter called 'CompanyID' which refers to the 'CompanyID' field in that table.
b1. Set the variable's type to 'Session'
b2. Set the name to 'CmpID' or whatever you used in the Session.
This will give them only docuents for their company. You can do the same for the display of the document, insuring that they can't look at anyone else's.
As for 'scanning' them in... If you intend to actually use a scanner to scan in a paper document, prepare to be shocked. It's not very easy to do, and get in a proper form. Then you need to deal with updating the DB from the scanned document, which means clumsy OCR and a whole bunch of user-land issues.
The site itself is quite do-able. However, updating from an real scanner will be quite a trial to put it lightly. I tried to train one of the companies I worked for to scan in their technical documents and place them in the web server folders (even automated that) and they couldn't do it reliably. They really wanted to turn them into web pages, which *I* can do, but then they had to master the scanning software, the ocr software, software to fix OCRs f*#%ups and all the other sundry items.
I wish you luck.
|
|
|
|
Sarah
|
| Posted: 02/07/2002, 10:08 PM |
|
I have set up a database that has these tables:
CUSTOMERS- id, name, user_name, password, company_name, email, security_level, is_notified
DOCUMENTS- document_number, document_date, document_link, company_name, name
EMAIL_REGISTER- email_id, email_date, name, company_name
I am getting errors saying my syntax is incorrect. The field I would ike to use to filter the records is company_name. I a little confused on what the correct syntax is. Any help is greatly appreciated!!! Thanks
|
|
|
|
Nicole
|
| Posted: 02/08/2002, 5:02 AM |
|
Sarah,
I suppose it make sense to contact CC support (http://support.codecharge.com/support_new.asp)
about your problem and describe what form you have created, what are the settings where have you used company_name field, etc.
|
|
|
|
Sarah
|
| Posted: 02/08/2002, 12:19 PM |
|
I've contacted support, I get different answers from this forum and sometimes they are a little easier to understand.
|
|
|
|
Sarah
|
| Posted: 02/09/2002, 8:46 AM |
|
Under page properties event tab, under open I put $company_name = dlookup("customers", "company_name", "id=" . get_session("UserID"));
$sWhere = "where company_name =" . tosql($company_name, "text");
Then under the form properties tab I clicked the input tab and used put Variable Name- company_name Type- session Data Type- Text
And I still get all of the records, not the company records that I am trying for. I have also put echo $company_name; in the open page events and it prints out the correct company name I am looking for. Why is it not filtering the records?
|
|
|
|
Sean
|
| Posted: 02/09/2002, 10:16 AM |
|
Would you be willing to send me an example of what you are trying to do? I have done something similiar to what you are talking about and would be willing to help you if I can. Send a reply tosmroe@bak.rr.com.
|
|
|
|
Kris
|
| Posted: 02/09/2002, 2:23 PM |
|
Sara,
You might want to scan the files and store it as a PDF file using Adobe Acrobat. Then you can select a location of the source files and upload to a Web server or a database. If have code for this if you like. Once you publish you can have your customer view, download, or print. Also while uploading, you can name the document and provide description.
|
|
|
|
Dean
|
| Posted: 02/09/2002, 4:59 PM |
|
|
|
|
|
Sarah
|
| Posted: 02/09/2002, 11:28 PM |
|
I would love to have the code. Can I download it from some where or do you need my email?
|
|
|
|
Kris
|
| Posted: 02/10/2002, 8:20 AM |
|
Sara,
Please send me your email. I can send you the ASP code for database upload and web server upload.
kris@influentialtech.com
|
|
|
|
Ted
|
| Posted: 02/16/2003, 2:04 PM |
|
I would like the code for doing this
tj@theibnetwork.com
|
|
|
|
Tom
|
| Posted: 08/21/2003, 11:29 AM |
|
I would like the code as well
tom.ray@mirant.com
|
|
|
|
Users Test
|
| Posted: 10/20/2003, 2:50 PM |
|
I would like the code for doing this
|
|
|
|
test Chui
|
| Posted: 10/20/2003, 2:50 PM |
|
chivitaz@yahoo.com
|
|
|
|
Albert
|
| Posted: 11/20/2003, 12:39 PM |
|
I would like a copy of the code please. Send tomaya2@mayaco.com
Thanks,
Albert
|
|
|
|
mia
|
| Posted: 12/15/2003, 12:36 PM |
|
I'm trying the same thing, could you email the codes to me too?
miary@usa.net
Thanks.
P.S. Preferably JSP code, but if you have something else that's fine.
|
|
|
|
|
