Solved

Filemaker Output

Posted on 2014-11-14
6
199 Views
Last Modified: 2014-11-14
Hi Experts,

I have a client that has an old Filemaker 12 database, we are replacing it with an SQL system. We need some kind of export of all the data inside the old one. The person who created it is not cooperating, and we're having trouble finding anyone that knows enough about Filemaker to do so.  We have an account for the DB with admin rights, but no idea where to start. We don't really care what format the output is in, as long as it's something we can read to CSV or Excel and prepare for import into the new system.

Is there some kind of script or function we can run to export ALL the tables to some friendlier format?

Thanks!
0
Comment
Question by:mylescardiff
  • 2
  • 2
  • 2
6 Comments
 
LVL 12

Expert Comment

by:North2Alaska
ID: 40443126
I can understand the feelings of the previous owner, but what you are asking for is not unreasonable.   That said, yes you can export the data.  Can you get to the relationship graph?  You need to start there.
0
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 40443680
You can probably manually export all records from each table and if this is a one-time export then it's probably faster than scripting it. You need a list of all tables which you can get from File -> Manage -> Database -> Table tab.  If you don't have access to that (which means you don't have full admin rights or what FileMaker calls a "Full Access" privilege set), then try the Layouts dialog (File -> Manage -> Layouts).

Each layout is associated with a table so open a layout for each table you want to export, use "Show All Records" from the Records menu or Status bar at the top, and then File -> Export...  I would recommend using the "Merge" format which is simply a CSV export with a header record containing the field names. Having the field names will be of great help as you do your conversion.
0
 
LVL 1

Author Comment

by:mylescardiff
ID: 40443731
Thank you for your responses.

Will, we've started an export of the first table as you suggested, So this will work, but it's pretty slow. The current table has about 8000 records, and it does about 1 per second. There are some other tables in the database that we know have 80,000+ rows. My guess is that it's slow because we're doing this from a client machine, Are you aware of any tools that could perform directly from the server side? Like you would with SQL Server Management Studio?

Thanks!
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 24

Expert Comment

by:Will Loving
ID: 40443772
Working from a client machine using hosted files will definitely make the export slower. The best speed will be from having a copy of the files open locally in FM Pro as opposed to connecting to a server via "Open Remote..."

The other thing that will make the export slow is if you are exporting summary and calculation fields. Assuming you have access to File -> Manage -> Database you can look at each table and see the field types. There is no reason to export Summary fields at all as they are generally used for reporting and rely on other fields only. Also look for calculation fields that reference other tables. These may have been added for reporting, appearances, dialogs, etc. and are most likely unnecessary as they also reference other fields and do not contain raw data. Global fields also do not need to be exported and container fields will not give you anything of value in a CSV export.

If you don't have access to the full field list you might be able to determine which fields are summary and calculation based on naming convention, but only if the original developer choose to use one. One convention is to include a suffix such as "_s" for summary fields or "_c" for calculation fields.
0
 
LVL 1

Author Comment

by:mylescardiff
ID: 40443779
Ok, great. This really helps!

Thank you!
0
 
LVL 12

Expert Comment

by:North2Alaska
ID: 40443782
If you have full access, you could set it up as and ODBC source and point a SQL tool at it to do the extract.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now