Denniz

yes i noticed them but i wanna know if the other options are possible. I need to know before i begin

Hey there! I wanna make a FM app. which works as a photoalbum with the possibility to choose different layouts en pagestyles. So on each page i can select a picture with some text then i go the the next page...and so on.. After this i want the possibility to upload the whole FM album with FTP, this has to happen userfriendly so on background or something.. Somebody knows if this is possible in filemaker pro 6.0?

That did the trick It's working so perfect now! If you have another cool add-ons, let me know so i can make it total perfect Thanks for helping!

don't think there is something wrong with that script: Replace Contents [No dialog, "ChangeSummary", ... Case(not NumToText(FIELD1)= Left( status; Position( status; "|" ; 1; 1)-1); "FIELD1: "& Left( status; Position( status; "|" ; 1; 1)-1) & " >> " & NumToText(FIELD1)) & Case(not NumToText(FIELD2)= Middle( status; Position( status; "|" ; 1; 1)+1; Position( status; "|" ; 1; 2) - Position( status; "|" ; 1; 1)-1);"

I found one error, i had SET FIELD [ChangeSummary.. Now changed that to REPLACE CONTENTS [ChangeSummary.. but now when i import the database with one change, the Statusfield goes to "CHANGED" and the ChangeSummary shows all the recordinfo WITH all the pipes

It didnt't work, my status field sais 'changed' and the changeSummary sais; name: >> Peter |||| age: >> 23 |||| And when i change 2 records, just 1 records work with the changeSummary so i think there is a flaw somewhere? (FIELD1 | FIELD2 | FIELD3 didnt work, it has to be FIELD1 "|" FIELD2 "|" FIELD3 but that didnt seems the problem over here)

ok but then i have to change it to; FIELD1 | FIELD2 | FIELD 3 etc.? Then its gonna be a messed up field with some text and pipes

thanks CobaltSky, when you typed your reply i editted my post. I did exactly what you said BUT did nothing with the pipes maybe there i can find my error? (i now use FIELD1 & FIELD2 & FIELD4 etc)

hey cool concept that ChangeSummary! It works pretty fine BUT, now when i change something and import it, the CS field shows the same values as the recordset. So you can't see whats the old and what's the new value, it just shows all the fields. Another flaw is that he just changes the first record with a difference, when i change more records then after importing he gives back just one record with a difference, so CS field stays empty in the other records (status field works fine btw) Is it possible to just show the old value of the changed field in all changed records?

It was the comparison between the two replace[] scripts, they weren't the same...now they are and it's working! Another *bonus* question is, is there a possibility to see 'what' is changed in the record? (maybe just by a * or show the old value?)

Hey Cobalt, The Script works ALMOST perfect now My Unique ID is the field i made by myself (Keyfield) so every record has his own ID/key. I have 2 more questions about my script. when activating my first script in the Tempfile: Delete all records [no dialog] Import Records [restore, no dialog, "database.dbf") SetField [Exact("Keyfield";"main::keyfield")] Open ["main.fp5"] Close[] I get a message "this field is not midifiable" after OK the script goes on, how can i get rid of that message? (when i delete "SetField [Exact("Keyfield";"main::keyfield")]" the warning is gone. But this one is quite important huh?) Another question about your last script with the 'status' field, it works very nice...... BUT! When i import a NEW record it goes OK (it says NEW). When i do the same import again, the new record goes to CHANGED (it must be UNCHANGED). I Only want a CHANGED when something in a record (with the same ID/Key) is changed. When this is working i'm a happy man

found the trick..sorry "In your document preferences you can specify a script on startup or on exit of that file. Check the perform script on startup and select your script."

Hi there, I want to load a Script in Scriptmaker without clicking a button to activate. (So want to load a layout and On-load activate the script)Is it possible?

Keyfield is mij unique field where i store most important info of that record (there is no ID). So i want to compare that Keyfield in my imported temp file with the Main database, if its equal, UNCHANGED, if the record CHANGED .., if the keyfield is NEW make a new record. thats my whole story The script above only imports te record over and over again, no status text is seen in my status textbox..

you're understanding me very well and i'm coming close now but i miss some points What do you mean with the 'synchronisation' , is it the part with "SetField[Exact(Keyfield;main::keyfield)]"? after that nothing happends to sync? I'm now gonna try your solution, but think i miss some sync stuff in my temp file. now my scriptmaker is as follows: Delete all records [no dialog] Import Records [restore, no dialog, "database.dbf") SetField [Exact("Keyfield";"main::keyfield")] Open ["main.fp5"] Close[]

Have it done know, forgot to make a relation can you explain this part of your solution: do a scripted find on selectforimport =1 delete found records trigger a script in masin db to import (with update, your key field) thanks.

Thanks, i'm on my way! maybe a strange question but how can i get connected to the other database, i'm now active in temp.fp5 en want to exact() in main.fp5 (field name = 'Key') field "Key"(in temp db) exact(Key, main.fp5:Key) does not work.

Hi there! Got a question. I have 2 db's, one "Temp" database with an Import button to import data from a dbf file, after importing i'm activating the other db; "Orders". Now i want to import the data from the "Temp db" in my "Order db"(script on startup), but i first want to check a calculation field(unique code) to see if its a new, editted or unchanged record. If they are the same..do noting, if there is a difference...change the record...else ...make a new record. I also want a statusfield after updating (so if a record is NEW, CHANGED or NOT CHANGED since last synchronisation) I really dont have a clue how to do this, can somebody help me with this one? thanks..

Hi there, I'm a newbie with Scriptmaker so maybe some of you can help me with this problem: I have to make a script which IMPORTS RECORDS (dbf), then COMPARES the records with records in another database. Then IF they are the same DO NOTHING, ELSE REPLACE them. (everytime i have to import a whole new database, so i have to check every record every day). Is there a way to do this in Scriptmaker, IF yes...how? Thanks, Dennis

it still doesn't works, isn't there another way?? maybe some java/CDML script i can put in my not-protected files?

i have FM 6 but how can i protect my format files? and how do i change my database to "exact search"? (maybe its too early today )

I know have a login page, which works with my user/pass fields in my database: [color:"red"] <form action="FMPro" method="post" name="loginform"> <input type="hidden" name="-DB" value="web_site.fp5"> <input type="hidden" name="-Format" value="startindex.html"> <input type="hidden" name="-Type" value="user"> <table width="250" border="0" cellspacing="0" cellpadding="0"> <tr> <td>Loginnaam</font></td> <td> <input type="hidden" name="-op" value="="> <input type="text" name="guser" size="20"> </td> </tr> <tr> <td>Password</font></td> <td> <input type="hidden" name="-op" value="="> <input type="password" name="gpassword" size="20"> </td> </tr> <tr> <td> <input type="submit" name="-find" value="Login!"> </td> </tr> </table> </form> the login works great! but every source checker can pass this login (see hidden type=-Format). Does anyone have a solution for this?? ciao, Denniz

I dont use frames in my admin (its a home made one with forms). And if i secure with the Web Security nothing happends when i go to my admin (no password pop-up or something). Is there a way i can do it with a login page (which will leave a cookie) and protect the rest with a cookie check or something?

Hi there! I've got a security question: My webroot is like this: - index.html - index2.html - mailme.html ^images ^admin --adminindex.html --adminindex2.html Now i want to protect my admin directory with a login (login.html form)(i have a Username and Password field in my database), after login they have to go to the adminindex.html file. I also want that adminindex2.html is protected, so that file has to check if i'm already logged in (cookie?). I hope somebody can help me with this one! Thanks, Denniz

thanks but i have the answer written above your reply..it works!!! Thanks anyway Jeff