Excelisys Custom Database eX Cetera Blog

FileMaker, Inc. has released FileMaker Server 11.0v4 for Mac OS X

September 29th, 2011

FileMaker, Inc. has released FileMaker Server 11.0v4 for Mac OS X versions 10.5, 10.6, and 10.7. This update addresses the following issues:

Installer
• The fmserver user is no longer displayed as a user in the Mac OS X Lion login window.

Database Server
• Fixed an issue where a scheduled script using the Get(FileMakerPath) function on Mac OS X could cause
FileMaker Server to crash.

Web Publishing Engine
• Web Publishing is now fully compatible and supported on Mac OS X Lion. This includes Instant Web
Publishing and Custom Web Publishing (PHP, XML, and XSLT).

When upgrading your server’s operating system, you must reinstall FileMaker Server.  Because this software adds support for Mac OS X version 10.7 Lion, it is a full installer rather than an updater.

Learn more and download here:
http://help.filemaker.com/app/answers/detail/a_id/9965

Best regards,

FileMaker Developer Relations Team

FileMaker, Inc.
5201 Patrick Henry Drive
Santa Clara, CA 95054
http://www.filemaker.com

Happy Birthday Excelisys! 1o Years of Excellence!

September 1st, 2011

Excelisys celebrates 10 years as of 9/1/2011 in building, supporting, migrating, upgrading, tweaking, fixing, and integrating quality custom database solutions and web applications.

Specializing in technologies like FileMaker Pro, FileMaker Go, MySQL, MS SQL Server, PostgreSQL, Adobe Flex, PHP, AJAX, ASP.net, Integration with QuickBooks, Excel to FileMaker conversions, iPhone and iPad integration, and other various database technologies and frameworks for Web, Mobile, and LAN/WAN deployment strategies. Our goal is to foster solid relationships, provide exceptional value, extreme high quality, intuitive end-user usability and excellent customer service for our clientele.

If you are a new or existing client of Excelisys, we have a present for YOU! Find us on FaceBook or Twitter, send us some wishes via a Tweet or FB post and we will give you an hour of our time, on our dime!

 

We look forward to celebrating the next 10 years!

Drag & Drop Using TSM (The Separation Model)

February 28th, 2011

This was brought to our attention from one of our respected and beloved collegues, Steve Abrahamson of  Ascending Technologies.

I thought we would recap here on our blog for those wanting to know the issue and the resolution. You can find here as well on the FBA List.

– THE ISSUE –

So I went to implement a little drag and drop sorting goodness in a solution tonight. A while ago I downloaded a demo from Exelisys on drag & drop sorting, so I fired that up and went to put it in… and it doesn’t work with TSM.

 

I got it here: http://www.excelisys.com/tips-tricks-filemaker-downloads.php

 

You see, the technique relies on an Auto-Calc field evaluating during a script execution and setting some $$variables. Unfortunately, with TSM, that data field is in a different file, and hence, the $$variables are not visible to the script during execution.

 

Took me a good 45 minutes to realize that, of course. *sigh*

 

Does anyone know a good drag & drop portal sorting technique that WILL work in TSM?

 

– THE SOLUTION OFFERED BY EXCELISYS–

Easy modification:

 

1. Create unstored calcs in the other file that reference those global variables

2. In the interface file, reference the unstored calcs instead of the global variables

 

– ADDITIONAL TWEAK INFO VIA STEVE –

Thanks! It does work; note that it requires one more modification: an extra script in the data file to be called at the end, to clear out the $$variables there

 

The only real *problem* is this: there’s a 2-3 second lag with this, which feels just short of forever… and that’s running locally on my development machine. I’m not sure what performance will be like in production, but it won’t be faster than that. (Andrew’s original file executes instantaneously, which is great.)

 

 

Conceptually, the original technique is great for FMP, though oppositional to TSM: it requires the addition of 2 extra TOs in the data file for every place where you want to implement this UI feature; the idea of TSM is to have this detritus in the UI file, so conceptually, it rankles. It’s untidy. That’s just me being anal.

 

