AnsweredAssumed Answered

Updating matching records by importing records from an excel file works incorrectly.

Question asked by IwaoAVE! on Mar 28, 2011
Latest reply on Apr 1, 2011 by TSBear

Summary

Updating matching records by importing records from an excel file works incorrectly.

Product

FileMaker Pro

Version

11v3

Operating system version

Mac OS X 10.6.7, Windows XP Professional SP3

Description of the issue

When updating matching records by importing records from an excel file (.xls), an empty cell is ignored when there is no more non-empty cells in the same row.
As a result, records could be partially updated.

Steps to reproduce the problem

1. Create a table with three text fields 'id', 'value1', 'value2'.

2. Create two records as follows.

  id | value1 | value2
   1  | aaa    | 111
   2  | bbb   | 222

3. Create an excel workbook (.xls) with the following rows (the third column of the first row is empty).

   1 | xxx |
   2 | yyy | 999

4. Choose [File] -> [Import...] and select the .xls file created in step 3.

5. In the 'Import Field Mapping' dialog, choose 'Update matching records in found set' for the 'Import Action' and map fields as follows.
  first column <=> id
  second column -> value1
  third column -> value2

6. Execute import.

Expected result

The records are updated as follows.

id | value1 | value2
1 | xxx    |
2 | yyy    | 999

Actual result

The records are updated, but the 'value2' of the first record is not updated.

id | value1 | value2
1 | xxx    | 111
2 | yyy    | 999

Workaround

* If the imported file is CSV or TSV with the same content, it works as expected.

  * If the content of the xls file has a fourth column with some non-empty value, it works as expected.
  1 | xxx |        | DUMMY
  2 | yyy | 999 | DUMMY

Outcomes