Flo

Hi there, I have some problems to put the date in English when it comes from a script. The only parameters I can modify are : - Either it takes the language of the OS (which is in French here) - Either it takes the language used when you created the DB (which is German ) ) How can I force it to be in English for all users ? Thanks :)

Hi folks, I have quite a weird problem.... I have to search someone among a list of person.... this looks like this : This works fine for every one, except for the name "Frank Pintér"... The research is based on this layout : I do the name research (upon the "Name Concatenated" field) in every possible way (Last name first, then first name, first name first, then last name, upper case, lower case, considering the accents etc...) The thing is, when I manually research "Frank Pintér" using the search mode (Ctrl + F), it works... Here is the script i use : Code Here This lookds weird and I tried my best to make you understand my problem.... feel free to ask for precisions if you don't understand anything Thanks !

Ok, I made some tests, I think I located the problem... The thing is, when I am pushig the button to get to this layout, I do some stuff in a script, and after that comes the "Go To Layout ...", then I put the focus on the first field that needs to be filled up. But on the IWP, once you click for the first time on a field/list/whatever, it "activates" the fields so you can modify/fill them. After being activated, I cannot go to another tab.... Thank you for your time and help ! Regards, F.

Hi folks, I (again) have a problem with the IWP... well, on the full client, as usual, everything works fine, which is not the case on the web client. I have a layout with a tab control on it, and I have some problem with it on the IWP... My problem is that, when I access the layout through the IWP, I simply cannot switch between the tabs. Well, if i clic on another tab, it does nothing, and if after that I push a button that redirects me to another layout, an error messages pops and says "Data not found: The following data cannot be found" (Translated from German) You can view and understand this more precisely here : SCREENSHOT Thank you in advance for your help! Regards, F.

Ok, I found the solution, sub-summary field are simply not compatible with the IWP.... So I adapted my solution in a compatible way : Seeya

Thank you again Fitch ! I am going to read this carefully in order to set up the good privilege set... Regards, F.

Thank you Fitch ! Could you please indicate me how can I manage these privileges then ? Regards, F.

Hi folks, is it possile to restrict priviliges on the IWP ? For instance, I want to prevent people from creating, deleting or modifying records. See printscreen >>> HERE <<< Thanks in advance :)

Hi everybody, I would like to generate a report that contains sub-summary fields. It works very well on the full client, but if I access the layout on the IWP, no records are shown. Also, whenever I want to sort these records (even if there is nothing to sort -/ ) It's like if there were no field on the layout.... Is there any known issue about sub-summary fields and IWP ? I hope you understood my problem, it's a bit weird tho. Thanks for your help !

Thank you for your answers ! I really appreciate. Well, I also tried to export in another local folder. But in vain The path is correct, but it just doesn't export and it gives me a "scripting error" : 2010-09-16 14:46:00.766 +0200 Information 645 PMDB Scheduled Task "fg": Scripting error (800) at "Dev_Patchlog_PMDB_V100 : PL_WebExportTrigger : Export Records". I am really getting a headache at trying to export this stuff ! I tried to export using "Get(DesktopPath), Get(DocumentsPath), Get(FileMakerPath)" .... F.

Hi I just fell on your post and it's exactly what I am looking for... I am still pretty confused with the send DDE command. What should I put in the "Service Name", Topic, and command field ? Well, I guess that cmd /c "..." goes into commands, but the rest ? Thanks in advance for your help, F.

