The FileMaker development environment is today one of the leaders among DBMSs for small and medium-sized workgroups, allowing you to quickly develop ready-made solutions that are fully tailored to the needs of the customer's enterprise. FileMaker's powerful capabilities, teamwork mode, support for a large number of target platforms, and a graphical interface ideal for rapid development - all this makes FileMaker indispensable for solving problems related to data collection and people management, Internet projects and management of heterogeneous information. FileMaker's ready-to-use built-in templates help you quickly create your own solution and get it up and running. With its ability to share data with virtually any application, FileMaker blurs the boundaries of heterogeneous networks by providing simple solutions for any complex problem.

Recently, the DBMS market has traditionally been dominated by market giants, primarily Oracle Database, Microsoft SQL Server, etc. If we consider the market for such open solutions with its diversity, then here, again, DBMSs are presented primarily for professional developers - MySQL, PostgreSQL, etc.

It is obvious that when using such serious and powerful tools, the development and maintenance of databases itself becomes the domain of only experienced professional developers. On the one hand, this niche is extremely saturated with a range of various very flexible and powerful solutions, but on the other hand, it must be admitted that the cost of development for such platforms will cost quite a lot of money, also requiring time and a certain amount of experience, even at the stage of correct formulation technical specifications by the customer himself, not to mention the time required to create and deploy such solutions. If, during the operation of a ready-made solution, it turns out, as often happens in life, that the product requires some refinement and further adaptation, then again, it is unlikely that you will be able to do this on your own, which means that you will again have to attract outside specialists.

Ready-made solutions are not always as flexible as required; life has repeatedly proven that it is always better and more reliable to create a personalized solution, as they say, “completely for yourself,” but here we are faced with the problem of the complexity and duration of such development.

If you just think and dream for a second: oh, if such databases could be created entirely on your own, if you didn’t need to be a specialist in several related technical fields at once, if it were just as easy to not only create programs from scratch, but also to correct, expand and refine... And if for large and partly medium-sized businesses, expensive specialized solutions based on serious and expensive DBMSs are still somehow justified and economically feasible, then for small businesses, of which the majority are represented, or for home needs, even - using Oracle or even free MySQL is perhaps redundant and even more so – absurd.

Such a long introduction to the topic is intended for only one purpose: the DBMS market for small businesses and home use is extremely in demand and it is practically not represented in the domestic space. If you need to quickly develop a specialized warehouse accounting system for a specific specificity, or just a personal business or financial planning system built on some new-fangled time management concept that you like, where to look for help in this case? What tools are best to use for this - perhaps the popular MySQL in conjunction with some kind of visual front-end written in the equally popular Visual Studio? What quick and easy development options could you suggest for this situation, suitable for any non-technical professional as well as an accountant or first-year student?

And today we have good news: our review will be devoted to a detailed examination of a DBMS of exactly this class, extremely well-known and popular in the West, but not yet very widespread in Russia - FileMaker. Since it has become typical to compare FileMaker with its niche analogs - Microsoft Access and FoxPro - for the sake of decency, we will also repeat this hackneyed analogy, but for the sake of completeness and fairness, we will immediately present their main differences, due to which this comparison, in our opinion , very tense.

Another MS Access?

A very pronounced specificity of the FileMaker DBMS is that it is aimed not so much at the programmer, but at the end user, the non-professional in the field of databases. Even in descriptions of their product, developers stubbornly avoid using the cumbersome term DBMS (database management system), although it is given in the product specification, replacing it everywhere with database application.

The fundamental difference is the method of visual design, which is chosen in these two similar, but not analogous systems. In FileMaker, this approach is different and, in my opinion, much more successful and large-scale. Correctly chosen design strategies (for example, the presence of a very intelligently selected set of ready-made templates for all typical tasks that can always be taken as a basis) further simplify the quick start of your new project based on this development system. For example, here you can program in the built-in visual language FileMaker Script, even without any understanding of the basics of programming, or start immediately designing your database by simply dragging and dropping an Excel file onto an empty project form.

If in MS Access or FoxPro working on a project is an insider's view, and you need to have a clear understanding of how the database functions, then FileMaker is more of an outsider's view. FileMaker encourages you to focus on creating the external view of the database, that is, the interface. FileMaker almost completely takes care of the rest. If you don't even want to develop an interface, you are immediately provided with a standard one, and you have access to powerful data display and search tools to start working with the database immediately. On the other hand, if you wish, you can delve into the essence of the processes and fill your project with additional functionality, independently determine the levels of complexity of interaction with the DBMS that are acceptable to you.

We will return to the numerous successful details of the implementation of FileMaker later, but here we would like to put an end to this stereotypical comparison: in our opinion, FileMaker is a much more accessible and user-friendly system than MS Access, while all its capabilities are in no way are not inferior to MS Access, and in many ways, and we will show this later, they are significantly superior to it.

As for FoxPro, it’s still a system for programmers, no matter how you look at it. Of course, when getting acquainted with FileMaker, it will not hurt you to have programming experience in “serious” languages ​​- this will allow you to “get into” the system and its capabilities literally on the go, in a maximum of 24 hours, immediately starting to work. But, putting the task on the contrary, it will be very difficult for a humanities specialist to quickly and immediately understand FoxPro, you will agree, and there is no need to do this at all! As we will convincingly prove today, there is a much simpler, and please note, much more powerful development system in comparison with MS Access and FoxPro - the FileMaker DBMS.

Definition and target niche

FileMaker Pro is a cross-platform desktop designer of spreadsheet and other information applications built on the basis of its own relational database. Together with the actual engine of this database, as mentioned above, a powerful visual designer is supplied in a single package, with a developed and intuitive GUI interface, which allows you to create any applications in a visual mode: with your own logic, appearance, forms and tables. In addition to storing, operating and processing user data, this environment provides many additional functions and capabilities (which will be discussed in more detail below), which largely depend on the edition of this product (see the second part of this article). In short, if there are RAD (Rapid application development) development environments, then this is a kind of “SuperRAD”, which allows you to create completely similar applications, but 10 times faster and easier!

So, having given a very dry and somewhat official definition, let us summarize for the average person with the promised benefit: having mastered FileMaker, you can easily and quickly create your own projects based on databases, the use of which is practically unlimited. You can very quickly, literally “on your knees,” create, for example, a large catalog of your home library or films, catalog your huge music collection, develop your own system for accounting for goods in an enterprise or accounting for consumables and office equipment, a system for processing orders in your company or personalized printing systems. After spending literally a minute, expose your database to the Internet in the form of an automatically generated PHP website. And many many others...

Maybe someone will object to my bold comparison of FileMaker with real RAD systems, calling it incorrect and appealing to the quality of the final code that a similar application, traditionally developed, for example, in Visual Studio, will have, as incomparably better and more meaningful. But in response, I believe that today this is not the most convincing argument against “desktop frameworks” (and FileMaker, in some way, is one), since today man-hours cost much more than the hardware that needs to be upgraded once for such decisions so that “everything can fly” on it. With this final remark, I tried to respond in absentia to some obvious ideological attacks towards FileMaker that are taking place. And now, having finished with unnecessary rhetoric, let's move on directly to considering its capabilities.

Key Features of FileMaker

This is a multi-platform product - the following platforms are supported: Windows (XP, Vista, 7); MacOS X, iOS.
. Plugin architecture – there are many third-party plugins for connection that further expand the functionality of the main system. . Multilingual support - the system has been translated into more than 12 languages, including Russian.
. Ability to automatically generate advanced and attractive graphs, reports and histograms.
. Support for your own FDML markup language for generating web pages with the ability to dynamically insert from the FileMaker database.
. And if we're talking about websites, the server version of FileMaker has the ability to quickly generate a PHP website automatically - from the structure and content of an existing database.
. Ability to encrypt all used tables and data structures.
. A huge number of formats for importing data into the database: Excel, Lotus 1-2-3, txt, cvs, dbf, etc.; as well as an abundance of formats for the reverse operation - export.
. A close-to-visual script editor that makes programming very easy to understand (if you need it at all).

