FileMaker Pro is the #1-selling easy-to-use database software for Windows and Mac OS that helps you manage people, projects, assets and more the easy way! The award-winning ease of use that is built into every aspect of FileMaker Pro continues to be praised by millions of customers and industry experts around the world. With its easy installation and setup, youll be up and running in a matter of minutes not hours or days. Then a few clicks will convert your Microsoft Excel spreadsheets and other files to FileMaker databases for easier searching, sorting, printing and reporting. The intuitive point-and-click interface helps you customize solutions and share them with ease. So whether you're tracking a simple contact list or multiple project tasks, FileMaker Pro helps you manage it all faster and easier than ever before! FileMaker Pro 9 Advanced includes all the features of FileMaker Pro 9 plus a suite of advanced development and customization tools to help you design and develop more powerful, more customized database solutions faster and easier than ever before! Enhanced In Pro 9 Advanced
- PHP site assistant menu item
- Debug login
- Script debugger
- Database design report
- Data Viewer With its advanced development and customization tools, FileMaker Pro 9 Advanced will help you take advantage of the new features of FileMaker Pro 9 to connect to your FileMaker data, connect to your External SQL Data and connect to your creative genius.
- Build PHP websites: FileMaker Pro 9 Advanced includes a new menu item that launches the PHP Site Assistant feature. It creates a set of PHP web pages for accessing FileMaker data using the new FileMaker PHP Class. You must have FileMaker Server 9 or the FileMaker Server 9 Development License, available free to members of the FileMaker Technical Network to use this feature.
- Debug login: Administrators can now log in to the Script Debugger and FileMaker Data Viewer and troubleshoot restricted access scripts upon authentication.
- Super script surveillance: Pinpointing problem areas and reviewing scripts step-by-step is a piece of cake with theScript Debugger. New enhancements give you more refined control. Place breakpoints on multiple steps at the same time or pause script steps that are about to be executed. Addressing errors is easier than ever because you can view the error result of the last script step and set scripts to automatically pause when a script error occurs, enabling you to go directly to the error definition in the help system.
- Document your use of the new features: The Database design report has been updated to document information on the great new features in FileMaker Pro 9. As an advanced user, youll love connecting to your FileMaker data with the FileMaker Quick Start Screen, Conditional Formatting, Send Link Database Sharing and more. Or create secure easy one-way or two-way connections to External SQL Data Sources. And connect to your creativity with new layout and design tools.
- Optimized for observation: The FileMaker Data Viewer makes it easy to debug and troubleshoot your database. Use the new Current Tab to view all field and variables used in the currently executing script. And sort the columns of the FileMaker Data Viewer by just clicking on the header. Benefits And Features The Top 10 Things You Can Do Faster and Easier with FileMaker Pro
- Manage customers, clients, and vendors
- Track inventory, products, and assets
- Organize pictures, video and other multimedia files
- Access project details and associated tasks
- Print invoices, letters and mailing labels
- Produce reports in PDF or Excel formats
- Create customized electronic forms that look just like your paper forms
- Design a custom application that works the way you do
- View live Web information associated with your data from within FileMaker
- Share databases with Windows and Mac users simultaneously over the network or across the Web The Award Winning Ease Of Use
- Easy to set up and easy to learn: Just follow the on-screen, step-by-step instructions, and you'll be up and running in a matter of minutes not hours or days. And with the new File Maker Learning Center, you'll have unlimited access to a wealth of resources, including online demos and training videos, to help you master FileMaker Pro with ease.
- Easy to convert your existing data: Just drag your Excel files onto the FileMaker icon on your desktop, and the information will import automatically. FileMaker can also import many different file formats so theres no need to re-key your information
- Easy to get the job done: Searching, sorting, and reporting is easier than ever. When you need to create daily project lists, weekly sales reports, monthly newsletters or mailing labels, FileMaker produces what you want, sorted the way you want. Plus, you can save your output to Adobe PDF or Microsoft Excel formats, and send it via email in seconds.
- Easy to customize: The intuitive point-and-click interface helps you customize your database to work the way you do and you dont have to know a thing about computer programming! Add your company logo, change background colors, move things around, and add buttons to automate tasks. Plus you can track virtually any type of information you want, including real-time web content, pictures, video clips, music files, Microsoft Word documents, and PDF files.
- Easy to share and scale: Your information is even more powerful when you can share it. With the cross-platform, multi-user network support, youll be able to share FileMaker information over a network with up to five simultaneous Windows users, Intel-based Mac users or PowerPC Mac users. And its Instant Web Publishing lets you share FileMaker information over the Web giving your team access to the information they need anytime, anywhere via a browser. Plus, FileMaker supports so many formats, including PDF and Excel, that virtually anyone you choose can view and analyze your information. And when youre ready to share with more than five simultaneous users, FileMaker Server products are ready to provide the scalability you need while maximizing the performance and security of your shared databases. Pre-Designed Databases We've pre-designed databases, set up reports and mailing labels, and added automation features to help you get started even faster! Choose from more than 30 starter solutions templates for the most popular FileMaker tasks, like managing contacts, organizing projects, and tracking assets. These Starter Solutions all come with FileMaker Pro and can be easily customized to meet your unique needs. FileMaker Pro installs Starter Solution Templates to help you manage people, projects, assets, and more.
- Manage People: Contact Management, Personnel Records, People/Performance Management, Faculty and Staff Management, Email Campaign Management, Registration Tracking, Time Cards
- Manage Projects: Student Records, Medical Records, Event Management, To-Do Lists, Issue Tracking, Resource Scheduling, Task Management, Research Notes, Field Trips, Asset Management
- Manage Assets: Inventory Tracking, Purchase Orders, Expense Reports, Lending Library, Document Library, Recipes, Product Catalog, Movie Library, Music Library, Student Emergency Cards Robust Customization Features FileMaker Pro delivers so many powerful customization and design features in an incredibly intuitive environment, that youll see advanced tasks reduced to a few simple clicks. And as quickly as new ideas come to you, you can refine your database all without programming!
- Use the built-in assistant: Let the Layout and Report Assistant guide you through the creation of custom layouts, labels, and reports so your screens have a professional, polished look.
- Drag and drop objects: Drag and drop fields and objects wherever you want. Add buttons, calculations, icons, your company logo, your favorite colors, or new fields to capture images of products and employee. The possibilities are endless, and FileMaker doesn't require you to hire an expensive expert to make your database look and work the way you want it to.
- Create your own views of the data: Customize different views of your data so you can see the information the way you want, and others in your workgroup can view it the way they want. FileMaker Pro will remember which view you want to see. The Layout Assistant makes it easy to add as many views as you need.
- Link information with a point-and-click: Link different pieces of data together using a simple point-and-click approach to get a more complete view of your information. Powerful Productivity Feature FileMaker Pro helps you work faster so youll have more time to spend on what's most important to your business, community, or life. It includes dozens of features that simplify and automate operations from faster searching and sorting to easy creation of email newsletters and pre-programmed functions. You just might wonder why you have spare time on your hands and why you didn't invest in FileMaker Pro sooner!
- Email marketing made easy: Using Email Merge, you can send e-mails to one or many contacts in a few simple steps without scripting. Add merge fields from your database for added personalization, and automatically add attachments if you choose. Great for email newsletters, news updates, and more.
- Email the contents of any field instantly: E-mail the contents of any field in your database using Fast Send. Send images, documents, Excel files, and more right from within FileMaker. Simply click on any field, then right click (or ctrl-click on Mac), and select "Export Field Contents" to automatically attach the field content to an email.
- Search databases without typing: With the FileMaker Fast Match feature, you can select information from the current field, and with one mouse click, find all matching records. Simply click on any field, then right click (or ctrl-click on Mac), and select Find Matching records to automatically perform a find for that field using its content as the search criteria. You can then constrain or extend your found set to find more records or refine your search.
- Import tables more efficiently: Immediately add a new table to your database's structure by simply importing new data. There's no need to create a table to receive the data first - the table is optionally created on-the-fly without you having to lift a finger.
- Automate data entry: The Auto-complete features gives you faster and more accurate data entry by adding the ability to fill in field contents automatically based on previous entries or Value Lists.
- Ensure everything is letter perfect: Check the spelling of data entry with the visual spell checker that underlines misspelled words and suggests alternatives.
- Choose from hundreds of built-in functions: You can easily add calendar drop downs, data entry value lists, and hundreds of other built-in programming functions to save data entry time and automate repetitive tasks. Built-in Security & Sharing FileMaker Pro comes with multi-user support so you can securely share FileMaker databases with Windows and Mac users - over your network or across the Web. Plus, FileMaker supports the most popular file formats so youll be able to share your information with virtually anyone you choose.
- Sharing over your network: You can share FileMaker databases over a network with up to five simultaneous users *** with either the Mac OS-based or Windows versions of FileMaker Pro or FileMaker Pro Advanced. And with the advanced security features of FileMaker, you decide who have access to what information and when. You can secure your databases by assigning account names and passwords, and then assign custom privileges for each user, specifying what they can view and edit, down to the field level.
- Sharing across the Web: If you have remote offices, clients or vendors that need anytime, anywhere access to your FileMaker information, you're in business. FileMaker comes with powerful web publishing tools to provide secure access to specified users via their browser. The database displays in a format familiar to what is displayed in the Windows or Mac OS versions of FileMaker Pro, and it uses your existing Internet connection to publish the database to the Web so no additional hardware or software, other than a supported web browser **, is required.
- Support for Popular File Formats: Thanks to support for the most-popular file formats, you can easily share FileMaker information with others outside you FileMaker workgroup. The PDF Maker creates Adobe® PDF files from you FileMaker information with a single click even add a password to secure editing or printing abilities. And if you ever need to send data to Microsoft Excel users, you'll find the Excel Maker indispensable. In addition to PDF and Excel support, FileMaker Pro imports and exports a variety of file formats and is compatible with the most-popular email programs.
- FileMaker Pro imports and exports these file formats: Adobe PDF, Microsoft Excel, BASIC, Comma or Tab-separated Text, DBASE III and IV, DIF, HTML, Lotus 1-2-3, Merge Files, SYLK, XML Universal Application
- Rocket-fast: FileMaker Pro runs up to 91% faster on your Intel-based Mac than on your PowerPC-based Mac. Import in a flash. Find things faster. Add, delete and edit data in record time. FileMaker Pro harnesses the horsepower of the new Intel Core Duo architecture, delivering the speed you want.
- Seamless sharing: FileMaker Pro is a Universal application, so youll get the best performance on both PowerPC-based Macs and Intel-based Macs. And sharing your database is easy. FileMaker Pro runs on Windows, PowerPC-based Macs, and the new Intel-based Macs. FileMaker Learning Center
- Learn FileMaker Pro with ease: Quickly tap into the richest features of the FileMaker product line. Whether you are a novice or an expert, the FileMaker Learning Center will help you get up and running quickly on numerous features of FileMaker Pro. It offers step-by-step video tutorials and other resources so that you can learn FileMaker Pro at your own pace. Resources At Your Fingertips
- View more than 30 new QuickTime video tutorials designed to get you up and running with FileMaker Pro as quickly as possible.
- Put into practice what you've watched by downloading the sample databases used to create the Quicktime videos.
- Discover new ways to deliver information from the Web to your database with the FileMaker Web Viewer Sample Database.
- Search the FileMaker Knowledge Base to get answers to all your questions and stay up-to-date with the latest product information.
- Learn how to get started in minutes using your own data, a ready-made solution or by creating your own database from scratch.
- Access documentation for your FileMaker products, including User Guides and Tutorials.
- Tap into the wealth of additional resources at your disposal, including books, newsgroups, and even subscribe to FileMaker News. Object Functions And Scripts
- Take control of your solutions: Start your users right where you want them to be. Lets say that you have assigned an object name to each of the tabs in a Tab Control. Then, you use the Go to Object script step so that the tab you specify will be the active and selected tab when the database is opened. What else could you use the new functions and scripts for? You could write a script that would Navigate to a specific portal instance, tab, or button , Position a new window precisely next to any object, Discover the exact position of an object on a layout
- Layout object names: Assign an object name to any kind of layout object, from tabs in a tab panel to portals to buttons.
- Go to Object script step: Identify the current active object and perform a specific action based on that information.
- Layout object calculations: Get information about objects on a layout including the object type, content, location, state and more.
- Set Web Viewer script step: Easily control what the FileMaker Web Viewer shows. Re-evaluate the URL calculation, go to a different URL that you specify, or navigate forwards and backwards.
- List Function: Make complex text processing calculations simpler by using the List function to easily grab all the values from a set of related records. FileMaker Quick Start Screen and enhanced Help. Its never been easier to connect directly to the information you need in FileMaker Pro with the FileMaker Quick Start Screen and enhanced built-in FileMaker Help. For those who are new to FileMaker Pro, youll have everything you need in one place to get you started on your first database. For those who have been using FileMaker Pro for years, youll love being able to open recent files or create a favorites list of the databases that you use most often.
- Faster from the start: The FileMaker Quick Start Screen is the first screen you see when launching FileMaker Pro 9. It provides a simple navigation to create a new database, open an existing database, or learn more about the product with the FileMaker Learning Center.
- Create Database: Build a FileMaker Pro database from scratch or choose from one of 30 Starter Solutions.
- Open Database: Browse files, open recent files or choose from your customized list of favorite files. Even add or delete files from your favorites list.
- Learn More: Learn FileMaker Pro at your own pace with the FileMaker Learning Center.
- Help when you need it: Now it is even easier to harness the power and flexibility of FileMaker Pro to build a solution that works for you. When you are working on a calculation, setting up a button, creating a new layout, or adding a FileMaker Web Viewer, just click on the new Learn more button in these dialogs for quick access to the relevant sections of the built-in FileMaker Help. Youll quickly be on your way to managing people, projects, assets and more the easy way! Conditional Formatting Stay on top of the details that matter the most. Conditional formatting is great for visually identifying when something is out-of-bounds or needs attention.
- At-a-glance knowledge: Are any payments overdue? What contracts are expiring next month? Are you on-time and under budget? Connect to changes in your data with Conditional Formatting. You set the way a field or object is displayed based on parameters that you decide. Choose the font, font style, font size, font color and fill color. Youll know who owes you money and what tasks are overdue because the font will change to bright red and bold (or whatever you want it to) when this occurs.
- Never miss a due date again: Lets say that you schedule shifts for a department where employees can only be scheduled to work if all of their certifications are current. A visual reminder of the status of a certification would be very helpful to you.
- Quick performance indicators: Many organizations use performance indicators to judge how well they are doing or to achieve desired outcomes. Choose from a list of 20 pre-defined conditions or create your own with a calculation. This makes it simple to monitor and troubleshoot when your performance indicators are outside of the thresholds that youve defined. For example, with Conditional Formatting you can set the date field so that:
- If date is more than 30 days away, the date appears green.
- If date is within the next 30 days, the date appears yellow.
- If date is today or has already occurred, the date appears red. Connect To External SQL Data Sources Create live connections to Microsoft® SQL Server, Oracle and MySQL with ease!
- Do-it-yourself SQL reporting: Have you ever wished that you could access information stored in MS SQL Server, Oracle and MySQL? Now you can! During a fast one-time setup, you add a SQL table or view to the FileMaker Relationship Graph and from that point on you have a live connection to the external SQL data source.1 Then, create custom reports and solutions using all your familiar FileMaker Pro tools.
- Create solutions that include SQL data: No longer do you need high-end programming skills to add SQL data to FileMaker Pro solutions. Now anyone can extend FileMaker Pro solutions to include information located in SQL systems all without needing to know any programming languages or how to write SQL queries. You can create new information by adding supplemental calculation and summary fields to the SQL table in FileMaker. Run finds, sorts, and exports on the table. Even use the values in scripts. It's easy because it is FileMaker Pro. FileMaker Pro gives you the tools you need to do all sorts of useful things with data from an external SQL data source, multiple external SQL data sources, or FileMaker Pro and external SQL data source(s). Use SQL information to create name badges or shipping labels. Track requisitions and purchase orders. Develop a visual catalog of inventory and assets. Everything that FileMaker Pro can do now you can do with data from SQL.
- Enable knowledge workers to use SQL data - safely: If you are an administrator for a SQL database, you know the constant demand for ad-hoc data pulls and custom solutions. Simply provide the knowledge workers in your organization with access to your SQL views or tables. FileMaker Pro utilizes standard system-level DSNs and you decide what level of access to provide (read only or read/write). Then theyll be off reporting and creating solutions to their hearts content and youll be free to work on other projects. Or use FileMaker Pro yourself and enjoy a dream environment for Rapid Application Development and deployment.
- Based on future-proof open ODBC standards: FileMaker Pros External Data Source feature was built with future expansion in mind. The initial release is certified to work with the following popular SQL databases:
- MS SQL Server 2000
- MS SQL Server 2005
- Oracle 9g
- Oracle 10g
- MySQL 5.0 Community Edition (free) The External Data Source feature also allows you to connect to remote FileMaker Pro databases, creating a one source tool for bringing all your critical data together. Script Grouping And Editing Tools Locate the scripts you need, when you need them. Create new scripts in a flash with multiple script editing windows.
- Get organized: Tracking down the script you need is virtually trouble-free with new Script Organization features. Group related scripts for faster access. You can put all Report scripts in one group and all navigation scripts in another group. Categorize scripts in whatever way makes sense to you. If you have a lot of scripts, you can collapse and expand groups to make the list more manageable.
- Instant discovery: Find the scripts you need in the blink of an eye, even if you dont know which group to look in. Just type as much of the script name as you know in the search box and FileMaker Pro will show you the list of scripts that match.
- Super script editing: Get more out of scripts you have, and create new scripts faster. Quickly create new scripts by duplicating similar ones youve already created. With multiple script editing windows, you can view existing scripts while you develop a new script. In addition, now multiple users can login to the same solution and edit scripts at the same time. Enhanced Layout Objects Connect to your creative side with more tools to make your layouts, including those with a Tab Control or FileMaker Web Viewer, even better than before.
- Precision tuning: The Tab Control is a great way to logically organize information. Now you can set the tabs to the width you want. For example, you may have a small label but want the tab containing the label to be larger, possibly because it looks better or because you want a larger area to click on. Or you may be putting images on the tabs so you want the tabs to be big enough to fit the image. Now you can specify the size of the tab. Also, you can designate which tab is the default front tab.
- Up-to-date information: When a web page is loading in your browser, you can glance at the status bar to monitor progress. Now, you can add the same status bar to the FileMaker Web Viewer. Also, you can dynamically display web pages in the FileMaker Web Viewer that are driven by HTML stored in a field in your database. What's Included With FileMaker Pro 9
- Product CD
- User's Guide
- Installation and New Features Guide
- Customer support information
- A license key for installation. System Requirements Mac OS X 10.4.8 ****
- PowerPC G3, G4, G5 or Intel-based Mac
- 256 MB of RAM
- CD-ROM drive System Requirements Windows XP Professional, Home Edition (Service Pack 2) ****
- Pentium III 500MHz or higher
- 256MB of RAM
- CD-ROM drive
- SVGA (800 x 600) or higher resolution video adapter and display System Requirements Windows Vista Ultimate, Business, Home ****
- 800 MHz 32-bit (x86) or higher
- 512 MB of RAM
- SVGA (800x600) or higher resolution video adapter and display
- CD-ROM drive Additional Requirements (all platforms)
- Networking: TCP/IP: limited to nine simultaneous FileMaker client connections; each client requires a licensed copy of the software; See FileMaker Server 9 for increased capacity.
- Any computer accessing FileMaker Pro files over a network will need to have a licensed installation of versions 7, 8 or 9 of FileMaker Pro or FileMaker Pro Advanced.
- Instant Web Publishing: A host computer with continuous access to the Internet or intranet via TCP/IP (FileMaker Pro 9 can manage up to five simultaneous Instant Web Publishing sessions. See FileMaker Server 9 Advanced for increased capacity.)
- Web browser requirements: To use a database shared with Instant Web Publishing, Windows web users need Microsoft Internet Explorer version 6.x or Firefox 1.x on Windows. On the Mac OS, web users need Safari 1.2.x (Mac OS X 10.3), Safari 2.0.x (Mac OS X 10.4) or Firefox 1.x only. On both platforms, some earlier versions of Microsoft Internet Explorer and Safari are blocked. Other Mozilla family browsers are not blocked but are unsupported and users will receive a dialog encouraging them to upgrade to a supported browser. JavaScript must be enabled in the web browser. Compatibility
- FileMaker Pro 9 databases use the same file format (.fp7) as FileMaker Pro 8 and FileMaker Pro 7, therefore databases can easily be shared between these three versions. Features specific to the newer versions, are only supported in the newer versions (e.g. The new External SQL Data Source feature, introduced with FileMaker Pro 9, is only supported by FileMaker Pro 9. ) Language
- English Key Features
- Suits: Windows PC & Mac
- Warranty: 12 Month Limited Important Notes
- Product Activation is required for use of this product. Activation may be completed by Internet or telephone.
- * For qualifying customers. See Buying FAQ for more information.
- ** Supports Safari Web Browser for Mac, Internet Explorer on Windows, and Firefox on several platforms. See tech specs for details.
- *** If you have more than 5 users, please learn more about FileMaker Server products that increase the performance and security of shared databases.
- **** Version state is the minimum requirement. The software may also work with later versions certified by FileMaker, Inc.
|