Diadem script- need help modifying the script

[Mikekass89]

Hello,

I am new to scripting, hoping I can get some help here.
I have 200+ tdms files that i need to add a calculated channel in each one of them.
The way I have been doing it is I load each file separately, I have a script that I run to add the calculated channel, then I manually save the new tdms file on the drive.
I would like to have a script that can load all the files at once, add the calculated channel that I need and save the files somewhere else on the drive.
The script that I have looks like this
" Option Explicit 
Call Calculate("ch(""[1]/Calculated_channel"")=(Ch(""[1]/Channel_1"")-Ch(""[1]/Channel_2""))*2",NULL,NULL,"")".
lets say I have 10 tdms files in "folder 1" on C drive, and I want to have my output files (that contains the calculated channel) saved in "folder 2" on C drive.
How do modify my script to do that
Appreciate any help

[NickelsAndDimes]

Hi MikeKass89,

If you open up DIAdem and go to Help >> Find Examples, there's an example that does pretty close to what you're asking. In the "Mining and Loading Data" folder, there's an example called "Parallel File Analysis". This gives you the option to perform an analysis on all the results of a DIAdem query.

It also gives instructions for how to add a user-defined analysis function, which you could take advantage of to add your script's functionality.

[Mikekass89]

I couldn't find "Parallel File Analysis", I have the 2012 version maybe that's why!

I am running out of time, It should be a small modification, can you please modify it and show me what it is supposed to look like, would really appreciate it

[Pesmith8]

Hi Mike,

The script below will process as many files that are in the path, and will then save the data to the junkout path.

You Just change the paths for your needs, and add the processing of adding the channel of interest you have.

Paul

'-------------------------------------------------------------------------------
'-- VBS script file
'-- Created on 12/17/2018 20:18:22
'-- Author:
'-- Comment:
'-------------------------------------------------------------------------------
Option Explicit 'Forces the explicit declaration of all the variables in a script.

dim sStartPath : sStartPath = "c:\junk\"
dim sEndPath: sEndPath = "c:\junkout\"

Dim ofso,oFolder,oFile,oFiles
Set ofso = CreateObject("Scripting.FileSystemObject")

set ofolder = oFso.GetFolder(sStartPath)

set oFiles = oFolder.Files
dim sExt,sFileName
for each oFile in oFiles
sExt = namesplit(oFile.Name,"E")
sFileName = namesplit(oFile.Name,"N") & "." & sExt
if ucase(sExt) = "TDMS" then
data.Root.Clear ' clears dataportal
' Do processing on file here

call datafileload(oFile.Path,"TDMS","load")
' then save to new filepath
call datafilesave(sEndPath&sFileName)

end if
next

[Mikekass89]

Hi Paul,

I did that and ran the script but I get an error that the channel I am trying to add to the files is unknown.

the error I get is "input channel "CH[1]/scaled" is unknown.

I never had that issue when I loaded one file at a time, do you know what I need to add to define the new channel, I appreciate your help.

this is what my script looks like now

Option Explicit 'Forces the explicit declaration of all the variables in a script.　

dim sStartPath : sStartPath = "C:\DIAdem\Temp data files\"

dim sEndPath: sEndPath = "C:\DIAdem\Output files\"　

Dim ofso,oFolder,oFile,oFiles

Set ofso = CreateObject("Scripting.FileSystemObject")　

set ofolder = oFso.GetFolder(sStartPath)　

set oFiles = oFolder.Files

dim sExt,sFileName

for each oFile in oFiles

sExt = namesplit(oFile.Name,"E")

sFileName = namesplit(oFile.Name,"N") & "." & sExt

if ucase(sExt) = "TDMS" then

data.Root.Clear

call Calculate("ch(""[1]/scaled"")=(Ch(""[1]/channel1"")-Ch(""[1]/channel2""))",NULL,NULL,"") ' I got the error at this line

call datafileload(oFile.Path,"TDMS","load")

call datafilesave(sEndPath&sFileName)

end if

Regards,

Mike

[Pesmith8]

Try loading the channel before you calculate!

[Mikekass89]

it didn't work either. Even if it worked, my goal is to be able to do multiple files at once!

I think I need to define the variable for calculated channel that I am adding but I am not sure how, any idea?

Regards,

Mike