- There are many different ways to get data…into your solution, most of which involves…creating records while you're…inside your FileMaker solution,…but what if you have data…that was created elsewhere?…In that case, you want to do what's called…importing data into your FileMaker solution.…So I'm gonna show you how to do that in this movie.…First of all, let's take a look…at the database that we've got so far.…We can see under the Tables here…that we've got four of these tables…and three records and customers,…but no records in any of the rest of them.…
If you recall, in previous movies…I did have some data inside Products,…but for the purpose of this exercise…I've removed them.…So you can see we have zero records…in the Products table.…That's also evidenced in the upper left hand corner…by there being zero records indicated there as well.…So let's say that somebody has given us…an output from another system,…they've exported data out of another system,…or however that data was created,…but it's in a format that is not FileMaker.…
Author
Cris Ippolite
Released
5/12/2015- Comparing flat vs. relational databases
- Creating databases from starter solutions
- Determining what tables you need
- Understanding relationship types
- Defining key fields and creating relationships between tables
- Creating and working with fields, including container fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Working with layout themes
- Using layout parts and tools
- Formatting layout objects
- Finding and sorting data
- Creating value lists
- Printing and saving
- Building reports, including subsummary reports and quick charts
- Using the Calculation dialog
- Creating and triggering scripts in the Script workspace
- Working with script triggers
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome57s
-
Touring the Launch Center6m 44s
-
Using the exercise files1m 25s
-
-
1. Getting Started
-
What is a database?2m 35s
-
Exploring the interface5m 35s
-
-
2. Solution Creation Essentials
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields5m 27s
-
5. Working with Fields
-
Understanding field types7m 50s
-
Defining fields8m 23s
-
Adding fields to layouts5m 33s
-
6. Working with Container Fields
-
7. Working with Records
-
Editing and locking records3m 33s
-
8. Importing and Exporting
-
Importing data6m 25s
-
Exporting data4m 17s
-
-
9. Creating Layouts
-
Introducing layouts3m 18s
-
Working with layout themes5m 41s
-
-
10. Working with Layouts
-
Understanding layout parts6m 24s
-
Previewing the Inspector2m 23s
-
11. Formatting Layout Objects
-
Applying themes to layouts6m 35s
-
Applying screen stencils4m 2s
-
Applying gradients2m 43s
-
Understanding states7m 47s
-
Setting field behaviors4m 47s
-
Using the tab control feature12m 38s
-
Setting the tab order4m 9s
-
12. Finding Data
-
13. Sorting Data
-
Sorting with related fields2m 41s
-
Sorting using custom values2m 59s
-
Sorting using buttons4m 4s
-
14. Value Lists
-
15. Printing and Saving
-
Printing merge letters4m 52s
-
Saving as PDF or Excel1m 54s
-
16. Reports
-
Creating subsummary reports9m 35s
-
Adding charts to reports6m 54s
-
17. Calculation Essentials
-
Introducing calculations3m 26s
-
Using number functions6m 57s
-
Using text functions11m 50s
-
Using get functions5m 49s
-
Using logic functions12m 42s
-
-
18. Script Essentials
-
Touring the Script workspace5m 14s
-
Creating multiline scripts7m 56s
-
Using script parameters3m 48s
-
19. Script Triggers
-
Introducing script triggers1m 23s
-
Using object-based triggers9m 18s
-
Using layout-based triggers7m 26s
-
-
Conclusion
-
Goodbye1m 48s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Importing data