Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


dkey last won the day on July 3 2015

dkey had the most liked content!

About dkey

  • Birthday 03/20/1937

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    13 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

2,793 profile views

dkey's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. My FMP pro 15 doesn't allow to import ".avi" and ".mkv" files. The error is the files are not the specified file type How to do so?
  2. Thanks GG I found an old version of FMP Advanced 9 This version works fine with smaller files, but crashes on High Sierra if the FP5 files are larger. And I am unable to find my old FMP 11 ... and filemaker doesn't have it at all. Thanks
  3. Hello I find in an old drives some fmp5 files. To open them in FMP18 I need to convert them first to FMP7. I have an old version of FMP7 however each time I install it the app crashes telling me the installer was modified with another version and crashes. I tried to download from the Filemaker site the trial version but I can't find it ... any help? Thanks
  4. Thanks again Fitch and miss Agnes Sorry I made a mistake my first post as I meant to export the video from the container field and name it joining 2 other fields as a title for the exported container field the actual field names are exactly as this: CLIP (container field with a ".mov" suffix) ClipName (text field) Sequence (textfield) The result should be Sequence&ClipName, as the new name for the Container Field (CLIP)
  5. Thanks for your time and reply: My answer will be a bit long and I hope you will have the patience to read it. I am a film maker and I use FILEMAKER as the heart of my editing process. Is a great program and in my job I use it in ways which might be not so common, this includes editing within FMP13 advanced and organising my work in different ways according to each project and step of the project. I can do so as other film software I use generally gives me the opportunity to export files in TAB format, but as they are not database, they don't allow me selections, sorts and more which I can easily accomplish in FMP. In this case I have this DB where I imported 1216 Clips and linking this file to other filemaker files I get duration, size shape and more. From this file I can export the files I need to export and in the way I need to export them, adding fields, changing the size and shape of the clips and so on. I now need to be able to export just video files (all 1920x1080 px), and use the name for each file as it appears in the clipname field in my FMP13 Advanced DB. At the end I hope to have a folder CLIPS with the 1216 video clips each with the assigned name. Is far too complex explaining what else I did in the main file, as it requires working in video editing and other facilities I created in FMP, often with great help from other people who is far more expert in FMP than myself. It would be really nice if you could tell me how can I export to a folder of choice the videoclip only but with the name I assigned in another field. If not thanks for reading my post and asking my reasons. So far nobody else had any suggestions. I will add a little comment. I used computers since the apple][ back in the 1980. I slowly learned how to manipulate several different software packages even when intended for usage quite different from what they were meant to be programmed: I had surprising results and obvious failures. I am not a great expert in Filemaker which I use since it was a<n independent company back in the late 80s, but with the help of many kind people I was always able to accomplish what I tried to do. I think programmers are not always aware of the potential of their software as I found ways to use a lot of stuff to get combined results which helped me a lot. Thanks again and regards
  6. I'm surte this is quite a simple task ... for someone expert I see I can export Record content using a Variable as the new filename for the exported file. I have more than 1200 records in my db and I hope to export 3 fields using one [fieldname: Title] as a filename. The path for my db is as follows file:/Macintosh HD/Users/Claudio/Documents/Synch Test Copy Copy.fmp12 Thanks a lot
  7. It works perfectly in case the pattern is either KB or GB Hower it doenst work in case the pattern is MB
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  • Create New...

Important Information

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