Communications and media programs filemaker. General information about the filemaker subd, creating a database from scratch. Appointment and goal niche

About tsyu DBMS as if, as if it were known, in the rest of the hour they started to forget about trochs, having choked on Oracle, MS SQL Server and other giants of the industry. Well, tell about it - a miraculous way to guess about the basis of such a miraculous software product.

Tse sche one Access?

The specificity of the FileMaker DBMS lies in the fact that it is oriented not so much at the programmer, like at the end of the world. In the descriptions of your product, retailers uniquely use the cumbersome term DBMS (database management system), replacing it with a database application.

"So what's up? - You can ask. - Get out, FileMaker is an analogue of Microsoft Access?". So I want to say: "Hi, well, you see, tse DBMS is right!" And yet, Access is not a game, but a zvichaynistinka flooring database management system. І FileMaker is somewhat similar in some ways, and different in some ways. Zagalom, maybe, from my side, it’ll be right, but I’ll leave evidence on the chain of food for your thought. Even more so about FileMaker, so you can just write in kshtalt: "From the miracle of the FileMaker DBMS, even similar to Access, zavantazhyte on zdorov'ya and koristuytes on the quiet!".

Before that, as I would like to inform you about the possibilities of this software product, I want to tell you about those who can independently learn about it. In what way will the official site, distribution for the address www.filemaker.com. Respectfully, in order to get a trial version of the program, you need a registration.

Possibility of FileMaker

As I already said, FileMaker does not focus on retailers, but on end-users. So, the first thing to do is to achieve a simple-to-use graphical interface of a coristuvach.

When creating databases, FileMaker will load typical templates - for business, for education, for home use. The templates are not too rich, but the stink of tyamuschi, wanting not to need them, who is not the English language. Under the hour of the creation of the data base, it is declared a garnet with fields, as if it were the fields in the tables of the data base. They can change the font, the scale of the display, and you can also switch to a special name (and, I respect, not only me) of the tabular data.

Visually, you can edit both the data itself and its structure. For which it is necessary to select "Define" in the "File" menu, and in the new one, select the elements of the structure of the data base as you wish. You can create tables and fields in the middle of these tables, put behind the help of handy diagrams the spread between tables, create power functions on the basis of already existing ones ...