Hi there, It seems that I have a small problem with a scheduled task... What I am trying to do is to run a batch script which will mount a share, and then execute my filemaker script (which is supposed to export records as a .xls file on the share. The problem is It blocks while executing the batch file... it stays in "processing"..... See screenshot : (Wird ausgefürt = Processing in german) ZOOM here Any ideas ? Thanks a lot in advance ! EDIT : The batch file works perfectly when executed manualy !

Hi folks, I did not really know if I had to put this topic in the "Import/Export" or the "IWP" forum, so I put it here As you all know, the filemaker command "export" is not compatible with the IWP. So there is no direct way to export records in a excel file from there. I found a way (pretty complicated tho) but it SHOULD work. Could you please give me your opinion about it ? and IF BY LUCK, someone has the miracle solution, I will be glad to read it ;-) So, my solution : If a user wants to exports a bunch of records from the IWP, it will put a "command" in a spool (layout) with the desired parameters. In my case, this will put : command_id, user_id (who wants to export), the status (i'll explain after) and some other fields. THEN, I'll schedule script every x min (let's say every 5 min) that will check the spool-layout, ans see if there are any "Pending" command (the status i wrote before, "Pending", "Processing", "Error", "Done"). Once it has found a "pending command" it will export it. ZOOM here Ok, it sounds pretty weird and complicated but it's the only solution I've found so far (not fully implemented btw). There you go, feel free to comment it See ya

Thanks !! This works perfectly... Cheers ! F.

Oh Thank you for the quick answer... I'm going to test that and I'll keep you posted of the result ! Cheers, F.

Hi there I'm getting mad trying to do something (which would be very very easy in Java or PHP) in FileMaker. Here is the thing : I have a list of modules I get from a checkbox. This looks like this : AA BG BR SR1 SR2 ... And I would like to store each module in a tab (a variable with repetition in fact). If all module were written with 2 letters, that would be easier... but it's not the case ;o) Set Variable [$mod_list; Value:Global::G_Export_Module_List] Set Variable [$mod_list_tab; Value:""] Set Variable [$repet; Value:1] Loop //It's here I need your help ;-) End Loop Thank you in advance for your help ! F. [color:red]EDIT : Check the custom function "split" which might be helpful : http://www.briandunning.com/cf/45

Hi there, I'm having troubles with a checkbox field using the IWP. On the full client, everything is looking perfectly, but it's not the case on the IWP. Here is a screenshot of the problem. http://yfrog.com/n9checkboxproblemj I've been trying to resize, change the fonts, the borders, etc. But the problem is still here. I know some people already posted topics about it, but either there is a link with the solution which is no longer working, either I don't get the solution. Thank you in advance for helping me !

Thank you for both of your answers ! @ Barbara : I though about the solution with the batch file, but it's not very clean :s ... @ Wim : Yep, that's the problem indeed. I need a user with the privileges to perform the task. (I created one which should work by the way). And it's why I wanted to mount the volume, using the privileges of the new user. I am kind of stuck right now. The thing is : Whenever I try to make a script-sequence with in first position the batch, and in second position the FM Script, it doesn't work ! (FMS get stuck while try to perform the batch (which is correctly written) I will try once again with the new User i created... Cheer, Flo

Thank you very much Win :-) ! Cheer

up : ?

Hi there, Here is a sample of my Event log file 2010-08-24 16:54:00.207 +0200 Informationen 645 PMDB Zeitplan "rt": Scriptingfehler (800) bei "Dev_Patchlog_PMDB_V100 : PL_WebExportTrigger : Export Records". Does anyone know what the number [color:red]645 corresponds to ? Thank you in advance, Flo

Thank you for your answer Barbara. The thing is that the command "Send Event" is not supported in a FMS scheduled script. So I can't use it... I think that the only option would be to mount the share through a batch file (or whatever script language) before the execution of the Filemaker script. I'm still digging around .....

Hi there, I'm trying to execute the following batch BEFORE a Filemaker script @ECHO OFF net use L: sharefolder /user:myUser "myPassword" pause Note that, the user i'm using to mount the share has full privilege. I have to mount a share in order to export periodically a .xls via a Filemaker script. [color:red]THE PROBLEM IS that when the scheduler starts the batch, it says "processing" (or "Wird ausgeführt", I'm using the german version of FMS) and nothing happens. Seems that he cannot execute the command "mount". Any idea ? Thanks in advance ! Flo