excellent video! Next video should also include how to import data within the same database, from one table to other (in case we create new tables from existing tables) or we make new relationships.
Hey Sunny, Your tutorial was very helpful, especially the part where you use a button with a script to import the data. BUT... I noticed something: when you are in a list view and you have performed a search (so you get a found set) and you hit the import button to IMPORT AND UPDATE again, you risk errors with your import. At least: that what I noticed on my file. If you hit the button with a found set still active, FM imports your data a second time, so you get double the amount of records. To avoid this, I added 1 step to your script: as line 1 I added "show all records". That way, the find action gets eliminated and FM returns to your full set of data in that list view. The script then compares existing data with the source file and imports and updates in a correct way. Of course, you could tell your user(s) to "always turn off any find results before importing". But it seems safer to add that one "show all records" line to the script. ;-)
Thanks for this Great video! So easy to follow. If the client sends you updates of the Target.xlsx file but renames it with a new version every time eg Target_v1.xlsx, Target_v2.xlsx, Target_v3.xlsx etc is there a way for the filemaker script to automatically import the latest version?
Yes you can import folders and file into a container field. There's a script called "Import Folder" or something, couldn't recall it on top of my head but the name should be roughly that.
Thank you so much. I have successfully created a search as you type field by following another tutorial of yours. What I would like to be able to do is the opposite of this script and keep updating an excel file from FileMaker, is there a way?
You can probably create something close with the "export record" script + a bit of script trigger. Automatically updating excel without opening FileMaker is another story...
Thank you! This really helps me as a teacher. Is there a way to import new fields, eg test results, or would I need to set these up as empty fields in the initial set up?
Great video dude! Thank you for the step-by-step explanation of the process.
excellent video! Next video should also include how to import data within the same database, from one table to other (in case we create new tables from existing tables) or we make new relationships.
Nice job always short and to the point with excellent content.
super explained, I am thrilled
Hey Sunny,
Your tutorial was very helpful, especially the part where you use a button with a script to import the data. BUT... I noticed something: when you are in a list view and you have performed a search (so you get a found set) and you hit the import button to IMPORT AND UPDATE again, you risk errors with your import. At least: that what I noticed on my file. If you hit the button with a found set still active, FM imports your data a second time, so you get double the amount of records.
To avoid this, I added 1 step to your script: as line 1 I added "show all records". That way, the find action gets eliminated and FM returns to your full set of data in that list view. The script then compares existing data with the source file and imports and updates in a correct way.
Of course, you could tell your user(s) to "always turn off any find results before importing". But it seems safer to add that one "show all records" line to the script. ;-)
Holy smokes...this was great. Thx!!
Thanks you. Very clear and Usefull
We want to learn more about filemaker.
Please make a new video.
Thanks for this Great video! So easy to follow. If the client sends you updates of the Target.xlsx file but renames it with a new version every time eg Target_v1.xlsx, Target_v2.xlsx, Target_v3.xlsx etc is there a way for the filemaker script to automatically import the latest version?
starts at 5:00
This is a very very useful one. Just one question: Is it possible to import data from container fields? ( I´m thinking about PDF´s, pictures...)
Yes you can import folders and file into a container field. There's a script called "Import Folder" or something, couldn't recall it on top of my head but the name should be roughly that.
Thank you so much. I have successfully created a search as you type field by following another tutorial of yours. What I would like to be able to do is the opposite of this script and keep updating an excel file from FileMaker, is there a way?
You can probably create something close with the "export record" script + a bit of script trigger. Automatically updating excel without opening FileMaker is another story...
Thank you for such a prompt reply
Thank you! This really helps me as a teacher. Is there a way to import new fields, eg test results, or would I need to set these up as empty fields in the initial set up?
New empty fields probably the easiest way to go
Is possible to import the pictures from the excel sheet?
The link to the sample file is incorrect , I get access denied.
I've fixed it, should be good now