There is a built-in script debugger that allows you to solve all complex situations. In general, I want to immediately express my subjective opinion that FileMaker has its own scripting language, and will probably be inconvenient for experienced programmers, and is rather more suitable for beginners and advanced users (which can be considered both a plus and a minus of this system ). . FileMaker supports multi-user work with the database, within reasonable limits, of course (you don’t need to count on simultaneous access to the database by a crowd of 400 people). But, in defense of the internal data storage, I would like to say that in the latest versions it has been significantly expanded and supplemented, and now it can quite freely operate with fairly large volumes of data (again, within reasonable limits - within small and medium-sized businesses, it will never will become a direct competitor in this regard for Oracle or PostgreSQL).

External interaction

Often when using such products, the first question that arises is: “How can I connect them with some of my external solutions?” Well, this question is natural. And if I don’t even question the internal capabilities for quick design and extremely convenient creation of applications on FileMaker (because it is so - just try), then the issue of researching FileMaker regarding its capabilities for interaction with other external products requires additional coverage, due to the special importance of this parameter when creating modern and flexible heterogeneous systems.

The first thing to highlight in this area is that FileMaker very widely supports and actively uses the universal XML standard for exchanging a wide variety of information with external applications. In particular, it supports:

XML Data Source Import – import of external data into the DBMS in XML format;
. Export Records and Export Records script step – types of exporting your data in XML format;
. Custom Web Publishing with XML is a mechanism for sending XML data in response to an Internet request for it from an external service.

In addition to XML support for exchanging data with external sources, full ODBC/JDBC support is also available, which further enhances FileMaker's capabilities.

And finally, the most interesting thing from the point of view of an application programmer is the SQL language.

As I wrote above, FileMaker uses its own quasi-visual tools for creating selections, but besides this, there is almost full support for features and SQL, so let's list the main points in this matter as briefly as possible:

External SQL Data Source – a standard tool for creating a “live” two-way connection between FileMaker and the world's leading DBMS (Oracle, MS SQL Server, MySQL);

ODBC/JDBC - alternative way connections if you do not need a constant “live” connection to external data sources. This approach has both a plus and a minus: the plus is the much greater versatility and breadth of available data sources; in fact, you just need to find and install a standard ODBC driver for your database on a system with FileMaker. Minus – slightly slower interaction speed; . Execute SQL – the availability of dynamic SQL queries at the level of the FileMaker scripting language through this command, which creates a kind of additional dimension for the successful, and I would even say, sophisticated use of SQL within the FileMaker ecosystem;

MySQL partnership – I especially want to highlight the support as an external data source for the popular free database server MySQL data. It should be noted that the level of integration with this source in the External SQL Data Source mode is extremely high quality. The manufacturer FileMaker itself describes many successful examples of large implementations, where the use of such a symbiosis of these two DBMSs was placed at the forefront of the entire information infrastructure. The official partnership between FileMaker, Inc and MySQL AB further strengthens these ties, not only at the technical level, but also at the legal level of support.

Well, in conclusion, in the current topic of “External interaction” it is once again worth recalling the built-in smtp solution, which makes email permanently integrated into common system, which again adds convenience to development, especially for corporate purposes, which, along with flexible export from XML sources, allows such an application to constantly stay “in touch”.

In the second part of this article we will describe the Internet capabilities of FileMaker, its numerous editions, and along the way we will discuss many of its other pleasant features.

To be continued.

Igor Savchuk

For small and medium enterprises who want to choose between the best system database management, I will provide a comparison between Filemaker Pro and Microsoft Access.

Do you know that?
Filemaker Pro was going to be part of Microsoft Office, but was purchased by Apple as part of their word processing suite.

Databases are used to store data that is synchronized with the server for quick access. They serve as an online inventory, software companies and the protection of its intellectual property, and to protect user privacy. Database management has evolved from a single server to a server-based database system that serves multiple users, and finally a web-integrated database allows data to be updated and deleted from virtually anywhere. So, the question arises: what features should you look for when choosing such a system? The two most popular systems Database management systems currently include FileMaker Pro and Microsoft Access.

FileMakerPro vsMicrosoftAccess

Filemaker is a database management software that started out as an MS-DOS program but now runs successfully on the Mac platform. It has a graphical interface with move and delete options for easy data management. It is available on various platforms and the latest version has additional themes and templates for creating iOS databases. It can connect to SQL databases such as SQL Server and Oracle when installing the (Open Database Connectivity ODBC) driver. Today this program has undergone significant updates and now has an application that allows you to manage your data. One of the features is an improved "Popover" button that appears when the user touches or clicks the mouse. FileMaker Pro takes up only 26 MB of disk space, has a storage capacity of up to 8 TB of data per file, and 3 different versions for you to choose from, namely FileMaker Pro, FileMaker Pro Advanced, and FileMaker WebDirect for database access from web browsers.

MicrosoftAccess was available as part of the Microsoft Office suite, in combination with other programs such as Excel, Word, PowerPoint, etc. It works well as a client application, providing support for databases such as Oracle, Sybase, etc. The application size is 160MB disk. Access allows you to store 1 TB of data on the SharePoint server, but only 2 GB of storage in a single file.

Operating platform

Filemaker is a cross-platform database system compatible with Windows, OS X, and iOS.

MicrosoftAccess, works only on Windows and is better adapted to Microsoft Office.

Database Potential

Filemaker Pro has objects such as layouts, resume layouts, scripts and plugins for building a base. It uses scripts and third party plugins to access the database.

You can include a number of objects in Microsoft Access, such as tables, queries, forms, reports, data access pages, macros, and modules. Access uses Visual Basic for Applications (VBA) as its development language, which is a subset of Visual Basic.

Number of users

Access can support 255 concurrent users.

Filemaker Server, combined with filemaker Pro, can support 250 users simultaneously.

Number of modes

Filemaker Pro has 3 modes: Design mode (for editing the layout design), Search mode (for searching records) and View mode (for displaying records).

Access has automated safe mode To detect any problems within a file, user-initiated safe mode allows files to run even if they are damaged.

Safety

Filemaker Pro has 256-bit AES encryption to protect data on your desktop or server used to protect sensitive information.

In Access, files can be accessed by transferring them to a Microsoft SQL server. This provides additional protection by providing security to workgroups that require a username and password that can be used to determine a specific person's rights (read or read-write).

Price

For a single user, filemaker Pro costs $9.00 per month on an annual basis. For a single user of FileMaker Pro Advanced, $15.00 per month is charged, also on an annual basis. To manage the server database, you can use the services of FileMaker WebDirect, which exists based on its users. It costs $54.00 per month for 5 users, and $279.00 per month for 50 users. It is distributed differently for volume licenses, which can be installed on more than one computer.

Microsoft Access users can enjoy all the benefits of this software and the rest of the Office suite for $6.99 per month, or $69.99 for the entire year. For a family, you can order it for $9.99 per month or $99.99 per year. For business users, it will cost $5.00 for Office 365 Business Essentials, $8.25 for Office 365 Business, and $12.50 for Office 365 Business Premium, according to different versions.

Looking at the advantages and disadvantages of Filemaker Pro and Microsoft Access, we can summarize that users who have paid for a license do not have access to the FileMaker server for free. To run the app on your iPad or iPhone, you can download it in FileMaker Go, which is free to download from the Apple store. is ideal for people who use MS Office and its applications, while filemaker can be used even by people who are new to database programming thanks to its Drag-and-Drop interface technology.

This article opens a series of articles by Igor Shichko about the FileMaker system

1. General information about the DBMS "FileMaker»

The FileMaker database management system was developed by a company of the same name “FileMaker”, which in turn is a subsidiary of the well-known Apple company. At the time of publication of this article (August 2015), the 14th version of this DBMS was released.

Let's consider the main features of the FileMaker DBMS, taking into account existing ideas about databases in general.

First of all, it should be noted that this DBMS is multi-system, i.e. can be installed on both computers with installed Windows(IBM PC) and on a PC with installed Mac OS X (Apple computers).

The first feature of this system are valid database field types. There are very few of them, unlike other systems:

— Number– for number format data

— Text– for text format data

— Date– for fields containing date

— Time– for fields containing time

— Timestamp- a very convenient type of field that contains a time stamp (date and time)

— Container– a container type field that can store a fairly wide range of data (files of various types, images, videos, etc.).

