Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


dkey last won the day on July 3 2015

dkey had the most liked content!

Community Reputation

1 Neutral

About dkey

  • Rank
  • Birthday 03/20/1937

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    13 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

1,515 profile views
  1. It works perfectly in case the pattern is either KB or GB Hower it doenst work in case the pattern is MB
  2. Thanks for your interest however even following step by step I am unable to create the external function After I paste in New external function the code FMPADV 13 tells me I need to enter the function for: Floor ( Ln ( bytes ) / Ln ( _ratio ) ) It selects the word bytes and I am unable to continue as I am not skilled enough to do it Even if some kind person will help to find the "bytes" I am afraid I will run into some similar or different tasks which I won't know how to solve. Thanks however Dan
  3. Thanks for your interes and time. But .... How do I add it as a custom function to my FMPADV 13? If I use it as a calculation or script FMP tells me it cannot find various fields and I am totally lost Thanks again
  4. In my DB I have a text file which tells me the size of audio and video clips as such 927 KB or 1020 KB and 27.5 MB or 15.26 MB and 2.01 GB or 11,3 GB I used the following suggestion from this forum: Mediasize::MediaSize * If ( PatternCount ( Convert Mediasize::MediaSize ; "GB" ) ; 1024 ; 1 ) but while it works fine with GB it doesnt work with MB or KB Instead of doing a script a did a calculation as such Case ( PatternCount ( Convert Mediasize::MediaSize ; "GB" ) ; Convert Mediasize::MediaSize* 1024; PatternCount ( Convert Mediasize::MediaSize ; "KB" ) ; Left ( Convert Mediasize::MediaSize ; Length ( Convert Mediasize::MediaSize ) - 3) /1024^2 ; PatternCount ( Convert Mediasize::MediaSize ; "MB" ) ; "0,00" & Substitute ( Left ( Convert Mediasize::MediaSize ; Length ( Convert Mediasize::MediaSize ) - 3) ; "." ; "" ) ) I used the Substitute function as in my country we use commas for decimals however while the calculation works I get really large numbers for KB files and MB files Is there a different way to calculate the text files to get regular number with perhaps a maximum of 3 decimals? I could use it as a script or as a calculation defining the field Thanks a lot and regards
  5. Hi in FMP 13 every time I create a new field I need to go to the layout mode and add it manually I think there is a way to do it automatically ... but I forgot how Would anyone be so kind to refresh my memory .... Thanks a lot
  6. Works perfectly thanks
  7. Hello I am using FMP13 and I have a MEDIASIZE field where all the data is something like this: 64.3 MB or 3.96 GB How to write a script which will convert to a regular number this information? As it si I can't sort the various records while converting them as an even number it will be possible Thanks a lot
  8. Thanks LaRetta for your time and suggestions which I will try right now I will explain a bit further the need for those two related tables and so on. I need to synchronise Audio which was recorded on a separate machine from the Camera And explain why I hope to be able to order the Vidoe Audio combo and export them to another tab file. I would be able with a script I still need to think about ot open the files in Quicktime and rename them according to various criteria for the rest of the process. In Filemaker I did amazing stuff including video editing just using the scripts and I hope it will help me again. The problem is: the Audio Recorder calls each file it records using the recording date as such:(example) 170704124718.wav where the first 2 are the year, the 3-4 are the months the 5-6 are the day and the following six are the hour minutes and seconds The Camera instead gives conventional serial numbers with the mov suffix. I am ahowever able to collect the recording date with some video editing software however as the machines are different and the people handling them are also different there are no possible ways to find fields which allow me to match the 2 database As the Camera also has a lower quality sound I could do it by hand (or by ear) but this is driving me nuts. Also at times either one of the two machines will cut for various reasons, or start awhile before the other or not start at all. This also gives me a different number of records which I can easily work with as if anything is less then a certain number of seconds I can assume is a mistake, and FMP helps a lot. Nonetheless I believe my only option is to find ranges say "anything filmed and recorded" within a certain amount of time in this case I have a fairly usable start point. As the Audio tracks are more than the video tracks (because sound people will stop recording if there is any sound bothering the results) I use the Audio DB as the main source. If any filming happened and enters the range of the audio file then I can organise the recods and continue the job. Unfortunately the files are very many as we have about 3000 takes. If any other and certainly better idea comes to you I will be very glad. File Maker gives me almost every single piece of info I can use as duration, timestamps, size and more. But Audio and video have different weight hence the filming time seems to be the most handy way for me to relate audio and video and synch them. I hope this long dissertation didn't bother you and thanks again for your time and care. Regards dkey
  9. Thanks for your reply I will explain better The first db Has a number of Video files: I only have 2 fields Clip (text) and Record date (timestamp) The second DB has a number of Audio files: 4 fields Sound (Text) Record date, START and END (these are time stamps) The relationship is as follows Audio TABLE where AUDIO START and AUDIO END relate to the Record Date of the video file. I can get a result telling me if within a certain amount of time I have both audio and video files recorded within that period of time. The portal tells me which Video files are within that range based on the Record date of the audio I include a short example of my work The Video Calc file is just a reference for the audio file I have a script there "Empty Script" but looking at the results I am sure I could do better than this Thanks and regards from a really old user of File Maker which I bought when it was a company of its own long before Apple bought it --- but I am always learning and at my super old age I experiment very little AudioCalc.fmp12 VIDEOCalc.fmp12
  10. Hello I have two related db which returns a proper result in a portal I created As the records involved are many how to write a script to only find the populated records and then export them to a tab file for additional work? Thanks and Regards Dan
  11. Script to open a file from a field

    Thanks to both of you but both MBS and the suggested script don't work with my files It seems as if I need to change the path to actually open the file .... and I am not experienced enough to do so Regards
  12. This is an example of my path /Volumes/SHOWDOW_2017/SYnch Tests/00 - 11072017/Video 11072017/DSC9197.MOV How can I write a script to tell the finder to open the movie in QuicktimePro7? Thanks
  13. Thanks a lot it works really well Kind regards
  14. Hello I have 2 DB with the following fields VIDEO: CLIPNAME, RECORDED_DATE, and other fields not relevant to my question AUDIO: SOUNDFILE, RECORDED_DATE etc Unfortunately the recorded dates are different and so are the names. I need to link the two db and I hope to find a way to relate the two files so that the RECORDED_DATE in the VIDEO file will tell me what is the SOUNDFILE recorded in the other DB I tried to add a STARTDATE and ENDDATE to the AUDIO db to get a range of times so the VIDEO file could give me the Video FileNames recorded during the selected timestamp range Here I add samples of the two files to make it easier for anyone willing to help There are a few more records in the VIDEO files but this is normal while filming VIDEO.fmp12 Audio.fmp12 Thanks a lot for any help and regards

Important Information

By using this site, you agree to our Terms of Use.