Exporting data

The important purpose of the Dewesoft Analyse mode is also to export acquired data for off-line analysis using other software.

Dewesoft is intended to be an acquisition package. You can use other post-processing packages for advanced analysis. Data Export is easy, fast, flexible and dynamic with Dewesoft, supporting a wide variety of popular formats which makes data files highly transportable that can be imported into virtually any analysis program. To enable efficient export data process perform the following procedures:

1. STEP

Set export data properties: to define the type of data with Data export and determine Time axis; Time range of data can be selected for export.

2. STEP

Exported channels: select the channels to export from Channels list; not available for Dewesoft export option.

3. STEP

Export option: selects another software application as the target for data export and off-line analysis:

4. STEP

Template management: Creating and changing template - scripts which are listed on central Postprocessing in FlexPro / MS Excel part of screen (only available for Microsoft Excel and FlexPro export option)

5. STEP

Perform export data: after all settings are done, select Export data button to export data

You also have two special procedures to:

Time range of data

To export only part of acquired data select time range on the recorder or vertical recorder with zooming in the portion of the data.

HELP: For detailed information about Time range selection see  -> User Guide ->Selecting data)

NOTE: Be aware that only selected portion of data will be exported. To export full range of data, zoom out first to entire length of the data.

To export data, press the Export button on main Dewesoft toolbar, which is visible only when you are in the Analyse mode:

Exporting_data_Tool_bar_Export_button

Once you press Export, the following screen will appear, ready as standard to export data directly into FlexPro:

Exporting_data_Screen

Set export data properties

Data export

Select type of data from Data export the drop-down list:

Real data

  • Full speed data
  • Reduced - When using reduced data, you can select diferent parameters by checking the appropriate box: Min, Max, RMS and/or Average type.

Time axis

Select type of time scale from the Time axis drop-down list:

  • Relative, Absolute or Trigger type.
  • Relative axis will start with time 0 at the beginning of the measurement.
  • Absolute axis will export the absolute date and time of measurement as the time axis.

Trigger time axis will start with time 0 at the trigger point (pre-trigger will show negative time values). 

Exported channels

Next you have to select the channels to export from displayed Channels list (at the bottom of the window).

Selection can be made in two ways:

  1. Click on the icon in the Exported column to select from the displayed menu:

  • Select all channels
  • Deselect all channels
  • Invert selection
  1. Click Yes / No button in the Exported column to toggle between this choices to export / don’t export a particular channel.

As a standard, all channels will be exported.

Channel can be moved with click on button up and on button down within Channels list. This will change the export order.

The export list options will be stored when we choose Store settings and events from the main Data menu.

Export option - formats

Dewesoft supports the following data export:

Exporting_data_Export_option_formats

  • Microsoft Excel - direct data transfer via ActiveX
  • FlexPro - direct data transfer via ActiveX
  • File Export - several file formats
  • Dewesoft - stores selected area in new Dewesoft file; used to cut files
  • Clipboard - copy data to Windows Clipboard, allows pasting into another running application

Simply click on the desired application to select it.

We strongly recommend FlexPro, a third-party application that is easy to learn and use, and yet extremely powerful. Dewesoft offers easy export to this format, and advanced automation when data is exported to this program, including the ability to run custom macro ‘scripts’ inside.

The other file formats except FlexPro and MS Excel just prompt you for a filename, which you supply using a standard Windows file dialog box. Click OK and the software will do the rest. Be sure to supply the proper filename extension.

File export

