Cimbura.com iPad Solution Wins First Place

The IAFE or International Association of Fairs and Expositions is the largest association of fairs in the world including over 1,300 member fairs. Each year they have a competition among fairs at their fall conference held in Las Vegas in 2011 and sponsored by John Deere.

The Minnesota State Fair entered the custom application Cimbura.com designed and built for tracking all horse and livestock competitions with an iPad solution used to enter awards and scoring quickly in the arena.

Our solution won FIRST PLACE in the Division 5 size fair (the largest with fairs that have attendance of over 1 million visitors) for “a program designed to solve a problem in a competitive agriculture program”. It is truly the most advanced system available of its kind anywhere in the world. Every year it saves hundreds of hours of time and makes the information for over 5,000 competitions readily available to visitors and participants.

We based our custom solution on FileMaker Go mobile client for iPad, FileMaker Server for the data host, a FileMaker client based administration/reporting application for Windows/Mac OS, and html/php/jQuery-based code to drive the large screen displays. The system integrates with another State Fair application to take in all registration info online from their web site. For more info and photos see our article about how it all works along with customer praise and a write up about the project that appeared in the news.

Making Sense of all the FileMaker News

With the release of FileMaker 12, there is now an onslaught of news, ideas, tips, training, etc.

To help make sense of it all and point you in the right direction for helpful quality articles, we’ve created a curated news source called FileMaker News. Follow this news topic to get up-to-date FileMaker information. It’s a good mix of technical articles and information for developers that want to take advantage of the new features of FileMaker and learn about it quickly from some of the best online resources.

12 Ways FileMaker 12 Will Impact Your Work and Business

The newest version of FileMaker was released today after nearly 2 years in the making. With it has come a slew of new features and many things that the FileMaker world has waited for with anticipation. We will be providing a more in depth review in the next few weeks. Meanwhile, here are 12 ways FileMaker 12 will affect you and your business:

1. FileMaker 12 is a major release. Along with it comes a new database file format change…the first since FileMaker 7. Although conversion of your existing files will be fairly painless, there must be testing and planning in the upgrade of this software. If you haven’t yet converted old databases from FileMaker 5 format, you’ve got two file format conversions to do to get up-to-date. If you remember the migration from .fp5 to .fp7 as being painful and expensive, the migration from .pf7 to .fp12 will be nothing like that. FileMaker 12 is a release that builds the infrastructure possible for even more future innovation.

2. You must upgrade your FileMaker server, clients, and databases all at the same time. Everyone will need to be running FileMaker 12 to access your updated databases. No more mixing and matching of server and client 9, 10, and 11. There may also be increased system requirements. For example, FileMaker 12 will not run on any older PowerPC based Macintoshes anymore. You may need to upgrade your operating system to a more recent version before you can install FileMaker 12.

System Requirements for FileMaker client:
Mac OS 10.6 Snow Leopard, and 10.7 Lion (Leopard and PPC no longer supported on the Mac OS.)
Windows XP SP3, Vista SP2, and Windows 7

3. If you run any plug-ins or other software that integrates with FileMaker, you’ll want to wait until new versions are released that are fully compatible and tested with FileMaker 12.

4. The pre-built themes are one flashy new FileMaker 12 feature. You’ll need to find a balance for using them. They are easiest to use with new solutions that are built from the ground up. Old solutions may need a lot of work to take advantage of the theme features. If you’re testing the themes always work on a backup copy of your solution.

5. The new starter solutions will provide you with better starting points for new databases that you want to develop on your own. Taking advantage of the iPad and iPhone with FileMaker Go is much easier with built-in layouts and support for mobile devices.

6. FileMaker Go 12 on the iPad, iPod Touch, and iPhone is now FREE…making it easier to deploy your custom database application on the latest mobile technology. (Formerly, FileMaker Go was about $19.99 for the iPhone/iPod Touch and $39.99 for the iPad.)

7. FileMaker 12 performance enhancements make remote hosting of FileMaker in the cloud an even more attractive option.

8. New development tools make it easier for developers like Cimbura.com to create custom business application solutions faster. The result is that you’ll save money with our increased productivity.

