06-05-2012 10:31 AM
I can load my individual .ADF files by calling DataFileLoad but I have about 120 files in three folders in one parent folder.
Is their a way to search for all these files (perhaps using the datafinder which I configured for .adf files) and then load them all together?
Thanks,
Omar
Solved! Go to Solution.
06-05-2012 11:27 AM
dim result : result = DirListGet("C:\tmp", "*.adf", "filename", "FullFilenamesRecursive")
dim fl : for each fl in result
DataFileImport fl
Next
or using Datafinder which can be used to with more than file extension to deterermine which files to load.
Dim DataFinder : Set DataFinder = Navigator.ConnectDataFinder("My DataFinder")
Dim Query : Set Query = DataFinder.CreateQuery(eAdvancedQuery)
Call Query.Conditions.Add(eSearchFile, "folder", "=", "C:\tmp\*")
Call Query.Conditions.Add(eSearchFile, "fileName", "=", "*.adf")
DataFinder.Search(Query)
Dim File
For each File in DataFinder.Results
DataFileImport File.Properties("fullpath").Value
Next
06-05-2012 11:35 AM
Thanks, that was really helpful!