
david s
Members-
Posts
57 -
Joined
-
Last visited
Everything posted by david s
-
Hello to everybody, i have a big question for me, maybe not for you :-) : I need a db where my user after having put the records, can print a list with a very good layout (similar to word). The user must put all the record, then check what he wants to be published in a list, and then only the selected records must be written in a particular layout (no ptoblem on this). He must be able to change the spaces between the output list, and the characters. I know this could be done in two ways: 1. create a layout in fmp where the selected records are inserted (in this case i don't know how to let the user modify the layout, the spaces, the character, ecc...) without modifying the fmp layout. 2. create a script that exports the records and then open the file with word. In the second way i loose all the formats of the layout made with fmp (character, spaces, ecc...) beacuse fmp exports only the data and not the formats, and i need to make a script that automatize all the process from fmp to word. Any suggestion? Thanks
-
Garry the user could have more than one record (some one and others more than one). Anatoli even if i have never used token i'll try with a little tests... i'll let you know what kind of mess i'm going to generate -) Thanks David
-
After a lot of tests i've found out that the error was simply in the type of link. I needed to put a full link and not a relative path. Now all is ok. I want to thank all who helped me in the solution of my problem, and i hope that this post will be of help for future visitors who have the same problem. Have a nice day to all. David
-
ok, it works. But now i've a little new problem: BEFORE THE WEB SECURITY DB User logged in with a form which checked the field login and password and found his record to make changes on it. (on the db i have user and passowrd) AFTER WEB SECURITY I've set up a form (yours) to autenticate the user who has now edit privilegies. The fact is that after the log in the user can access all the records and edit all. I need to let the user access only his record... any ideas? I know why it happens but i don't know how to resolve it and have: 1. User access only his records 2. User edit only his records Then i have another problem but next time. Thanks David
-
hello, i've inserted the new math function you suggested. But i think the problem isn't there. This is the eviroment where i find the error: After going to the main page with the javascript i navigate into the next page, i've set up a link at the bottom to go to the main page. With IE 5.1 for mac os 9 i click the link to go to the main page and it seems to me that the javascript doesn't run. I have a blank page as result. So when i write the domain name again it works. Very strange. The link to go to the main page is something like: http://ipadress/index.html where index.html is the page I set up with your script. This problem doesn't occur on win machines. Could it be a problem with IE 5.1 on mac? Thanks
-
Ok these are the news: I've set up a correct configuration of javascript and it works: <html> <head> <script language="JavaScript"> function GetRandomRecord() { var i = Math.round(Math.random() * 100) parent.main.location= "http://FMPro?-DB=database.fp5&-Lay=layout&-Format=index1.html&-Error=error.html&-Skip=" + i + "&field1=a&-Find" } </script> </head> <frameset rows="0,*" border="0" framespacing="0" frameborder="no"> <frame src="testa.html" name="testa" noresize> <frame src="javascript:parent.GetRandomRecord()" name="main" noresize> </frameset> </html> The error was in the-- frame src="javascript:parent.GetRandomRecord()"-- that must be without the '. THANKS TO ALL for your help. Note: on a win browser everything is ok. On mac browser (same as win) i'm finding problems whith links to this page (the one of the code above) Sometimes the page, after the click on the link, is blank so when i refresh it's ok... any ideas? Have a nice week end. David
-
Hello, thanks for your time, but i doesn't work. The only thing i see is the name of the function in the frame. It seems to me it doesn't run the javascript.
-
I had a lot of times this problem: sometimes with iis5 connector doesn't work: it works for one or two months then it's impossible to access the configuration tool with no reason. I think it is a problem with privilegies in iis that sometimes go away with no reason. The solution for me was to format all and perform a clean installation of iis and fm. The last time it happened after a deframmentation procedure.....?:?:? There things not explicable for me... Bye bye
-
It works. Thanks again One more question: this is what i have set up: the index page of my site is composed by two frame the frame 2 (the main one where people navigate) perform the redirect to the search of fmp automatically...i need to put that javascript to that frame in order to perform the random search. Is it possible without going to another page again (where i put the redirect again) or i need to redirect two times the visitors? Thanks
-
Thanks to garry and to everyone who is helping me.
-
Sorry but i don't understand: first part of my questions? You mean to insert an hidden field in the login form to make the button of the form work? Thanks
-
ok many thanks i've tried and everything seems to work fine. Two more quesyions: 1. The form button doesn't work fine: when i put log+pass and press enter nothing happens, when i click on the button everything is ok. 2. After the login procedure i need a link to let the user create a new record. (as a test for privilegies). How should be this link, i mean where are stored the information about log+pass? directly in the link as "fmpclientusername"? something like this? &-new]http://localhost/FMPro?.............[FMP-Clientusername]&-new could you please write an example? Thanks Garry
-
Thanks for your time, i'll try it. The pourpose of the scripts are differents: send to me an email when a new user sign up and to him to retain the login password, ecc... Thanks a lot
-
Thanks for your post: A few question: - the port number is necessary? what is it aim? - In which sense "if you use javascript"? I need to prepare a javascript code or it's necessary only the link you posted? Other questions: I've tested ws db and this is what i've discovered: - If i make a user "everyone" with no password (browse, script) and then another user "user1" with different privilegies (browse,script,edit) my dbs can't be browsed.... and everytime it promts the login window. If i delete "user1" everything is ok. Missing something?
-
Hello, i really don't know what could be i can guess: - problem with a old version of web companion? check the latest - problem with your browser? check the latest Hope it can help Bye
-
Nothing to check there..... Probably an old link.. Thanks anyway
-
Hello, i'm testing fmp with web security db. I need to let the visitor log in with an http form (not with the standard window of web security db). How can i pass the username to web security db? in my db i've set up a field called password wich is the same of client username of web security db. Thanks
-
SECURE DBS: WEB SECURITY DB Ok let's talk about it. In the web security db you assign to each user the privilegies to: db,layout,fields. Imagine a db where each record has progressive number of visits: so "everyone" should have access to "edit" or to run script that increment the visits to each record. The user "everyone" so could run remotely the script or the edit command to make a mess.... And i'm not talking about the "new" command.... And much more the web security db is a db...so if you make a script that copy the user name (log+pass) to let him access, you must assign privilegies to "everyone" to run scripts...we are at the beginning. I confess my skill in fm is not like others here, probably i miss a lot of things... help me to continue this information on security. Thanks to all.
-
Ok i knew this. The fact is that filemaker web publishing is completely unsecure. My aim is, as explained before, to compile an unique article for all publisher (if it doesn't exist on this forum) that intend to publish with custom web publishing. So i'll continue with this: PUBLISHING PROBLEMS Even if you can restrict access privilegies on each database file with windows privilegies you must remeber these considerations: - All the data in your database are accessible (format,script,ecc..), so a user can do what you dbs are created to do (edit,delete,find,view,run script) and look to all the fields. So i'm asking again: what is the most secure method to publish dbs? LASSO?
-
I'd like to resolve one by one problem before going to custom publishing. (i speaks about SERVER WEB: IIS5 + WSC + FMUNLIMITED 5) 1. NOT TO LET THE VISITOR DOWNLOAD FM DBS - All the files are in the web folder of FMP - The IIS privilegies for each db file are only for Admin (everyone has no privilegies): in this case nobody can see FM dbs. - The IIS privilegies for the general folder in wich i put DBS+WEB PAGES are for everyone read,execute. Please post here your info and corrections.
-
Hello to everyone, i'd like to know what is the best security methot to: 1.protect dbs over web 2. manage password to let the web audience edit,clear,create records My purpose is then to assembly the best method and publish here for future visitors bacause all the forums are full of security issues and notices and i really don't understand what is the best method. Could everyone partecipate with me to this goal?
-
thanks peter i'll try and then write back as reply.
-
Hello, i've tried but no solution for now. How could i generate a random number with javascript or other method? Thanks
-
Great, i new there was a cdml that could help me but i couldn't remeber what... it was skip!!! Thanks a lot. These are the news: - Everything goes great with skip (if skip is major than the number of records i think it publish the last one) And now....any suggestions? I'll try something i have in mind if you get an idea please write it. Thanks
-
You're right i didn't say i 'm publishing with Custom Web publishing. I'll take a look to your site. I don't need to run scriptmaker, it was only a test to find a solution. Any idea?