9. Features like gradient fills, corner radius, etc. will allow FileMaker solutions to look more modern.

10. Some FileMaker 12 features you’ll notice immediately after your upgrade, but others will require database enhancements to take advantage of them. So you’ll see more improvements over time as we rework fmIgnite features and our other solutions for FileMaker 12 . We’ll suggest the improvements to you that will make the most sense for your organization. For example, maybe you’ve wanted to manage files within FileMaker. The new container field options make this easier and more practical.

11. FileMaker Server enhancements will make hosting more reliable, capable, and speedy. We’ll be able to take better advantage of the hardware available on a server. Backups will be easier to maintain. If you’re not currently taking advantage of FileMaker server, now may be the time to do so. Configuration of the server will be critical. The following articles contains some helpful server 12 technical information from Wim Decorte and Steven Blackwell.

12. Anyone that has purchased FileMaker volume licenses through Cimbura.com and has a current maintenance plan will automatically receive FileMaker 12 at no additional cost. When you get your announcement email from FileMaker just hold onto the new license codes. We will be scheduling migrations of your databases as we upgrade our hosting servers and your databases.

Many other features included with FileMaker 12 make it a more powerful, reliable, and useful application solution tool kit so that it can solve even more problems and make your business more efficient, productive, and profitable. Download a free copy of FileMaker 12 for evaluation, then contact us when you’re ready to purchase for the best discount available.

Check out the following Scoop.it link for more FileMaker 12 News.

WordPress Post-it Note Pull Quotes

I wanted to create post-it note like calls to action on this WordPress-based web site. Here’s what I came up with…

First off, I found the Simple Pull Quote plug-in from The Mighty Mo Design Co and installed it on my WordPress site.  This did part of the job in making it easy to identify the text I wanted displayed and sliding it off to the right as a pull quote. I added sections in my pages with text that looked like the following to identify the call to action.

[ pullquote]
<div><a href="http://www.cimbura.com/tech/wordpresstech/index.php/contact-us/project-request-form/" target="_blank">Request a demonstration of fmIgnite.</a></div>
[ /pullquote]
Now I needed to modify the CSS to look like  post it note. I edited the simple-pull-quote.css file in the /wp-content/plugins/simple-pull-quote/css/  directory. Here’s the final CSS that I created to create the note:
/* Makes pull quote look like a post-it note. Tim Cimbura 3/30/12 */
.simplePullQuote {
font-family:"Reenie Beanie",arial,sans-serif; /* Google handwriting type if available */
 text-decoration:none;
 text-indent:0px;
 font-size:150%;
 font-weight:normal;
 line-height:100%;
 text-align:center;
color:#000;
 background:#ffc; /* Yellow */
 float:right;
 padding:20px;
 border:0px;
display:block;
 height:6em;
 width:12em;
position:relative;
 top:-10px;
 margin:10px 10px 10px 10px; /* From the surrounding text */
-moz-box-shadow:5px 5px 7px rgba(33,33,33,1); /* Drop shadow */
 -webkit-box-shadow: 5px 5px 7px rgba(33,33,33,.7);
 box-shadow: 5px 5px 7px rgba(33,33,33,.7);
-o-transform:rotate(2deg); /* Rotate the note a few degrees to the right */
 -webkit-transform:rotate(2deg);
 -moz-transform:rotate(2deg);
 }

Enjoy!

Display Your iPad/iPhone on Your Mac Screen

There’s a new way to get your iPad/iPhone to display on the Mac screen that utilizes the built-in Airplay functionality in the iPhone 4S and iPad 2 with your Mac running Snow Leopard (10.6) or Lion (10.7). This makes it easy to demonstrate iOS apps with a video projector.

You need an application called Reflection. Then follow these steps to set it up:

  1. Open the Reflection app on your Mac.
  2. Make sure your iPad/iPhone are on the same WiFi network. (You may also need to disable Bluetooth if the Airplay icon doesn’t show up in step 4.)
  3. Double-tap the home button on your iPhone 4S or iPad 2
  4. Swipe right on the multitask tray until you see the AirPlay icon next to the volume slider.
  5. Tap the AirPlay icon and select your Mac from the list.

