AnsweredAssumed Answered

Importing Data to FMPro 12 from Excel

Question asked by wstonejr on Oct 15, 2013
Latest reply on Oct 17, 2013 by philmodjunk

Summary

Importing Data to FMPro 12 from Excel

Product

FileMaker Pro

Version

12.v4

Operating system version

OS X v 10.8.5

Description of the issue

Thanks to comments by PhilModJunk and TKnTexas, I was able to set up a table for importing data from Excel.  When I examine the table after the import, all of the fields are properly imported, except for the TIME BILLING ID MATCH FIELD, which remains blank.  When I switch from  the time billings data table to the time billings detail table, the newly imported data does not appear and the fees are not included in the total.

I have checked the format of the TIME BILLING ID MATCH FIELD in FMP and Excel and they are both set to text (which is what I found in FMP). I also have the TIME BILLING MATCH FIELD in the Excel file matched with the TIME BILLING MATCH FIELD in the FPM import field mapping dialog box. The only other thing which I noticed in the manage database dialog box is that the TIME BILLING ID MATCH FIELD is listed as "Indexed, Auto-enter Calculation replaces existing values", but I am not sure how that affects the import.

I would appreciate any suggestions.

Steps to reproduce the problem

Importing data from Excel version 2010

Expected result

All fields imported

Actual result

TIME BILLING ID MATCH FIELD is not imported

Exact text of any error message(s) that appear

None.  The program reports that all records are imported without errors.

Outcomes