You can import records from various other databases without any special features (they can be in the format of FileMaker itself, as well as in text files, DBF "iv, files Microsoft Excel or in the rare Lotus 1-2-3). In a similar way, information from the data base can be exported. Okremo transferred the ability to export data to PDF format- Dosit not unique for the DBMS solution, if you want, imovirno, not the most necessary. Vtіm, ymovіrno, tse zruchno at Zakhodі, de PDF - the standard for document processing, and we will have more requests for export to Excel. But it's better to type in "1C" - but this is not the case in FileMaker, of course.

FileMaker has added three modes to work with the data itself. These three modes are called in the following order: Browse, Find, Layout and Preview. Another mode, as you can easily guess, marveling at its unsightly name, is used to search for data that satisfies your criteria. When the search is completed, FileMaker will automatically turn to the first mode, so that the data you know can continue to be edited, seen and known to you fantasy ways. The mode under the name Layout allows you to design the layout of the working window for editing data in FileMaker old look. Also, in this mode, you can set the current view of the sounds from the given information, and you can look at them in the rest of the mode - Preview. How to move at the dovіdtsі, whose mode is especially effective for warehouse calls with pіdbityam pіdbags.

Scripting in FileMaker

Be it a DBMS, don't let it be as simple as FileMaker, you can't end up pushing buttons and let's just "drive" data into the database. It's too early to start scripting and programming - and FileMaker gives you such a possibility.

Scripting in FileMaker provides a special tool, which can be found in the "Scripts" menu of the main window. At the editor's window, you can use a large number of scripts already present in the program, which are used mainly for sorting data. Right from the beginning, the script can be hacked, deleted, or changed, and you can also create a new script.

FileMaker's script builder can be called not visual, but close to visual. Look like this: livoruch y vikni - the "text" of the script, to describe the sequence of commands, how the script is written. Ale, vlasne, the text of the script is not worth it, so it’s impossible to edit the text of the yogo. By clicking on the command in the list, you can set parameters for it, moreover, to set the parameters, they have their own window. The parameter is a field in the table, then is a list of available fields, and if the parameter is of a different type, then there is an even greater number of commands, which allows you to visually set the mind, the operation to resolve it and otherwise. The list is long to complete, and it will not be so easy to orient yourself in a new bud, if you want, singsongly, you can call for an hour.

Obviously, such a way of working with scripts will not be too easy for programmers, as they called to write the text of the script without intermediary, prote for the short ones, as they did not sound before programming, that is, insanely, richly shortening option.

In order to run the scripts in the setup mode, you need to put a check mark on the "Debug Scripts" item in the "Tools" menu. Possibility of upgrading to achieve the standard: points of teeth, vykonannya procedures with pokrokovymi vykonannyam commands use the middle of it or without it. It’s possible to review the results of that chi іnshoy vіrazu in the okremomu vіknі. Zagalom, the improvement of scripts is like the improvement of scripts. and, take care of the scripting improvements.

At the same time, the use of scripting scripts in FileMaker "does not mean that it is not possible to work with them for the help of SQL-zapitiv. It is also possible to navigate, only, as it seems, carefully. FileMaker scripts" and the Execute SQL command is supported, so SQL -Request. In addition, SQL can be hacked when working with FileMaker databases via ODBC or JDBC.

Nine version

At the time of writing, the nineth version of FileMaker was up-to-date".

As the main thorough, implemented in the ninth version, the retailers themselves call the bidirectional database from the SQL database. Rocks allow you to increase the productivity of systems, defiance FileMaker. In addition, in order to complete the summation, part of the program that works with SQL has been reworked, and that summation has been advanced from SQL by data bases. In FileMaker Pro 9, you can convert to the SQL data tree the same way as to another FileMaker Pro 9 file. , - you. This, however, does not mean that knowledge of SQL has become obligatory for working with version 9 of FileMaker.

For koristuvach in FileMaker Pro 9 cіkavoi bude mozhlivіst pіdsvіchuvannya vidіlennya important polіv, yakі zalishenі empty or zapovnіnі incorrectly (for example, entered negative kіlkіst product). FileMaker Pro 9 Server allows you to quickly generate a PHP site automatically from a database. The possibility of grouping scripts in the middle of catalogs has been added.

Summary

Well, the axis is such a wine, the whole FileMaker. Obviously, this program cannot be called a direct competitor to Oracle or PostgreSQL, but the skin is a good product for its own niche and optimally works on its own in quiet minds, just like that. As for the similarities between FileMaker and Microsoft Access, I think you already know Access, but now that you've read about FileMaker, you can tell yourself how similar they are.

For whatever it is, you should know that FileMaker is handy, has a need for market. І tse is an indicator of a good software product.

The middle of FileMaker expansion is now one of the leading DBMS middleware for small and medium workgroups, allowing you to quickly expand ready solutions that will be added to the needs of the deputy. Потужні можливості FileMaker, режим колективної роботи, підтримка великої кількості цільових платформ, ідеальний для швидкої розробки графічний інтерфейс – все це робить FileMaker незамінним під час вирішення завдань, пов'язаних зі збором даних та управлінням людьми, інтернет-проектами та менеджментом різноманітної інформації. Ready to use FileMaker templates to help you quickly create your own solution and put it into operation. The foundations of one's own building are exchanged with them practically with some kind of supplement, FileMaker erases the boundaries in heterogeneous dimensions, proponuyuchi for any folding tasks of one's own solution.

For the rest of the hour, the DBMS market is traditionally dominated by the giants of the market, which are ahead of Oracle Database, Microsoft SQL Server, etc. If you look at the market for similar solutions for different people, then here I will renew the presentation of the DBMS in front of professional retailers - MySQL, PostgreSQL, etc.

It is obvious that with the choice of such serious and hard tools, the distribution itself and the support of data bases become more and more of professional retailers. On the one side, this niche is oversized with a spectrum of different arches of the gnuchki and tight solutions, but on the other side, you need to know, and the versatility of rozrobka under the similar platform is koshtuvatime more than vodchutny pennies, despite the fact that the right way to formulate the correct one, zavdannya by the zamovnik himself, not seeming about the hour of the creation of that roaring of similar decisions. If the process of exploitation already has a ready-made solution to appear, as it often trapleyaetsya in life, that the product will seem to be supplemented by that black adaptation - self-mutilation, I’m again, it’s unlikely that we’ll get around here, and that means, we’ll get lucky again.

Ready, then, do not make such a decision, as it is necessary, life has repeatedly brought, that you should create a personalized decision more quickly and even more, which is called, "I will repeat myself," but here we are stuck with the problem of folding and three such problems.

Just for a second to think and remember: oh, just like a database could be created by all powers of power, for which it was not necessary to be a specialist in a lot of different technical areas, just like programs were just not correct, create from scratch , Rozshiryuvati il ​​Dopratsovuvati ... I Yakshcho for the Great, I often Busha, I have the road specialized RISHENNYA on the BAZ SERYOZHICH I ALIDARY ASKOSO ONE ONEA, I have the same time for the domesticity, the owned in the home. MySQL, maybe, transcendental and navit navit absurd.

Such a long introduction to the topic was conceived only for one reason: the DBMS market for small businesses and home-based applications of over-the-counter demands and practically no representations in the domestic space. How do you need a fast delivery a specialized system warehouse look and specific specifics, or just a special system of planning, right or finance, inspired by the black new-fangled concept of time management, which was worthy of you, - de shukati help in such a time? What are the tools for which it is optimal to hack - why is MySQL not popular among communication with a visual frontend, let's write in the equally popular Visual Studio? Yakі shvidki that simple options rozrobki for such a situation could proponuvat vy, yakі fit be-yakom non-technical fakhivtsu as it is, like an accountant or a first-year student?

Today we may have some good news: our review will be devoted to the reporting review of the DBMS itself of a similar class, supervised and popular in Zakhod, but still not much wider in Russia - FileMaker. It has already become typical to compare FileMaker with its niche counterparts - Microsoft Access and FoxPro - for decency, we also repeat this analogy, but for the sake of completeness and fairness, for the sake of it, we point it out and їх smut vіdminnosti, through yakі tse porіvnyannya, on our mind, .

One more MS Access?

The specificity of the FileMaker DBMS is even more pronounced in that it is oriented not so much at the programmer, like at the kіntsovogo koristuvach, at the non-professional in the field of databases. In the descriptions of your product, the retailers deliberately use the cumbersome term DBMS (database management system), although they want to be introduced in the product specification, replacing it with a database application.

The main way to know visual design, which vibrates in two similar, but not analogous systems. FileMaker has a smaller and, in my opinion, richly distant and large-scale. Choosing the right design strategy (for example, the presence of a reasonably chosen set of ready-made templates for all typical orders, which can be taken as a basis) Swedish start your new project based on the distribution system. For example, here you can program using the visual FileMaker Script, learn about the basics of programming, or start designing your database by simply dragging the Excel file onto an empty project form with the mouse.

If MS Access or FoxPro is working on a project - just look in the middle, and you need to be clear about how the data base functions, then FileMaker - just look at the call. FileMaker encourages you to focus on the formation of a well-known representation of the data base, then on the interface. Reshta FileMaker is practical to take on myself. If you don't want to open the expanded interface, you'll hopefully get a standard one, and you won't have access to the hard tools that need to be sorted out for the cob of non-gay work from the database. From the other side, as you can imagine, you can delve into the essence of the processes and imitate your project with additional functionality, independently signifying the pleasant and equal folding in the intermodality of the DBMS.

Before the numerical details of the implementation of FileMaker in the distance, if we turn around, I would immediately like to put a dot on this stereotypical line: in our opinion, FileMaker is a system that is richly accessible and friendly great koristuvachev, lower MS Access, moreover, all the possibilities of the world are not compromised by MS Access, but rather in what, for some apparent distance, it is significant to overturn її.

What about FoxPro - after all, it’s a system for programmers, anyway. Obviously, if you know FileMaker, you won't be able to get your hands on programming with "serious" language - you should be allowed to "get into" the system and її possiblity literally on the go, maximum for doba, once more pratsyuvati. Ale, stavlyachi zavdannya navpak - quickly and immediately rose to the humanities at FoxPro, you'll be more comfortable, wait, that and you don't need to work! As of today, it’s possible to change it - where it’s simple, and I ask you to remember when it comes to this, the system of expansion is richly torn apart from MS Access and FoxPro - tse DBMS FileMaker.

Appointment and goal niche

FileMaker Pro is a cross-platform desktop designer of tabular and other informational add-ons based on a data relational data base. Together with the engine of the database, as already mentioned above, a single package is supplied with a tight visual designer, with an intuitively intelligent GUI interface that allows the visual mode to create add-ons: with its own form, logic . Krim sberigannya, operuvannya that obrobki danikh, tse middle of the nada is impersonal additional functions that feasibility (about how the report is given), how rich in what to lie in the editorial office of the product (to marvel at another part of this article). In short, it seems to be the core of the RAD (Rapid application development) development, but it is a kind of “SuperRAD”, which allows you to create similar programs, but it’s 10 times more simple!

Otzhe, having given even dryer and more often to the treasury, it is supposed to be an obedient benefit for the inhabitant: having mastered FileMaker, you can easily and quickly create your own power projects, based on data bases, zastosuvannya such practically not obmezhene. You can already quickly, literally "on the knee", create, for example, a great catalog of your home library or films, catalog your great musical collection, expand the system of the appearance of goods in the production, or the appearance of glass materials that office equipment, the system of passing through your company or the system of a personalized friend. Vitrativshi literally whilina, post your database on the Internet as an automatically generated php site. І richly richly other...

You can rebuke such my daring FileMaker versatility with the right RAD-systems, calling it inaccurate and appealing to the point of final code, which would be in a similar add-on, traditionally broken, for example, in Visual Studio, as incomprehensibly more meaningful and more meaningful. But I, at the same time, I respect that today is not the most controversial argument against “desktop frameworks” (and FileMaker to the singing peace of it and є), because today the man-year-old is more expensive, lower, it is necessary to upgrade your mouth for upgrades , so that they gave him “everything flew”. With this final respect, I tried in absentia the opinions on some obvious ideological vipadi at the FileMaker bik, yakі mіtse. And now, having finished with indecent rhetoric, let's move on without any middle ground to a look at his possibilities.

Key features of FileMaker

This multi-platform product supports the following platforms: Windows (XP, Vista, 7); macOS X, iOS.
. p align="justify"> Plugin architecture - for connecting anonymous third-party plugins, which further expand the functionality of the main system. . Bagatomovna pіdtrimka - the system was translated by more than 12 mov, including Russian.
. Possibility to automatically generate inserted and optional graphs, call and histograms.
. Supports FDML movable layouts for generating web pages with the possibility of dynamic inserts from the FileMaker database.
. Even though we are talking about sites, the server version of FileMaker has the ability to automatically generate a PHP site automatically - this structure is already explicit data base.
. Possibility of encryption of all victorious tables and structures of data.
. Large number of formats for importing data from the database: Excel, Lotus 1-2-3, txt, cvs, dbf and in; and there is also a large number of formats for the pivotal operation - export.
. close up visual editor scripts, which allows you to simply get around the programming (as you need it here).

Іsnuє vbudovaniya nalagodzhuvach skriptіv, which allows virіshuvati all folding situations. In the beginning, I want to express my subjective thought, that the scripting language of FileMaker is good, and, ymovirno, it will be unhandy to the most informed programmers, and it’s better to go as soon as the buds and stick out the koristuvachs (you can look at it immediately as a plus, so it’s a plus) . . FileMaker grants insurance for a rich workflow with a data base, within reasonable limits, especially (it is not necessary to pay for one-hour access to the database for 400 cases). Ale na zahist internal treasure danih want to say what's in other versions It has been significantly expanded and supplemented, and now you can fully operate with great obligations (but again, in reasonable terms - within the framework of small and medium-sized businesses, it won’t become a direct competitor with this plan for Oracle or PostgreSQL).

Zovnishnya vzaemodiya

Often, when choosing similar products, first of all, as a ruba: “And how can I help them with my own best decisions?”. Well, food is natural. І якщо внутрішні можливості щодо швидкого проектування та надзвичайно зручного створення додатків на FileMaker я не ставлю навіть під сумнів (бо це так і є – просто спробуйте), то питання дослідження FileMaker на предмет його можливостей щодо взаємодії з іншими зовнішніми продуктами потребує додаткового освітлення, через especially the importance of this parameter in the case of the creation of modern and flexible heterogeneous systems.

First of all, it should be noted that FileMaker already widely promotes and actively promotes the universal XML standard for exchanging various information with foreign programs. Zocrema, pidtrimuetsya:

XML Data Source Import - import of original data from the DBMS XML format;
. Export Records and Export Records script step - change the export of your data in XML format;
. Custom Web Publishing with XML is a mechanism for forwarding XML data from a source to an Internet request for data from an external service.

XML support cream for exchanging data from existing sources is also available povna pidtrimka ODBC/JDBC to further expand FileMaker's capabilities.

Well і, nareshti, naytsіkavіshe z glance of the application programmer - mov SQL.

As I already wrote earlier, FileMaker uses its own quasi-visual tools for the creation of vibrators, but for the most part, it may be a world-wide support for the possibilities and SQL, so let's briefly review the main points in this food:

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

ODBC/JDBC- alternative way connection, as you do not need a permanent live connection to the old dzherel danikh. This may be a plus, and a minus: a plus - a lot more versatility and breadth of available databases, in fact, you just need to know and install a standard ODBC driver for your database in a FileMaker system. Minus - trohi less swidk_st vzaєmodії; . Execute SQL - availability of dynamic SQL queries on the FileMaker scripting engine through this command, which creates a kind of advanced script for a successful, and I say bi, sophisticated SQL query within the FileMaker ecosystem;

MySQL partnership - I especially want to see the support of the old danich dzherel no-cost server MySQL databases. It should be noted that the level of integration with this term as External SQL Data Source is superbly clear. The FileMaker compiler itself describes impersonal examples of great developments in the distance, deducing such a symbiosis of these two DBMSs as the basis of all information infrastructure. The official partnership between FileMaker, Inc and MySQL AB makes even more difference, not only on a technical level, but also on a legal level.

Well, let's talk about the current topic "Zovnishnyoї vzaєmodії" in which varto guess about the smtp-solution, how to rob e-mail permanently integrated into the global system, which will again add convenience to the distribution, especially for corporate purposes, which, along with the flexible export from XML-dzherel, allows such an add-on to be permanently released "on the link".

In the other part of the article, we will describe the Internet-capability of FileMaker, its numerical editions, and, incidentally, we will discuss the impersonal other features of the receiver.

Far be.

Igor Savchuk

Most of the innovations implemented in FileMaker 12 products, the world is pushing retailers to "mobilize" their platform.

Many of the proposals are more appropriately addressed to representatives of small and medium-sized businesses, who would like to more easily integrate mobile attachments with their essential work processes. Undertakings are taken away from your order by simple and superfluous tools that allow you to create data bases of professional equality and to compose them without writing program code.

Koristuvach hope to expand the possibilities of using the functions of tablets and smartphones. In addition, Filemaker 12 Go transfers the possibility of a secure placement of video and audio materials, recorded on a mobile phone, at the “container” type field. Guess what in earlier versions tsі fields can be vikorated for collecting signs, signatures and GPS data.

Support for portable devices is implemented in server editions of FileMaker 12 Server and FileMaker 12 Server Advanced, which now supports streaming large files to the mobile client, including images, audio, video and PDF documents.

The stock of FileMaker Pro 12 includes new themes and types of solutions, advanced tools for designing add-ons for the iPad, iPhone and desktop PCs, as well as stocking files for today's programs, which will win a great deal of multimedia. FileMaker Pro 12 Advanced has the added benefit of developing and managing projects.

FileMaker Go 12 for iPad and iPhone is available free of charge through the App Store. At the moment, these programs are not Russified. FileMaker Go 12's no-frills versatility makes it easy for anyone to use iOS with the database programs created in FileMaker Pro 12.

The new 64-bit versions of FileMaker Server 12 and FileMaker 12 Server Advanced improve productivity globally, expand the support capabilities of large databases, and enable fast file streaming and multimedia content.

The main elements of localization for the Central European and Near European versions:

• localization of the interface with the Czech, Russian and Turkish languages;
• templates in Hebrew, Arabic, Polish, Czech, Russian and Turkish languages;
• the function of mitteva publications in the media in Hebrew, Arabic, Ugrian, Greek, Polish, Czech, Russian and Turkish languages;
• dictionaries and spelling checks for Czech, Slovak, Ugric and Polish languages.
• the function of a mirror layout, which allows the coristuvachs to move one onslaught from the layout with the orientation to the right into the layout with the orientation right-handed to the left (for the countries of the Close Gathering and Pivnichnaya Africa).

For the help of FileMaker Pro 12, you can create basic data without special zusil. 16 new model tasks will speed up the creation of databases for managing contacts, projects, digital, inventory and other important business tasks. Typical tasks include ready screens optimized for iPad and iPhone. Coristuvachi can change the current look of the program for help with 40 new topics. Those can be twisted with typical tasks or zastosovuvat to basic data bases. Specially designed for iPad and iPhone, especially touch themes to replace fonts, colors, buttons and other design elements of iOS.

Koristuvachі can create programs exclusively on the basis of ready-made themes, or individually adjust the skin detail for the help of new design tools, such as gradients, image cropping, dynamic direct viewing and grids that are configured. Special screen stencils to simplify the placement of information on iPad and iPhone screens.

FileMaker Pro 12 includes a new "Swedish Chart" tool for scheduling random charts, as well as five new styles for charts: bulbous charts, expansion charts, positive and negative charts, and stacked partial charts and stacked charts.

Enhanced container fields in FileMaker Pro 12 save a lot of file types such as PDF, video, photos, audio, and other drag and drop features. Files can be taken from the database or from the linked view. Managing file associations has become easier because FileMaker 12 now automatically organizes files on disk and can encrypt them for additional security.

New 64-bit versions of FileMaker Server 12 and FileMaker Server 12 Advanced are optimized for swedish data processing. The productivity of the global network has been improved to make it easier for the robot when remote connection especially for koristuvachіv pristroїv z iOS. Modifications of the mechanism of publication in the least increase the flexibility and stability of the integration of powerful web pages with FileMaker databases, and consequently backup copy ask the administration of the server and improve the solution.

Koristuvachi corporate licenses with maintenance support take away the ability to upgrade to version 12 of FileMaker without a cost.

2014: File Maker 13

On December 19, 2013, FileMaker introduced version 13 of the FileMaker DBMS.

On March 18, 2014, sales of FileMaker 13 DBMS, localized for Russia and the region of Central Europe, were announced on the territory of Russia and in the countries of CIS.

Description of change and innovation

For a small company, an organization is available access up to a base for 5 other FileMaker Pro extensions or FileMaker Go for additional FileMaker Pro support. To organize access to a larger number of coristuvachs needed by FileMaker Server. FileMaker Server 13 is under review promotion equal security, more flexible possibilities for access to data, including support for launching the solution in the browser with wikis new technologies File Maker WebDirect.

Innovations and additions

Mid innovation:

• creation of individual business solutions for the browser for the help of FileMaker WebDirect;
• new opportunities for iOS expansion and optimal working environment for iPad and iPhone for desktop special functions(visual panels, additional screens, barcode scanning support, scrolling gestures, keyboard types, script triggers and other functions, developed specifically for iPad and iPhone);
• the creation of more functional business solutions with a variety of new functions (such as: choice of fields, styles to adjust, control of the visibility of layout objects);
• Guaranteed protection of data from modern encryption systems based on Galuze standards.

Additional functions, tools:

• FileMaker Pro 13 has improved container fields in layouts. The "Defeat Container Attribute" function automatically rotates metadata for elements that are stored in container fields. You can rotate more than 40 attributes (file name, file size, name, model, image name, album, genre, composer, height, width, latitude, age, date of creation, date of change) , barcode and in.).

