The FileMaker Platform gives you plenty of options for exporting data out of your app. You can export files as text or even a separate FileMaker file but in our experience, the most common export format is Excel. It’s pretty easy to export data out of FileMaker into Excel; the tricky part is customizing the headers of […]
Excel Exports using XML and XSLT All FileMaker developers spend time figuring out how to export FileMaker data in a usable format for their clients. Kevin Frank had a series of posts on just that subject (link in the next paragraph below). There is way to export data from FileMaker using XML and XSLT, but […]
Alex: Thank you Don. This will be super useful...
Don Clark: Glad to hear it, Alex. Hope things are going well for you!
FileMaker to Amazon Database I’ve blogged for four and a half years now, and in the past two years I’ve seen an incredible increase in both the quantity and quality of blogging in the FileMaker world. I’ve also noticed better posts, better writing, and posts on an incredible breadth of subjects – web connectivity, design, […]
Parsing XML Data Getting data from web sources is the trend in FileMaker (and all other languages) these days. With the popularity and breadth of web services available to your clients, it’s no wonder they need it. For example, your client may be using a web store order consolidation service, one that brings in all […]
Last January, Jesse Barnum spent two hours showing MirrorSync 2 t0 the New Mexico User Group. Sadly, audio recording problems made the video unusable and it was never shared here. So I am happy to see the below video from FileMaker Training Videos. MirrorSync 2 is an incredible product that will synch two databases very quickly: Go […]
FileMaker data to text file using Base64 Look out, FileMaker fans, there’s a new blogger in town. Joe Simpson of Radical Application Development, posted his first blog on October 5th, and shows us how to use the Base64 function to output different types of text files: Simple text files XML files Vcards Clearly outside the box […]
Emory Brown of DBServices digs into the XML behind the new (in FileMaker 14) SVG format for button icons: FileMaker 14 ushered in a new era of vector graphics with the advent of button icons. FileMaker comes pre-loaded with 140 very useful glyphs; additionally you can expand your collection with any number of custom glyphs and […]
Building an online form can be tricky, and linking it to FileMaker even more so. Tim Dietrich attacked the problem from a different perspective: Use an online form builder, Wufoo, to take the pain out of the web building side. Next, design a FileMaker solution, fmfoo, using PHP to link to Wufoo to FileMaker: I released […]
Kevin Frank has a guest blogger at FileMakerHacks, Guiseppe Pupita, an Italian FileMaker developer who has developed a modular way to process outgoing and incoming xml packets. He calls his technique wrap and unwrap: I developed a solution to send electronic invoices to the State Administration (for those who are maniac enough and fluent in […]
PARSING XML documents looks daunting, but don;t let that scare you. Once you get past the ugly look of XML and XSLT, it’s pretty straight forward. And since thousands of programs and websites provide data streams in XML format, learning how to process XML into FileMaker is a handy tool to have in your toolbox. David Nahodyl […]
XML HANDLES DATA. And makes it easily movable between different languages and computers and systems. That’s what it does, and it does it well. And FileMaker easily handles XML: FileMaker Pro can import XML data into an existing FileMaker Pro file, or convert XML into a new FileMaker Pro file. The XML can be a […]
John: Don, looks good. Only the final file is not a *.xlsx file, but a *.csv. In the movie it is…
Don Clark: Hi John, You can open the .csv file with Excel and then save it as a .xlsx file. Don