Gossamer Forum
Home : Products : DBMan : Customization :

Assigning Passwords

Quote Reply
Assigning Passwords
I am fairly new with DBMan and I am trying to figure out a way to automatically assign a password from a database field. So say we had field names, ID number and Last Name. I want to set the ID number as the userid and the Last Name as the password. Is there a way I can do this?

*this is my first experience with Perl too, so be gentle . . Wink Thanks.
Quote Reply
Re: [Em6554] Assigning Passwords In reply to
So you already have an existing database you are importing to use with DBMan? Or you are just looking for a way to generate the password while records are added?

Please visit the FAQ noted below and look under the section "Admin - Passwords" and you will find various threads, and you may find some ideas there. One thread which may be what you are looking for is called "Generating Logins & Password"?

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [LoisC] Assigning Passwords In reply to
What I want the program to do is take two fields as they are entered into the database and automatically assign them to the UserID and Password. The program is being used by an Automotive Group to track the progress of cars in the Body Shop. The customers can then sign on and see how far along their car is. They will enter in their RO# and their Last Name as the user name and password. Does that make sense??
Quote Reply
Re: [Em6554] Assigning Passwords In reply to
I'm pretty sure I remember someone else doing something much like you explained.

Did you check the FAQ under the section for ADMIN/ Passords? I'm sure the information you need can be found there. I'm sorry , but I'm in the middle of a project and don't have time to track it down myself.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Quote Reply
Re: [Em6554] Assigning Passwords In reply to
How about turning the problem round?

Write the db so that when the body shop updates the record, an email is sent to the customer with the updated info?

I have written my Form application in this way. When a record is created either or both of the Admin or Customer gets an email and an html file with a unique name is created and saved on the server. You can easily determine what info is put in the html file.

The customer can click the link provided in the email and see the record. The same thing happens every time the record is updated.

No need then for the customer to log in.
-------------
David Olley
Anglo & Foreign International Limited,
http://www.firehelmets.co.uk

There are 10 types of people in the world: those who understand binary, and those who don't.
Quote Reply
Re: [Em6554] Assigning Passwords In reply to
I guess what I really want to do is change the script so that instead of looking in the password file for the user name and password, it looks in the database. Any suggestions on how to do that???

Sorry, I'm new at this. . . .
Quote Reply
Re: [Em6554] Assigning Passwords In reply to
It sounds like you want to set the username/password automatically before the data is submitted. In that case use some javascript in the add_record form to do this. If you wanted to hide it from the user, just set a hidden form field to "" and then assign it a value using onsubmit e.g.

html code:
<form method=get action=url_to_dbman name=theForm onSubmit=setPasswd>
<INPUT TYPE=hidden NAME="passwd" VALUE="">


javascript code:
function setPasswd(){
document.theForm.passwd.value = document.theForm.last_name.value
}