From the course: FileMaker Pro Essential Training (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Importing data

Importing data - FileMaker Pro Tutorial

From the course: FileMaker Pro Essential Training (2019)

Start my 1-month free trial

Importing data

of a FileMaker custom app is to store and manage a bunch of different data. And the best way to get large amounts of data into your app, is to do what's called an import. So, for example in this case, I have a Products table. And that Products table does not have any records in it. And in our example, let's say there's another application that has a lot of Products data, or connect via API, which are both native functions in FileMaker that can extract data from other applications. So, in this case let's say we just have to dump data out of this other application so that FileMaker can import it. First, you'll need to export that data in a format that FileMaker supports for Import functions, for example, other FileMaker Pro Advanced files, custom-separated values, comma-separated values, merge files and Excel, in both different file formats, the .xls or the .xlsx, and even dBase files. So, let's say in this example our other application can dump data out in the form of an Excel file. So…

Contents