I was trying to make a version that, instead of relying on an auto-evaluate field, rather uses two triggers, one on field entry, one on field modification, plus one OnTimer call. It’s a bigger script by a long shot, but was hoping it’d be cleaner in execution, and all script, no field-level stuff. As it is, I need to get going on this project, and since this works (awkwardly, but works), this may get tabled for now.

 

Please extend my thanks to your guys for the assist. I’ll put a happy response up on FBA Tech Talk. Everybody likes happy, don’t they? Especially when it ends that way.

 

 

FileMaker DevCon 2011

February 22nd, 2011

Come to the FileMaker Developer Conference 2011 and discover just how far your FileMaker solutions can go. Learn how to build more professional databases, extend your solutions to the web or deploy iPhone and iPad solutions using FileMaker Go.

Go Farther, join us at DevCon 2011!

Whether you’re a novice or a seasoned developer, you’ll increase your technical expertise – along with your career potential – in just a few days. Go farther when you come to San Diego by meeting people from over 35 countries to network and exchange ideas. And DevCon is the place to go when it comes to learning all about the latest products and services at the Exhibitor Showcase.

Come to DevCon and you’ll go farther.

FileMaker Announces Significant Updates to FileMaker Go for iPhone and FileMaker Go for iPad

September 22nd, 2010

FileMaker Announces Significant Updates to FileMaker Go for iPhone and FileMaker Go for iPad

Free updates allow users to create PDFs, email databases, insert photos, and more