Thus, the user does not have to think long about the structure of the database in terms of determining field types. If it is necessary to take into account numeric data, then, regardless of its format (integer, decimal, etc.), a field of type Number is used. Text data is also taken into account regardless of the length of the text. This field type (Text) supports message size up to 2 GB.

You should also pay attention to the remaining two field types:

— Calculation– calculated field, allows you to create a calculated database structure based on existing fields.

— Summary– summing field, calculates the sum of accounting data by columns (fields) of the database.

These two above field types (Calculation and Summary) are very convenient to use when creating various types of reports.

In addition, the FileMaker system allows you to use each field as a composite of several values, the so-called repeating field, which is of no small importance when developing reports and displaying their results.

The second feature What I would like to focus on is the development of forms for displaying credentials.

The system developers have simplified the interface design algorithm as much as possible to present data in a user-friendly form. Placing a field on the form takes literally two button clicks (Select operation + Select field). In addition, all formatting options for the information displayed on the screen (location, fonts, fills, etc.) are available in the same view.

The database developer interface in terms of designing the data layout includes four types of information presentation:

— Browse– viewing information on the PC screen

— Find– enable information search mode

— Layout– enable form design mode

—Preview– preview of the form, i.e. how the document will appear when printed, depending on the page and printer settings.

Accordingly, switching between modes is done by pressing one button, and it is also available via software, which we will briefly discuss below.

The third feature FileMaker database management system that I would like to focus on is the output data formats.

It was already noted above that FileMaker is a program that is not critical to the installed operating system. Therefore, the format of the output data provides for its use on any of these systems. Those. one user can enter data using the operating Windows systems, and the same data can be exported and processed on a computer running Mac OS X.

Data output provides several formats. The most used and familiar to users are the *.pdf (Adobe Acrobat Reader) and *.xls (Excel) formats. Data stored in container-type fields can be exported to the corresponding file (image, video, file).

Layout PDF document is developed directly in the database structure, respectively, its preview is available.

And finally fourth feature of the FileMaker DBMS.

It is logical to include the wide possibilities and reasonable simplicity of developing program code for the database. Almost any procedure for sampling, exporting data, generating reports, provided for in the system menu, is available for automation.

The basis of program code development is writing scripts (scenarios, a certain sequence of actions performed). The script is based on the use of a wide range of predefined functions and calculated fields. Scripts can be created by a developer who is more or less familiar with the basics of algorithmization and school-level English.

In addition, FileMaker provides the opportunity for the developer to design some of his own functions, as well as use external libraries (plugins).

All features of the FileMaker database management system are not limited to those mentioned in this article. In the future, as we talk about the components of the DBMS and the methodology for working with them, we will dwell in more detail on these and many other features of this software that distinguish it from others, perhaps more widely used in Russia.

1. Creating a base, first steps, features of setting up access and developing a structure.

2.1. Creating a new database.

Creating a new database is possible in two main ways.

— To create a new database, select the menu item File – New Database…(in FileMaker 14 the menu item is named File – New Solution…) A form opens, indicating the name of the database to be created and its location. Select the drive, enter the name of the database to be created and click on the button "Save". A table with the name Table.

— The second way to create a database is based on the templates supplied with the software package. Select an item File– New From Starter Solution… In the window that opens, select the type of database template, based on it a new file bases. Depending on the version, the number of templates may vary (from 15 to 30).

This completes the first step of the FileMaker database creation procedure.

1. Creating a database structure.

To create and describe the database structure of the system, a menu item is provided File – Manage – Database… When you select this item, a window with three tabs opens. Let's briefly look at their description.

A) TabTables(Tables). This tab contains information about the tables contained in this database. The developer can perform the following actions:

- create a new table. To do this, enter the name of the table in the Table Name field and click the Create button. Another way to create a database table is by importing tables from external files. To do this, use the menu File – Import Records – File... FileMaker allows you to import from files of other FileMaker databases, Excel files, files with delimiters (such as *.csv or *.tab).

— change the table name. Select the table, enter a new name in the Table Name field, and click the Change button

— delete table. Having selected the table, click on the Delete button

- copy table. Select the table and click the Copy button. This will copy the table structure to the PC clipboard. If you then click on the Paste button, a table named Table 2 will be inserted (if the original one was Table).

- import table. To do this, click on the Import button. In the window that opens, select the file external base data and table in this file.

B) TabFields(Fields). This tab displays the structure of the fields of the selected table current base data. I won’t dwell on the capabilities of this tab. They are similar to the capabilities of the Tables tab. These are the create, modify, copy, paste and delete functions. Only the function has been added Duplicate(Duplicate). This function combines the copy and paste functions into one.

B) TabRelationships. This tab displays the structure of the entire database in graphical format. At the bottom of this tab there is a menu for managing the database structure. Let's look at the main functions available from this interface. They are divided into three categories:

— Add table– adding a table to the database structure

— Establishing a new connection– allows you to organize a new connection between fields of different data tables

— Duplicate table– allows you to create a copy of the selected data table. It should be noted that not a physical copy of the table with data is created, but a logical one. In this case, the system requests a new table name in the structure. Those. physically there can be one table (Table), but logically there can be several (Table1, Table2, etc.). This structure is very convenient when creating various reports and calculating results for any parameter. As the system developers themselves note, building a report means building certain connections between images of data tables.

— Edit table– allows you to change the logical name of the table and the data source for it.

— Delete table– performs a logical (not physical) deletion of a table from the graphical interface.

— horizontal alignment– includes center, left and right alignment functions

— vertical alignment– includes center, bottom and top alignment functions

— distribution– includes horizontal and vertical distribution functions

— change of size– bringing all selected objects to one of six parameters (the smallest in width, in height, in width and height, the largest in width, in height, in width and height).

I note that the functions of this subgroup are used for two or more selected objects and are aimed at creating a readable appearance of a graphical image of the database structure.

— table color– allows you to change the color of the selected table(s) to visually highlight groups of tables in the graphical interface.

— power button graphics mode/ text mode enable button– two buttons designed to work with graphic and text elements. FileMaker provides the ability to include table descriptions in the GUI. To create an inscription, there is a button to switch to text mode.

— Increase/Decrease/Normal buttons– three buttons for controlling the interface display scale.

— scale display window (in percent)

— button to display pagination

— print settings button

Thus, using the three tabs described above, the structure of database tables is created and configured, fields are created and described.

1. Setting up database access

The FileMaker database management system provides a fairly wide range of customization options for restricting access to data.

To configure data access restrictions, use the menu File – Manage – Security. This opens a window with four tabs. Let us briefly describe their purpose.

Tab Accounts– designed to add and edit the list of database users. This panel contains the New, Edit, Duplicate, Delete buttons. They are respectively intended for creating a new user, editing the access parameters of a selected user, duplicating a user (with all access parameters), and deleting a user.

Tab Privilege Sets– designed to add and edit types of privileges. By default, three types of privileges are configured in the database:

— Full Access- full access

— Data Entry Only– reading, writing, deleting all records without the ability to develop a data structure

— Read— Only Access– read-only access to data.

Creating a new type of privilege.

The database administrator can also add his own privilege type. To do this, click on the New button. A window will open Edit Plivilege Set.

In field Privilege Set Name specify the name of the privilege type to be created. In a group of fields with a common name Data Access and Design access to database records (Records field), views (Layouts field), lists of values ​​(Value Lists field), scripts (Scripts field) is configured. In each of these fields, you can fine-tune user access. For example, setting up access to individual fields of a database table, individual views, etc. This allows you to limit user access to data without disrupting system operation.

Note: it is necessary to understand that in the structure of the DBMSFileMakeraccess to data is carried out through views (Layouts). Thus, data from any table can be read (edited) only through the appropriate view.

Next on the access rights editing form there is a group of checkboxes under the name Extended Privileges(Extended Privileges). They are designed to organize access for this group of users to work via a WEB interface, via an ODBC connection, via network connection and so on.

And finally, on the right side of the form there is a group of checkboxes called Other Privileges(Other privileges). With their help, a developer can configure access for a group of users to print ( Allow printing), data export ( Allow exporting), setting up extended access rights ( Manage Extended Privileges), the mode of checking the entered data, the mode of disconnecting users from the database, the mode of changing the password.

