Add charts, calendars, kanban boards, activity timelines, and more. Für eine Live-Verbindung ist, soweit ich weiss, immer der ODBC-Treiber usw erforderlich. Drag and drop prebuilt add-ons for instant app development. I selected the option to ignore the error, to leave all the data stored as text, with the intention of preserving the trailing zeros.Īlas, the issue persists. FileMaker Server 15.0.2 auf OS X 10.10.5 ABER dies ist ja nur ein Import, da konnte mann einfacher aus FileMaker eine Excel-Datei importieren. All the cells in the courseID.personID column gave a "number stored as text error", with the option to convert the text to numbers. Then, I did a Paste Special from my original data, and selected Paste as Values. I first noticed this was happening, and was very careful to go back to Excel and make a new file (to start fresh), select all cells and set format to Text.
I am matching the Excel field to the FMP field. 120, and so courseID.personID becomes something like "123.120". Some "personID" values end in a zero, e.g. The field in my Excel file is formed similarly, using Excel formulae. To explain further: the field in the database is a calculated text field, "courseID.personID", determined by concatenating the numerical "courseID" and "personID" fields (with a dot in between them). When importing, FMP does not match the fields correctly, because it ignores the trailing zeros. However, the field that I am using to match occasionally contains trailing zeros. I am using the imported data to "Update matching records in found set". I am importing data from an Excel file into a Filemaker Pro database (FMP 12.0 v5 for Mac).