Importing Data to FMPro 12 from Excel
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
All fields imported
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.