05-25-2009 11:52 AM
Hello,
Can somebody tell me how to load automatic some .csv file form a folder to Data Portal in Diadem.
I do some tests and during this tests I record data ( .csv files), files that I load manual now (*FileNameGet command), but I want when the tests are done and I load the script, atomatic to load the csv files, analyze and build the report.
Please advice me how can I do that.
Thank you
Solved! Go to Solution.
05-26-2009 06:28 AM
Something like the following should work.
dim dirToLookIn : dirToLookIn="D:\temp"
dim fs : Set fs = CreateObject("Scripting.FileSystemObject")
dim folder : Set folder = fs.GetFolder(dirToLookIn)
dim file : For Each file In folder.Files
dim fileName : fileName = file.name
Next