FileMaker® Pro 11 Advanced comes with brand new features to help you create eye- catching reports, boost your productivity, and build better databases. FileMaker Pro is a cross-platform relational database application from Claris International, . FileMaker 11, released on March 9, , introduced charting, which was further streamlined in FileMaker 12, released April 4, That version Stable release: 18 / May 22, ; 5 months ago. Jul 11, - VERY, DISAPPOINTED IN BOTH SONY AND AMAZON!, All I got was the console to create music in. The FileMaker Pro 11 Advanced library is.
The following two notification emails were sent out: I checked in with my client, and he reported that users were still able to use the system.
Since it was Sunday, we agreed that I would work on addressing the issue the next day towards the end of the work shift. At this point, FileMaker Server sent out another notification email: Options to recover from damaged database At this point, I had two options: Recover the file and continue using it — not recommended!
Revert to a last known good backup Many FileMaker administrators choose the first option, because it is the quickest way to get up-and-running. However, it is NOT the recommended option. There is no guarantee that recovering a file will remove the underlying database corruption. File recovery may even end up removing solution elements like layout objects or record data in an attempt to fix the file corruption.
The second option is best practice: This data and functionality loss can be overcome, but not easily. Functionality Loss To address functionality loss, you need to re-deploy all of the changes made since the backup file was created.
If you follow the practice of tracking your changes over time, this is possible but still may involve significant effort. Be sure to perform a manual backup after each release to help ensure that this is the case. Data Loss Until now, in order to address data loss, you would have to import all records for all tables into a clone of the backup to which you are reverting. Even if you already had a script in place that did this, running the script could take a long time.
For a solution the size of several gigabytes, a script like this could run for several hours. However, with the release of the Data Migration Tool, this data import process becomes much easier and much, much faster. I decided to revert to the last known good backup and then try restoring the data using the new Data Migration Tool. This involves specifying a source file and a target file. In my case, the source file was my damaged file, and the target was a clone of the backup file.
I had previously configured hourly, daily, and weekly backup schedules for my client. The daily and weekly schedules are both set up to create clones of the solution, so I had plenty of clones to choose from.
I selected the clone from the weekly March 11, , backup schedule. I got this error: File cannot be opened as read only in its current state. It seemed like it should have worked, so I tried again. However, before doing so, I opened the recovered file and closed it. I then re-ran the Data Migration Tool the same way once again, and this time it worked. No errors were reported in the log. I compacted the DMT-recovered file and copied it to the live folder.
It opened without errors. I also ran an ad hoc verify schedule that I already had in place from before, and it did not report any errors. At this point, I considered the file to be fully recovered, and I notified our client that the system was back online. As a point of reference, the damaged source file was 1. Running recovery on the file took less than three minutes, and it took the Data Migration Tool just 66 seconds to migrate the data.
Remote Containers Note that externally-stored containers do not get migrated over with the Data Migration Tool; they need to be copied over manually. In my case, I just left them in the original live folder as-is. The Data Migration Tool can help recover from a damaged file, but can it also be used to remove more benign cases of database corruption? For example, can I use it when fields display question marks instead of actual values?
I tried out the tool for another one of our clients who reported the following symptoms: When I took the file offline and opened it locally, the fields for these corrupt records displayed question marks instead of blanks. These symptoms could be describing corrupt record data or corrupt field indexes. I was curious to see if the Data Migration Tool would recognize and fix the corrupt records or indexes. I did not recover the file prior to running DMT.
So, what should you do in this case? Here are some other methods you can try: FALSE Some think that FileMaker is so simple that they would never need to hire someone else to build something they could do themselves. Developers who are experts with FileMaker often have numerous years of experience that can help you build and deploy your solution faster and mitigate many challenges before they arise.
Additionally, expert developers will be able to help with your systems analysis and workflow discovery. This saves you money in the long run. To ensure you are truly hiring a FileMaker expert; FileMaker has a certified developer program in which they vet potential members and have benchmarks that developers must reach to maintain their certified status.
Since version 7, FileMaker allows multiple users to contribute to the same project from different locations. Cross-platform relational databases allow for teams to construct and build databases in an ever-interconnected workflow. A few examples include: FileMaker Pro allows users to manage and share important information with their teams. It allows you to share data and materials, using iPads, iPhones, Windows or Macs, through a network with up to five other users.
FileMaker Go 13 allows iPhone and iPad users to receive up-to-the-minute information through the FileMaker Server using mobile communication. FileMaker Server 13 allows FileMaker Pro users to instantaneously share information with their team; there is not even a restriction on the number of networked clients you can have.
FileMaker WebDirect available in FileMaker Server 13 allows you to run and share your solutions directly on a web browser. FALSE To ensure everything has a proper backup and none of your data is lost, the built-in backup scheduling feature in the FileMaker Server must be used.
It is the only way to properly backup data and ensure everything is saved correctly. Technically True While this is technically possible and this technique may have been used in the past peer-to-peer sharing , it is in your best interest to not share peer-to-peer FileMaker databases. The risk of losing data is so much higher in peer-to-peer sharing.
You can get creative and make your own theme or modify existing themes.
What's New New user interface for importing data More easily map imported source data to FileMaker fields using the new Import Field Mapping dialog box. Open specific app at launch Provide better app discoverability for your users.
Open a specific custom app when opening FileMaker Pro Advanced. Use the XML file to more easily compare changes between file versions. File-based script steps Create scripts that read, write, and manage external data files to write log files or export data in a custom format. Script Error Logging More easily debug your workflow automation.
Use a preview script step to write information about script errors to a log file. While calculation function Repeats logic while the condition is true, then returns the result; replacing the need for some recursive custom functions. SetRecursion calculation function Sets the maximum number of iterations for recursion and loops within an expression.
The default limit is 50, iterations, which can be lowered or raised using this function. New managed security access New privilege allows developers to offload account access management to other team members without needing to provide full access to any other parts of the file.
New Manage Security dialog box The streamlined Manage Security dialog box makes managing access to your custom apps more efficient. Notifications warn users before loading an unsigned plug-in. Default file access protection Prevent other FileMaker files from accessing the data and schema in your custom app. The "Require full access privileges to use references to this file" is now enabled by default in newly created files.
Features Start quickly Create precisely the app you want using the intuitive graphical interface, flexible design tools, built-in Starter apps, and ready-to-use themes. Import existing data Bring your existing data into a FileMaker app. Import data types such as. Built-in reporting tools Easily make summary reports, colorful charts, and executive dashboards using built-in reporting and charting tools.
Save your information in popular Excel and PDF formats. Out-of-the-box security Centralize your information and safely access data using proven encryption standards. Manage group or individual user privileges — even for a single field. Share with your team Create custom apps that work together seamlessly across iPad, iPhone, Windows, Mac, and the web.
Turn off Script Triggers when debugging to fine tune the troubleshooting process. Data Viewer Monitor fields, variables, and calculations while troubleshooting. Custom Menus Create, change, or delete specific menu items or entire menu sets.
Custom Functions Build your own functions and copy, paste, or import them into any FileMaker file. Database Design Report Run comprehensive reports on all elements of your database schema. Kiosk mode.