General information about the DBMS " FileMaker »

FileMakerdeveloped by a company of the same name "FileMaker", which in turn is a subsidiary of a well-known companyApple. At the time of publication of this article (August 2015), the 14th version of this DBMS was published.

Let's consider the main features of the DBMSFileMakertaking into account existing ideas about databases in general.

First of all, it should be noted that this DBMS is multi-system, i.e. can be installed on both computers withWindows ( IBM PC), and on a PC with installedMac OS X(computersApple).

The first feature of this system are valid database field types.There are very few of them, unlike other systems:

— Number – for number format data

— Text – for text format data

— Date – for fields containing date

— Time – for fields containing time

— Timestamp - a very convenient type of field that contains a time stamp (date and time)

— Container – a container type field that can store a fairly wide range of data (files of various types, images, videos, etc.).

Thus, the user does not have to think long about the structure of the database in terms of determining field types. If it is necessary to take into account numeric data, then, regardless of their format (integer, decimal, etc.), a field likeNumber. Text data is also taken into account regardless of the length of the text. This field type (Text) Supports message volume up to 2 GB.

You should also pay attention to the remaining two types of fields:

— Calculation – calculated field, allows you to create a calculated database structure based on existing fields.

— Summary – summing field, calculates the sum of accounting data by columns (fields) of the database.

These two above field types (CalculationAndSummary) are very convenient to use when creating various types of reports.

In addition, the systemFileMakerallows you to use each field as a composite of several values, the so-calledrepeating field , which is of no small importance when developing reports and displaying their results.

The second feature What I would like to focus on is the development of forms for displaying credentials.

The system developers have simplified the interface design algorithm as much as possible to present data in a user-friendly form. Placing a field on the form takes literally two button clicks (Select operation + Select field). In addition, all formatting options for the information displayed on the screen (location, fonts, fills, etc.) are available in the same view.

The database developer interface in terms of designing the data layout includes four types of information presentation:

— Browse – viewing information on the PC screen

— Find – enable information search mode

— Layout – enable form design mode

— Preview – preview of the form, i.e. how the document will appear when printed, depending on the page and printer settings.

Accordingly, switching between modes is done by pressing one button, and it is also available via software, which we will briefly discuss below.

The third feature database management systemsFileMakerThe thing I would like to focus on is the output data formats.

It was already noted above thatFileMaker– a program that is not critical to the installed operating system. Therefore, the format of the output data provides for its use on any of these systems. Those. one user can enter data using operating system Windows, and the same data can be exported and processed on a computer withMac OS X.

Data output provides several formats. The most used and familiar to users are *.pdf( Adobe Acrobat Reader) And *.xls( Excel). Data stored in container-type fields can be exported to the corresponding file (image, video, file).

Document LayoutPDFis developed directly in the database structure, respectively, its preview is available.

AND , finally,fourth DBMS featureFileMaker.

It is logical to include the wide possibilities and reasonable simplicity of developing program code for the database. Almost any procedure for sampling, exporting data, generating reports, provided for in the system menu, is available for automation.

The basis of program code development is writing scripts (scenarios, a certain sequence of actions performed). The script is based on the use of a wide range of predefined functions and calculated fields. Scripts can be created by a developer who is more or less familiar with the basics of algorithmization and school-level English.

Besides,FileMakerprovides the opportunity for the developer to design some of his own functions, as well as use external libraries (plugins).

All features of a database management systemFileMakerare not limited to those specified in this article. In the future, as we talk about the components of the DBMS and the methodology for working with them, we will dwell in more detail on these and many other features of this software that distinguish it from others, perhaps more widely used in Russia.

2. Creating a base, first steps, features of setting up access and developing a structure.

2.1. Creating a new database.

Creating a new database is possible in two main ways.

— To create a new database, select the menu itemFile – New Database… ( V versionsFileMaker 14paragraph menu named File – New Solution…) A form opens, indicating the name of the database to be created and its location. Select the drive, enter the name of the database to be created and click on the button"Save" . A table with the nameTable .

— The second way to create a database is based on the templates supplied with the software package. Select an itemFile – New From Starter Solution … In the window that opens, select the type of database template, and a new database file is created based on it. Depending on the version, the number of templates may vary (from 15 to 30).

This is the first step of the database creation procedure.FileMakercompleted.

2. Creating a database structure.

To create and describe the database structure of the system, a menu item is providedFile – Manage – Database … When you select this item, a window with three tabs opens. Let's briefly look at their description.

A) Tab Tables (Tables). This tab contains information about the tables contained in this database. The developer can perform the following actions:

- create a new table . To do this in the fieldTable Nameenter the table name and click the buttonCreate. Another way to create a database table is by importing tables from external files. For this purpose the menu is usedFile – Import Records – File… FileMakerallows you to import from files of other databasesFileMaker, filesExcel, delimited files (type *.csvor *.tab).

— change the table name . Select the table in the fieldTable Nameenter a new name, click on the buttonChange

— delete table . Having selected the table, click on the buttonDelete

- copy table . Select the table and press the buttonCopy. This will copy the table structure to the PC clipboard. If you then press the buttonPaste, then a table with the name will be insertedTable2 (if the original wasTable).

- import table . To do this you need to click on the buttonImport. In the window that opens, select the external database file and the table in this file.

B) Tab Fields (Fields). This tab displays the structure of the fields of the selected table of the current database. I won’t dwell on the capabilities of this tab. These are similar to the tab optionsTables. These are the create, modify, copy, paste and delete functions. Only the function has been addedDuplicate (Duplicate). This function combines the copy and paste functions into one.

B) Tab Relationships . This tab displays the structure of the entire database in graphical format. At the bottom of this tab there is a menu for managing the database structure. Let's look at the main functions available from this interface. They are divided into three categories:

First category – Tables / Relationships :

— Add table – adding a table to the database structure

— Establishing a new connection – allows you to organize a new connection between fields of different data tables

— Duplicate table – allows you to create a copy of the selected data table. It should be noted that not a physical copy of the table with data is created, but a logical one. In this case, the system requests a new table name in the structure. Those. physically there can be one table (Table), and logically there can be several of them (Table1, Table2, etc.). This structure is very convenient when creating various reports and calculating results for any parameter. As the system developers themselves note, building a report means building certain connections between images of data tables.

— Edit table – allows you to change the logical name of the table and the data source for it.

— Delete table – performs a logical (not physical) deletion of a table from the graphical interface.

— horizontal alignment – includes center, left and right alignment functions

— vertical alignment – includes center, bottom and top alignment functions

— distribution – includes horizontal and vertical distribution functions

— change of size – bringing all selected objects to one of six parameters (the smallest in width, in height, in width and height, the largest in width, in height, in width and height).

I note that the functions of this subgroup are used for two or more selected objects and are aimed at creating a readable appearance of a graphical image of the database structure.

— table color – allows you to change the color of the selected table(s) to visually highlight groups of tables in the graphical interface.

— graphics mode button / text mode button – two buttons designed to work with graphic and text elements.FileMakerprovides the ability to include table descriptions in the graphical interface. To create an inscription, there is a button to switch to text mode.

— Increase/Decrease/Normal buttons – three buttons for controlling the interface display scale.

— scale display window (in percent)

— button to display pagination

— print settings button

We will leave the buttons of the fourth category without comment.

Thus, using the three tabs described above, the structure of database tables is created and configured, fields are created and described.

3. Setting up access to the database

Database management systemFileMakerprovides a fairly wide range of customization options for limiting access to data.

To configure data access restrictions, use the menuFile – Manage – Security . This opens a window with four tabs. Let us briefly describe their purpose.

TabAccounts – designed to add and edit the list of database users. This panel contains buttonsNew, Edit, Duplicate, Delete. They are respectively intended for creating a new user, editing the access parameters of a selected user, duplicating a user (with all access parameters), and deleting a user.

TabPrivilege Sets – designed to add and edit types of privileges. By default, three types of privileges are configured in the database:

— Full Access – full access

— Data Entry Only – reading, writing, deleting all records without the ability to develop a data structure

— Read — Only Access – read-only access to data.

