[rikupasanen]

I'm new on this forum, so sorry if this has been discussed earlier.

We've made tons of measurements during 2008 to 2016 and all stuff were saved as .mdat and exported to .txt and finally to complex excel sheet, as sort of database.

Now, for reason I can't tell, we updated v5.0 to latest software version v5.19 and something has happened to export function.

In v5.0 export gives information: 96 ppo, in 1/3 smoothing (900 points in our measurement set), but with same settings in v5.19 its now 1/12 octave in 1/3 smoothing (only few measurement points). What am I missing?

And another annoying point when export txt file, decimal devider... commas are now dots. Oh why, oh why?

Thanks for help on this.

 

[JohnM]

Exports use dots as decimal delimiter regardless of locale now to avoid problems when subsequently importing in other packages (user request).

Exports of smoothed responses are at 1/4 the smoothing interval (per the help) to cut down on file size, removing the redundant content.

 

[rikupasanen]

So there are changes in export function between 5 and 5.19? hmm..

That means a lot of work for us to update the current database and all related interfaces. Oh my..

 

[JohnM]

That particular change was made in 5.01 beta 8 in April 2012. Other export options would be possible, but that isn't something that has come up much, if at all.

 

[JohnM]

Looking back, you asked for more control over export settings in 2011. Taken me a while to get to that then but I've made a start, it will be in the next beta:

 

[JohnM]

OK, finished that, will be in the next beta release. Here is the final dialog:



For ref, here is the help entry:

The entire measurement can be exported (Use range of measurement) or a range can be selected, if the selected range starts before or ends after the range of data within the measurement only the range that overlaps the measurement will be exported. If the data is exported at the measurement resolution that may be 96 PPO log spaced if the Allow 96 PPO log spacing Analysis preference is selected or linear spaced at the FFT resolution. Linear spaced exports are very large files (typically more than 1 MB). If a custom (log spaced) export resolution is selected REW picks a start frequency that is as close as possible to the desired start but that ensures the exported frequencies include the nominal octave centres (e.g. 20 Hz, 40 Hz etc). Smoothing should be applied when using log exports, the dialog will warn if insufficient smoothing has been selected for the chosen output resolution. Exports can use whatever smoothing is currently applied to the measurement, or any other smoothing selected from the dialog (the selection will not change the smoothing of the measurement in REW, only the smoothing for the exported data). By default REW's export number format uses dot as the decimal delimiter and no digit grouping, for ease of import in other packages subsequently, but Use computer's number format will mean the current format of the computer on which REW is running will be used. The delimiter between exported values can also be selected here, this is the same selection as offered in the export menu. A preview of the export output is shown in the dialog including the first few lines of exported data. The format is compatible with the .FRD format. Comment lines start with *, data lines begin with the frequency, then the SPL in dB and finally the phase in degrees (0.0 if the measurement does not have phase information).