Exporting Data From DewesoftX

Course overview

The course teaches you to seamlessly transfer acquired and processed data into external tools for further analysis or reporting. Starting in Analyze mode, you’ll learn to define the exact time range and data type (e.g., full-speed, RMS, phase) to export. Visual previews guide you to select only the relevant portions of your dataset.

Next, you’ll customize your export by selecting which channels to include, rearranging their order, and specifying a custom export rate, with alias-free resampling options explained  . The course also teaches how to create export templates for commonly used configurations—especially useful for repeated exports to Excel or FlexPro.

Advanced features cover:

• Batch exporting multiple data files in one go

• Capturing on-screen visual data or instrument panels and exporting them as video files for presentations 

• Auto-export plugins to automatically save files upon storage stop, ideal for long-term or unattended testing 

• Sequencer integration, enabling scheduled or conditional export workflows

By the end of this course, you’ll have the confidence to export precisely filtered, well-structured data and visuals, ready for downstream analysis or client delivery. Let me know if you’d like to add details on template creation, sequence block setup, or handling export formats for large datasets!

We can use 3rd party post-processing software packages for advanced signal and data analysis. Data export in the DewesoftX software is easy, fast, flexible, and dynamic. It supports a wide variety of popular formats that make data files highly transportable and can be imported into virtually any analysis program.

 To perform the data export process follow these steps:

1. Set export data properties: define the type of data with data export and determine the time axis (the time range of data for export can be defined).

2. Exported channels: select the channels to export from the channel list.

3. Export option: select another software application as a target for data export and offline analysis (MS Excel, FlexPro, Dewesoft, File export, Clipboard, etc.).

4. Template management: create and edit templates (scripts) that are listed on central post-processing in FlexPro and MS Excel part of the screen.

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

We have also two special functions that allow you to:

• Export multiple files

• Export instrument display to video

Sometimes our data file contains a lot of acquired data and we don't need the whole range of data for the export. We can select only one part of the data and perform analysis and export only on the selected part.

To export only a part of acquired data, select the time range on the recorder (or vertical recorder) by zooming on the portion of data.

To export the selected data, press the Export button on the main toolbar. The Export button is only available in Analyse mode.

Once you press the Export button, the following window will appear:

File export in DewesoftX offers several properties which you can use to correctly export data to your desired format.

Type of data

Select the type of data from the data export drop-down list.

Full speed data

Real data exported with full speed

• Real: export the real part of the values.

• Imag: export the imaginary part of the values.

• Ampl: export the amplitude of the data.

• Phase: export the phase.

Reduced data

For this type of data, we can select several different calculations

• Min: export the minimum values.

• Max: export the maximum values.

• RMS: export the RMS of the data.

• Average: export the average from the data.

Time axis

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

• Relative time: axis will start with time 0 at the beginning of the measurement.

• Absolute time: 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 (pretrigger will show negative time values).

• Pre Trigger time: axis will start with time 0 at the beginning of the measurement.

You can select the channels you want to export from the displayed channels list.

Selection can be made in two ways:

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

• Select all channels - all the channels will be selected for export.

• Deselect all channels - this will deselect all the channels. None of the channels will be exported.

• Invert selection - this will invert you selection. The channels that were selected for export, will not be selected anymore and the channels that were not selected, will be selected for export.

In the Exported column toggle between these choices to export/do not export particular channels. If the rectangular is in dark grey color, the channel will be exported and if the rectangular is in light gray color, it will not be selected for export.

Channels can be moved up with a click on the following button:

and moved down with the click on the following button:

This will change the export order of the channels.

With a click on the following button, your selected channel will be moved to the top.

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

DewesoftX "online" export options

You can define which channel will be exported, in which order export the channel, and the exported rate before starting the measurement.

Go to Global channel view, which can be found under More / General / Channels.

Right-click on the main column and select the Edit columns option.

• Exported: in the Analysis mode, when exporting data, the channel will be selected for export.

• Export order: define the export order, channel with number 1 will be exported first, etc. 

• Export rate (Hz): for each individual channel define the export rate.

DewesoftX supports numerous export formats.

Export toolbar

In general, the export toolbar will have shortcuts for the following export formats:

• Dewesoft: stores selected area in new Dewesoft DXD data file (used to cut files).

• File export: several file formats (txt, unv, uff, mat, dat, wav, etc.).

• FlexPro: direct data transfer via ActiveX.

• MS Excel: - direct data transfer via ActiveX.

• Clipboard: copy the data to Window's clipboard, it allows pasting the data into another running application.

