1 of 1 people found this helpful
If I am understanding what you are trying to do correctly, you are importing a series of spreadsheets into one master FileMaker Pro file...correct?
Seems like you could import one spreadsheet into your Master file and tag those records somehow (for example put a "1" in a field called "tag"). Then you could repeat the process for each spreadsheet that you have and put a different value in the "tag" field. When all is said and done you will have all your records in the master file jumbled up with different tags.
At that point you could do a search on the tag field for the set of records that you are looking for and when you export you will only export those found set of records.
In your example above you could also search for the records that are marked "#N/A" and omit them from the found set leaving you with the 300 remaining records.
If this is on the right track - a script could be written that simply finds all the records with "1" in the tag field, exports them, then finds all the records with "2" in the tag field and export those, etc.
I do something like this on a much smaller scale. It may be easier to do one more step. Make another sheet in the workbook, call it (ImportToFM) that only contains the 300 records you want to import. Then reference that sheet for the import in FM
Thanks for this, that's exactly what I'd be looking for.
I'm doing a bit of searching around via Google and might need some help running this script! For the purpose of this example, I want to do the following:
- Open my "MASTER" sheet, go to a field named "CHECK"
- Look in the "CHECK" column for entries which say "#N/A" and select all the other records (so those that do not include "#N/A")
- Once all those records have been selected, duplicate the necessary records held in "MASTER" to another FM output called "OUTPUT1"
This is how far I've got with the scripting (I imagine I'm probably way off...):
- Go to Record/Request/Page [First]
- Set Selection [MASTER::_CHECK)
- If [MASTER::_CHECK ≠ "#N/A"]
- Open File [OUTPUT1]
- Duplicate Record/Request
- End If
- Go to Record/Request/Page [Next]
- End Loop
Once again, hope I am being clear on this, but any advice would be greatly appreciated.
SteveMartino, thanks too for your response and I could see how that could work. The only thing is that the Master records sheet will be updated and this will impact the outputs in the other sheets. So producing the output directly from FM would be the way to go I think.
This was fairly easy to do in the end (although took me a while to get there!):
- Go to Layout
- Perform Find (Omit records including #N/A)
- Export Records