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

2,123 profile views
  1. 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)
  2. 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
  3. 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
  4. It works perfectly in case the pattern is either KB or GB Hower it doenst work in case the pattern is MB
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  • Create New...

Important Information

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