Can I import data fields from an Excel or CSV file?
Is it possible to import data as fields into Filemaker? e.g. I have a bunch of rows in Excel called A, B, C that I wish to be fields in my FM database.
Rows, no - columns, yes (but only into a new table). Import the file and specify "Don't import first record…".
There's an excel tool called "transpose" that swaps rows for columns you can use that tool in excel to get your spreadsheet ordered correctly for import in to filemaker.
Thanks, I'm able to import the data fields! Do you know if it's also possible to "import" the *field type* if this was stated in a seperate column. By default these fields are set to "text" upon import.
Alternatively, if it's possible to get a "Design View" of the fields where we can configure the "field type" more quickly. I guess I'm trying to replicate the feature in MS Access, here the fields are listed in tabular format and we can define the the 'Data Type' quickly...
I have a large number of fields and I'm sure there is a easier way to specify the field types without needing to right-click on each of them and set the field type manually...
Thanks so much for your help! :)
Should have mentioned, I've worked out using "Manage Database" >> editing the fields makes this process easier but still requires editing fields manually one-by-one which is time consuming.
AFAIK, the only format that carries data types (which Filemaker will respect) is XML*. So perhaps you could export from Excel as XML, then use a custom stylesheet to transform the type from data (assuming it's listed in one of the Excel columns) into field type. Or export from Filemaker as XML, edit the <METADATA> section and import back (into a new table). I am not sure either one would be a time-saver, though.
(*) Actually, DBF does it too - but I don't see how it could be used here.
Retrieving data ...