We strongly recommend FlexPro, a third-party application that is easy to learn and use, and yet extremely powerful. DewesoftX 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 s standard Windows file dialog box. Click Export and the software will do the rest. Be sure to supply a proper filename extension.

File export

When selecting the file export, we offer export to the following data formats:

• 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 the 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

• RPC III [*.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

• ASAM ODS [*.atfx] - Standard file format in the automotive industry

• S3 [*.s3t] - nCode S3 Time Series data type

• ATI [*.ati] - For the direct import in the iDEAS analysis package (available as custom export)

• HDF5 [*.h5] - H5 files are commonly used in aerospace, physics, engineering, academic research, electronic instruments, and medical fields

• DynaWorks neutral file [*.nt] - DynaWorks compatible data format

• Standard data file (SDF) [*.dat/sdf] - For the direct import in the 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

• CAN messages [*.asc] - tab-delimited export of CAN messages for replay in demo mode

• IFile CA [*.ifl] - Export of combustion data to AVL Concerto compatible

• TAFFmat [*.hdr] - Teac Data Acquisition File Format

• Winplot [*.sun] - Data format compatible with Winplot, a powerful desktop graphical analysis tool that allows the user to generate displays of unrestrictive amounts of data.

When you s the File export option from the toolbar, the following display appears:

The file export offers the following options:

• Export file name: Name of the exported file.

• File directory: Name of the folder where the exported files are saved. Select it with a double click from the dropdown list.

• Existing files: List of existing files in the selected folder that are the same type.

• Export file type: A list of available exported file types.

The supported data file formats are:

Build-in formats

FlexPro (*.fpd)

Powerful and easy-to-use data analysis software.

Excel (*.xls) 

Microsoft Excel spreadsheet software. Please note that Excel is not the best option for large amounts of data.

DIAdem (*.dat)

Powerful data analysis package for the automotive industry. Diadem has an option to export certain groups of channels at a specific sample rate, so the resulting data file is shorter. We can achieve this by de-selecting 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 a full rate.

Matlab (*.mat)

Common signal analysis and mathematical computation package.

Export precision can be selected from a dropdown 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. Matlab can also export each channel with a separate time channel or export all data at full speed if you manually set the export rate (Hz) to the maximum value. Resampler does the job of linear interpolation, hold or alias-free when exporting to Custom sample rate.

Universal file format 58 (*.unv, *.uff)

For import to 3D modeling and structural analysis software from different vendors.

Famos (*.dat)

Famos file format export. Use channel colors can be checked to use DewesoftX channel colors, otherwise default Famos color is chosen.

NSoft (*.dac, *.mdf)

NSoft file format.

Text/CSV (*.txt, *.csv)

Delimited ASCII text file. With checked Export events you can also export events to the CSV file.

Sony (*.log)

Sony DAT recorder data format.

RPCIII (*.rsp)

RCP III data format used for road load data analysis. The buffer length field can be set to match the analysis capabilities. With large files, a larger buffer length is recommended. The buffer length should be multiple of 2, i.e. 256, 512, 1024, and so on.

Comtrade (*.cfg)

Comtrade data format for power analysis.

CAN messages (*.csv, *.asc)

Tab-delimited export of CAN messages for replay in demo mode.

ASAM MDF4 (*.mf4)

MDF (Measurement Data Format) is a binary file format to store recorded or calculated data for post-measurement processing, off-line evaluation, or long-term storage. The format has become a de-facto standard for measurement & calibration systems (MC-systems) but is also used in many other application areas.

Broadcast Wave Format (*.bwf)

Multi-channel audio data format (available as custom export).

EthDump (*.txt)

Google Earth KML (*.kml)

Export of GPS path to Google earth (available as custom export).

HDF5 (*.hdf)

JSON Export (*.json)

S3 (*.s3t)

Standard data file (*.dat)

Technical Data Management (*.tdm)

UNV Export (*.unv)

Wave (*.wav)

Wave audio data format (available as a custom export-

WFT (*.wft)

Nicolet file format (available as custom export)

FileReplay

Export channels and use them as a replay file in a new DewesoftX setup.

The function to export data files to a new Dewesoft DXD data file is primarly used to cut the files into smaller chunks if needed.

The following options are available:

• File extension: Choose between *.dxd and *.dxz.

• Export filename: Name of the exported file.

• File directory: Name of the directory where the exported file is to be saved. Select with a double click from the drop-down list.

• Existing files: List of existing files that are the same type in the selected category.

Export data to a desktop clipboard (or copy data to clipboard) allows pasting the data into another running application.

With this option, you can select channels that you want to export from the displayed channel list (at the bottom of the window).

To enhance data export to Microsoft Excel and FlexPro, you can use the following settings:

1. Select application: Click on either FlexPro (ActiveX) or MS Excel (ActiveX) on the Export toolbar.

2. Template management: Template management controls are only available for Microsoft Excel and FlexPro export options. Templates are listed on central Postprocessing in FlexPro or MS Excel panel. Templates can be created and changed or deleted

3. Select template (script): Appropriate script should be selected from the list of available scripts.

4. Import Flexpro (databases): MergeDB script allows the user to import existing FlexPro-Databases to the exported measurement data.

If you click on either FlexPro (ActiveX) or MS Excel (ActiveX) on the Export option, additional template management controls will be visible on the left bottom part of the screen together with the list of available templates.

Microsoft Excel

FlexPro

For both, the Microsoft Excel and FlexPro export options you will see that a list of preformatted scripts appears in the center of the screen with two columns Setup name and Description of the script.

Now you should select from the list of available scripts. You can select any one of them and then click the Export data button below the format icons to perform the exporting. Don't forget to select the channels to be exported before you press the Export data button.

You can examine the preformatted MS Excel and FlexPro scripts and macros that are loaded in the \Dewesoft\System\X2\Scripts subdirectory and learn how to create their own scripts for export.

The concept is very simple. Once the script is created, just load any data file and run the script. What happens next is a big time-saver. DewesoftX runs this script and:

• Automatically starts the host application (you will see a notice on the screen that it is starting the other application, and there will be a slight delay as it does so and establishes communication).

• Creates the dataset.

• Runs the script.

Let's say that you have a script that:

• takes four incoming signals,

• runs 3rd-octave analysis on them,

• creates a polished report,

• complete with your company's title bar and logo,

• automatically puts in the data and other variables from the data file, and

• formats it for your color printer.

After you click the Export button and this process runs, you will see your final report on the screen, and just need to click print to complete your report.

This is the power of "hot script" ActiveX data exporting to either MS Excel or FlexPro.

Typical FlexPro screen

Typical MS Excel screen

Template management controls

You can easily create your own scripts in MS Excel or FlexPro or edit the existing ones.

Just press the New template button to create a new one or Edit template to change an existing script.

To delete an existing script simply select it and press the Delete template button.

When you press the New template button, you have to enter a setup name, a description, and a comment for the new script.

If you want to export several files at once, there is a nice multi-file export function available. Press the Analyse button to enter the file explorer. Select all files you want to export.

There are two possibilities to mark several datafiles (similar to Windows Explorer):

• To mark several files which are listed near to each other, keep the Shift button pressed during selection.

• To mark several files picked out of the list, keep the Ctrl key pressed during selection.

After all files to export are marked, select Multifile export from the menu.

Now the Export multi file window appears:

This window allows you to select:

• Dewesoft export type or file export type.

• Destination folder for the exported data.

• Export file type, described in the chapter above.

• Data export:

  • Full speed data.

  • Reduced data: Min, Max, RMS, and/or Average type can be selected by checking the appropriate box.

• Time axis: relative, absolute or trigger time type.

Press the Export button to start the export process or Cancel to leave without exporting the files.

Dewesoft multifile export to Dewesoft format

Multi files can also be exported to Dewesoft data file format.

A new way of presenting data is multimedia documentation. DewesoftX offers the possibility to export any display widget like scope, recorder, 2D graph, etc. to a video file, which can be replayed in any video player.

Select Export screen to AVI from the Edit menu and the following window will appear:

According to your requirements, you can change the export settings on this window. The following settings can be changed:

• File name and storage path: select folder and filename.

• Compression: DivX codec or similar is recommended. Press the Change button and the window will appear for selecting standard compression codecs from the drop-down list and for configuring them.

• Resolution: From 640x480 to 1920x1080 selectable from dropdown list. Please note that higher resolutions will create larger files.

• Frame output control

• Frame rate: From 1 to 60 fps. The standard video players can not handle faster data.

• Play speed: perfect for slow-motion (from 1/2x to 1/10000x real-time) or fast overview (from 1x to 5000x real time).

• Sound channel: Select from the dropdown list one of the available analog channels to be your audio channel in the exported video file.

When you have done all the needed changes press the Export button to start the export or Cancel to leave without exporting the video.

The export progress will be displayed on an Export screen to the AVI file window.

When DewesoftX has completed the export (depending on data and compression, this can take several minutes) you can open the exported file in a standard video player.

DewesoftX offers the possibility to automatically export the data into a selected file format.

Under Extensions (Settings -> Extensions) first, click the + button to add the AutoExport plugin. 

Search for AutoExport and enable it.

After that, the plugin icon will be seen in the channel setup. In the plugin, you select to which format the data are exported and where to: