CampSoftware Logo       FileMaker Certified Have a question? Email Us

Home | Products | Contact & About | Blog | Twitter | RSS Feed

Art Licensing Manager 3 Progress

Hal Gumbert

Making Progress

We just wanted to share a quick video on the progress we've made on Art Licensing Manager 3. So far...

- EasyData 2 has been brought into the project for the database model.
- The web app is now accepting user logins and even using cookies to relogin!
- The navigation system is taking shape. We have a toolbar with buttons to take us to the correct page.

There's still more to do, but it's progressing faster than expected! If you need an app that can run on Mac, Window, Linux, iPhone, iPad, or a Web App like Art Licensing Manager, get in touch! Xojo make development of app so easy, and we've been at it since 1998!

Avast! Mac's Need Protection Too

Hal Gumbert

But Mac's are Secure!

Yes, Mac's are very secure, but there is some malware out there. Just the other day a friend of ours couldn't web surf due to a nasty bit of malware.

Avast is comprehensive too. It scans your Files, email in Mac Mail, and Websites that you browse. I can't tell you how many viruses it's found in junk mail sent to my email accounts.

Google Link Checker

Avast will also let you know wich links are safe when searching with Google as you can see in the picture below. See the green checkboxes on the right? Virus Test

Install Avast for Free

You can download and install Avast for free.

Excited Labels for Xojo which could also work in FileMaker

Hal Gumbert

Field Labels can be Excited

Just like a microwave excites water molecules, you can excite your field labels.

Normally we all place field labels to the left of our fields but that takes up a ton of space. That works and will continue to work, but when I was visiting last night I saw a very nice animated way to handle a field label.

Before Clicking

Label Before

After Clicking

Label After

Xojo or FileMaker

While our example file works in Xojo, it could also be accomplished in FIleMaker using Object Hiding. It's great that these type of techniques can be build for just about any platform.

In our example, we use Xojo's CueText to place the Label text into the Field. We also set the Label to the HelpTag / Tooltip. When the Window/Page/View loads, the user will see the Label in the Field. When anything is typed in to a field, the CueText is hidden and the Label above the Field is shown. The only time that the Label above the Field and the CueText is show is when nothing is typed into the Field and the cursor is in the Field.
Excited Labels

Download the Example or Watch How it Works

Check out the video below and download the example file. Using techniques like this help to make software for our clients much faster!

More to Come

We'll be posting more as we progress with the Art Licensing Manager 3 conversion from a FileMaker Runtime to a Xojo Web App!

Art Licensing Manager v3 - EasyData2 Database Model for Xojo

Hal Gumbert

Summer Vacations and Thinking

It's been a few months since the last post about converting the Art Licensing Manager to a Xojo Web App. It's been a busy summer between working on projects for clients, going on RV camping trips, and thinking about the best way to convert our FileMaker Runtime to a Xojo Web App. One of my favorite 'work' days this summer was working on the web app from our travel trailer campsite while enjoying the weather.

FileMaker Runtimes Still Listed as Deprecated

The 2015 FileMaker DevCon has come and gone but we've gotten some great news about Runtimes. FileMaker stated on the Community Forums that FileMaker Runtimes will be in the next version of FileMaker. Since FileMaker 14 was released in May 2015 the next version should be available 12 to 16 months later. That gives us plenty of time to complete the conversion. Just to be clear, Runtimes are not deprecated yet, but are on the list to be possibly deprecated.

Database Models Galore

After some conversations, looking at several data models, and a bunch of coding, I think we found a solution. We took EasyData1 that is currently on github and make it easier to work with. It's now very flexible. There are now simple calls that can be used most of the time or the detail calls can be used for complex work. The prior version was all or nothing that made complex work difficult. One of our favorite features of EasyData2 is that it only loads the database fields that you need rather than all of them all of the time.

Showing Promise

It's already starting to look good. EasyData2 can now automatically mask fields like changing text to Title Case. It will be trivial to mask data like phone numbers and zipcodes. We already have ideas for security and navigation. Keep in mind that Xojo Apps are quite a bit different than a FileMaker Database. With Xojo, fields on a Window, WebPage, or a View are are not bound to a database field. You have the power and responsibility to do with it what you will. I think a good an example in FileMaker would be if you created a layout based on table of only global fields. In that scenario, the developer is responsible for prepping the data to be edited, saved, or deleted.

Seeing is Believing

Check out the video below and download the example file. Using techniques like this help to make software for our clients much faster!

More to Come

We'll be posting more as we progress with the Art Licensing Manager 3 conversion from a FileMaker Runtime to a Xojo Web App!

ALM v3 - Conversion of a FileMaker Runtime to a Xojo Web App

Hal Gumbert

Getting Started

This is the beginning of a series of posts discuss converting our Art Licensing Manager product that runs as a FileMaker Runtime to a Xojo Web App. We'd love suggestions, feedback and more than willing to answer any questions about the process. We plan to get into a little detail, but not too much and some sample code. If you're not a developer, the goal is to create better software at reasonable cost / investment. If you are a developer, this might be an option for you. If you're not sure if you can do this, we could assist you or help you out as much as you need. WE HAVE NO PLANS to halt our FileMaker development. We're simply moving our runtimes to Xojo because FIleMaker may not be providing another option to Runtimes in the future.

What is a Runtime?

If you don't know what I runtime is it's described by FileMaker as: With FileMaker Pro Advanced, you can bind FileMaker database files into runtime solutions, which are solutions that do not require FileMaker Pro or FileMaker Pro Advanced in order to be used on a computer. You can also create runtime solutions in Kiosk mode. FileMaker 14 shipped a month or so ago and have added Runtimes to the list of deprecated features: Runtimes have been around for years and years, but its deprecation was a surprise to the FileMaker community. It was brought up and discussed on the FileMaker Community FileMaker eventually locked the discussion after 440 replies. On May 18th FileMaker replied and stated:
We've heard your comments related to the deprecation of the FileMaker Runtime. We'd like to remind everyone that the Runtime is supported today and the feature is included in FileMaker Pro 14 Advanced. And at this time we have set no specific timeframe for it's removal. A number of you have described uses of the Runtime such as for commercial applications, for demos, and as part of solutions. Over the coming weeks we will reach out to various individuals to understand more how you use the Runtime so that we can consider your concerns as we move forward. FileMaker, Inc.
While I appreciate the reply, I still don't know what the future of Runtimes will be and need to make decisions with the information I have now. I have to assume Runtimes will be removed in FileMaker 15.

FileMaker and Xojo Multi User Solutions Costs

We currently have two products that use Runtimes, but we're going to focus on the Art Licensing Manager. We offer the ALM as a Runtime to save our clients money and Runtimes works great as a demo. Once folks start to use the ALM, they eventually want to move to multiuser. When that happens, they usually purchase two or more copies of FileMaker Pro so they can share with up to five ( used to be 10 ) users. If they need more than five users, they need FileMaker Server. This shows that while Runtimes are free, they do make FileMaker money, just not directly. The cost of FileMaker has gone up dramatically since FileMaker 12, especially with concurrent connections. As soon as our users want to share the ALM between two users, they need to pay $330 for each FileMaker Pro which would be double the cost of our solution. Once they go past five users, they need server and possibly concurrent connections. Concurrent connections costs skyrocketed from ~$40 each in FM 12 to $180 each for FM 13 to $288 each for FM 14. The other option is to pay annually which offers a lower annual cost, but the overall costs increases dramatically over time since it's essentially a rental fee. We also considered transitioning the FileMaker Runtimes to using FileMaker Server with WebDirect. WebDirect is very similar to Xojo Web Apps in functionality as users can use the FileMaker database with just a web browser. One option would be that we host the server for ALM users or they could host it themselves. Unfortunately, the costs are EXTREMELY high. FileMaker Server 14 with 100 concurrent connections would cost $597/per month which is $7,163/per year under annual licensing and the price to pay for it once is $21,488. The same setup with 5 concurrent connections is $69/month or $828/year and the pay for it once price is $2,884. These numbers are from Xojo licensing works differently. The developer purchases Xojo and can then distribute any number of apps for no additional fee or royalty. We're already using Xojo Pro which is $699/year, but they have other plans too. Xojo Pro gives us the ability to create Desktop ( Mac, Windows, Linux ), Web, and iOS apps. We've created all of those, except for Linux apps, which might change this year when Xojo adds the ability to Compile to Raspberry Pi. In the past, we've created many, but here's a sample: - The MacAcademy Windows Academy CDROM Training interface for Mac & Windows. - A school attendance and behavior tracking Web App. - The "Reference for FileMaker" iOS app.

Positives and Negatives

I've been a long time Xojo developer, but I've been using FileMaker for seven years longer. I love both tools and they each have their positives and negatives. The speed of development is much faster with FileMaker than Xojo, but the cost of FileMaker is much larger than Xojo. Given a typical FileMaker solution, it would take me much longer to develop, maybe four times longer. At some point, the Xojo solution becomes less expensive since the FileMaker costs reoccur every year, but there is a higher initial expense. I can also create real app with Xojo that can run on Mac, Windows, Linux, iOS, and Web with Raspberry Pi coming soon.