This method requires the additional processing power of the iPhone 4S and iPad 2…but it’s really cool!

FileMaker Custom Web Publishing

Quite often we want to take much of the data included in a FileMaker database and make it available to a large audience without the need for them to own the FileMaker application and have it installed on their computer. To do this, we can utilize custom web publishing to make the information avaialable to any person with an internet connection and web browser like FireFox, Safari, Chrome, or Internet Explorer.

There are several ways to build customized web solutions based on FileMaker Pro:

  1. IWP (Instant Web Publishing)
  2. Connect to an existing web site database like MySQL or Microsoft SQL Server via ESS (External SQL Sources) and synchronize the data.
  3. Connect the web site directly to the FileMaker database as a backend via the FileMaker API for PHP (Application Programming Interface for the PHP language)

Option 1: IWP
We almost never recommend IWP. It converts FileMaker layouts automatically to web site pages on the fly. Although it is interesting technology, it is not easily scalable to many users and limited in its functionality and reliability.

Option 2: ESS
Connecting to an exsiting web site database via ESS is a great option especially if you need to scale your web site to thousands of users or the web site already exists. It also allows for division of development labor. One developer can be responsibly for the front end user facing web site and another developer can work on the back-end administrative FileMaker database with lots of reporting features for use in the office.

Option 3: FileMaker API for PHP
The first FileMaker PHP interface was a product called fx.php. It is no longer used as much. The officially supported product for custom web publishing today is known as the “FileMaker API for PHP”. It can be a good option…and here we include a listing of some resources that will assist in learning more about the API.

Resources for Learning and Utilizing the FileMaker API for PHP

If you have any other resources that you feel might apply, feel free to add a comment below.

Easily Launch a Remote FileMaker Database from a Desktop Icon

It’s easy to open a FileMaker database when it’s stored on your local computer…just double-click on it. However, if you have s shared database stored on a remote server, it’s a little more work. You need to open FileMaker, point to the right network path, etc. Some people have created a small starter FileMaker database with an auto open script on their desktop to make it a quick double-click for users to access their primary database. This method is easier and anyone can set it up in a few seconds.

We’ll take advantage of the FileMaker URL (uniform resource locater…or “way to find it”) capability to create an icon on your desktop to quickly open a particular FileMaker database. FileMaker has a detailed article about the URL if you’re interested in know more about it or see their FileMaker 12 URL help article. All you need to know is that a FileMaker database has a URL format like this:

fmp7://ServerNameOrIPAddress/FileMakerDBName

or in FileMaker 12, it’s

fmp://ServerNameOrIPAddress/FileMakerDBName

Then follow the process below for your operating system, Mac OS or Windows.

On the Mac OS…

