The Crow

Demo showing how to use this plugin form 360Works

It is in fact an SSL issue. I fixed the problem by replacing the server.pem SSL certificate file with one from a working system.

"It is in fact an SSL issue. I fixed the problem by replacing the server.pem SSL certificate file with one from a working system. While this is a full working solution, it comes with a caveat. This will allow you to leave SSL encryption enabled, but having the same cert on multiple client machines is generally a bad idea.

On Win:
-Replace server.pem at the "Program Files > FileMaker > FileMaker " directory.

On Mac:
-Replace server.pem at the "Applications > FileMaker > FileMaker .app > Contents > MacOS" directory. Note: A *.app (application) package can be accessed by right/control clicking on it and choosing "Show Package Contents".


The bug is caused because the FileMaker installer fails to create a valid certificate file on install. Each cert file contains "not before" and "not after" dates to define the scope of the certificate. The "not before" date is the date of the install. The "not after" date is 863913600 seconds (9,999 days) after the install date. If you add 863913600 seconds to any date after September 22th, 2008, the date is incorrectly interpreted by the installer as a date on or after Jan 1st, 1970. This makes the cert unusable because the "not after" date is in 1970 and 2008 is definitely after 1970. This affects multiple versions of FileMaker. Seems like the cause is not a code change or update. Time just had to pass to make this one happen.

The best solution to the problem is to do a reinstall of the application while having your computer's clock set to a date before September 22th, 2008, apply all updates and set the date back to today. The cert that's created should be valid.

We have tried to change the date manually, but the encrypted portion of the certificate relies on the original date set. It did not work."

This my prediction for BYU in the 2010 Season.

Schedule and Prediction:

Washington in PROVO, UT (Win - by a field goal)
Air Force in USAFA, CO (Win - Air Force is better by they never really give BYU a good game)
Florida State in Tallahassee, FL (Win - this one is my upset. I think BYU finds a way to slow FSU down and they win by a field goal.)
Nevada in PROVO, UT (Win - BYU at home... close game but...)
Utah State in Logan, UT (Win - again a closer game than most expect. Utah State will continue to improve but this isn't the year.)
San Diego State in PROVO, UT (Win - I worry about this one. BYU was particularly good last year against San Diego State.)
TCU in Fort Worth, TX (Loss - BYU a year away from beating TCU.)
Wyoming in PROVO, UT (Win)
UNLV in PROVO, UT (Win)
Colorado State at Fort Collins, CO (Win)
New Mexico in PROVO, UT (Win)
Utah in Salt Lake City, UT (Win - but once again very close. Possible last minute field goal.)

Ok now I know everyone thinks I'm crazy (maybe I do have the Blue goggles on) but I really think this team can be better than most suspect. BYU finishes 11-1. Feel free to ridicule me later.

How do you merge to FileMaker Database?

1. Import the tables with fields into the target file.
2. On the relationship graph, change the base table for any external references to the new corresponding table in the target file.
3. Create a new blank layout in the target file for each layout from the old file using the exact same name as before (be sure the base TO is set correctly).
4. Add the old value lists into the target file using the same names as before.
5. Import the old scripts into the target file.
6. Copy/Paste all the old layouts into the new blank layouts.
7. Reset external script and value list references to use the corresponding script/value list in the target file.
8. Test that everything works.

I had a scenario where I needed a number to be 2 decimal places even when the number was: 1 - needed 1.00

Heres a solution:

Int(Round(Amount,2)) & "." & Right("00" & Round(Amount,2) *100,2)

With the talk of the PAC10 raiding the Big 12 there is talk of the Mountain West Conference getting some scraps.

6/10/2010
Well it's official. We now know the PAC10's true colors. Colorado has officially been accepted into the Big10. The PAC10 told us academics, research, etc were important. They just added a team that is being penalized by the NCAA for poor academics. They're teams stink and haven't done anything for years. Shocker... well not really. Denver is a major TV market. The thing is - Denver is a pro town. They don't care about college ball. Bad move PAC10.

6/9/2010
The latest now is that Utah to the PAC10 and BYU to the Big 12. Good for both schools. I'd still like to see how this plays out.

6/8/2010
So the rumor has it that the PAC 10 is going to add Texas, Texas Tech, Oklahoma, Oklahoma State, Colorado, and Texas A&M. That would leave Kansas, Kansas St., Nebraska, Iowa St., Baylor, and Missouri as "scraps". We're also being told that Nebraska and Missouri are being slated for the Big Ten. Now, the so called "scraps" would be Kansas, Kansas St., Iowa St. and Baylor.

After meetings this week we are also being told that Boise St has not been invited to join the MWC. I have mixed feelings about this. I think Boise would be a great addition for football. They may be the best team in the conference if they joined. The problem begins after that. They aren't real strong in any other sports. They also would be another cut of the MWC pie which isn't all that big now. They don't guarantee the MWC a seat at the BCS table. If they did - you pick them up now!

So for now the MWC for now is going to sit back and wait to see what happens. Probably a smart decision.

If the Big 12 falls apart I'd like the following to happen: the MWC invites Kansas and Kansas St. Though not great in football this would be a big boost for basketball. It could be fun to see them compete with UNLV, Utah, BYU, San Diego, and New Mexico. All good programs. I wouldn't bother with Baylor or Iowa St. They really contribute little to the conference. At this point you add Boise and now would have 12 in the MWC... and a pretty dang good football / basketball conference. Renegotiate television for more money. I don't mind the MTN tv. Contrary to everyone and they're negativeness they allow me to see the games I want to see when I want to see them. With the new Kansas/Kansas City/Boise market they should be able to get into a few more homes.

Finally, I've found a editor to replace my old GoLive. I never have really liked Dreamweaver so that option was off the table.

The program is called Flux.

http://www.theescapers.com/flux/index.html

I requested Lasso support. Within a week there was an update with Lasso support. This is some really great software.

So I was looking for a SMS solution to send messages for one of my clients. I had seen several paid solution (you buy so many SMS's) but the complexity to make these work was bugging me.

So I was looking for a SMS solution to send messages for one of my clients. I had seen several paid solution (you buy so many SMS's) but the complexity to make these work was bugging me. I download a bunch of different demos. Unbelievably, I was unable to make any work. Then I was thinking... my favorite plugin maker 360Works has probably got something that would do this. Sure enough. Fast, simple and easy.

To do this you need three things: FileMaker, the 360Works Messenger plugin , and a AIM account.

Steps:

1 - Load the 360Works Messenger plugin. Restart FileMaker.
2 - Create a AIM account. www.aim.com
3 - Create a text field in FileMaker containing something similar to the following.

IM_SendMessage( "AIM" ; "xxxxxaccountnamexxxxx" ; "xxxxxpasswordxxxxx" ; "+1" & xxxxxphonetosmsxxxxx ; xxxxxtextmessageherexxxxx )

It's that easy and it's free!

How to set up FileMaker to use Gmail's SMTP

I was recently trying to set up a clients FileMaker to send confirmation emails. After reading on the gmail on my gmail account they said to use port 587. I could never get it to work. When I switched to port 465 it worked like a charm.

Clean and pure CSS FORM design

Navigation bar with tabs using CSS and sliding doors effect

Liquid expandable section with rounded corners using CSS

Elegant navigation bar using CSS

Liquid styled input element with CSS