1 Reply Latest reply on Apr 1, 2011 12:57 PM by TSBear

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

    IwaoAVE!

      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