• Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About balooka

  • Rank
  • Birthday 10/04/1972

Profile Information

  • Gender
    Not Telling

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Mac OS X El Capitan
  • Skill Level
  1. Thanks Wim, I assumed that because I was able to select the script in the server (using my admin username/password) I would be able to run it. I didn't think about the user rights on the machine itself as script maker ran the script on the FMS just fine. I'll look into the this now. Thanks for helping!
  2. Hello I need to run a daily script to unmount and mount a volume using applescript. The script runs fine in AppleScript but does nothing (as far is I can tell) in a scheduled script in FM server. Is this a problem of location of the files (on the server) that causes the AppleScript to not function? Testing the same on a local copy of the file works just fine. The script I'm trying to run inside FM: tell application "Finder" try eject disk "directie" end try end tell set my_volumes to "directie" set the_volumes to list disks if my_volumes is not in the_volumes then try mount volume "smb://" as user name "directie" with password "Vekabestadm2016!" end try end if Thanks!
  3. Hello Wim, I think I might have misread your solution. I already have a web viewer on my layouts and somehow I only half-read your solution. I thought you meant to view the whole thing inside a webviewer.... my mistake! I'm going to try that right now!
  4. Hmmm I think I have it working now... looking for the flaws that I missed. I have an on commit trigger to set 2 $$vars with record ID and timestamp if there was a modification in the record (empty otherwise), the account name is the current user so no need for a $$var there, So every time it is triggered by a modification and commit it will set these two $$vars to the exact same values. The second trigger is the Onload script trigger that will check if both $$vars are empty. If both are in use, meaning there has been a modification in the previous record, it will set a new line in the log using the $$vars and the account name. Clearing both $$vars after that will reset the script trigger. One flaw I already see is that a user could close the database after the last modification. ETA The two Vars somehow did not transfer as I would like them to. Solved that by using two globals to hold the content of the recordID and the timestamp. The vars are only used when adding the line because I needed to clear the globals before the end of the script (started looping).
  5. Thanks Wim I seem to always assume that some things are pretty basic and would not involve that much hassle. I'm not in the position (time wise) to redo my designs, unfortunately. I tried to work around this by having am 'on commit' script trigger to set a field to 'yes'. So even if there are 10 modifications in a single record, the value would still be just one 'yes'. I then made a second script that was triggered by the 'OnLoadRecord' script trigger (not sure what the English translation is) and using $$vars to see if the previous record was modified and if so, write a line to the log. But there are many flaws in this (if a user is not going to a next record or when the next action is a search etc). Why isn't there a script trigger for leaving a record... Thanks for the help!
  6. Hi Comment, You are correct when a user has modified a record ten different times it would need to show up ten times in the list (with a different timestamp). I have that now, but I saw a massive record increase in the new table and found that when a user opens a record and modifies a field and clicks somewhere on the layout in the same record, it commits. If a user modifies 10 fields and clicks on the layout between modifying the fields, it would commit 10 times. The result I now get is the same user modified the record 10 times when all that the user did was modify the whole record just once. In other words, this user only should have been mentioned once because he/she modified the record once, multiple fields, but just one record. Problem I have seems to be that the record commits when you leave a field in a record, rather than when you leave a record. A list of ten would indeed be much more efficient, I have to figure that out then (unless you have a working snippet for me?)
  7. Hi I would like to have a log or list of users that modified a record, but I do not really need to see what they have modified. Anyway, I have tried using the on commit script trigger to fill a table with record ID, timestamp and account name, which in a way works but the problem with this is that every time something is modified in a record, like a radiobutton the script will trigger if the user clicks somewhere else on the same layout and same record. So it commits a lot of times, filling the table with countless and useless entries. I would like to see only the ten (or so) last users to modify the record (not those that only viewed it!). I can use a timer to do a nightly run and delete all entries that are over 10, but I have no idea how to stop it from filling up the table. My script is now: if Get(ModifiedFields) = "", do nothing else set current record and user values in a var and create a new record in the acces table. It's triggered by the on commit script trigger. (My FM is Dutch so the translation might be a bit off). I am aware that there a solution that track everything, but all I need is so see who actually accessed and modified a record. Thanks!
  8. But to make use of the sub-summary I must sort on the A-field values, correct? I need to sort on another value and not disturb the current layout. ETA: Solved it in another manner using pattern count. This way I can sort on whatever field I need and see the individual summary values. FIELD PATTERN ONE would be: PatternCount ( Field_A ; "ONE" ) This will look for the pattern in field A and a resume total of that field FIELD SUMMERY ONE would be: Resume total of FIELD PATTERN ONE
  9. Hahah that would indeed get very boring, but this solution might just work fine for 5 options. I'll give this a shot - thank you very much!
  10. Hi After doing a search I get 65 records. The records have field [A] that holds 3 values; ONE, TWO and THREE. In the search result (as list view) I'd like to see the total amount of ONE's, TWO's and THREE's. I can self relate to get that value but isn't there a more elegant way to count N occurrences in a found set? Thanks
  11. Thanks Wim Indeed I meant schedule in FMS. There's nothing else running on the FMS and there are only about 5 people active at the same time. I've done the same setup with FMS 13 and there were never any issues. I should have checked of course if the backups were OK, and I did by looking at the file size. I've tried to zip them before transferring them to my own machine but nothing really helped. I'm going to install FMS again on a new machine and see if I can replicate the problem. If not, I'll just wipe the remote server and start over. I couldn't find anything related to this besides making clones, which I'm not doing. Thanks!
  12. Hi I'm running FMS server and have daily and hourly backups. I'm not using cloning and I do verify integrity. Today we ran into a major problem were some data was deleted and I wanted to use a backup and restore the data. I moved the backup file to a local machine (away from the FMS and to my local FMA 14) to check if the data we deleted was stil there. But the whole file is empty?! All backups are empty, zero records. The file size is large enough to assume it should be there but there simply is nothing. 0/0 records shown. I'm not cloning for sure! I have made a new rule for backup and ran it right away and the data is still gone! So all 99 rolling backups are useless. I need this fixed as this is absolutely unreliable now. We assumes we had plenty backups, when there is actually no backup at all. PLEASE HELP. ps. Stopping the DB and downloading it results in yellow/red/green icons but I don't see it anywhere. Everything is on Macs and the FMS is running at another location.
  13. oh.... but can I create a new path for the Mac users, based on the path that the Win user created? I mean, the files are still stored at that location so I should be able to make a calc with container and present it in there. Or am I completely wrong here? I know I cannot show the container it was imported into, but the file would still exist at that same location, no?
  14. Thanks Wim, With 'never' you mean that the Mac folks will not see the files until I recalculate a new path for them, no?
  15. Hi I need to set a file path to a referenced image but I can't get it done. and really could use some help or guidance. I have an FMServer running on a Mac at a remote location. There are Win users that import images into a database, all as referenced files on a NAS disk (Z: drive). On Windows, the referenced file path works of course, but I need the Mac users to also see the files. A filepath to an image looks like: file://Z:/VKB Archief Data/DATA BELGIË/BE 2016-06 Motor/BE 2016-06 Motor inlezen/20160616-DSCF2970.jpg I've tried numerous ways of calculating the mac file path but I can't get anything into the container other than 'file not found'. [FMServer 14 and all clients are FMP 14] Can someone please help me out here? Thanks!