Aller au contenu

Blogs

 

Fiche Astuce n°126 – les actions Suspendre/reprendre script et Installer script sur temporisation de FileMaker

Maîtriser le temps d’une action… Il y a parfois avec FileMaker des moments magiques… Pour ne rien vous cacher, j’en ai vécu un en réalisant cette dernière fiche Astuce et si j’en crois la réaction de Jean-Luc, l’un de nos relecteurs, il en a été de même pour lui 😉 C’est en effet magique de créer […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Thinking About JSON, part 1

I’ve been working on a couple large JSON projects over the last few months, and with the one year anniversary of FileMaker having built-in JSON capabilities just around the corner, this seems an opportune moment to share some reflections and opinions (some of which may contradict JSON-related opinions I have expressed previously). Demo file: json-sandbox.zip […]
Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

 

Ultimate Card Window Control

FileMaker 16 changed the entire landscape of how many things are accomplished within FileMaker. Because of the ability to show a completely different context as a new Card Window, you can now do all kinds of wonderful things. Need an interactive sidebar? Use a Card Window. Need greater degree of control over your custom dialog boxes? Use Card Windows. Need to present a pick list, a palette or pretty much any information you could ever want to display in a dedicated child window? Used Card Windows! Awesome, so we now have Card Windows. But, the immediate utility may not seem as powerful as it could be when the Card Window defaults to the same size as the layout upon which it's based. Plus, if you want to position the window relative to its parent you need to be ready to do a bit of simple math. So, why do the simple math when you can make it even more simple? That's what this video is all about - Ultimate Card Window Control! Click the title or link to this article to view the video.
Afficher la totalité du billet

FileMaker Magazine

FileMaker Magazine

 

QR 85 – Limiter l’accès à certains enregistrements dans FileMaker (1)

FileMaker gère de manière fine et précise les droits d’accès des utilisateurs et leurs privilèges. Nous avons consacré à cette question trois fiches Astuces, les fiches Astuces 79, 80 et 81 sur les comptes utilisateurs et les privilèges d’accès. Nous avons vu par exemple qu’il est possible de limiter l’accès d’une base de données à […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Cherchez Charlie

Malgré la sueur, vous reconnaîtrez ici quelques visages https://www.facebook.com/filemaker.1.more.thing/videos/10160338267475584/  

fabriceN

fabriceN

 

Une Nova pour Alfred

Ou comment une agence de communication transforme sa façon de travailler grâce une solution de gestion de projets. C’est ainsi que l’agence de communication Montréalaise présente la manière dont elle conçoit la relation client et la conduite de ses projets. Des services de création publicitaire, planification stratégique ou encore d’identité de marque, les équipes d’Alfred recherchent toujours l’échange et la compréhension des besoins afin de faire naître des idées innovantes et porteuses. Cette approche de travail a d’ailleurs porté ses fruits, puisque l’agence, créée en 2003, a doublé ses effectifs au cours des dernières années, comptant aujourd’hui une vingtaine de collaborateurs. Retrouvez les réalisations d’Alfred ici.Au vu de cette croissance, Antoine Bernier, directeur financier d’Alfred, a ainsi décidé de doter l’agence d’une solution pour gérer plus efficacement les projets et le système de facturations. C’est ainsi que ce “gardien des facturations”, tel qu’il se définit, va initier un processus de changement au sein de l’organisation. Vers une solution intégrée… 📈 Auparavant, Alfred utilisait une solution Web-based pour les feuilles de temps, effectuait les devis sous Excel et avait également son propre système de comptabilité interne. Antoine, intéressé par les nouvelles technologies et l’informatique, va ainsi commencer à se renseigner sur les solutions qui pourraient convenir à l’agence. Il repère premièrement une solution Web-based mais non disponible en français. “Pour notre activité, il est essentiel d’avoir un logiciel bilingue. L’ensemble de nos documentations et facturations doit en effet pouvoir être envoyé en français”. Rapidement, Antoine réalise qu’une solution basée sur FileMaker serait la plus adaptée aux besoins de l’agence. www.casserolenova.comAntoine assiste ainsi à une présentation de Casserole Nova, une solution développée par Fin Finaud, partenaire officiel et membre de FileMaker Business Alliance. Cette application, utilisée par 125 entreprises dans la seule région de Montréal, comporte une suite complète d’outils, adaptée pour des organisations comme Alfred : de la planification des projets, au suivi des budgets, à l’allocation des tâches et la création des devis et factures. Antoine commence ainsi à travailler avec les équipes de Fin Finaud pour l’implémentation de cette application au sein de l’agence. www.finfinaud.com…aux bénéfices nombreux 👌 Casserole Nova est aujourd’hui utilisée par l’ensemble des collaborateurs d’Alfred. En fonction des missions de chacun, l’application offre la possibilité de définir des niveaux d’accès utilisateurs. Cela permet ainsi à l’agence d’ajuster ses coûts d’une part, et de proposer une solution adaptée à chacun des membres d’autre part, qu’ils soient de l’équipe création ou du service clientèle par exemple. Ces derniers apprécient en outre la possibilité de partager des informations plus aisément, facilitant ainsi la collaboration entre les équipes. L’outil de communication interne à Casserole Nova, “Bla Bla”, permet, par exemple, de conserver un historique pour l’ensemble des projets de l’agence en matière de suivi des échanges, facturations ou temps passé. Aussi, les collaborateurs ont à présent la possibilité d’inscrire le temps qu’ils consacrent à chaque projet directement dans Casserole Nova. Il est par ailleurs plus aisé pour Antoine d’exporter des données de l’application et d’effectuer les rapports qu’il souhaite. Pour chaque projet, ce dernier dispose en effet d’un tableau de bord lui permettant d’en contrôler l’état d’avancement, la rentabilité, d’en analyser le coût et de suivre le budget. … et aux possibilités multiples ⚡️ Avec la version mobile de Casserole Nova disponible prochainement, les membres de l’agence pourront remplir leurs feuilles de temps directement sur iPhones ou iPads, sans avoir besoin d’être au bureau. Les entrées de temps pourront ainsi être effectuées de manière quotidienne. Cette flexibilité offerte aux salariés permettra en outre au service comptable de disposer d’informations plus précises et à jour. Et le Champagne dans tout cela… ? Savouré, avec modération bien sûr 🍾 Pour plus d’informations sur la plateforme FileMaker, RDV sur notre site Internet. Découvrez l’ensemble des fonctionnalités de Casserole Nova ici. Une Nova pour Alfred 💫 was originally published in FileMaker Fr on Medium, where people are continuing the conversation by highlighting and responding to this story.
Afficher la totalité du billet
 

Créer des préférences dans vos solutions FileMaker (9)

Des préférences sur l’interface utilisateur Des préférences pour l’applicatif ? Cette fois-ci, nous abordons les préférences qui portent sur l’applicatif, c’est-à-dire sur l’app que vous avez développée et qui contient les données à partir desquelles votre client travaille quotidiennement. Pallier à une carence du logiciel FileMaker ? Précisons qu’au niveau des Préférences, le logiciel FileMaker lui-même […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Getting Started with FileMaker and REST

Representational State Transfer (REST) defines a set of standards and principals commonly used to provide web and application developers an Application Programming Interface (API). Built atop the HyperText Transfer Protocol (HTTP), REST is commonly used for viewing web pages. You are currently reading this blog post using HTTP. FileMaker and REST In every HTTP request, there is a specified method. If you type in a URL and press enter, the Method used is GET. If you submit a form on the web, you most likely use the POST Method. The difference is that a POST request can include a payload that is not part of the URL. GET requests, if they include data, will include a question mark at the end of a URL and path. This is followed by data that usually appears in key-value pairs. RESTful services may or may not use key-value pairs and instead include all needed data in the URL path. Usually, data is transferred in XML or JSON as part of a POST payload in the HTTP request. In general, following REST methodology, a GET request is used to read data, whereas a POST request is used to create a resource. These correlate to database interaction known as CRUD, or Create, Read, Update, and Delete. Modern versions of HTTP also support PUT and DELETE methods, which REST then commonly translates to Update and Delete database operations. PUT and DELETE are functionally identical to POST requests, the only difference being that the method specified is different. This also includes encrypted in-transit information if you are using SSL and specify "https" in your URL. FilerMaker "Insert from URL" Script Step With me so far? Good. So how does FileMaker work with RESTful APIs and web services? With FileMaker 16, there was a lot of changes to the Insert from URL script step that allows you to use cURL functions. This also works across the entire FileMaker platform, so this includes server-side scripts as well as WebDirect and FM Go. Anatomy of the script step: Figure 1: Configure the script step Figure 2: Specify target The script step is configurable with several options. You can specify a Target, which can either be a field or a variable (see Figure 2). To specify a variable, select that option and give the variable a name you can reference it with, so you can use it later. Whether you use a global variable or not depends on where you need to use it. Then specify the URL, which is the base URL and usually the complete path to the resource you are working with. Specify cURL Options Then there are the cURL options, which give you access to an entire library of functions for handling web requests. FileMaker supports quite a bit, but not all, cURL functionality. I recommend checking that documentation. There are a couple points of interest when working with cURL options in FileMaker, specifically. The syntax for specifying variables can be confusing. You create a variable like you normally would, with a single or double dollar sign. However, when specifying the calculation to result in your desired cURL options, the variable name is INSIDE the quote marks, like so: "--data @$myVariable" This makes more sense if you are familiar with using the curl application with command line in a terminal window. For example, to upload a file with a command line, you use the atmark (@) and then the path to the file you want to include. Similarly, an atmark tells the cURL options in FileMaker where the variable you want to include resides. Referencing variables this way will also take care of any needed quoting, so your data does not break during transit. When you send any kind of payload in the HTTP body using "--data" or "-d", then POST is used by default as the method. If you need another method, you can specify it with the "--request" or "-X" flag in your cURL options. Another point of note: using the "-D" or "--dump-header" option that allows you to get any returned HTTP headers and store them in a variable. This is especially important, as many RESTful services will return error codes as part of the HTTP header returned. By the way, most cURL options are specified with flags, like "-D" above, but most also have the option to use a more verbose variant, which can be more readable, like "--dump-header". They both work the same. One more...since most RESTful services expect the payload to be JSON, you will also want to specify that as an HTTP header, like so: " --header \"Content-Type: application/json\"" If the payload is XML, for example, you would change the content-type to match what you are sending, like text/xml. This will depend on the web service you are integrating with. Troubleshooting "Insert from URL" Scripts Trying to debug and troubleshoot when working with Insert from URL results can present challenges. It's a little like working blind, where you construct a request and send it off without seeing how the request is being received on the other side. There are a couple websites that allow you to create endpoints that log requests and then view them. In my experience, however, they can be unreliable or slow. To that end, I have written my own debugging tool that helps return information about requests sent with FileMaker. You can use it for free and put it on any web server that can serve PHP: https://github.com/SoliantMike/PHP-HTTPDebug If you already have FileMaker Server, you can simply enable the web server with PHP and use it from there. Once hosted, simply point your Insert from URL script to that PHP scripts URL and test any cURL options you need. Results are returned in plain text instead of HTML, since you would view the output in a FileMaker field or variable anyway. Other Factors Concerning FileMaker and REST You can encounter a host of other factors involved when working with APIs and web services. Those can include oAuth or information in your HTTP headers, such as signed requests or size information. It all depends on the service with which you integrate. This guide should help you start with the basics. Resources REST (Representational state transfer) CRUD (Create, read, update and delete) Available cURL options in FileMaker The post Getting Started with FileMaker and REST appeared first on Soliant Consulting.
Voir le billet d'origine
 

FileMaker EDI Integration

FileMaker EDI Integration Electronic data interchange (EDI) is used by businesses to electronically exchange standard business documents. EDI standards help reduce cost of processing email or mail-in orders and can speed up business by simplifying communication between two companies. Amazon, Walmart and many other companies use established EDI standards to process their orders securely. Supply Chain Insights published a study showing that 55% of customer orders are received via EDI, placing EDI on the #1 spot of multi-party business exchanges. Integrating EDI with your FileMaker solution can automate your order processing and allow you to connect to large retail partners using this technology.  EDI Standards Handling EDI can be tricky when there’s multiple standards in play and with retailers having different sets of fields they require in order to process requests. EDI platforms like SPS Commerce can help you figure out the required fields for a particular document and industry, and translate a simpler XML format provided by the platform to the actual standard’s format. To illustrate how complex a standard’s format can be, and why platforms like SPS Commerce provide XML versions of these complex formats, below is an example of a purchase order written in EDIFACT EDI standard. UNB+UNOA:1+US::US+50138::THEM+140531:0305+001934++ORDERS' UNH+1+ORDERS:91:2:UN' BGM+220+A761902+4:20140530:102+9' RFF+CT:EUA01349' RFF+AAV::C' TXT+THIS IS WHAT AN EDI MESSAGE WOULD LOOK LIKE... ' NAD+BY++OUR NAME PLC::::+++++EW4 34J' CTA+PD' COM+01752 253939:TE+01752 253939:FX+0:TL' CTA+OC+:A.SURNAME' COM+2407:EX' CTA+TI+:B.BROWN' COM+0:EX' CTA+SU' COM+0161 4297476:TE+01752 670633:FX' UNT+15+1' UNZ+1+001934' And below a purchase order document like above but written in XML format: <PurchaseOrders> <PO> <ID>123</ID> <date>4/3/2018</date> <customer>DB Services</customer> <firstName>Gayoung</firstName> <lastName>Moon</lastName> <email>gmoon@dbservices.com</email> <item>Sunglasses</item> <price>200</price> <quantity>1</quantity> </PO> <PO> <ID>234</ID> <date>4/4/2018</date> <customer>DB Services</customer> <firstName>Test</firstName> <lastName>Customer</lastName> <email>gmoon@dbservices.com</email> <item>Desk</item> <price>400</price> <quantity>3</quantity> </PO> </PurchaseOrders> Not only is the XML version easier to read and follow, it’s much easy to program, especially considering that one EDI document can have thousands of possible fields to pick from, as EDI is used across almost every industry. General Approach to EDI Integration as a Vendor EDI platforms like SPS will require that you read or write XML files from an FTP server they provide. In the case of handling purchase orders from a retailer like Target, your FileMaker system will need to periodically scrape the FTP server’s purchase orders folder for all new PO documents, import them into your FileMaker system, and delete them from the folder. Then you will parse each PO XML document in FileMaker and create or update purchase orders in your database. For example, you could use the xmlGetElement function from the demo file to parse the purchase order XML. Set Variable [ $ID ; Value: xmlGetElement ( $eachPO ; "ID" ) ] Set Variable [ $date ; Value: xmlGetElement ( $eachPO ; "date" ) ] Set Variable [ $customer ; Value: xmlGetElement ( $eachPO ; "customer" ) ] If your retailer requires it, you will also create an purchase order acknowledgement notice XML file and upload it to the FTP server in a different folder. The insert from URL cURL options would look something like this: "--user " & $user & ":" & $pwd & " --ftp-ssl" & " --upload-file $xmlfile --header \"Content-type: application/xml\"" As your employees process new purchase orders, statuses of each purchase order will change and your FileMaker system will need to create another type of EDI XML document with all active purchase order status and shipping information. This document will then be uploaded to the corresponding location on the FTP server. In addition some retailers require frequent updates on your inventory levels, which is another type of EDI document, called an inventory query document, that you will need to create create and upload to the FTPS server. Check out the demo file below to see simple EDI examples. The file uses the native FileMaker Insert from URL script step to connect to FTP and BaseElements plugin to parse XML documents. Conclusion If you want to work with retailer giants like Walmart, Target, etc, you will be required to process orders using EDI. And handling orders this way can allow your company to work on them real time and cut down on time spent manually communicating your inventory and order status. Contact us if you need help with integrating your FileMaker system with an EDI platform. Download FileMaker EDI Integration Please complete the form below to download your FREE FileMaker database file.
Name* First Last Company Phone* Email* Deployment Assistance?Please contact us to assist integrating into your FileMaker Database. Yes Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime.
Afficher la totalité du billet

DB Services

DB Services

 

No Duplicate Emails

FileMaker Pro has some very simple and straight-forward validation options. For example, if you only want one field named email to only ever have a single copy of a given email, you choose the Unique option in the Validations section of the field's options. But, what if you want to allow a given contact record to have multiple email addresses. How do you check for uniqueness across multiple fields? The same email could appear within one field and then would be perfectly valid in a second field which doesn't contain the original email. Well, here's the solution. Watch this video and use the provided technique file to simply copy the solution into your own FileMaker database. We'll use some creative tricks in order to make the process both robust and very powerful! Click the title or link to this article to view the video.
Afficher la totalité du billet
 

Créer des préférences dans vos solutions FileMaker (8)

Utilisation de bases spécialisées Nous avons vu notamment pour la gestion de la TVA qu’il était utile de connaître le pays du client. En fonction du cœur de métier de votre client, il peut lui être nécessaire de retrouver par exemple tous les contacts de la base qui sont dans un domaine d’activité bien précis. […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Azure AD (Active Directory) Authentication with FileMaker

In addition to the more typical external authentication methods, FileMaker supports client authentication using OAuth accounts from Google, Amazon, and Microsoft. In this instance, I needed to set up a FileMaker Cloud server to use a company’s directory accounts, which were hosted at Azure. In order to set this up I hit a couple of […]
Afficher la totalité du billet

vincenzo

vincenzo

 

Créer des préférences dans vos solutions FileMaker (7)

Gestion financière et administrative Nous avons vu la semaine dernière que les préférences que nous créons dans FileMaker peuvent porter – et doivent porter – prioritairement sur des données concernant notre métier, que ce soit d’un point de vue commercial, marketing ou production. Mais la vie d’une entreprise, pas davantage que celle d’une association, ne se limite pas […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

What is an MVP?

My favorite aspect of my job at MainSpring is discussing the myriad of great ideas that our clients have, and helping them turn those ideas into a solution. One of the biggest challenges in this process is helping people understand the value of starting off small—and that starting small is the first step toward achieving the ultimate goal. It’s easy to be entranced by your ideas and want to do everything immediately, but there are a number of definite advantages to starting off with the Minimum Viable Product (MVP).  The beginning is not the end  You’ve probably heard the term MVP used a lot in the technology space, and this largely stems from modern application development methodologies that stress early delivery and flexibility as the keys to delivering great results. The basic premise of an MVP is to deliver the smallest possible feature set while fulfilling the core requirements of the users. Building an MVP comes with the understanding that there will be more work required to achieve the ultimate goal, and that the ultimate goal is best achived through confident organizational buy-in and informed decision making.   Planning through evaluation  Choosing to develop an MVP can seem antithetical to the motivation to build a custom app—you know you want everything, so why not plan for everything from the beginning? The truth is, it’s inevitable that, once the users get their hands on a custom app, the requirements change.  Perhaps the most important reason for building an MVP is to get users involved in the feedback cycle that fuels the requirements for further development. Shifting the focus to requirements for further development is incredibly valuable; therefore, planning based upon the evaluation of what you’ve already built delivers the most valuable features.  Gain adoption through delivering value  Developing an MVP first verifies that the custom app is a viable solution because it only requires a small initial investment, yet it delivers value right away and builds stakeholder buy-in.  Seeing that value upfront is crucial to helping an organization determine three things…  How much they should build  How fast they should build  How they should prioritize what to build  The value produced from the MVP defines the case for further investment and drives the engagement of users who will operate the tool.  Learning how to achieve together  Many of our clients have never worked on a custom app development project, or even used an interactive process to accomplish a project—and it’s definitely a learning experience. One of the overlooked advantages to the MVP approach is that clients are able to learn about the development process through hands-on experience working with developers. At the same time, our consultants get to learn about your team, your company and your industry.  The post-deployment evaluation of the MVP generally serves as a sort of “shakedown cruise” for the whole team. Essentially, we get to evaluate our interactions with our clients and discuss how we can achieve better results together, which allows us to deliver more value in future development. 
Afficher la totalité du billet

MainSpring

MainSpring

 

Créer des préférences dans vos solutions FileMaker (6)

Des préférences sur les données en rapport avec votre métier Définir la relation avec les contacts de la base Si vous développez une base commerciale, c’est que celle-ci est censée gérer une relation avec une clientèle ou une patientèle. Or, certaines informations concernant cette relation peuvent vous être utile pour savoir où vous en êtes avec […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Working with FileMaker Cloud Backups Using SSH

Recently, I needed to revert a database file hosted on a FileMaker Cloud 16 server. Due to a problem I was having with the Download function however I had to take a different route from the usual method. The first steps in this process went normally. After I determined which backup was the best available, […]
Afficher la totalité du billet

vincenzo

vincenzo

 

FileMaker across borders

Through my annual visits to FileMaker DevCon, and my recent trips to the Japan FileMaker Conference and Quebec FileMaker Conference, I’ve met a lot of great people from the worldwide FileMaker community. One thing I’ve found is that many people don’t realize that the use cases for FileMaker can vary as much as the developers making their apps. Therefore, I’m happy to share some of my experiences and things I’ve learned from communicating with developers across the globe. FileMaker data security In Europe, one of the major concerns right now is data security. As this recent thread in the FileMaker Community points out, the new GDPR regulations in Europe will soon take effect. With that comes a greater responsibility for app developers to take a security-forward approach to developing data-driven apps. In America, we have similar approaches for apps that require PCI and HIPAA, but something like GDPR affects a much broader app market. We can learn from this by taking security-forward approaches to our own apps. For instance, we recently conducted internal security testing that lead to the discovery of a flaw in FileMaker WebDirect 13 and 14. That’s why it’s so important to audit your own systems on a regular basis. Contributing FileMaker ideas and issues to the community During my time at the conference in Japan, it was shocking to see and hear that there are so few consulting developers in Japan—so much so, that the conference itself was made up of tracks geared toward business prospects rather than developers. For example, an entire day and track was devoted to Healthcare. The vendors’ exhibits also varied greatly, focusing on vertical market products that were ready for sale, rather than developer tools, like at the North American FileMaker DevCon. Mike speaking at FMCJPAs the small-team FileMaker market grows around the world, so the citizen developer role has risen. A citizen developer is someone that bridges the role between a consultant, or professional developer, and just a regular user. In Japan, a lot of citizen developers are in the FileMaker community. They do lightweight changes on their company’s apps and may not be involved with sharing in the community. While this allows for conferences (like Japan’s) that are more geared toward business, it can lead to equal frustration from the professional and consulting community, as they end up not receiving the community support and innovation that other areas have. In fact, there’s always a large group of Japanese developers that attend FileMaker DevCon in the United States just for that reason. Consequently, it’s important to provide support in the community in a way that equally benefits all levels of developers. FileMaker user groups One last experience I’d like to share is that of user groups. FileMaker recently started promoting and setting up spaces for user groups inside the community, like my Central Ohio FileMaker User Group (COFMUG) space. This is a unique commitment to grow the community around FileMaker and allow for the entire ecosystem to grow. However, when it comes to FileMaker user groups, there is this phenomenon of “super cities”—where certain cities, like in southern California and Montreal, Canada, hold regular meetings with large groups of developers attending. In comparison, COFMUG struggles to keep a 5-10-person monthly attendance average. What’s more, I recently read about a developer that was trying to start a user group in Maine who was also worried about attendance… My hope is that, with these new community user group resources, the borders in our community will start to blur to the point where simply sharing ideas and concerns matters more than the developer’s geography. Growing the FileMaker community There’s a whole, wide world in the FileMaker community. It’s important for consultants, developers and users alike to start taking advantage of its resources. Explore the FileMaker Community site, attend some of the worldwide DevCon events and join as many FileMaker user groups as possible.
Afficher la totalité du billet

MainSpring

MainSpring

 

Reducing Available List Options

Whether you're just starting out with FileMaker Pro or you've been hovering in the intermediate zone for a little while, it's always a good thing to have a solid understanding of how to structure data and use the Relationship Graph in order to accomplish the end objective. When it comes to presenting a reducing set of available options, you have to understand how to get at what isn't being used in order to present it. The steps you need to take to show what isn't being used requires you to, first, know what IS being used. In this example technique file and video, we take a look at breaking down the individual parts which make it easier to understand how to present a list of reducing available options. Once you know how to create dedicated filtering keys and how to construct your value list, it should be pretty easy to present the data you want to present. Click the title or link to this article to view the video.
Afficher la totalité du billet
 

Le 22 avril, venez courir avec nous

Parce que nous aimons les données. Parce que la science moderne repose sur les données. Parce que nous avons besoin de la science comme la science a besoin de nous… et parce qu’on aime aussi bien rigoler… 1-more-thing sponsorise les 10km de l’ULB (Université Libre de Bruxelles), au profit de la recherche scientifique. Pour le […] Cet article Le 22 avril, venez courir avec nous est apparu en premier sur 1-more-thing.   >>> Lire la suite… <<<  

fabriceN

fabriceN

 

Your Guide to Using the FileMaker Data API to Enhance Your Application

What is the FileMaker Data API? Released in beta with FileMaker 16, the FileMaker Data API allows you to open up your FileMaker data to other systems. This makes the sharing of this data more straightforward than it’s been in the past. The functionality opens up your data capabilities through a variety of potential integrations. You can access your FileMaker data from any system that can make HTTP calls and accept JSON data in response. This creates hundreds, if not thousands, of opportunities for your organization. In the past, accessing your FileMaker data from outside systems required complex programming in XML, PHP or related technologies, often requiring the creation of middleware. With the FileMaker Data API, external systems can access FileMaker data directly, via the widely-used REST approach. This simplifies solutions and reduces the need for middleware or additional libraries such as ODBC. What Do You Need to Use the FileMaker Data API? You need a FileMaker Server license to use this functionality. How Can You Use the FileMaker Data API? The possibilities for this functionality are endless and ultimately depend on your business. The FileMaker Data API opens the door to your FileMaker data to work with other systems. This enhances your offerings and better serves your key audiences. You now have the capabilities of other systems at the disposal of your FileMaker data in a newer, faster, and more secure way. But what does this mean exactly? Here are a couple of use cases for several industries to give you an idea. Higher Education Colleges and universities can utilize the FileMaker API to bring data from various FileMaker solutions into common learning platforms. For example, they can connect Blackboard, a popular technology for student-teacher communication, with departmental systems that contain department-specific or course-specific information. From Blackboard, students could also modify data within individual departments’ FileMaker databases. Printing Large printing-software packages such as Heidelberg Prinect could query data from more agile line-of-business FileMaker systems. For example, sales leads stored in a FileMaker system could be queried in order to generate jobs and projects in the main Heidelberg system. Food & Beverage Companies with a wealth of product, distributor, customer, and other types of data at their fingertips have a significant opportunity to customize their offerings. First, however, they need to analyze their data with complex reporting to uncover necessary insights. With the new FileMaker Data API, data managers can connect their clients’ account data with Tableau. This popular data analytics platform makes analysis much easier and streamlined. School Districts While K-12 schools continue to heavily emphasize parent involvement in students’ education, many cannot determine the best way to communicate with parents about their students without reducing teachers’ time with students. For schools using a FileMaker database to track students’ progress, they can bridge the gap with a common communication application. This automatically pulls data from FileMaker and sending a daily update report to parents without monopolizing educators’ time. CMS Integration It’s been possible in the past to share FileMaker data with widely-used content management systems (CMS) such as WordPress, Drupal, and Joomla, to name a few. The FileMaker Data AI makes it faster and simpler. CMS users can inspect data stored in a FileMaker database, and integrate that data directly into web pages. Users could also send data back into FileMaker. For example, they can addresses and other profile information inside WordPress. This data would then be sent back and stored in a FileMaker System. Enterprise Integration Platforms Enterprise Integration Platforms such as Informatica and Dell Boomi bring together data from many disparate sources across an organization. For example, an organization may wish to bring together data from Salesforce, ERP systems, EDI systems, CMS systems, and distributor catalogs. With the FileMaker DATA API, these platforms can easily query data from FileMaker and include it in their overall integration architecture. Infinite Capabilities Of course, these are just a few examples. The FileMaker Data API can bridge thousands of applications to drive more power with your data. You can connect Quickbooks to FileMaker, pulling customer data into your invoice process automatically to make your internal workflows more efficient. Through a Toggl-FileMaker integration, you can report on how your employees spend their time by data organized in FileMaker, such as project or task data. We recommend brainstorming how your existing business applications could work together to improve efficiency and speed up your workflows. Then, you can move onto exploring other systems and how you can gain greater insights by connecting them with your FileMaker data. How Much Does the FileMaker Data API cost? This is a trickier question. At this point, it’s unclear how FileMaker plans to license this functionality. They probably won’t announce their intentions until FileMaker 17 is released. We don’t anticipate the FileMaker Data API carrying a significant added cost for typical users. Our guess is that costs will be data volume based, as opposed to call volume based. In other words, the more data you plan on sending through the API, the more you should expect to spend. This is all conjecture, though. We I do recommend getting an idea of what kind of value you expect so that when pricing is released, you can weigh costs versus benefits. Next Steps While still in beta, this functionality is already quite powerful. You can start exploring benefits for your organization right away and prepare for a full version launching with FileMaker 17. Since the announcement of the FileMaker Data API, we’ve been helping our clients understand and leverage its capabilities. We’ve been empowering organizations to connect their FileMaker data to external systems for years through our free SimpleFM and fmDotNet tools and have years of experiencing in this area. To showcase this experience, we will be delivering a session at this year’s FileMaker Developers Conference. Join us for “IoT and the FileMaker Data API: Sending Sensor Data to FileMaker Server from a Raspberry Pi.” We’re happy to help you navigate the best path forward with the new API. Contact us to schedule a call with our team of certified FileMaker consultants today. For a great introduction to how to use the FileMaker Data API functionality, check out this helpful article my team wrote. The post Your Guide to Using the FileMaker Data API to Enhance Your Application appeared first on Soliant Consulting.
Voir le billet d'origine
 

Truc n°84 – Apparence des étiquettes de boutons dans FileMaker

De belles possibilités de travailler sur l’apparence d’un bouton ! Si vous vous êtes un peu arrêté sur le petit fichier livré avec la fiche Astuce n°125 que je vous ai fournie vendredi dernier, vous avez pu remarquer que j’ai un peu travaillé l’apparence des étiquettes des segments de la barre de boutons permettant d’activer […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Full-Featured PDF Viewer Embedded in FileMaker

Integrating A JavaScript PDF Viewer Into Native FileMaker—No JavaScript Coding Required! We recently built an application that included PDF document management. While it might seem as simple as a quick FileMaker container field, we wanted to impress our client with an integrated solution on par with a content management system (CMS). Here’s how we built […]
Afficher la totalité du billet

vincenzo

vincenzo

×