• 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. 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
  2. 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!
  3. 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
  4. 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!
  5. 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.
  6. 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?
  7. Thanks Wim, With 'never' you mean that the Mac folks will not see the files until I recalculate a new path for them, no?
  8. 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!
  9. Thanks for the reply the mistake I made was not with the quotations marks but when I turned the path from local to server... that's fixed now but overlooked earlier... sorry. As for the $$globals... I've been reading up on using the vars in AS, and somehow I was convinced that using globals was the way to go, not sure why. I'll make them local and see if it still works fine Thanks comment!
  10. Hello I have a script that creates an indesign file with correct measurements, and it stores it perfectly when I set a fixed filepath in the AS. I need a filepath that is calculated to a folder on a server. If I put the path in as text, in AS, it works fine, but when I insert a $$VAR it somehow does not understand what it... I am using the following (wich works but is not calculated) save document 1 to "MC Kranten:Weekproductie:WK03:H24997188_POLDER-EN_2.indd"¶ I have tried to create a calc field for the whole path+name and use that in a $$VAR but that does not work. This down not work: save document 1 to" & $$DOCPATH & ¶ Is there anyone that spots what I did wrong here?
  11. Update: Joe (360works) made it work. The file path (on Mac) has to start with /Volumes/ when accessing a network share. I did try that and filemac:/, file:/, full server path, IP/share etc etc, but a simple typo (the capital 'V' in volumes was what went wrong. Really stupid. But fixed now and working like a charm! Thanks again Joe for fixing this, and john for trying to help!
  12. uhm maybe someone else can help me with this? I would really appreciate it if this was solved, it's kind of a showstopper now :/ Thanks in advance!
  13. Hello I have a folder on an ftpserver where clients upload their data (xml). After uploading it gets moved from the FTP to a (Mac) server in a folder on a share named 'MC Kranten'. Filemaker imports all the XML files that drop into that folder on a timed script. That works just fine. However, I would like FM to remove the said XML's after importing as they have no use anymore and would only slow down the import process when it's checking for duplicates all the time. I installed the 360works ScriptMaster, which worked like a charm on my local machine, but now that I have the scripts all running like they should and I'm confident that importing/deleting would good very smooth, it's not deleting from a share. I'm using a path structure as specified by FM, but it somehow does nothing. Also tried it in the sample database that is provided: local yes, network share... nope. Is this not possible or am I having a 'duh' moment (again). Thanks!!
  14. hmm I think I did forget to ask the question… sorry about that. Your answer is correct and the same as I had done it. But it's not working. In that order, Time (asc) is not working anymore. The other way around, the locked is not working. Tried to separate the two in two different sorts in a script, but no luck. The Time field is from a related record, so I figured that might be a problem and then populated a field in the parent DB with the same time and tried to sort again, not working… very odd. I'm working at it for over an hour now. note I was about to post some images for you but my machine froze up. So after opening and checking the data, it now works ?!? very very odd. Working now - thank you very much, Eos!
  15. Hello Not sure if this is the correct topic, but here it goes: The search returns a set of records and the two fields I'd like to sort them on are 'locked' and a time field 'TIME'. 'Locked=1' means that the record does not need any attention now but should still be listed, and the time it a deadline. I can sort on one of them without a problem, but I would like to know if I can sort them like this: REC#1 -> LOCKED = 0 - TIME is 16:00 REC#2 -> LOCKED = 0 - TIME is 16:50 REC#3 -> LOCKED = 0 - TIME is 17:00 REC#4 -> LOCKED = 0 - TIME is 17:20 REC#5 -> LOCKED = 0 - TIME is 18:00 REC#6 -> LOCKED = 1 - TIME is 13:00 REC#7 -> LOCKED = 1 - TIME is 14:20 REC#8 -> LOCKED = 1 - TIME is 15:00 Is this possible?