• The main innovation in FileMaker Server 13 is the FileMaker WebDirect component. Tsya web technology secures the business-management without interruption from the browser and does not require the basics of web development. FileMaker WebDirect allows you to use any type of mov programming PHP, HMTL5, CSS and JavaScript to create a web solution.

• A new administration console has appeared. The console has been rewritten in HTML5 to ensure secure and manual access by any browser. It will now take less than an hour to clear administrative tasks, and updating the database status will be faster.

Purchases of FileMaker Pro 12 are free of charge for the new version, during the transition period and restocking of FileMaker with an upgrade subscription. Other FileMaker Pro owners can get an upgrade version with a reduction.

Licensing

AT new version the product has changed its license to access the server. To connect to FileMaker Server 13 with any browser or FileMaker Go for iPad and iPhone, you need to get a connection license

madness

Windows XP and Mac OS X 10.6 (Snow Leopard) are not supported by FileMaker Pro 13. When switching to FileMaker Pro 13, older versions of the OS will need to upgrade.

FileMaker, an Apple subsidiary, has released FileMaker 15, a new release of its platform for creating powerful applications, aimed at non-professional retailers, writing appendages for myself and my colleagues.

FileMaker 15 avenges improvements in five key areas: portability, automation/integration, ease of use, security of productivity. Oriented to small and medium businesses and internal businesses, the FileMaker platform empowers entrepreneurs to create software for iPad, iPhone, Mac, Windows and the Internet.