SANTA CLARA, Calif. — Sept. 22, 2010 — FileMaker, Inc. today announced version 1.1 of FileMaker Go for iPhone (http://www.filemaker.com/fm_go_pr) and FileMaker Go for iPad (http://www.filemaker.com/fm_go_pr), the popular new apps that let users work with FileMaker Pro (http://www.filemaker.com/products/filemaker-pro/) databases on iPhone or iPad. These significant updates, are available free from the iTunes App Store, and include enhancements for creating PDFs, sharing databases via email, and inserting photos in databases.

Users can now produce PDFs directly from FileMaker Go and either save them on their mobile devices or email them. This feature lets mobile users easily save and distribute reports, create invoices, and share project status directly from their iPad or iPhone.

Another enhancement is the ability to save a copy of a complete database and email it directly from FileMaker Go. With this feature, iPhone and iPad users can exchange databases from their devices without needing to dock with a desktop or laptop.

The update also delivers new ways to work more efficiently with photos and other media and information. FileMaker Go users can capture photos on an iPhone, or take photos that are already in the photo library of an iPhone or iPad, and insert them directly into a FileMaker Go database. Photos stored in a database can be emailed out later using FileMaker Go.

Other file types, such as spreadsheets, can be emailed directly from FileMaker Go.

Also new is the ability for FileMaker Go users to import records from local or hosted FileMaker databases using script steps.

iOS app developers may take advantage of the newly enhanced URL protocol from FileMaker for calling FileMaker Go. Using the URL protocol, developers can now specify a FileMaker Pro script and script parameters. This allows developers of commercial and in-house iOS applications to extend FileMaker Go databases and provide a wide spectrum of useful solutions such as bar code scanning.

“FileMaker Go for iPhone and FileMaker Go for iPad have stirred up huge excitement in the FileMaker community and beyond. Initial acceptance has been strong and this is just the beginning,” said Ryan Rosenberg, vice president of marketing and services for FileMaker, Inc. “With these free updates, we are already making both apps even more powerful and adding new ways to share information remotely.”

FileMaker Go, which launched in July 2010, has already received much editorial praise, including a 4.5 mice rating from MacWorld magazine.

FileMaker Go: Access FileMaker Pro information anywhere
FileMaker Go lets user view, edit and search FileMaker Pro records on iPhone or iPad. Databases can be accessed directly from files hosted on FileMaker Pro or FileMaker Server, or database files can be copied locally onto FileMaker Go via File Sharing in iTunes.

Compatibility, Pricing, and Availability
Compatible with FileMaker Pro 7 and all later versions, FileMaker Go 1.1 is available now as a free download for existing FileMaker Go users from the App Store. FileMaker Go for iPhone and iPod touch (running iOS 4) is $19.99 and FileMaker Go for iPad (running iOS 3.2) is $39.99.  Additional details are available at http://www.filemaker.com/fm_go_pr.

About FileMaker, Inc.
FileMaker (http://www.filemaker.com) is the leader in easy-to-use database software. Millions of people, from individuals to some of the world’s largest companies, rely on FileMaker software to manage, analyze and share essential information. The company’s products are the FileMaker Pro line – versatile database software for teams and organizations, for Windows, Mac, iPhone, iPad and the web – and Bento, the personal database for Mac, iPhone and iPad. FileMaker, Inc. is a subsidiary of Apple.

Customer contact:
800-325-2747
http://www.filemaker.com

Copyright 2010 FileMaker, Inc. All rights reserved. FileMaker and Bento are trademarks of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners.

FileMaker, Inc. Announces GO – For iPad and iPhone

July 20th, 2010

Looks like we have another way to access FileMaker Pro solutions! EXcellent – nice job FileMaker!

If you need any application tweaked or enhanced to take advantage of the new deployment strategy of GO from FileMaker, Inc. – Excelisys is the GO to team to help!

Want more info on go: http://www.filemakertrial.com/go/

Want more info on Excelisys’ FileMaker services: http://excelisys.com/database-development-consulting.php

ExBizTracker V3.0 FREE Public Beta Demo Available

June 3rd, 2010

The NEW eX-BizTracker V3.0 for FileMaker Pro 11 is built off of the strong foundation of the original FileMaker Business Tracker developed by Excelisys for FileMaker, Inc., and both the eX BizTracker V1.0 and V2.0. Excelisys has upgraded the jump–start solution with dozens of new features including: eye–popping charts and graphs; dynamic sub–summaries in list views; activity tracking; sending email directly out of FileMaker Pro; and an upgraded graphic interface.

The eX–BizTracker V3.0 is an easy to use “jump–start” solution for small to medium size businesses and organizations who wish to track clients, invoices, inventory, payments and communications in a robust multi–user scalable solution with dozens of new features based on the recent release of FileMaker Pro 11.

NEW features added to the eX Biz Tracker V3.0 include:

  • Report module now includes eye–popping charts and graphs
  • Dynamic sub–summaries in list views
  • Track activities such as phone calls, appointments, follow–up reminders and email
  • Send email and email invoices directly out of FileMaker Pro
  • Completely upgraded graphic interface
  • New invoices features include quote tracking and drop–shipments
  • Revamped navigation uses script triggers to handle background tasks when manually changing layouts
  • Script triggers used throughout to provide better UI controls
  • Expanded user preferences

It’s Official: Use our Drag-n-Drop Technique With Confidence

September 11th, 2009

Engineers at FileMaker Inc. have finally dispelled a rumor.

During the recent FileMaker Developer Conference in San Francisco last month, quite a few attendees approached us asking whether a statement heard in one of the sessions was true or not. It seems one of the presenters from FMI suggested the idea that Excelisys‘ now famous drag-n-drop technique was not necessarily reliable and should be used with caution.

The statement was made in recognition of the fact that the technique, which allows you to create a once-impossible user interface feature, is based on what engineers call an “unexpected behavior” which could possibly change in future versions of FileMaker Pro. However, this behavior is NOT a bug, and is in fact considered a feature by many developers.

The behavior in question is the fact that an auto-enter calc will trigger before a script trigger is executed. Discovering this behavior was a surprise to many, including FMI engineers.

We wanted to set the record straight, so we spoke with FileMaker engineers. The word finally came down from them this week that there is almost no likelihood of this behavior changing anytime soon. Of course, FMI can’t guarantee the low-level behavior will persist in future versions, nor would we expect them to. But we are confident that such a change is highly unlikely.

So relax and integrate this amazing technique into your solutions with confidence. The advice to use with caution is generally made when any technique is dependent on an unexpected behavior. But with a confirmation direct from the “horse’s mouth”, as it were, we consider this a green light.

Excelisys is 100% Snow Leopard Compatible!

September 4th, 2009

EXCELISYS IS NOW 100% SNOW LEOPARD COMPATIBLE

South Bend, IN, September 3, 2009 — Excelisys, Inc., a database solutions and consulting organization specializing in quality custom database application design, development, and consulting for LAN, WAN, Web, and Mobile deployments, and a member of the FileMaker Business Alliance, is pleased to announce that all of their FileMaker® Pro development and consulting practices, abilities and methodologies are fully functional and 100% compliant with the new release of the Apple® Mac OS® X 10.6.

Snow Leopard Compatibility

All of the following Excelisys practices are fully compatible with Mac OS X 10.6, a.k.a. Snow Leopard: Initial Free Consultation, Project Scope Gathering, Design Specification Production, Estimating, Interim Build Delivering, Final Deployments, and most importantly, Ongoing Support.

“We are very excited and pleased that our services are 100% compatible and fully functional with this new Mac OS release,” said Christo, CEO and founder of Excelisys. “Our methods are now bug-free and ready to use!”

Scott Mosher, Business Development Manager at Excelisys, is confident that the company’s quick response time was a key element in their smooth transition. “Keeping up with evolving software and operating systems is integral to the success of any good development and consulting firm. At Excelisys, we worked quickly and efficiently to update our practices and policies to adapt to this new OS. We are most confident that our services will continue to be as rock solid as they have historically been, and plan to move forward with no interruptions.”

Geoff Ryle, President and Co-Founder of Excelisys, envisions immediate benefits for the company’s clients. “With the release of Snow Leopard, our clients can now enjoy enhanced productivity and superior performance with the solutions we build for them.”

“The entire computing industry is moving from 32-bit to 64-bit technology, and it’s easy to see why,” explained Greg Furry, VP of Technology at Excelisys. “Today’s Mac computers can hold up to 32GB of physical memory, but the 32-bit applications that run on them can address only 4GB of RAM at a time. 64-bit computing shatters that barrier by enabling applications to address a theoretical 16 billion gigabytes of memory, or 16 exabytes. Does that scare you? It shouldn’t. At Excelisys, we’ve been planning for the 64-bit changeover for 8 years.”

Snow Leopard Discount

To commemorate this auspicious occasion, Excelisys is offering discounted hourly rates until September 30th, 2009, and bonus hours based on time purchased and used. Call one of our FileMaker® experts today at 866-592-9235 or e-mail us at info@excelisys.com to find out the details of this extraordinary offer!

About Excelisys, Inc.:
For over 8 years, Excelisys, Inc. has been helping companies become more efficient, reliable, and profitable by providing excellent, integrity-driven consulting and development software services. From custom FileMaker® Pro database development and consulting, to the eX-File jump-start products, to Web Site/Application design, development and consulting services. Excelisys is should be your first strategic partner of choice for all your company’s technology needs.

Contact:

Excelisys, Inc.
South Bend, IN 46635
Phone (sales): 866-592-9235
Media Contact: 574-273-5805
Email: info@excelisys.com
Web: http://www.excelisys.com/

Copyright 2009 Excelisys, Inc. All rights reserved. FileMaker Pro is a registered trademark of FileMaker, Inc. Apple, Mac, and Snow Leopard are registered trademarks of Apple, Inc.

Excelisys Turns 8, You Get To Celebrate!

September 3rd, 2009

For our Octo-celebration Excelisys is offering an incredible gift good until the end of September; greatly discounted hourly rates and free time to those who make the wise decision to retain our services! If you have been looking for the right FileMaker, MySQL, Web, PHP consulting and development firm, you found it and now is a better time than any to act on it!

Excelisys was founded initially by Christo & Geoff Ryle on 9/1/01. The Excelisys organization initially started with only FileMaker Pro development and consulting services with Christo handling marketing, sales and administration duties, and Geoff acting as lead programmer and project manager. Both individuals shared many other responsibilities until they grew the team. Since then Excelisys has been honored to have some of the finest talent come, stay, and unfortunately go. With a client base of over 300+ and still growing steadily, Excelisys is pleased that despite this years economic “issues” they are still going strong!

Kurt Knippel, VP of production and a Project Manager stated “Excelisys, Inc. has brought together some of the finest individuals that I have ever had the pleasure to know and work with.  The distributed office model has made possible the gathering into a single entity of a diverse group of people, not possible in a traditional centralized office model.  I am honored to work with each and everyone of our management, sales and development staff.”

Geoff Ryle, President/Co-Founder and Project Manager bragged “Time sure flies when you’re having fun. When we started this company 8years ago, we had two main goals: to foster long-term technology relationships with our client and create a flexible and positive environment within which our developers can thrive and do their best. We’ve since grown our team to include some of the most talented developers I’ve had the pleasure to know, and in doing so have become a family that works, learns
and plays together.”

Scott Mosher, Account/Business Manager for Excelisys went on with “As Excelisys celebrates it’s 8th birthday, I celebrate my 3rd year as a Business Account Manager for them. Working with this team has been a great experience and different then with most.  Although the Excelisys business model is untraditional in it’s work-from-anywhere model, all members perform in a very professional manner with outstanding communication and constant availability.  This team consistently shows it’s flexibility and foresight by bending and morphing it’s strategies and dynamics to the current and rising trends in technology and development paradigms.  It’s a pleasure and comfort working with such a spirited and progressive company.”

Greg Furry who is Excelisys’ CTO and also a Project Manager claimed “As Excelisys celebrates birthday number eight we stopped to ask. Is eight enough? Heck no! We are just getting started. Think about the tech scene 8 years ago. In September of 2001 the iPod® wasn’t even announced yet! We are excited to continue on the leading edge of high tech for years to come. We have assembled a team of developers, designer, writers and other techie type people across the country to design, develop and deploy solutions to make your life easier and far more productive. ”

Rick Middleton, Account/Business Manager for Excelisys says “Excelisys turns 8 years old this month, I’ve been with them for 3 1/2 years.  It has been a wild ride.  It still amazes me every day.  There are experts in very area of our company, from the “new” tech toy, to the latest and greatest script trigger.  Any time I have a question, a Project Manger or developer is ready willing and able to assist me, and they don’t even giggle when I ask “simple” questions.  I have never worked with a greater bunch of people.  The Project Manager and Developers have worked extremely hard to make sure there is always constant, continuous, communication, not only between us and the clients, but also between the staff.


Excelisys

Explore the eX Cetera Blog


Services Database Development
& Consulting

Web Site / Applications
Commercialware
Custom vs Commercial
The Development Process
Custom FileMaker Applications
FileMaker Consultants
FileMaker Consulting
FileMaker Developer
FileMaker Development
FileMaker Experts
FileMaker Help and Support
FileMaker Professional
FileMaker Programmers
FileMaker Services
FileMaker Web Solutions

Company Our Team
Why Choose Excelisys?
Our Philosophy
About Us
How Do We Charge?
Alliances
Industry News
The Goods eX Files
eX BizTracker 3.0
eX BizTracker 2.0
eX BizTracker Pro
Tips N Tricks
Demos
Portfolio Our Portfolio
Client Testimonials
Our Clients
Contact Us Our Team
About Us
Employment
1–866–592–9235
Legal | © 2012 Excelisys eX Logo Excelisys.com