The supported data file formats are:

  • FlexPro [*.fpd] - Powerful, easy-to-use data analysis software
  • Microsoft Excel [*.xls] - Standard spreadsheet software (not useful for large amounts of data)
  • DIAdem [*.dat] - Powerful data analysis package for automotive industry
  • Matlab [*.mat] - Common analysis and mathematics package
  • Universal file format 58 [*.unv] - For import to 3D modeling and structural analysis software from different vendors
  • FAMOS [*.dat] - FAMOS file format export
  • NSoft time series [*.dac] NSoft file format
  • Text File [*.txt] - Delimited ASCII text file
  • Sony [*.log] - Sony DAT recorder data format
  • RPCIII [*.rsp] - RPC III data format used for road load data analysis
  • Comtrade [*.cfg] - Comtrade data format for power analysis
  • Technical data management [*.tdm] - LabVIEW compatible data format
  • JSON [*.json] - JavaScript Object Notation format is an open-standard file format that uses human-readable text to transmit data objects
  • ASAM MDF4 [*.mf4] - Standard file format in the automotive industry
  • S3 [*.s3t] - nCode S3 Time Series data type
  • ATI [*.ati] - For direct import in iDEAS analysis package (available as custom export)
  • HDF5 [*.h5] - H5 files are commonly used in aerospace, physics, engineering, academic research, electronics instruments, and medical fields
  • DynaWorks neutral file [*.nt] - DynaWorks compatible data format
  • Standard data file (SDF) [*.dat/sdf] - For direct import in Prosig analysis package (available as custom export)
  • WFT [*.wft] Nicolet file format (available as custom export)
  • Replay [*.rpl] - Used to simulate data readings from Dewesoft data acquisition devices
  • Wave [*.wav] - Wave audio data format (available as custom export)
  • Google earth [*.kml] Export of GPS path to Google earth (available as custom export)
  • BWF [*.dat] - Multi channel audio data format (available as custom export)
  • CAN messages [*.csv] - tab delimited export of CAN messages for replay in demo mode
  • IFile CA [*.csv] - tab delimited export of CAN messages for replay in demo mode

If you select the File Export, following display appears:

Exporting_data_File_export

On central part following Export to different file formats sections is displayed:

  • Export file name - name of exported file; enter name according to OS name convention
  • File directory - name of directory where exported file to be saved; select with double click from drop down list
  • Existing files - list of existing files same type in selected directory
  • Export file type - list of available type exported file with optional file settings for:

DIAdem *.dat  file type

Exporting_data_File_type_DIAdem

Diadem has an option to export certain groups of channels at specific sample rate, so the resulting data file is shorter. You can achieve this by deselecting Export all channel groups with full rate and defining the rate for each channel group (PAD, CAN, GPS, Plugin and MATH). If -1 is entered, the data will be exported at full rate.

Matlab *.mat file type

Exporting_data_File_type_Mathlab

Exporting_data_File_type_Mathlab_Export_precision

You can select Export precision from drop down list between Single and Double. Usually single precision is enough, but sometimes Matlab functions expect data in double precision. Please be aware that the amount of exported data will be doubled if this option is chosen and Matlab files can’t exceed 2 GB except if you chose MATLAB 7.3 MAT-file format. Matlab can also export each channel with separate time channel or exports all data with full speed if Export synchronous channels with full sample rate check box is checked.

FAMOS *.dat file type

Exporting_data_File_type_FAMOS

Use channel colors can be checked to use Dewesoft channel colors otherwise default Famos color is chosen.

Text *.txt file type

Exporting_data_File_type_Text

With checked Export events also events will be exported in text file.

RPCIII *.rsp file type

Exporting_data_File_type_RPCIII

Buffer length field can be set to match the analysis capabilities. With large files larger buffer length is recommended. The buffer length should be multiple of 2, i.e. 256, 512, 1024 and so on.

Dewesoft export

Stores selected time range in new Dewesoft file; this procedure is primary used to cut files.

Exporting_data_DEWESoft

By this option on central Export to Dewesoft part of screen are displayed:

  • Export file name - name of exported file; enter new file name according to OS name convention
  • File directory - name of directory where exported file to be saved; select with double click from drop down list
  • Existing files - list of existing files same type in selected directory

When Export to Dewesoft is selected, Channels list disappear, therefore all channels will be exported.

After you select time range on the recorder or vertical recorder display, enter Export file name and selecExport data button, only acquired data for selected range (and for all channels) will be exported to new file. 

Copy to Clipboard export

Copy data to Windows Clipboard and with them allows pasting data into another running application.

Exporting_data_Clipboard

By this option the channels to export can be selected from displayed Channels list (at the bottom of the window).