“This new release reflects our uninterrupted success, straightened out by simplifying the process of development and launching into the robot core applications, building development without problems on mobile devices, personal computers and on the Internet,” said Enn Monroe, vice president of marketing at FileMaker .

FileMaker 15's new mobility features include a Touch ID scanner feature that allows retailers to enroll secure access to their dodatkіv one dotik finger. Zavdyaky pіdtrimtsі new tekhnologii 3D Touch can be quickly launched sevnі programs. And for the help of new extensions of the program, you can create content that is displayed and exchange files through the cloud.

In addition, the addendum to the iBeacon protocol added in FileMaker 15 allows you to include data about the local income of the beacon in the appendix, and FileMaker WebDirect technology gives clients the ability to win their own mobile phone to access the extensions of FileMaker programs from an Internet browser.

By the appearance of the 15th release, it was announced that FileMaker had already been on the market for a long time - the stench of the 80s of the last century was repaired. Andrew Lecates, director of technical consulting at FileMaker, says that in an hour of its development, a product will change dramatically. Lakes was a product development announcement of a single-source list manager for Macintosh based on data base graphical interface to a client-server business platform, and then to a cross-platform solution for Mac and Windows.

"FileMaker's key idea is to give non-professional retailers the ability to create power-ups, help people win jobs, expand their business-powered add-ons, not checks until they need to be satisfied with a purchased corporate add-on," Lakeites said.

