carlschneider

I am trying to figure out how to write a FileMaker script, using AppleScript, that will allow me to select a folder full of QuickTime video clips and import the following from each clip: Clip Length (duration in hours, minutes, seconds, etc, such as “00:00:08.67") Frame Rate (in frames per second, such as “23.98”) Frame Size (such as “1920x1080”) This metadata would need to be imported into each correct record in FM that matches the Filename. Can anyone please point me in the right direction?

Hi Bruce, Thanks for your response, but can you please show me an example or the steps to get this done? Thanks, Carl

Is it possible to have different text field boxes and have them connected? For example, can I have a large text field box on each of several pages (like for a letter that spans more than one page), and have the text in these boxes connected? If I add text to the top box on the first page, it should push the text down onto the next page. This is possible in a program like Quark, but I have not been able to figure out how to do it in FileMaker. I have always just used one very large text box that spans several pages, but I always have to manually reformat it where the pages break. There must be a better way! Thanks in advance for any solutions.

I'm trying to do the same thing, but have have not been able to make the connection. My website and MySQL database is shared-hosted by GoDaddy and when I called them, they said I cannot connect to this database because when this database was created, we did not check the box to allow direct access. Therefore, the GoDaddy server only allows access to this database from the same IP address that the database is hosted on. If we want direct access, we now have to recreate a new database and check this box, but the database will be much less secure. I do not want our database to not be secure, so I need to know if there is another way I can access the data in the database from FileMaker Pro on my desktop. Any ideas?

Is there a way to have a layout with a field that spans several pages and set margins at the top and bottom? This is usually done in word processing applications by linking text boxes, but I cannot figure out how to do this in Filemaker.

I'm still hoping for some opinions here. I am also hoping for some advice about possibly using MySQL as a data-source with PHP.

Hi Guys, I am looking for some advice on creating some new dynamic database websites. I am a longtime user of Filemaker (I think since version 2), but I still have limited skills, and practically no CWP skills. I am exclusively Mac. I have a couple of new websites I need to have developed for some new companies (some startups I have been working on myself). These websites will be relatively simple, basically consisting of user registration/log-in, some products, shopping cart, checkout, admin, and a few other things. I am trying to figure out if it makes more sense to have these websites developed with Filemaker (and Lasso?) or some other database. I had a website developed a while back with all of these same functions as CWP using FileMaker and Lasso. Most of this code could probably be reused (by this same development company) to develop my new websites. Here are the pros and cons of going with Filemaker (and Lasso) as I see it: Pros: 1. I can use the Filemaker database and easily access the data offline. I could not access the data from other databases offline, since I am Mac only. 2. A lot, if not all, of the Admin could be done offline. I think all Admin of any other database would all have to be online, since I am Mac only. 3. Already have most needed code in Lasso, as well as FM database that could be reused. 4. I could setup and edit much of the database myself, at least in the beginning. Cons: 1. Cost of Hosting Filemaker websites (min $40/month), much less expensive with other more-common databases. 2. Less universal 3. other unknown limits to Filemaker I'm interested in hearing your thoughts about this, as most of you have way more experience than I. I'm sure there are many other pros and cons that I haven't even thought about. I think if I choose the correct path now, I will save a lot of headaches later. Thanks in advance for your comments and suggestions. I am using Filemaker Pro 9, and Mac OS 10.4.11.

I still haven't had a chance to try it yet.

I'm not trying to get the file size. I'm trying to get the dimensions of the images, in pixels or inches. Any other suggestions? What I really want is for my database to automatically determine if an images is vertical, horizontal, or square. I just figured this was the first step, but maybe there is another way.

Thanks for all the info. I'm going out of town for a week, but I'll check it out when I get back.

Thanks for your help. Here is my exact calculation path (IMAGE NUMBER is a field in each record): "image:/G4 DP/Applications/FileMaker Pro 7/Web/WEBSITE-DISPLAY_IMAGES/" & IMAGE NUMBER & ".jpg" I don't know what ImageEvents is or how it works (and I did a search for it and couldn't find anything). Can you give me some more info on this approach? Thanks.

