Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About jwmickelson

  • Rank
  1. Very cool! I agree they should be updated more like this in 15+ I actually would prefer them to be a darker, more saturated, red for these breakpoints in FMP. The tone of your orange is still very close to the underlying grey from a contrast perspective (try the squint test to see what I mean). Orange is also a type of pale red, and thus red/green color deficient eye will not see the difference as well... a darker red would provide the contrast that would make such breakpoints obvious to everyone -- I think script beakpoints should really stand out Great stuff
  2. quote: Originally posted by ErikErikPolkaMan: We are trying to embed mp3 files in our database of music recordings. We know how to put .wav files into it, but we have not figured out how to put mp3's in it. The people I have talked to either do not know how to do it, or if it can be done. Has anyone ever done this sort of thing? -Erik Keilholtz Arhoolie Records Sorry to say that you cannot embed .mp3 files. On the PC, you can embed .wav's and on the Mac you can embed .aiff. I have not heard any mention of .mp3 support pending from FileMaker Pro. On a lighter side, I think we c
  3. [ August 20, 2001: Message edited by: Jonathan Mickelson ]
  4. quote: yes I have the problem is the movie isn't ready at the time of the database creation. The database file is made then a movie is encoded and put in a location on a web/ filemaker server. The movie takes about 30 min to encode and finish and we don't want the operator to have to wait around to add it to the record, can file maker look for a file on a share and then import the file? I have the exact same problem. No, not without judicious use of FileMaker Plug-ins can you have FMPro watch a folder. But I have been quite successfull using the 'Send AppleEvent' on Mac and 'Send Mes
  5. LiveOak is correct. In fact, for image storage and display, especially in cross-platform environs, FileMaker is the easiest database on the market. As an alternative to buying, try down-loading a trial version of File Maker Pro 5.5 at www.filemaker.com and create a sample database. It will be limited to 50 records, but it should give you a good idea of it's ease of use. INMHO, FileMaker ease of use Vs. Access is like 3-1. Hope that helps.
  6. This is a bit tricky, FileMaker Pro has not digned to allow us, the developer, any direct access to references to files. Now you mentioned images, but images tend to be stored in the file and hence are displayable in any platform, so I'm assumming there is the 'Store Reference Only' feature somewhere in here. Macs and PC's handle file paths totally differently, PC's use an absolute path structure and Macs have a similar structure, but based upon the names of volumes etc... One way to simulate these is to us ethe open URL script step where you say something like "C:filepathimage.img" and t
  7. Simple? No, I have't used the record locking and hiding features of FileMaker Pro 5.5 much yet, but it sure sounds like that would be the way to go. But using 5 or below, you will probably need to set up some very strict scripting upon login that take users to layouts they have access to and a restrict finds to include records that they should have access to. Usually this is inserted after the user performs a find in your system and you as the developer manually add their access to the find so they only find records they are supposed to. Many developers utilize an interface file that the
  8. Yes, it is unfortunate but this is the way FileMaker is designed. Set Fields and Goto fields and in fact any reference to a field on a layout, like copy, paste etc... all goto the uppermost and left most field availible. So if you have a layout all with the same field, just displayed differently, the upper left field will be the default one. The trick is, set a tab order for the layout and then use the Goto Field script step with 'Next' selected, the number of times you need to in order to get to the field you want, this will select the pulldown you need. It's very much a pain in the butt,
  9. My FMPro solution regularly has 50-70 users and is serverd via FMPro Server. Anyone who designs a large database system runs into this problem. Creating one record in a single file that everyone uses for storage of variables is the basic answer. The trick is to not allow users to manually access this single record, use scripts to send data to those variables. Thus, they can't lock the record by leaving their cursor in it. Now, in a multiuser environment, if users are not 'continuously' updating these values, it is not too dificult to use some validation scripting to make sure thay were abl
  10. In the FileMaker Help I ran across this paragraph in the 'match fields used to create a relationship' section. But this seems unheard of to me, read the following (the ending sentances is where it gets interesting) The match field in either (or both) the master file or related file can contain a calculation formula. For example, the formula Unit Price in the match field of the master file establishes a relationship to a record (or records) in the related file whose match field contains the value of the Unit Price field in the current record of the master file. You can also define a calculati
  11. FileMaker now has a new script step called "Execute SQL" which allows you to execute a single SQL function in an SQL datasource. This should theoretically let you send AND receive data, but I have as of yet to get it to work, maybe others can post here about their experiences with pulling info back into FileMaker from SQL. Unless something changes, though, FileMaker will never be a frontend for SQL. quote: Originally posted by ssd: I have heard that fmpro now has an SQL version. Is this true and can someone provide me a url for more info?
  12. I checked out your solution on your site, and I have to say I'm very impressed! I'd have to say that I think that use of your system would usually be by FMPro enthusiasts only, rather than business (i.e. paying customers). I would be very interested in seeeing you develop an area of your web-site, discussing and probably releasing the files that made it all possible. I'd note that this is a great way to establish extreeme credibility in the FMPro industry. I think that showing everyone what you have developed would increase everyone's understanding of the possiblilities availible in FileMa
  13. I've tested in my own solution and you are so very right, This IS a problem and thought I've never run into it in my own solution, it could prove VERY problematic to many people. I suggest you HOUND FileMaker to get their input on this... The very nature of copy is used to maintain the user's entered formatting, and Alignment is an integral part of this! Best of luck, chalk another one up to version 6.0 and another $250.00 we'll need to spend. -Jonathan
  14. When performing development tasks on our software in multi-user mode (ie.. hosted from another copy of Filemaker, not server), I often (8 times out of 10) have Filemaker on the hosting computer crash saying: "FileMaker Pro cannot read the disk." or some such. This only seemes to happen when replaces or other data manipulation is initiated on the hosting computer and only when another user is logged into the machine, using the files. It NEVER happens when only one computer is using the files. Because we host all our software on Server for customer installations this doesn't affect us too mu
  15. Yes, you're on the right track. This is usually due to Firewall ports being blocked. You said that the web server is hosting the files, usually this is either by Server or a standard copy of FileMaker Pro. Both require certain ports to see the files even when the IP is manually entered. The FileMaker Website has info on what ports are necessary. And of course you must be using TCP/IP not other proprietary protocols like AppleTalk etc... Another thing to check would be the Port Mapping feature of your Firewall. Port mapping will allow access to a specific computer to specific ports. Mu
  • Create New...

Important Information

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