To do the task described above you can use the following script:
Option Explicit
Call DataFileSave(CsvParameters("C:\temp\out_ger.csv", "ger"), "CSV")
Call DataFileSave(CsvParameters("C:\temp\out_eng.csv", "eng"), "CSV")
function CsvParameters(byval filePath, byVal lang)
select case lang
case "ger"
CsvParameters = "<filename>" & replace(filePath, "&", "&") _
& "</filename><decimalpoint>,</decimalpoint><delimiter>;</delimiter><timeformat>DD.MM.YYYY hh:mm:ss</timeformat>"
case "eng"
CsvParameters = "<filename>" & replace(filePath, "&", "&") _
& "</filename><decimalpoint>.</decimalpoint><delimiter>,</delimiter><timeformat>MM/DD/YYYY hh:mm:ss pp</timeformat>"
case else
CsvParameters = filePath
end select
end function
The script above will save all the data from the Data Portal into a .csv file.
To use this script:
- Open DIAdem SCRIPT panel
- Copy and paste the code to the SCRIPT editor
- Run the SCRIPT
- Two files will be created to the folder specified
Excel may use a comma or a dot as a decimal separator based on your Windows Regional Settings, thus use the "eng" or the "ger" version of the file created to make Excel read the .csv correctly.
Additional Information
An other way to export the Data Portal is to use the Excell Export Wizard. In the DATA device window, select
File»Save As and select
Excel format in the "Save as Type" pull-down menu. This will launch the Excel Export Wizard, where you can customize the data and channel information to be exported.
You can also use the TDM Excel Add-In to load and work with TDM and TDMS files in Excel.
However if you need more flexibility during the export you can customize the script on a deeper level.