What is a Xojo Web App?

We've decided to convert our Runtime solution to a Xojo Web App which can run on Mac, Windows, or Linux. They look and feel like REAL apps ( ), but just run in a browser. Xojo offers hosting on their servers ( ) where they are EXTREMELY security conscience but you can host the apps yourself. Web Apps are interesting because they are inherently multi user and can be run just about anywhere. Anyone who uses the Web App just uses their web browser to connect, but we plan to create an incredibly simple Mac and Windows app that is a one window web browser to help prevent folks from accidentally closing the browser or using the back / forward buttons. The Web App itself is essentially the server. It just runs and all access is via a browser. So if a single user wants to use it, they run the Web App and fire up their browser. For more than one user, it's the exact same process, except more users open their browsers. We plan to offer self hosting or we'll take care of hosting it for a monthly fee. I've already started on the conversion process about a month ago where I've been testing and experimenting with Xojo to reduce the development time as much as possible. I've gone down several paths with the goal of finding a method that is super easy to use for simple solution, but allows for complex solutions as well. My goal is for it to be FileMaker like. In most cases, I want to be able to add a field to the database table and then just put the field/control on the layout/window. So far, I've found the following database models in the order I've looked at them: - Active Record by BKeeney Software ( ): I like Active record, but It seems too complex for what I want. I know Bob, the B in BKeeney, has had great success with it. Active Record requires that you create a class ( just a definition of the tables and fields in a hierarchy ) that mirrors all of your Table and Field names and types that are the SQL database. It's really easy to do with Argen, a tool that Bob created. However, if I add a field to a table, I'd need to update the class with the newly added fields. That seems annoying, but it does provide type ahead when entering the table and field names which leads to less errors. - LazyDB by Bob Gordon presented at the Xojo Dev Conference. This was a mind blowing presentation. Bob, created smart fields that knew their table and field names and they just updated themselves and saved themselves in a very similar manner as FileMaker. Bob's not sure if he wants to make it available to the public or not, so it's out of the question. - EasyData by CampSoftware ( ): This is what I was able to develop to solve my own problem. It works great, but requires writing some code to 'register' the fields and list boxes to a 'table'. I like it, but I'd like something even easier. - Storm by Paul Lefebvre ( ): I'm currently leaning towards using Storm since it requires the LEAST amount of code. Paul and I talked about some options to have it use even less code. :) Once we decide on what database model to use we need to think about / solve the following: - [Our Next Post] Wrapping the Xojo Web App into a Server Desktop App and providing an optional Client Desktop App. - Exporting all the data from the FileMaker Runtime to the Xojo Web App. - Printing and printing reports in Xojo to paper and PDF. - Changing our licensing to multiuser. - In app payment processing to transform the demo into the full product. - Building a library of reusable functions ( like FileMaker Custom Functions but more powerful ) - Taking advantage of Xojo Containers ( like a sub layout, if that existed in FileMaker ) - Building tools for Xojo ( like FMSnippets and FMClips ) We'd love any suggestions, feedback, or questions.

Looking at FileMaker 14 a Month after the Release

Hal Gumbert
FileMaker 14 was released a month ago and it's a nice update. Here's what we found interesting...

For Non Developers

- Launch Center is very nice. You can now type cmd-O / ctrl-O to view files you recently opened in a very visual method. Our favorite feature is assigning icons to the database by going to File --> Options --> Icon tab.
Launch Center - WebDirect has been overhauled. It's now much faster and uses less resources which means your server can now handle more connections than before. It's also been updated to work better on phones and tablets, even non Apple devices. I have issues with the pricing which I go into detail below. - Status Tool Bar has been updated to flat icons. Personally, I think the icons look cheap, but doesn't change how it works. I really dislike the change to the pie graph for found / omitted records. Only using the pixels around a circle makes it difficult to see quickly. All the pixels in the circle are wasted.
Status Tool Bar - Auto Reconnect to Server is fantastic. This came out of a FileMaker Go feature which automatically will attempt to reconnect to the server if the internet is interrupted or if you laptop goes to sleep. I love keeping our FMSBFoundation database open all the time now. Here are the Security / Extended Privileges that we add to our solutions.
Security / Extended Privileges

For Developers