This works for me when I have manually imported the image (as a referenced file). However, my container fields with the images are actually calculation fields with the result being a container. The GetAsText () function is only giving me the path to the image (which is the path in my calculation). Is there a way to get the image dimensions in this situation? Or maybe there is another way to do what I'm trying to accomplish. What I'm trying to do is have my database automatically determine if an image is a vertical, horizontal, (portrait or landscape), or square. Is there another way of doing this?

What am I doing wrong? I'm trying to get the dimensions of images stored in a container field, as discussed here. My images are referenced, not stored directly. I am using the GetAsText (container) function, but it is only giving me the path to the images (image:/G4 DP/Applications/FileMaker Pro 7/Web/WEBSITE-THUMBNAILS/1001T.jpg), and does not give me the dimensions.

I'm creating a database that will function similar to a website (but used on desktops only, not online). I'm trying to figure out how to do a couple of things. First, is there a way to create a header menu once and just include it in several pages (layouts) of this database? I would like to be able to modify this header menu once and have it automatically be modified on all pages that it appears. Second, is there a way to designate text as a link to a particular page? I know I can select the text box and make it a button, but is this the only way? I would like to be able to highlight certain words and designate them as a link to a page, like you can in html. Last, related to the second question, is there any way to have different rollover colors for these text links, like you can in html?

How can I number my records so that the numbering starts over with each Sub-Summary occurrence? In other words, I am looking for a way for the record numbering to restart after each occurence the same way page numbers restart when that option is checked. Thanks, Par

This is great, but I am not sure how to use it. Here is the direct link for reference: http://www.clevelandconsulting.com/support/viewtopic.php?t=49&highlight=clairvoyance Do I create another calculation field with this as the calculation or do I use it in a script? I'm confused. Any direction would be appreciated!

I am looking for a way to do this same thing. It would be even better if there was a way for filemaker to complete what I type in the way a web browser does (it matches previous entrys). Is there a script or some other way to do this?

Thanks. That does the trick.

Thanks, that's just want I needed.

Thanks for your response. Sorry for the dumb question, but how do you do a right mouseclick on a Mac?

This is very simple question and I'm sure there is a simple answer. No matter what I do, the title of my FileMaker web page is "FileMaker Instant Web Publishing". How do I change this to what I want? I have tried a script that generates a New Window with my title. This works on my desktop, but on the web the title is still "FileMaker Instant Web Publishing".

I want to be able to do a find and then have a field that shows what was entered as the find request. For example, I do a find for "widget". I want the results to appear and have a field that says something like "Your search for "widget" returns 34 records", like you see on many searchable websites. How do I do this?

What would the path be for images stored in a folder on a website. I have tried every variation I could think of. I imagine it is something like: image:/http://www.domainname.com/folder/filename.jpg but this doesn't work. Does anyone know how to do this?

This can be done by creating a Calculation field with a calculation such as: "image:/Images/" & file name The calculation result needs to be a Container. If your images have the same name as a value in a field in each record (with ".jpg" at the end of the file name), you can use a calculation such as: "image:/G4/Applications/FileMaker Pro 7/Web/Images/" & IMAGE NUMBER & ".jpg" IMAGE NUMBER is the name of the field that has the same value as the name of the image file. This will automatically pull in your images (I believe it is a reference only, and not the actual image file) from that referenced folder. If you are going to publish to the web via IWP, the images need to be in the Web folder in your application is. See this thread: http://www.fmforums.com/threads/showflat.php?Cat=0&Number=124190&an=0&page=0#124190

How do you create a script to go to the next page (next 5 records)? I need a button that does the same thing as clicking the little right hand page in the Status Area, but I want the Status Area hidden and locked.