![Break[x]Berlin2013](https://gofilemaker.de/wp-content/uploads/poex2013berlin-artikelbild.jpg)
More than 20 sessions on FileMaker databases
In more than 20 sessions, workshops and presentations, interesting approaches were presented on how database developers can solve certain tasks in FileMaker even more effectively:
API fun: There are many really useful cloud or web services that extend the functionality of a FileMakerDatabase considerably. Learn how to deal with API interfaces, OAuth and the use of services such as Trello, FogBugz, Prowl, Teamviewer, Dropbox and many others.
Calculations vs. stored data in fields: Discussion on the pros and cons of non-saved formulas for saved values in normal fields, which can be created via Script be calculated. Which solution is best suited in which cases?
Client OffloadIn this session, the use of server-based services in FileMaker will be explained, with which a sometimes enormous increase in speed can be achieved in practice. Fabrice from 1-more-thing.com presents his solution FMSDIFM (FileMaker ServerSo It For Me).
Code smart - Not hardThis presentation by Claus Lavendt explains how functions can be created only once and then used throughout the entire solution.
Copy, Copy 2 and other Code SmellsIn this session, visitors learned how existing solutions can be optimized and redeveloped while making optimal use of existing code and minimizing development effort.
Data CarouselIn this session, Volker Krambrich presents ways in which fields in FileMaker can be named in an optimal and structured way. In a further session "Think Data in a New Way", Volker presents strategies and data models on how standard FileMaker solutions can be used flexibly for a wide variety of purposes. In this session, ideas for new data models in FileMaker were discussed.
Do more with SQL in FileMakerIn this presentation, visitors learned how the new FileMaker function ExecuteSQL() can simplify work in FileMaker considerably. For example, these new functions can be used to create formulas that contain values from other tables without having to link them in the relationship graph.
Experiences with syncingIn this presentation, Crispin presented ways in which data can be synchronized from FileMaker data. Using practical examples, he showed synchronization solutions and encouraged discussion about data synchronization in FileMaker.
feedzon - A More Awesome FileMaker - Features You've Always Wanted!With feedzon, a range of services and web services can be integrated into FileMaker solutions largely without programming knowledge. Some examples: Character recognition (OCR), business card OCR scanner in FileMaker GoGenerate 1D and 2D barcodes, FTP transfer, text to speech, translation, Dropbox support, SMS services, package tracking, geomapping, Google Contacts, Google Calendar, social networks, e-mail services, image manipulation and many other interesting services directly in FileMaker.
FileMaker in a material worldThis session discussed practical examples of how FileMaker solutions have been integrated into the processes of companies and institutions in a real-life environment.
Finding young talentsAlthough FileMaker is a database platform with many advantages, it is sometimes not so easy to find good young developers for FileMaker databases. This session will discuss opportunities and new ways to recruit young developers.
FMChallengeThis session showed how to develop a flexible mail merge module with the new ExecuteSQL() command in FileMaker. Using two example files, the author showed how small and large amounts of data can be optimally created with the ExecuteSQL() command and invited discussion on the topic.
FMPlanBThis interesting session was supposed to be about how to deal with the topic of "lifelong support for FileMaker databases". Although the session did not take place in this form, there was a lively discussion on this topic in a smaller group. FMPlanB is intended to show solutions on how FileMaker databases can continue to be maintained and supported even after the original developer has stopped working.
fmWorkMate - 10 Tools to Make FileMaker WorkFileMaker developer Russell Watson presented his FileMaker tool "fmWorkMate", which can make working in FileMaker much easier. The tool increases productivity in FileMaker, allows a more detailed analysis of FileMaker databases, FM-XML and logical text functions, creation of XML and XSLT transformations and optimized copying of FileMaker functions, even remotely.
Handling parametersIn this session, the standardized transfer of script parameters was discussed.
Optimization MadnessFileMaker developer HOnza alias "the Mad Optimizer" presented in this session interesting ways to optimize the speed of FileMaker databases and also introduced the tool "24U FM Bench".
Programming for large data setsThe best solutions for data models, formulas, stored and unsaved content and how to best visualize large amounts of data. How can a million data records be visualized in 2 minutes? Can reports be uploaded from the iPad to the server?
Super robust code, essential or obligatory? This session dealt with the question of how important "super robust code" is in FileMaker databases, i.e. how well errors are intercepted and processed in FileMaker. The more users have to work with a FileMaker database, the more important it is that all functions within the database run smoothly. During the presentation, various possibilities and the depth to which errors in FileMaker can be intercepted and processed by the developer were discussed.
Team DevelopmentThe development team from 24U Software shows in this presentation how FileMaker databases can be optimally developed in a team. The following topics were covered in a structured presentation:
- Introduction
- Advantages and disadvantages of team development
- Development tools for teams
- Developing databases with FileMaker Server
- Local development vs. development server vs. production server
- Conventions and technical documentation
- Collision risks of developers in the team
The Grid System used to design FileMaker layoutsYann Liqueur-Salzedo showed in this presentation how consistent user interfaces can be designed in FileMaker using the grid system, i.e. Guide lines in FileMaker using a specially developed tool for this purpose. During the discussion of the presentation, he went into great detail about the possibilities of developing professional user interfaces for desktops and iOS devices.
First Pause[x]Berlin 2013 a complete success

On Saturday evening, 15 FileMaker developers came together once again to enjoy a Berlin dinner in beautiful evening weather. During the conference days, many participants were also able to undertake joint activities outside the hotel complex during the lunch and evening hours.
To be continued next year


Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.

![nhow Hotel, venue of the Pause[x]Berlin 2013](https://gofilemaker.de/wp-content/uploads/poex2013berlin-nhow-hotel.jpg)

![Lecture at the Pause[x]Berlin 2013](https://gofilemaker.de/wp-content/uploads/poex2013berlin-session-2.jpg)