The Gartner company, which specializes in the manufacturing market, gives the following designation to this kind of retailers: other people". In his own name for 2009 Gartner predicted that by 2014 such retailers could be hired 25% of new business add-ons, which, for the її thought, would make life easier for the end-of-the-year coristuvachi and would improve the additional IT-resources. With this, Gartner is also ahead of the curve that IT organizations, if they can’t speed up with successes, if they give organizations such retailers, can’t fail to respond quickly to market trends that are rapidly changing, and advancing clients.

With this sense of Lecates, having determined that FileMaker should install only one of the most advanced, low-tech platforms for the development of add-ons, the target audience of which is formed from the great software development companies and professional distributors. “We believe in those who are non-professional retailers in various business enterprises can make up their own minds, and respect this on the practical side.”

FileMaker 15 continues the company's move towards increased mobility, Lecates said. For this reason, the company's customers asked to add the possibility of mitt authorization for additional Touch ID and 3D touch scanners, support for the extension of programs for integrating FileMaker with other programs on the iOS platform and navigating direct API access to such devices, such as iBeacon beacons, which go into the framework competencies of small business and internal businesses.

“We'll just stick with the iBeacon protocol,” Lekates said. - We also have a browser client for our platform called WebDirect, which gives us the ability to capture decent HTML5 code on the go without having to write the same row of code in the development process. The version of FileMaker 15 has all the client optimizations on phones.