Creating a new type of privilege.

The database administrator can also add his own privilege type. To do this you need to click on the buttonNew. A window will openEdit Plivilege Set .

In fieldPrivilege Set Name specify the name of the privilege type to be created. In a group of fields with a common nameData Access and Design access to database records is configured (fieldRecords), types (fieldLayouts), lists of values ​​(fieldValue Lists), scripts (fieldScripts). In each of these fields, you can fine-tune user access. For example, setting up access to individual fields of a database table, individual views, etc. This allows you to limit user access to data without disrupting system operation.

Note: it is necessary to understand that in the structure of the DBMS FileMaker data is accessed through layouts ( Layouts ). Thus, data from any table can be read (edited) only through the corresponding layout.

Next on the access rights editing form there is a group of checkboxes under the nameExtended Privileges (Extended Privileges). They are designed to organize access for this group of users to work throughWEB-interface, viaODBC-connection, via a network connection, etc.

And finally, on the right side of the form there is a group of checkboxes calledOther Privileges (Other privileges). With their help, a developer can configure access for a group of users to print (Allow printing ), data export (Allow exporting ), setting up extended access rights (Manage Extended Privileges ), the mode of checking the entered data, the mode of disconnecting users from the database, the mode of changing the password.

Size: px

Start showing from the page:

Transcript

1 FileMaker Installation and New Features Guide for FileMaker Pro 12 and FileMaker Pro 12 Advanced

2 FileMaker, Inc., All rights reserved. FileMaker, Inc. Patrick Henry Drive Santa Clara, California FileMaker and Bento are trademarks of FileMaker, Inc., registered in the United States and other countries. The file folder logo and the Bento logo are trademarks of FileMaker, Inc. All other trademarks are the property of their respective owners. FileMaker documentation is protected by copyright. You may not make additional copies of this documentation or distribute it without the written permission of FileMaker. This documentation may only be used with a valid, licensed copy of the FileMaker software. All persons, companies, email addresses and URLs listed in the examples are completely fictitious and any resemblance to existing persons, companies, email addresses and URLs is completely coincidental. A list of creditors is provided in the Acknowledgments documents supplied with this software. Mention of third party products and URLs is for informational purposes only and does not constitute an endorsement or recommendation. FileMaker, Inc. is not responsible for the performance of these products. For more information, visit our website Revision: 1

3 Contents Chapter 1 Before You Begin 5 About FileMaker Documentation 5 Customer Support and Knowledge Base 6 Technical Assistance 6 Update Notification 6 New Version Notification 7 About the License Key 7 Feature Requirements on Windows 9 Feature Requirements on Mac OS 10 Features not supported on Windows 10 Features not supported on Mac OS 10 Converting a trial version of FileMaker Pro to a full version 11 Upgrading FileMaker Pro from a previous version 11 Opening files from previous versions 12 Updating a custom dictionary 12 Installing with a volume license 12 Chapter 2 Installing FileMaker Pro on Windows 13 Installation Notes 13 Installing FileMaker Pro 14 Registering FileMaker Pro 15 Installing FileMaker Pro from command line 15 About installing the Bonjour service 15 Where files are located on your hard drive 16 Uninstalling, editing, or restoring FileMaker Pro 16 Changing the FileMaker Pro cache size 17 What to do next 18 Chapter 3 Installing FileMaker Pro in the operating room Mac system OS 19 Installation Notes 19 Installing FileMaker Pro 20 Registering FileMaker Pro 20 Viewing the Installation Log File 21 Uninstalling FileMaker Pro Setting the FileMaker Pro Cache Size 21 What to Do Next 22

4 4 Chapter 4 What's New 23 New Structure and Layout Controls 23 Improved Performance and Usability 24 Enhanced Reporting and Analysis Features 25 Integration with Other Applications and Data Sources 26 Script Steps, Script Triggers, and Functions 26 Script Steps 26 Script Triggers 27 Functions 28 Features changed and removed 29 Features changed in FileMaker Pro 29 Features removed from FileMaker Pro 30 FileMaker Pro 12 Advanced 31

5 Chapter 1 Before You Begin Welcome to FileMaker! FileMaker Pro makes information management easy and efficient. About FileMaker Documentation This Installation and New Features Guide will tell you how to install FileMaker Pro 12 or FileMaker Pro 12 Advanced on your Windows or Mac computer and introduce you to what's new in the software. Note. This guide uses the name "FileMaker Pro" to refer to both FileMaker Pro and FileMaker Pro Advanced unless it describes features unique to File Maker Pro Advanced. The FileMaker Pro User Guide contains the information you need to get started with productivity right away. If you're new to FileMaker Pro, check out the FileMaker Pro Tutorial to learn the basic features of the application. For details and complete step-by-step procedures, see FileMaker Pro Help. The Design Guide for FileMaker Pro Advanced describes the advanced features available in FileMaker Pro Advanced, including customizing menus, copying and importing tables, database design reports, and monitoring fields, variables, and expressions using the Data Viewer. Note. If a feature or procedure is limited to a specific platform, instructions and illustrations that also apply to that platform are displayed. For features and procedures that are similar on both platforms, illustrations are provided for either Windows or Mac OS. To view and download documentation for FileMaker, visit To provide feedback on this tutorial, visit

6 6 Before You Begin Customer Support and Knowledge Base Select the menu command Help > Resource Center to access the following components: ready-made solutions; videos and tutorials; user history; forums and other support tools. To access the FileMaker knowledge base, visit To view system requirements, visit Note. The FileMaker knowledge base and software forums are not available in all languages. Technical assistance Service representatives technical support FileMaker will help you install, run, or reinstall (except for data recovery) if the hardware configuration meets the minimum software system requirements. Visit Update Notification FileMaker Pro 12 automatically checks for software updates every seven days. If your computer is connected to the Internet, you can go to the updates web page and download the software update. You can update later by selecting Help > Downloads and Updates. Note. This feature does not install software. You must be connected to the Internet to access the updater and download it.

7 7 To turn off update notification, do one of the following: In the Update Notification dialog box, select the Don't check for updates automatically check box. On Windows, select Edit > Preferences. On Mac OS, select FileMaker Pro menu > Preferences. On the General tab, clear the Notify me when an update is available check box. To turn update notification back on, select this check box. If you disable update notification, the Update Notification dialog box will not appear. New Version Notification FileMaker Pro 12 automatically checks for new software versions every 30 days and notifies you when a new version becomes available. To turn off new version notification, do one of the following: In the New Version Notification dialog box, select the Do not notify me about new versions again check box. On Windows, select Edit > Preferences. On Mac OS, select FileMaker Pro menu > Preferences. On the General tab, clear the Notify me when a new version is available check box. To turn the new version notification back on, select this option. If you disable New Version Notification, the New Version Notification dialog box will not appear. About the License Key FileMaker software is distributed with a unique 35-character alphanumeric license key. Don't lose this key. It is recommended that you keep the license key in a safe place in case you ever need to reinstall the software. License keys are located on the back of the DVD sleeve. If you install software using an electronic download, follow the instructions in your order confirmation email. A valid license key is required to install the software.

8 8 Before You Begin The license key ensures compliance with the FileMaker Pro or FileMaker Pro Advanced software license, which permits one (1) copy of the software to be used on one computer at a time, along with a second copy for use on a home or laptop computer, subject to license restrictions. for software. For more information, see the FileMaker Pro or FileMaker Pro Advanced software license located in the appropriate installation folder. If there is another copy of the application running on the network that is installed with the same license key, FileMaker Pro displays the following error message: "Currently this copy FileMaker Pro uses the maximum number of licensed users." To install FileMaker Pro on multiple computers, you will need a unique license key for each installation or a multi-computer volume license. You must license one copy of FileMaker Pro on each computer.

