AnsweredAssumed Answered

Must choose file type for import to work correctly

Question asked by ktuley on Aug 19, 2012
Latest reply on May 30, 2013 by kessingb

Summary

Must choose file type for import to work correctly

Product

FileMaker Pro

Version

12

Operating system version

Mac 10.8

Description of the issue

in previous versions of FMP, when importing a file, leaving the type on All Available and choosing a .csv file, correctly identified the file type. in FMP 12, user must choose csv as the file type in order to import correctly.
more specifically, if you attempt to import a csv file, with All Available selected, all fields attempt to import to one field.
works properly if you choose csv file type.

Same appears to happen for Tab-delimited files.

Steps to reproduce the problem

start import of file. leave file type as All Available. import csv, or tab-delimited file. all fields will be combined as one field

however if you choose csv, or tab-delimited file type, and choose that file, all works as expected.

This MAY be happening only with files that have "field data", "more field data",
ie, comma separated, but with "" around field data.

Expected result

leaving file type as All Available, FMP correctly determines the file type.

Actual result

all fields of import file, line up as one field. unless file type is selected ahead of time

Exact text of any error message(s) that appear

n/a

Workaround

select file type before choosing file and import. Again this behavior was in FMP 11 and prior, seems to have been changed in FMP 12.

Screen_Shot_2012-08-19_at_6.05.31_PM.png

Outcomes