Tim an hour, before the FileMaker 15 security tools, a text field was added, in which confidential information was stored, which could not be shown on the screen. New updates to the security system will be announced within an hour of trying to connect to the site or website with a weekly security certificate. In addition, FileMaker Server now supports SSL certificates, seen by nine popular vendors, as well as broadcasting older certificates, subjectAltName (SAN) extension and wildcard certificates, supported by the company.

New functions of integration and automation include updating in the middle of the product and the ability to mimic the work of scripts for the additional function of multiple forward slashing. Seeing it in red colors helps a person to know the problematic areas of the Script Workspace, Lecates says. With the release of version 15, the FileMaker External SQL Sources (ESS) Adapter can connect up to greater quantity old dzherel SQL data, PostgreSQL and IBM DB2 code.

“To expand the list of SQL-gerels that can be serviced by adding PostgreSQL and IBM DB2 support to the ESS Adapter is of little importance,” said Christoffer Polit, iSolutions consultant and instructor at FileMaker. “Surely FileMaker now has the ability to have active two-way connections up to the five largest SQL databases (SQL Server, MySQL and Oracle were already supported in older versions).”

Ipolit, which, in his own words, having already taught hundreds of students and thousands of students in his audience - over the Internet, saying that you should always respect FileMaker " dark brandy"in the sphere of corporate IT tools and "cement", building creaking of impersonal systems and at the same time giving accessibility to the employees and at the same time kindly coding an interface for making money.