9 9 Feature Requirements on Windows Some features of FileMaker Pro for Windows require the installation of additional software. Function Script step “Submit” email» using the email application Phone dialing ODBC and JDBC functions Inserting QuickTime video files and image files Software requirement Microsoft Outlook Express, Windows Mail, Windows Live Mail or Office Mail This requirement does not apply to SMTP mail. Telephone dialer or other application software interface compatible software telephone communication(TAPI) FileMaker ODBC and JDBC drivers are located in the xdbc folder of the image installation disk, and in the FileMaker Knowledge Base at For more information about using ODBC and JDBC functions, see the FileMaker ODBC and JDBC Guide and FileMaker Pro Help. For more information about using third-party ODBC and JDBC drivers, see QuickTime 7.5 Software (available at

10 10 Before You Begin Feature Requirements for Mac OS Some features of FileMaker Pro for Mac OS require the installation of additional software. Feature Send Message Script Step Using Mail Application ODBC and JDBC Features Software Requirement Apple Mail, Microsoft Entourage, or Microsoft Outlook 2011 This requirement does not apply to sending mail via SMTP. Actual Technologies ODBC Manager (available at is free software and is not supported by FileMaker. The FileMaker ODBC and JDBC drivers are located in the xdbc folder of the installation disk image, as well as in the FileMaker Knowledge Base at For more information about using ODBC and JDBC features, see: See the FileMaker ODBC and JDBC Guide and the FileMaker Pro Help. For more information about using third-party ODBC and JDBC drivers, see Importing files from Bento Bento 2 or a newer supported version (available at Features not supported in Windows On Windows, FileMaker Pro does not support Execute AppleScript and Speech script steps. It also does not support importing files from Bento. Features not supported on Mac OS FileMaker Pro does not support Phone Dial script steps. and “Sending a DDE command to execute.”

11 11 Export to Excel: Exporting to .xls format requires Rosetta, which is not available on OS X Lion. Converting a trial version of FileMaker Pro to a full version If you have a trial version of FileMaker Pro 12 installed, you can convert the software to a full version without first uninstalling the trial version. You can also upgrade your retail copy of FileMaker Pro version 9, 10, or 11 to full version FileMaker Pro 12 by typing license key to update during the trial conversion process. Upgrading FileMaker Pro from a Previous Version If you are upgrading FileMaker Pro from a previous version, it is recommended that you upgrade to the new version before uninstalling the previous version. To upgrade FileMaker Pro from a previous version, follow these steps: 1. Install the update using the 35-character license key located on the back of the DVD sleeve, or the key sent to you by e-mail along with a download link. 2. Move your plugins, dictionary data, and your settings to the new version of FileMaker Pro. For information about how to move settings, see the FileMaker Knowledge Base, available at 3. If you plan to use only latest version, delete the previous one. If you choose to uninstall a previous version before upgrading to the newest version, make sure you have a license key for the previous version. When you install FileMaker Pro with an upgrade license key, the installer searches your hard drive for the previous version. If a previous version is not found, you are prompted to enter the license key for the previous version of the product.

12 12 Before You Begin Opening Files from Previous Versions of FileMaker Pro 12 opens files created in FileMaker Pro versions 7.x, 8.x, 9.x, 10.x, or 11.x. But to use files with FileMaker Pro, you must convert them to the FileMaker Pro 12 file format. For more information about converting files, see FileMaker Pro Help. Updating a custom dictionary If you added words to a custom dictionary in a previous version of FileMaker Pro, you can use it in FileMaker Pro 12. For more information about converting a custom dictionary, see FileMaker Pro Help. Volume License Installation If you are installing multiple copies of FileMaker Pro under a volume license, or if you want to install without human intervention, you can automate the process. To skip standard installation dialog boxes, use the Assisted Install.txt file on the disk image. For more information, see the Product Guide network installation FileMaker Pro. For volume licensing information, visit

13 Chapter 2 Installing FileMaker Pro on the Windows Operating System Before proceeding with the installation process, save everything open files and close all applications. For the latest information and release notes about FileMaker Pro, visit Installation Notes Before you begin installing FileMaker Pro, please read the following notes. To install FileMaker Pro, you must have administrator access and log in with an administrator username and password. If your computer is running antivirus software, disable it before installing FileMaker Pro. Once the installation is complete, you can turn it back on. By default, FileMaker Pro will be installed in the following folder: C:/Program Files/FileMaker/FileMaker Pro 12. You can change the installation drive and folder during installation. By default, FileMaker Pro Advanced will be installed in the following folder: C:/Program Files/FileMaker/FileMaker Pro 12 Advanced. You can change the installation drive and folder during installation. During the installation process, you can choose to install all components (Complete) or only selected program components (Custom). For example, you can disable the installation of some components to save disk space. At the beginning of the installation, the user selects the language of the FileMaker Pro installer. The default selection corresponds to the operating system language. A full installation installs only the version for the selected language. To install versions for other languages, use Custom installation mode to select language packs for other languages ​​from the list of supported languages.

14 14 Installing FileMaker Pro on Windows Before installing an update or downgrading, FileMaker will scan all hard drives and drives connected to your computer for the previous version. If your computer has many disks, this may take several minutes. Installing FileMaker Pro Installing FileMaker Pro must be done using the installer. FileMaker Pro cannot be installed by simply copying files to HDD. If you want to create an installation log containing a list of registry entries and paths installed files, FileMakerPro should be installed from the command line. See “Install FileMaker Pro from the Command Line” on page 15. To install FileMaker Pro to your hard drive, do the following. 1. Do one of the following: If you received the software electronically, after downloading the file, double-click the installation icon (EXE file); If you are installing FileMaker Pro from a DVD, insert it into your DVD drive, open the FileMaker DVD window, and click the install icon. Install Application Click to view DVD contents Exit 2. Install FileMaker Pro by following the onscreen instructions. For more information about installation, see "Installation Notes" on page Once installation is complete, click Finish. The Product Registration dialog box appears.

15 15 Registering FileMaker Pro Take the time to register your copy of the product. Registering FileMaker makes it possible to get help recovering your license key if it is lost. Plus, you'll receive earlier notifications about updates, new software versions, and special offers. Enter product, registration, and additional information when prompted. If you are using a trial version of FileMaker Pro, you must register it before you can start using it. You can also do this using the Help > Register FileMaker Pro menu item. Installing FileMaker Pro from the Command Line To install FileMaker Pro from the command line and create an installation log, follow these steps. 1. Insert a DVD into the drive. 2. Open a command prompt window. 3. Enter the following command line: E:\Files\setup.exe /v /Lr C:\FMP12InstallLog.txt where E: DVD drive. If DVD drive assigned a different letter, enter it instead of E. 4. Follow the onscreen instructions. The FMP12InstallLog.txt file will be created in the root directory hard drive. It can be viewed in WordPad or any other program text editor. About installing Bonjour Bonjour provides automatic discovery of computers, devices, and services on IP networks. It must be installed on your system to detect remote hosts. If the Bonjour service is not installed or running, FileMaker Pro will not be able to detect remote networks. In particular, it will not be possible to browse internal databases in the Open Remote File dialog box and obtain a list deleted files for use as an external data source. Without Bonjour, you will have to manually enter IP addresses for remote databases.

16 16 Installing FileMaker Pro on Windows Operating System During FileMaker installation Pro program installation works according to the following algorithm: if the Bonjour service is not detected, the installation program warns about this and offers to install it; if the Bonjour service is detected, but FileMaker does not support the installed version, the installer issues a warning about this and offers to manually remove old version Bonjour, and then manually install the version of Bonjour supported by FileMaker; If the Bonjour service is detected and a version supported by FileMaker is installed, the installer does not warn or install Bonjour. To manually install the Bonjour service, do the following. 1. Open the FileMaker Pro installation folder. 2. Open the Bonjour folder. 3. Open the folder for 32-bit or 64-bit, depending on your version of Windows. 4. Double-click the BonjourSetup icon. 5. Follow the onscreen instructions to install Bonjour. Where files are located on your hard drive The FileMaker Pro installer copies files to multiple folders on your hard drive, depending on the operating system version and the installation options you select. If you install from the command line and specify a log file to be created, the log file will indicate the location of each of the installed files. Uninstall, change, or repair FileMaker Pro You can uninstall, repair missing or damaged components, or change the set of installed FileMaker Pro components using the Add or Remove Programs (Windows XP) or Programs and Features (Windows Vista or Windows 7) control panel ). For more information, see Windows Help. When modifying or restoring FileMaker Pro, you may be prompted to enter a license key.

17 17 Changing the FileMaker Pro Cache Size FileMaker Pro provides internal caching of data from the database. Depending on the amount of memory on your computer, you may need to adjust the cache size to achieve optimal performance. It is worth increasing the cache size if you plan to: work with large database files; simultaneously work with several database files; place database files on your computer; insert large images into the database file. It is worth reducing the cache size if you plan to run several applications simultaneously in a small space random access memory(RAM). Note. Reducing or increasing the FileMaker Pro cache size reduces or increases the amount of memory required to run FileMaker Pro accordingly. For more information about memory management, see the documentation that came with your computer. To change the cache size used by FileMaker Pro, you must do the following: 1. In FileMaker Pro, select Edit > Preferences. The Preferences dialog box appears. 2. Open the Memory tab. 3. Enter a value in the Trying to set cache size box, and then click OK. The next time you start FileMaker Pro, the new cache size will be used.

18 18 Installing FileMaker Pro on Windows Operating System What to Do Next After installing FileMaker Pro, you can start using the application right away. Below are sections of the documentation that we recommend starting with. If you are new to databases, you can learn the basics of working with them in Chapters 2, Using Databases, and Chapter 3, Creating Databases, in the FileMaker Pro User's Guide. If you are new to File Maker Pro, take the classes in the FileMaker Pro Tutorial; The PDF file of the tutorial and examples are located in the “Tutorial” folder, which is nested in the “Russian Extras” folder. If you're already familiar with using FileMaker Pro, read Chapter 4, "What's New," in this guide to learn about the new features in FileMaker Pro 12. If you're using FileMaker Pro Advanced, see the FileMaker Pro Developer's Guide and FileMaker Pro Help.

19 Chapter 3 Installing FileMaker Pro on Mac OS Before proceeding with the installation process, save any open files and close all applications. For the latest information and release notes about FileMaker Pro, visit Installation Notes Before you begin installing FileMaker Pro, please read the following notes. To install FileMaker Pro, you must have administrator rights and log in with an administrator username and password. If your computer is running antivirus software, disable it before installing FileMaker Pro. Once the installation is complete, you can turn it back on. You can choose to install all program files (standard installation) or install a partial program (custom installation). For example, you can disable the installation of some components to save disk space. Standard mode installs the version of FileMaker Pro that matches the language version of the operating system. To install additional language versions, select the appropriate language packs in Custom installation mode. Before installing an update or downgrading, FileMaker will scan all hard drives and drives connected to your computer for the previous version. If your computer has many disks, this may take several minutes. You can also install FileMaker Pro using the command line or remotely using Apple Remote Desktop. For more information, see the FileMaker Pro Network Installation Guide.

20 20 Installing FileMaker Pro on Mac OS Installing FileMaker Pro Installing FileMaker Pro must be done using the installer. FileMaker Pro cannot be installed by simply copying files to your hard drive. Installing FileMaker Pro on your hard drive 1. Do one of the following. If you received the software electronically, after downloading it, double-click the disk image icon (.dmg file). If you are installing FileMaker from a DVD, insert the DVD into your DVD drive and open the FileMaker DVD window. 2. Find and double-click the FileMaker Pro installation icon. FileMaker Pro Installation Icon 3. Install FileMaker Pro by following the on-screen instructions. For more information about installation, see "Installation Notes" on page Once installation is complete, the Product Registration dialog box appears. Registering FileMaker Pro Take the time to register your copy of the product. Registering FileMaker software allows you to get help recovering your license key if you lose it. Plus, you'll receive earlier notifications about updates, new software versions, and special offers. Enter product, registration, and additional information when prompted. If you are using a trial version of FileMaker Pro, you must register it before you can start using it. You can also do this using the Help > Register FileMaker Pro menu item.

21 21 Viewing the installation log file To view and save the installation log file, select the Window > Installer Log menu in the program window. You can view error messages along with progress messages, just error messages, or all available installation messages. Uninstalling FileMaker Pro 12 To uninstall FileMaker Pro 12, follow these steps. 1. Drag the FileMaker Pro 12 or FileMaker Pro 12 Advanced folder from the Applications folder to the Trash along with all its contents. 2. Drag the FileMaker Pro or FileMaker Pro Advanced preferences file to the Trash. The settings are in the following file. For FileMaker Pro: /library/preferences/com.filemaker.client.pro.plist For FileMaker Pro Advanced: /library/preferences/com.filemaker.client.advanced.plist Setting the FileMaker Pro Cache Size Because Mac OS dynamically allocates memory for applications as needed, it is impossible not to allocate a certain amount of memory to FileMaker Pro. However, you can adjust the FileMaker Pro cache size. It is worth increasing the cache size if you plan to: work with large database files; simultaneously work with several database files; place database files on your computer; insert large images into the database file. It is worth reducing the cache size if you plan to run several applications simultaneously in a small amount of random access memory (RAM). You can change the cache size used by FileMaker Pro as follows.

22 22 Installing FileMaker Pro on Mac OS 1. In FileMaker Pro, select FileMaker Pro > Preferences and select the Storage tab. 2. Enter a value in the Attempt to set cache size field and click OK. The next time you start FileMaker Pro, the new cache size will be used. What to do next Once you install FileMaker Pro, you can start using the application right away. Below are sections of the documentation that we recommend starting with. For database basics, see Chapters 2, Using Databases, and Chapter 3, Creating Databases, in the FileMaker Pro User's Guide. If you've never used File Maker Pro before, take the lessons in the FileMaker Pro Tutorial. The PDF file of the tutorial and examples are located in the “Tutorial” folder, which is nested in the “Russian Extras” folder. If you're already familiar with using FileMaker Pro, read Chapter 4, "What's New," in this guide to learn about the new features in FileMaker Pro 12. If you're using FileMaker Pro Advanced, see the FileMaker Pro Advanced Developer's Guide and FileMaker Pro Help .

23 Chapter 4 What's New This chapter provides an overview of the new features and improvements made in FileMaker Pro 12. For more information about these features, see FileMaker Pro Help unless otherwise noted. New Structure and Layout Controls FileMaker Pro Themes: FileMaker Pro's architecture has been redesigned to support high-volume layout themes functionality and more attractive. You can easily change the theme using the Layouts menu in Layout mode. Layout Object Formatting: FileMaker Pro has expanded the object formatter with features such as gradient fills, pattern fills including scaling and clipping, transparency, object properties, and rounded corners. To format an object, use themes instead of the default object styles without selected objects. You can remove styles from selected objects and control theme changes using multi-level undo. New layout assistance tools—dynamic alignment guides, guides that drag outside of rulers, and grid controls in Layout mode—will provide users with visual guidance for designing new layouts and modifying existing ones. Multi-level undo and redo allow you to experiment and improve your layout structure with ease. Screen Stencils: In Layout mode, you can click to display guides to design layouts that are optimal for iPad, iPhone, and general desktop solutions or set custom sizes.

Contents of this Microsoft guide Appearance Microsoft OneNote 2010 applications are significantly different from OneNote 2007, and this guide is designed to help you get started quickly. new version programs.

Getting Started with QuarkXPress 10.0.1 TABLE OF CONTENTS Table of Contents Related Documents...3 System requirements...4 System requirements: Mac OS X...4 System requirements: Windows...4 Installation: Mac OS...5 Addition

Boot Camp Installation and Setup Guide Contents 3 Introduction 4 What you need 5 Installation 5 Step 1. Check for updates 5 Step 2. Preparation Mac computer to install Windows 5 Step 3.

User Manual Contents Introduction... 1 IMPORTANT NOTES... 1 Legal Notices... 2 Installation and Configuration... 3 System Requirements... 3 Installation... 3 Activation... 6 Automatic Updates...

Working with standard document templates Cognitive Technologies User's Guide Moscow, 2015 2 ABSTRACT This document provides information about the use of the E1 Euphrates software package

Samsung Universal Print Driver User Manual imagine the possibilities Copyright 2009 Samsung Electronics Co., Ltd. All rights reserved. This Administrator's Guide is intended only for

Capture Pro Software Getting Started A-61640 Quick Start Guide to Alaris Capture Pro and Capture Pro Limited Edition Software Installing the Software: Software

Reference Integration Library Materials and Assortments and Systems AutoCAD User's Guide Information contained in this document, subject to change without prior notice. None

Step by step guide on upgrading to Windows 8.1 Installing and updating Windows 8.1 Updating the BIOS, applications, drivers and running Windows Update Selecting the installation type Installing Windows 8.1

Electronic document management system A r h i v a r u s Installation manual Moscow, 2008 2 ABSTRACT This document provides a description of the delivery package of the software product “EUFRAT-Document Flow”

Acronis Backup & Recovery 10 Advanced Editions Quick Start This document describes how to install and run any of the following editions Acronis programs Backup & Recovery 10: Acronis Backup & Recovery

Contents of this Microsoft Guide The Microsoft application has a very different appearance than Excel 2003, and this guide is intended to help you get started with the new version of the program. Read this

SOFTWARE INSTALLATION GUIDE USER MANUAL Page CONTENTS 1 ABOUT THE SOFTWARE 2 BEFORE INSTALLING 2 INSTALLING THE SOFTWARE 3 CONNECTING TO A COMPUTER

Quick Guide to Powersuite 2013 Universal application setting up and optimizing your computer with a full range of functions and wide adaptation capabilities. Download and Install Powersuite Download

Acronis Backup & Recovery 11 Quick Start Guide Applies to the following editions: Advanced Server Virtual Edition Advanced Server SBS Edition Advanced Workstation Server for Linux Server for

Hardware and software encryption complex Continent Version 3.9 Administrator's Guide User authentication client RU.88338853.501430.022 90 8 Security Code Company, 2018. All rights reserved.

EnergyCS Electrics Version 3 Installation and Activation Guide CSoft Development, 2012 ElectriCS ECP. Installation and activation guide page 2 Contents General information... 3 Commercial and evaluation

Quick Start Guide The interface of Microsoft PowerPoint 2013 has changed since previous versions, and we've created this guide to help you get up to speed with it. Finding what you need

LASERJET ENTERPRISE COLOR FLOW MFP M575 Quick Start Guide Printing a Stored Job Follow these steps to print a job stored in the machine's memory. 1. From the control panel home screen

Description of the ViPNet Business Mail Program The ViPNet Business Mail program (or simply “Business Mail”) is designed for organizing electronic document flow in the secure ViPNet network. With the help of "Business

Support modules for CryptoPro CSP 2018 Aktiv Company General information. The Aktiv company has developed ready-made solutions that provide integration of Rutoken and different versions CIPF CryptoPro CSP. Installation

English MF Driver Installation Guide User Software CD....... 1 About Drivers and Software...... ....................................

Standard Components Library Manager CSoft Development, 2009. All rights reserved Contents Standard Components Library Manager...2 Security Note...4 Starting the Library Manager

Electronic document management system A r h i v a r i s Installation manual Moscow, 2009 2 ABSTRACT This document provides a description of the delivery package of the software product “EUFRAT-Document Flow”.

Boot Camp Installation and Setup Guide Contents 3 Introduction 4 Installation 4 Step 1: Check for updates 4 Step 2: Prepare your Mac for Windows 4 Step 3: Install Windows

Full control performance Compatible with Windows XP and Windows Vista 2013 Improve productivity and take care of your PC with one powerful and flexible application.

To upgrade a computer running Windows XP to Windows 7, you will need to perform a full installation, which does not save any programs, files, or settings. For this reason

Microsoft Windows 7 / Vista / XP / 2000 / Home Server / NT4 (Service Pack 6) Quick Start Guide ESET NOD32 Antivirus provides the most advanced antivirus software modern protection

Brother Meter Read Tool User Guide ENG Version 0 Copyright 2017 Brother Industries, Ltd. All rights reserved. The contents of this manual are subject to change without notice. Software

Quick Getting Started Guide The interface of Microsoft OneNote 2013 has changed from previous versions, and we've created this guide to help you get up to speed. Switching

Hardware and software encryption complex Continent Version 3.7 User authentication RU.88338853.501430.006 96 4 1 Security Code Company, 2017. All rights reserved. All copyrights to the exploitation

T.V. Glotova Methodological instructions for performing practical and independent work section Fundamentals of working with office suite OpenOffice.org 3.2 Part 6 History of OpenOffice.org. Platforms and system requirements

Readme file for Veritas System Recovery 16 Management Solution About the readme file System requirements for Veritas System Recovery 16 software delivery policies System requirements for Veritas

AutoLiquidator Version 1.1 Installation and registration of the program 2005-2006 Russian Information Technology 1. Introduction This document is a guide to installing and configuring the software product

About Microsoft Office Word 2007 files Microsoft Office 2007 introduced new format files based on XML language. By default, documents created in Word 2007 are saved with a new file name extension,

2017 Electronics For Imaging, Inc. The information in this document is subject to the Legal Notice for this product. November 25, 2017 Contents 3 Contents Fiery Review

Qlik Sense Desktop Qlik Sense 1.1 QlikTech International AB 1993-2015. All rights reserved. QlikTech International AB 1993-2015. All rights reserved. Qlik, QlikTech, Qlik Sense, QlikView, Sense and logo

2014 Electronics For Imaging. The information in this document is subject to the Legal Notice for this product. June 23, 2014 Contents 3 Contents...5 Access to the program...5

LASERJET ENTERPRISE MFP Quick Start Guide M725dn M725f M725z M725z+ Printing a Stored Job Follow these steps to print a job stored in the machine's memory. 1. On the home screen

Boot Camp Installation and Setup Guide Contents 3 Introduction 3 What you need 4 Installation 4 Step 1. Check for updates 4 Step 2. Prepare your Mac for Windows installation 4 Step 3.

IBM SPSS Statistics for Mac OS Installation Instructions (Single User License) The instructions below are for installing IBM SPSS Statistics version 19 using a single user

P-touch Transfer Manager Instructions Before using the printer, be sure to read this online user's guide. It is recommended to keep it on hand

Universal Driver Guide Brother Universal Printer Driver (BR-Script3) Brother Black and White Universal Printer Driver (PCL) Version

SMART Sync 2011 Quick Start Guide Incredible Made Simple Product Registration Once you register your SMART product, we'll keep you posted on new features and software updates.

English MF Driver Installation Guide User Software CD........ 1 About Drivers and Software................... ...................................

User Manual Contents Introduction... 1 IMPORTANT NOTES... 1 Legal Notices... 3 Installation and Configuration... 5 System Requirements... 5 Installation... 5 Activation... 7 Automatic Updates...

Small Office Security 2 Installing Kaspersky Small Office Security 2 on Personal Computer Contents Contents... 1 Installing Kaspersky Small Office Security 2 on a personal computer... 2 Quick

Starting the P touch Editor Before using the printer, be sure to read this online user's guide. It is recommended to keep it on hand for later use.

Windows Update Vista to Windows 7 Depending on your hardware and the current edition of Windows Vista, in the process Windows installations 7 you can use the Update option to go

Support modules for CryptoPro CSP 2014 Company "Active" Rutoken for CryptoPro CSP. The Aktiv company has developed ready-made solutions that provide integration of Rutoken and various versions of CIPF CryptoPro CSP. Installation

Installation Instructions for IBM SPSS Modeler Server 16 for Windows Contents Installation Instructions....... 1 System Requirements....... 1 Installation...... .. 1 Destination............... 1 IP address

APPROVED PBKM.33314-01 34 01-LU PC "Energosphere". Installer Operator's Manual PBKM.33314-01 34 01 Sheet 37 2008 Contents 1. INTRODUCTION... 3 2. TECHNICAL REQUIREMENTS AND USER TRAINING LEVEL...

About Microsoft files Office Excel 2007 Microsoft Office 2007 introduced a new file format based on the XML language. By default, documents created in Excel 2007 are saved with a new file name extension,

OJSC "InfoTeKS" Appendix to the ViPNet documentation version 3.1 FRKE. 00044-04 90 05 MOSCOW 2010 2 1991 2010 JSC "Infotex", Moscow, Russia. This document is included with the software

Using Conference Manager for Microsoft Outlook May 2012 Contents Chapter 1. Using Conference Manager for Microsoft Outlook... 5 Introduction to Conference Manager