Could you pull the data into a holding table first?
That way, once it is in FileMaker then you can (more easily) choose what to transfer into your existing live table.
Just a thought...!
Sight unseen, I typically recommend a temporary table for imports that are not consistent. If you just import into a new table, is it easy to delete rows/records that are headers/footers?
Sent from miPhone
You can also import from a range so you might be able to exclude rows by excluding them from the named range.
+1 on that method.
I would pull the records into a holding (temporary) table then write a process to search for the rows that I don't need and delete them out. I would then import the cleaned up data into the live table. Extra brownie points if you use Perform Script on Server for the processing!
Thank you so much for your answers and advice,
and sorry for not being able to respond earlier 'cause I got really tied up.
The problem is I've never worked on importing with filemaker so most of your suggestions were way over my head.
I think importing from a range limit might work for what I need but I could be wrong.
I've attached an example of an excel sheet that I want to work on.
any detailed suggestion would be appreciated
Thanks again for your help
1 of 1 people found this helpful
Start here for Importing into FileMaker:
and this on Excel
Have looked at your Excel file, there are 3 worksheets. It is not clear to me what it is your are trying to accomplish.
In any case, Beverly’s links are a good place to start.
Simply, you may drag the Excel file to the Filemaker icon, you will then be presented with choices:
1) A choice to select a worksheet to open, then
2) Give you a choice to set the 1st row as name of fields, or as the 1st record, you choose.
Repeat the above steps for each worksheet. You will then have 3 FM databases. Perhaps you are interested in only in the database for the 3rd worksheet. Open the FM for the 3rd worksheet, and compare to the corresponding Excel worksheet. Understand what you have and what you want.
Hope that helps,
2 of 2 people found this helpful
Personally, I will make a small script to do this import with a small button to launch it.
When you write the script and specialy the import action, you set the import.
You have to choose the file and the sheet to import.
Then you have to choose either to create a new table and to take the names of the fields in the first row that contains the column names, or to enter the values in an already existing table and not to take the first row in this case.
Then eliminate the few parasitic lines from the beginning of the table if necessary.
You have to match the excel columns with FileMaker headings.
Do not display an import dialog if the Excel file is still the same.
Beware of the straight or curved quotes in Excel cells, it can disrupt searches with FileMaker. If they exist, they must be eliminated.
Thank you so much
but how can I eliminate the parasitic lines from the spread sheet.
should I use the validation?
Validation could be used.
You can also perform a find and delete or just omit.