Importing unknown number of files

[Oyseka]

Hi, I have a requirement to import data from a variable number of spreadsheets which follow a naming convention but the number of files vary from project to project. i.e. In one project there may be 6 files from one section of samples: BP1-TP1 to BP1-TP6, followed by five samples in the next set BP2-TP1 to BP2-TP5 and further ones from different borrow pits. Is there a way to automate the import for however many files there may be.

[Ocean West]

Yes by use of a plugin that would get you a list of items in the folder then you can loop thru each file, exiting when you process the last file.

http://www.fmpug.com/resourcedirectory_plugin_list.php?find=File%20Manipulation

(FMPug members receive a discount)