“Yakby I told the IT manager about the use of a tool that could be connected to SQL Server, MySQL, DB2, PostgreSQL and Oracle, with the possibility of an active connection, and with the help of which I allow a single manager and navigate to the end of the shortest possible time to create programs, like many hundreds of run under OS X, Windows and iOS, then whether such an IT manager would singly want to know the details, - even political. - Regardless of those that FileMaker did a good job of over the diversity of connection options, the platform was left with such an accessible and easy one for the vicarious, which was always there. So, just like with other Apple products, they reported great achievements to the point that the hardy, with some level of preparation, could quickly open up the FileMaker core and start creating powerful programs, without loosing your shoulders to learn computer technologies in the gallery ".

FileMaker 15 also features a host of new features to ease some of the confusion and increase productivity, while also introducing new licensing options to retail teams. FileMaker 15 introduces a new, simpler way to revoke licenses for FileMaker security software in teams of five or more people. In the words of the representatives of the company, the skin can be processed in FileMaker Pro (with a User Connections license), FileMaker Go or FileMaker WebDirect (all services are distributed on the FileMaker Server) and safely exchange information in real time.

Tim, FileMaker recently released the latest SDK for iOS and updated it for version 15.

“Tse bula, mabut, the most cardinal change,” respects the politician. - So now it's enough to learn how to expand in FileMaker - and you can create programs for expanding everything through MDM-systems (mobile device management, mobile device management) and navigate through the iTunes store. Knowing Swift and Xcode is neo-language. Tse just in the head is not invested. Literally for a penny for a few days instead of months, you can put your ideas on the iPad, using FileMaker to expand the add-ons.

For information about the necessary level of technical qualifications, which is the fault of mother koristuvach, so that mother can create additives on FileMaker, Іpolit vіdpovіv: “Well, for example, my 66-year-old father of the past fate, having created his power additives and reminded the beast to do not change. But despite the fact that the new recorder on the video recorder has the hour 12:00, because I don’t know how, I’m yogo vistaviti. So, the new dosi has a video recorder.

Lecates, to his credit, by stating that the top dilemma "make your own or buy ready-made additions" for the FileMaker business is claiming those to fill a niche with these options.

“Buy the program, it doesn’t matter, but it won’t be necessary for you to work those that you need,” explaining wine. - And rozrobnih lock programs can take a lot of time and cost a fortune. We care that FileMaker is going to have two options and will go into its own best power.”

Personal DBMS FileMaker has been developed for more than thirty years on the Apple platform and may not compromise Microsoft Access capabilities. Then there are a few features that make this product accessible to non-professionals and allow you to create a working prototype of the program for the iPhone or iPad.

Programming skills are put to the test on Microsoft database Access and other similar benefits from confusion and anxiety. The stench mayut for someone else. Zavdannya, yakі vyrіshuyut for the help of such rozrobok, mayyyyyyut far-sighted, harder that correct decision. But it is unlikely that the floorings are simple, cheap and accessible for coristuvachiv, and the criteria are often important for the abstract "correctness". This is especially mindful, if you are right with one of Access's competitors - Addendum to FileMaker Pro 14.