You will create an .inetloc file that acts as an alias/shortcut. Follow these steps:

  1. Open your Safari internet browser.
  2. Enter the hosted database path in the address bar. (The format is fmp7://ServerNameOrIPAddress/FileMakerDBName or on FileMaker 12 use fmp://ServerNameOrIPAddress/FileMakerDBName)
    Do not press Return.
  3. Drag the blue world internet icon onto the desktop.

When you double-click on the file you just created, it will open up your FileMaker database.

If you like, you can click on the icon in the finder and from the File menu choose Get Info (Command-I). Click on the icon in the upper left corner of the windows, and you can then paste in a custom icon of your choice.

If you’re more technically minded, you can also manually create the .inetloc file with a free text editor application like Tex-Edit or Text Wrangler. Use the following code replacing the URL with the correct one pointing to your database and be sure to save the file as text only with a .inetloc suffix:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>URL</key>
<string>fmp7://ServerNameOrIPAddress/FileMakerDBName</string>
</dict>
</plist>

(Note: On FileMaker 12, substitute fmp: for the fmp7: URL prefix)

On Windows…

We’ll create a shortcut. Follow these steps:

  1. Right-click on the desktop and choose New>Shortcut.
  2. Enter the hosted database path. (The format is fmp7://ServerNameOrIPAddress/FileMakerDBName or on FileMaker 12, fmp://ServerNameOrIPAddress/FileMakerDBName) and click on Next.
  3.  Enter a name for the shortcut and click on Finish.

When you double-click on the shortcut you just created, it will open up your FileMaker database.

Mac OS Presentation Remotes for PowerPoint and Keynote

Here we discuss three presentation remote options that will assist you in changing slides during your next presentation.

Option 1: Keynote Remote on the iPod Touch (Mac Only)
Keynote is the presentation software from Apple. It has the great feature of utilizing a iPhone/iPod Touch app called “Keynote Remote” to control the slide presentation wirelessly. It has the following features:

  • Allows you to look at the current slide and your speaker notes (portrait view) or the current slide and the next one (landscape view).
  • Timer option
  • Up to 150 ft wireless range
  • Simple finger swipe controls

You need to own an iPhone or iPod Touch to use this remote option…and it only works with Keynote…not PowerPoint. Here are Apple’s instructions on how to utilize the Keynote Remote app.

To utilize the remote you must have your presentation Mac on the same WiFi network as your iOS device. In some cases, the wireless network in your area may not be available or unreliable. Here are instructions for how to set up your own temporary wireless network between you Mac and iOS device (this will not provide live internet access…just a connection between the devices):

On your Mac…

  1. Open System Preferences and click on Network.
  2. Select WiFi and be sure it is on.
  3. From the Network Name: pull down select Create Network…
  4. Enter a name like “My Network”… Do not use your name…or other people may try to connect and mess up your presentation. Make it something like “Unknown”.
  5. Select a Channel: or leave as default.
  6. Select Security: None for simplicity. You won’t be transferring any confidential information.
  7. Open your presentation in Keynote.
  8. From Keynote>Preferences…, click on Remote.

On your iPhone/iPod Touch…

  1. Select Settings.
  2. Select Wi-Fi and make sure it is set to ON.
  3. From Choose a Network… select the network you just created on your Mac.
  4. Press the home button to go back to your app screen and open the Keynote Remote app.
  5. Select Settings.
  6. Click on New Keynote Link… and make note of the 4-digit passcode.

Switch back to your Mac…
Click on Link next to the device and enter the 4-digit passcode

On your iPhone/iPod…
Select Done then select Play Slideshow

I would suggest have an iPod Touch just for use as a remote rather than utilizing your iPhone. Here’s why:

  • You can be sure it is always charged no matter how many phone calls you’ve made that day.
  • There will be no worries about getting interrupted by a phone call mid presentation.
  • Slimmer than an iPhone.
  • You can set the iPod Touch to not go to sleep/lock mode as often as might be true for you iPhone. I’d suggest 5 Minutes…this may be the longest you would stay on one slide. Change this in Settings>Auto-Lock
  • You can keep the iPod Touch on your exclusive network and user your iPhone for email and internet.

Option 2: Logitech Presenter
Another quality presentation control option is the Logitech Professional Presenter R800 with Green Laser Pointer

It has the following features:

  • Built in timer with silent alarm.
  • Green laser pointer so you see the pointer even on plasma/LCD screens and in brightly-lit rooms.
  • 100 foot wireless range.
  • Smooth slideshow controls.
  • Works with PowerPoint or Keynote.
  • Less expensive than an iPod Touch or iPhone.

It says that system requirements are for Windows only…but the remote acts like a wireless USB keyboard and so it can be made to work great on the Mac. On Mac OS all buttons work fine on Microsoft Powerpoint and Keynote except the Play Slideshow button (Start button) on Keynote. Here’s how to get the Start button to work in Keynote by remapping the default Play Slideshow keyboard shortcut:

  1. Open System Preferences.
  2. Click on the Keyboard icon.
  3. Select the Keyboard Shortcuts tab.
  4. Click on Application Shortcuts.
  5. Click the Plus button to assign a new shortcut.
  6. Scroll to the bottom of the list, select Other… and then select Keynote from the Applications:iWork ’09 folder or wherever you installed it and click on Add.
  7. In Menu Title: field, type “Play Slideshow”.
  8. Move the cursor to the Keyboard Shortcut: area and press F5.
  9. Click on Add and close the Keyboard system prefs.
  10. Quit out of Keynote and open it again. You’ll see on the View menu that “Play Slideshow” is now linked to the F5 shortcut. (The default is Command-Option-P.)

Now all the buttons of Logitech Professional Presenter R800 or R400 will work perfectly.

Notes:

  • If you use any other Logitech products on your Mac that require the Logitech Control Center, it is possible that you may need to uninstall this software for proper functioning of the remote.
  • There is a great application that aids in doing presentations or demos on the Mac (usually non-PowerPoint/Keynote) called Mousepose. It dims the screen and puts a spotlight on the area around the mouse pointer, easily guiding the audience‘s attention to an area of interest. Mousepose maps F5 to display keyboard typing keystrokes. You must disable this key if you want to use the start presentation key on the Logitech remote. Here’s how:
  1.  From the Mousepose menu icon, select Options… Open Settings Window…
  2. Click on the Keystrokes item.
  3. Under Activation Hotkey: click on the X to remove the F5 hotkey. You might also click on Deactive if you never want this feature.

Option 3: Honeywell PPRF Remote
Another option that I have not personally tested but heard good things about is the Honeywell PPRF Wireless PowerPoint Remote.

Lion and iCloud and Upgrading Your Mac OS/MobileMe System – Do It Now

Apple recently announced their new operating system Mountain Lion (Mac OS 10.8) to be released later this summer. It will move the Mac OS and iOS closer together so that you have a more consistent experience across your Mac and iPad/iPhone/iPod Touch devices. It will also make even more efficient use of iCloud.

Motivated by this new operating system coming soon and the fact that MobileMe is going away in a couple of months (June 30, 2012), my best advice is to move quickly toward upgrading your current Mac to Lion and iCloud (Mac OS 10.7).

Upgrading, is somewhat painful for some people because it may require losing some older applications that will not longer run. Quicken 2007 is one such app people complain about. There are several options available. Other apps that will no longer run are those based on the old PowerPC architecture and the emulator called Rosetta that was used in previous Mac OS to run this software. Dealing with change is tough but in order to move into the future of technology I recommend going with Apple’s direction. They are innovating quickly.

So, if you’re ready to make the move to Lion, my #1 tip is this:
Make a full SuperDuper! backup of your workstation on an external hard drive BEFORE upgrading. If you have a Time Machine backup, you may believe you’re safe but I would argue that it is not enough to EASILY recover if something goes wrong. With a full system sofware change, it is quite possible that something may go wrong. See my backup article for some details.

Upgrade to the latest versions of all your applications. I’d also look at upgrading to MS Office 2011 if you have an older version. It is less expensive than ever and is a better version for compatibility with the Windows version of Office and the Mac OS.

In general, you always want your OS to be the OLDEST piece of software you’re running. This is because software needs to be upgraded to be compatible and take full advantage of the operating system.

In order to update from Mac OS 10.5 (Leopard), you will need to purchase Snow Leopard (10.6) before you can upgrade to Lion. Lion upgrades are done through the Apple App store and the App store can’t be installed until you’re on version 10.6…so upgrading may be a two step process if you haven’t upgraded in a while.

By the way… I always suggest that you open System Prefs>Software Update and turn off “Check for updates” so you do not get prompted for new software updates every week. You do not want to be the first person on the block testing new updates…especially if everything is working OK for you. Do system updates manually every few months when you know things have been backed up and you have a few moments in case something goes wrong.

MobileMe to iCloud (after your Lion upgrade)

If you currently utilize MobileMe, switching to iCloud can be somewhat complex depending on what services you utilize with MobileMe. Things will change. Deal with it. In order to upgrade to iCloud, all the Macs that access your calendars must be on Lion and all your iOS devices must be running iOS 5.

I moved all my home/office devices (2 iPhones, 2 iPads, 1 iMac, and 2 MacBooks) over to iCloud in one day. Choose a day when things are quiet and you don’t need to depend on your calendar or email immediately. Here are some helpful steps:

1. Check your Apple IDs and choose one as your primary ID. Make sure it is formatted as an email address. Go to http://appleid.apple.com and click on “Find Out”. Enter your name and up to 4 email addresses. If you find more than one Apple ID, login for each one and click on “Manage Your Account”. Make sure your info is up to date, and that you have some backup email addresses assigned to the account in case you get locked out. For more details check out this Apple link. For me, I had two Apple IDs…one primarily for iTunes purchases and the other for my MobileMe account. I chose to go with my iTunes account AppleID for iCloud…and skip the auto upgrade transfer of my MobileMe info. Before I upgraded I logged out of my MobileMe account on all computers.

2. Open iTunes, plug in all your iOS devices and turn off syncing of Mail, Calendars, Contacts, etc.
Click on the icon for your device, then the Info tab…and turn everything off. Then click on Apply. iCloud will handle syncing things back up in the future. I did this step to prevent the possibility of duplicate contacts and calendar entries and make things as simple as possible for the upgrade.

3. Make sure all your software is up to date. Install iOS 5 on your mobile devices and Mac OS X 10.7.2 Lion minimum on your Macs.

4. Make a backup of all the various components that MobileMe touches. Get a DropBox account and make a folder called “Backup” in your DropBox account. DropBox can replace the functionality of the old iDisk and do it much better. Gather the following files and place them in the Backup folder:

a. Backup your Calendars
Open iCal.
Select File>Export>iCal Archive and save a copy in the Backup folder.
Also click on each calendar individually and save as a .ics file in the Backup folder. These are useful for importing one calendar at a time.

b. Backup your Mail.
In the Finder, find folder USERNAME/Library/Mail. If the folder is not visible, hold down the Option key and choose Library from the Finder’s Go menu.
Click on the folder choose “Compress Mail” from the File menu zip it up.
Drag the Mail.zip folder to the Backup folder.

c. Backup your Address Book contacts
In the Mac OS X Address Book app, Select File>Export>Address Book Archive and save a copy in the Backup folder.

d. Backup Safari Bookmarks
Select File>Export Bookmarks and save a copy in the Backup folder.

e. iDisk – Move any important files into DropBox Backup folder. (Note: The free DropBox account has a limit of 2 GB.)

5. Then do a full backup of your computer with SuperDuper!

6. Follow through the MobileMe to iCloud upgrade process. The following Apple articles will assist: http://www.apple.com/mobileme/transition.html and http://me.com/move

7. Open iCal. Create a New Calendar and import from your backups in iCal.

8. At the end after moving calendars, restart your computers…and wait patiently for things to sync to the cloud.

9. Turn on iCloud on each of your iOS devices.

If you’d like assistance making the move to Lion and iCloud give us a call and we can help you remotely nearly anywhere in the world.

FileMaker DevCon 2012 (Developer Conference)

The FileMaker Developer Conference is coming up later this summer July 16-19.

Cimbura.com developers will be heading out to Miami Beach, Florida to learn about the latest FileMaker and web development techniques and products. There will be 4 intense days with over 1100 other developers from all around the world. We’ll have a chance to talk directly with the engineers that build FileMaker to get the inside scoop on how things work and what the future holds.

We believe this conference is so vital that we’ve attended the it faithfully for the last 11 years. We wouldn’t miss it for anything because it provides our clients with so much value.

  • Seeing the HISTORY of FileMaker shows a consistent dedication to improving the product and building a solid platform to build on.
  • Seeing the PRESENT world of FileMaker makes it possible to utilize the best of breed products and technologies to make your business effective.
  • Seeing the FUTURE of FileMaker helps us to make development plans that make the best use of your resources.

If you have anything you’re contemplating in new technology related to your FileMaker database or business, let us know and we’ll keep an eye out for it…be it bar coding/RF ID tags, mobile apps on iPads/iPhone, web integration, credit card processing, or bionic leg control. : )

Last year, we had the honor of one of our custom applications being demonstrated during a session at DevCon as one of the premier examples of a mobile solution based on FileMaker Go.

One of the great things about DevCon is that it’s usually held somewhere extremely hot in the middle of the summer…Phoenix, Palm Desert, San Diego…and this year Miami. That way, all the developers can work on their tans in between sessions.

For developers that would like to keep track of their DevCon history, we’ve created a simple FileMaker database to track all past events going back to the first “FileMaker DevCon” in 1996. Download the free database here. If you have any additional information, corrections, or details to add feel free to send them to us and we’ll update it.