- The new Script Workspace is very nice. I found that I can create scripts with my hands on the keyboard more than before. Many of the options require using the mouse though. - The Manage Security panel is now more secure. Now you need to enter a Full Access account username and password to gain access.
Manage Security - The Script Coloring This very nice, but I wish were were additional categories. I've been using the MBS Plugin which gave more control over coloring. My preference was to color items based on their functionality. It's usable though. Below you can see the FileMaker panel and the MBS Panel.
Syntax Coloring
MBS Syntax Coloring


- 64 bit versions of FileMaker are now available. You'll need to make sure all of your plugins / extensions have 64 bit versions available. MBS, BaseElements, 360Works, and 2Empower have updated theirs. - FileMaker pricing has changed again and not for the better. Under FileMaker 12 Server Advanced, Instant Web Publishing came with 50 web connections. FileMaker 13 Server replaced IWP with WebDirect which came with 1 connection and additional connections were $180 each so users could connect via WebDirect or FileMaker Go. FileMaker 14 Server works the same way, but the connections are now $288 each. That's a huge price increase making the purchase of 50 connections around $14,400 where FileMaker 12 Server was $3.000. That's a massive price increase. FileMaker is now offering annual licensing where you pay essentially a rental fee every year, at a lower cost, but if you stop paying you must uninstall FileMaker. At $288 each, the cost of concurrent connections are almost the price of FileMaker Pro, but you can't develop in WebDirect or FileMaker Go.

FileMaker 14 Has Been Released

Hal Gumbert
We'll be blogging more about this next week. For now, we suggest that you don't upgrade for at least a month until we see if there are any issues with the new release.

Easily Generate and Install a $57 Custom FileMaker Server SSL Certificate

Hal Gumbert
Generating and getting a custom SSL Certificate for FileMaker Server is much more complicated than it should be. Last year, I personally spent much more time that it should have taken to get it to work. Unfortunately, FileMaker Inc doesn't provide detailed instructions on how to get through the process. Last year, I was able to get a Comodo InstantSLL Certificate to work great, but it cost $100 for a year. That certificate is expiring next week, so the timing of this was perfect. Before creating these instructions, I tried to follow the instructions that Tim Dietrich provided to create a certificate with MediaTemple. Luckily, when I went to spend the $75 for the certificate, I found out that you cannot buy a cert from MediaTemple if you don't use any of their other services. I would have bought two… They suggested that I go directly to GeoTrust, but that was even more expensive than the Comodo certificate. This time, I Googled for 'GeoTrust QuickSSL Certificate' and saw on the first page of the results that had the exact same certificate for $57. That's about half off the Comodo certificate and about 25% off the MediaTemple certificate! As an extra bonus, I recently moved the website from GoDaddy to recently. Overtime I went to pay for new services or even renew a service, GoDaddy would up sell products I don't need and the payment process was overly complicated.'s main feature is to make the process easy and affordable. With GoDaddy, they charged their max rate every time, forcing me to look for coupons to get the price down to a reasonable level. So, I took a slight chance and ordered the $57 NameCheap GeoTrust QuickSSL Premium Certificate and it worked perfectly! Try out the following instructions and let me know if you run into any problems. There are some Mac specific instructions, but we'll update this ASAP. - Buy the NameCheap GeoTrust QuickSSL Premium Certificate: - Generate the request certificate on the FileMaker Server. - On Mac: sudo fmsadmin certificate create / - Copy the contents of the FileMaker Server/CStore/serverRequest.pem file. - On Mac: Drag the serverRequest.pem file to TextEdit on and the copy the entire contents of the file. - In your NameCheap Panel, set up your certificate: - Click 'Activate Now' for your 'QuickSSL Premium' certificate. - Select 'Other' for the Web Server Type - Paste the contents of the serverRequest.pem file that you copied earlier. - Click Next - Choose Email Address for the domain in which you can receive an email. - Click Next - Check the Admin Contact settings and make sure you can receive an email from the email address where the cert will be sent. - Click Submit Order - Check for the email to approve the certificate. Check your junk mail if you don't find it. - Click the approve web link in the email. - Wait for the page to load and approve the certificate. - Wait for the certificate to be emailed to you. Check your junk mail if you don't find it. - In the email, look for the Web Server Certificate and create a text file containing the text from and including '-----BEGIN CERTIFICATE——' to '-----BEGIN CERTIFICATE-----'. Save it as 'serverCustom.pem'. - Import the serverCustom.pem file. - On Mac: sudo fmsadmin certificate import ( then drag file to terminal )

WARNING about FileMaker 13.0v9 Security Update