Like Access, FileMaker Pro is also a database management system and it is possible to use software extensions for access to these databases, including as many as possible (both locally and via the Internet for an additional stellar browser. Stop, then, use FileMaker Server) . If you want a strong scripting language in FileMaker Pro, you can do without it for the most part.

A new version of the product, which has appeared on the cob of grass, is being modernized by the interface (gradієnti, from the same vіn folded earlier, looked marvelously in Windows 8 і OS X 10.10) and will be rebuilt by the script editor. In addition, new elements of the interface and the possibility of their implementation have appeared.

FileMaker less entries, lower Access, but do not start. Tsya program may be old and lost in history. Її Perednik - one of the first database management systems for MS-DOS, which appeared about 35 years ago. When Apple released the Mac, the creators of FileMaker immediately moved to the new platform. Unexpectedly, their brainchild gained such popularity that at Microsoft they started working on the development of their own DBMS - the competition was vicious. Tse hindered the appearance of Access for five years.

The success of FileMaker has been short-lived. At ninety years of age, having spent their conquest, having taken a leading position in the market of software for Mac OS, having experienced not the best hours. Twenty years later, FileMaker Pro will become the most popular add-on of its kind that runs on OS X (the Windows version, of course, is also the corporate market without it). If you want the whole product to be equal with its competitors in terms of functionality and propratiovanization, you can achieve one glance, to understand: you are not copying them, but developing independently. FileMaker Pro is self-supporting and needs to be done easily.

While Access voluntarily, version by version, turns its faces to professional retailers, FileMaker Pro has tried to keep its focus on non-fachists. Pratsyyuchi with him not to start programming and knowing the databases, but to do it easily. It's as easy as creating a spreadsheet on the basis of FileMaker Pro with a non-standard interface.

Another one tsіkava singularity which product - iOS support. FileMaker Pro permissions allow you to create interfaces for manipulation on the screen of a tablet or a phone, and then run it on an iPhone or iPad. If so, the data base is entered through the mesh, then whether the changes made to the interface or the data are immediately entered on mobile extension- and navpak. Tse, krіm іnshgo, I'll remake FileMaker Pro on the basis of a swedish prototyping of mobile add-ons.

Axis like creating a simple data base for help FileMaker Pro 14. At startup, activate the layout editing mode (Layout) or else call speeches by their proper names, interfaces. Layouts override FileMaker Pro's Access format. The skin table is to blame if you want one layout, but they can also be a sprat. The layouts will be the same screens of the program, as we can. In addition, they allow you to issue data for a friend on a printer, or, for example, save in PDF format.

Crimea to the layout editing mode, є Browse mode, which has a corystuvach interaction with interfaces and data base. If the layout editing mode in FileMaker Pro is converted to the middle of the expansion, then the mode will be reviewed in the creation of "additions", and the plan itself will be different.

Two other modes are vikorated more closely. Search mode (Find) of appointments for viewing the database of information, as it is not possible to take one of the ready-made layouts for help, and the revision mode allows you to tinker, as if it sounds like a friend.

Skip to the bottom of the data, it is necessary to designate the tables, de stinks will be saved. This allows the large button Manage to be located at the right edge of the toolbar in layout editing mode. Having selected the Manage Database item, we will see a dialog box with three tabs: Tables, Fields and Relationships. Tі, hto sticking with the data bases, guess what the stink is. The first one has to create that separate table, another one is needed in order to set their structure, and the third one needs to link to them.

Our test addendum will be a primitive likeness of CRM and will be recognized for the appearance of the guardians. Obviously, we need a table for zamovniki and a table for animals. In addition, I’m going to make a table for vikonavtsiv: there is a list of spivrobitnikiv, how to vikonuyut animals.

Types of fields are significant, and especially two of them merit only two of them: Calculation and Summary. A field that has one of these types can be aligned with the center in spreadsheet, where the data is entered in the formula The Options button allows you to configure how the value is saved in the field when new record, and specify the criteria that you may be satisfied with the value of the field.

The Relationships tab is needed to match foreign keys, or to match FileMaker Pro terminology, “match fileds”. At the Zvernennya table, we have two external keys: the field "Zamovnik" can be equal to the identification number of a particular record in the table "Zamovniki", and the field "Vikonavets" - the same, but in the table "Vikonavtsi". The deputy of jealousy can win over other operators, but it is not necessary for our task.

Closing the Manage Database dialog box, we can see that FileMaker Pro automatically created the skin table layout: behind one simple form with the skin page entry field. In principle, it is possible to revise them: in the regime of revisiting, it is possible to add new entries with the help of forms, or to revise the existing ones. Ale better not to swell, but to doopratsyuvati їх. Tim more tse not so already th smoothly.

Promotion available only to members

Option 1. Come to the “site” to read all the materials on the site

Membership with a jointly assigned term grants you access to all materials of the Hacker, to increase the special accumulative discount and allow you to accumulate a professional Xakep Score rating!