Export TDMS Data for an Asset in NI InsightCM™ Using the Console

Issue Details

I am using NI InsightCM™ and want to use the command prompt to export TDMS data for specific assets so that I don't have to manually download via the web interface. How is this done?

Solution

InsightCM 3.1 and later allows users to export TDMS data with the InsightCM Console Application. Users can export and then analyze data in another application or share data with equipment manufacturers or non-InsightCM users. 

Follow the steps below to export TDMS data for an asset: 

1. Open the command prompt and change the directory to the NI InsightCM Server installation folder by typing cd <InstallDrive>:\Program Files\National Instruments\InsightCM Server 3.0 and press <Enter>.

2. Enter one of the following commands, depending on the version of InsightCM you're using:

InsightCM 3.1 and 3.2:

• InsightCMConsole exporttdms -dir [directory] -asset [asset path] (optional -dt [start date yyyy-mm-dd]).
  • Example: InsightCMConsole exporttdms -dir C:\temp -asset "Company|Plant|Turbines|01|Turbine Generator HP|Brg 1" -dt 2019-07-24

InsightCM 3.3 and 3.4:

• InsightCMConsole exporttdms -dir [directory] -asset [top-most equipment in path to sensor] -start [start date "yyyy-mm-dd hh:mm:ss.S"] -end [end date "yyyy-mm-dd hh:mm:ss.S"]
  • Example: InsightCMConsole exporttdms -dir C:\temp -asset "Turbine Generator" -start "2019-07-24 22:00:00.0" -stop "2019-07-25 01:00:00.0"

 

3. The exported TDMS data can then be found in the directory you specified.

Additional Information

The above commands do not require the time arguments to include both a date and a time. If you omit the hh:mm:ss.S, InsightCM will default to using midnight. This means if you specify -start and -end to be the same date without specifying hh:mm:ss.S, the command will output 0 results. In other words, the minimum time range is one day when hh:mm:ss.S is not specified.

Note: The maximum number of data events (i.e. distinct acquisitions) this command can export is 99. If you specify a time range with more than 99 data events, you will receive the below message:

ArgumentIsInvalid: Too many events. Select a smaller time range.

To remove this message, simply specify a smaller time range.