日本語のページはこちら

TableClipper

Overview

TableClipper allows you to copy tables and fields entered in Microsoft Excel worksheet and paste them into ‘Manage Database’ dialog of FileMaker Pro Advanced.
Example usage is…

• Generate tables and fields from a table design specification written in Microsoft Excel. See ‘Tutorial 1 : Table copy mode’.
• Generate field names with serial numbers using auto-fill feature of Microsoft Excel. See ‘Tutorial 2 : Field copy mode’.

Requirements

• Mac OS X (tested on 10.5.8, 10.6.3)
• FileMaker Pro Advanced 8.0 and later
• Microsoft Excel 2004 (test result with Excel 2008 would be appreciated)

License

Freeware

Download

TableClipper 1.0.dmg (97KB)

Tutorial

Field copy mode

Paste multiple fields into existing FileMaker table.

1. Create a new workbook in Microsoft Excel. Assuming the name of the new book is ‘Book1’ here.
2. Enter ‘Question 1’ and ‘Answer 1’ in the first sheet ‘Sheet1’ and generate 10 sets of questions and answers using auto-fill feature.
   
3. Launch TableClipper and choose ‘Book1.xls’ from the ‘Workbook’ drop-down list. If ‘Book1.xls’ is not listed, press ‘Refresh’ button.
4. Choose ‘Sheet1’ from the ‘Worksheet’ drop-down list. TableClipper works in field copy mode when worksheet is specified.
5. Configure TableClipper as shown in the following image.
   
6. Press ‘Copy’ button in the TableClipper window.
7. Create a new database file in FileMaker Pro Advanced and perform ‘Paste’ in the ‘Fields’ tab of the ‘Manage Database’ dialog.

Table copy mode

Generate multiple FileMaker tables from database desgin specification written in Microsoft Excel.

1. Open ‘Sample_english.xls’ in the example folder.
2. Launch TableClipper and choose ‘Sample_english.xls’ in the ‘Workbook’ drop-down list. If ‘Sample_english.xls’ is not listed, click ‘Refresh’ button. Leave the ‘Worksheet’ list unselected.
3. Configure TableClipper as shown in the following image. In the example workbook, the fifth row is the first data row and field names are in column ‘B’, data types in column ‘C’ and comments in column ‘D’. TableClipper takes worksheet name as table name.
   
4. Press ‘Copy’ button at the right bottom of the TableClipper window.
5. Table definitions are copied in your clipboard. Create a new database file in FileMaker Pro Advanced and perform ‘Paste’ in the ‘Tables’ tab of the ‘Manage Database’ dialog.
   

Options

Row Setting

First row

Specify the first row number of the data area.

Max rows to scan

TableClipper stops scanning when a field name cell is empty. If you want TableClipper to stop scanning on specific row, provide the row number here.

Column Setting

Field name

Specify the column which contains field names.

Data type

Specify the column which contains data types.

Comment

Specify the column which contains comments.

Data Type

Specify strings representing FileMaker data types. Multiple strings must be separated by comma.

FAQ

Q: What kind of data can TableClipper copy?

A: ‘Name’, ‘Data type’ and ‘Comment’ at present.

Q: Any plan for Windows version.

A: Nope.

Feedback

KEY_Planning on Twitter