Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Diogo Nunes Pereira]

Hello everybody,

has anyone been able to import scans from RF Explorer into Sennheiser WSM?

I can manage to import them pretty well into Shure WWB but the format of the data in WSM is bringing me nuts...

A coleague provided me with some WSM .cvs files for me to analyse and apparently the format is the following:

Frequency;RF level (%);RF level
518500;;16
518525;;15
518550;;15
518575;;15
518600;;16


I can easily adapt the first field, but the RF level field in RF Explorer gives the data in -dBm but it seems WSM expects positive dB numbers in this field; maybe this is the reason they fail to import.

Any ideas on how to convert this data field from -dBm to the data value WSM expects?

Thank you in advance.

Cheers

D

[Pete Erskine]

Hello everybody,

has anyone been able to import scans from RF Explorer into Sennheiser WSM?

Look on this page.  You will need to setup a login.  No charge.

http://www.bestaudio.com/spectrum-scans/

[Diogo Nunes Pereira]

Look on this page. 
http://www.bestaudio.com/spectrum-scans/

Thanks Pete, I love your page. I've been there many, many times... you actually have a link in that section for the tutorials I wrote on how to import RFE scans in WWB (Thanks for that...)

Still can't get them to import correctly in Sennheiser WSM, though, and either i missed it or there's no info there on how to do it... yet! 

Cheers,

D

[James Kazeze]

Yes! 

It's pretty simple but you need to have the right tools!
It's easiest if you use a text editor that allows you to use wildcards in the find and replace search. I am using a program called textwrangler which is free in the apple app store for mac.
I am using my RF explorer with a piece of software from RF Venue called Vantage which exports Shure WWB compatible csv files. Once I've got the csv in a Shure compatible format, I open it in Textwrangler and take the following steps:

1- Use find and replace to get rid of the decimal point in the frequencies, but not in the RF levels. (This is where the wildcard find and replace comes into it's own.)
2- Use find and replace to change the comma separators into two semicolons.
3- Insert the following text directly above the numbers:
            Receiver;
            Date/Time;
            RFUnit;dBm
            Owner;
            ScanCity;
            ScanComment;
            ScanCountry;
            ScanDescription;
            ScanInteriorExterior;
            ScanLatitude;
            ScanLongitude;
            ScanName;
            ScanPostalCode;

            Frequency Range [kHz];XXXXXX;YYYYYY;ZZ
            Frequency;RF level (%);RF level

Though note that you'll need to change XXXXXX to your scan's starting (lowest) frequency, YYYYYY to your scan's end (highest) frequency and ZZ to the size of frequency step between values in KHz. My scans all use 25KHz steps so I don't know if it will work with any other size step as WSM itself uses 25KHz steps for it's scans.
It's also important to note the RFUnit value. I have it set to dBm as that's what I get from my RF explorer. WSM defaults to dB with it's scans. If your scans give you RF level in dB change the RFUnit to dB instead.

Once that's done you'll end up with a file that looks like:

Receiver;
Date/Time;
RFUnit;dBm
Owner;
ScanCity;
ScanComment;
ScanCountry;
ScanDescription;
ScanInteriorExterior;
ScanLatitude;
ScanLongitude;
ScanName;
ScanPostalCode;

Frequency Range [kHz];450000;550000;25
Frequency;RF level (%);RF level
450000;;-110.5
450025;;-114.0
450050;;-116.0
450075;;-116.0
450100;;-116.0
450125;;-116.0
450150;;-116.0
450175;;-116.0
450200;;-116.0
450225;;-116.0
450250;;-116.0
450275;;-116.0
450300;;-116.0
450325;;-116.0
450350;;-116.0
450375;;-115.0
450400;;-116.0
450425;;-116.0
450450;;-116.0
450475;;-116.0
450500;;-116.0
450525;;-116.0
450550;;-116.0
450575;;-115.5
450600;;-116.0
etc etc... until the end of your scan.

Save this as a csv and it should import into Sennheiser's WSM no problem!
It sounds more complicated than it is. Once you know what you're doing you can make the conversion in a minute or two. It really is that straight forward. The hardest part will be learning to use wildcards in find and replace if you are not familiar with them. If you don't have a text editor that will let you use wildcards then it's a difficult proposition!
I hope this helps!

[James Kazeze]

Oh, Just realised I made a small error in my info above. The ScanName field in the header will need to be populated otherwise it will fail to load into WSM.

[Jason Glass]

Yes! 

It's pretty simple but you need to have the right tools!
It's easiest if you use a text editor that allows you to use wildcards in the find and replace search. I am using a program called textwrangler which is free in the apple app store for mac.
I am using my RF explorer with a piece of software from RF Venue called Vantage which exports Shure WWB compatible csv files. Once I've got the csv in a Shure compatible format, I open it in Textwrangler and take the following steps:

1- Use find and replace to get rid of the decimal point in the frequencies, but not in the RF levels. (This is where the wildcard find and replace comes into it's own.)
2- Use find and replace to change the comma separators into two semicolons.
3- Insert the following text directly above the numbers:
            Receiver;
            Date/Time;
            RFUnit;dBm
            Owner;
            ScanCity;
            ScanComment;
            ScanCountry;
            ScanDescription;
            ScanInteriorExterior;
            ScanLatitude;
            ScanLongitude;
            ScanName;
            ScanPostalCode;

            Frequency Range [kHz];XXXXXX;YYYYYY;ZZ
            Frequency;RF level (%);RF level

Though note that you'll need to change XXXXXX to your scan's starting (lowest) frequency, YYYYYY to your scan's end (highest) frequency and ZZ to the size of frequency step between values in KHz. My scans all use 25KHz steps so I don't know if it will work with any other size step as WSM itself uses 25KHz steps for it's scans.
It's also important to note the RFUnit value. I have it set to dBm as that's what I get from my RF explorer. WSM defaults to dB with it's scans. If your scans give you RF level in dB change the RFUnit to dB instead.

Once that's done you'll end up with a file that looks like:

Receiver;
Date/Time;
RFUnit;dBm
Owner;
ScanCity;
ScanComment;
ScanCountry;
ScanDescription;
ScanInteriorExterior;
ScanLatitude;
ScanLongitude;
ScanName;
ScanPostalCode;

Frequency Range [kHz];450000;550000;25
Frequency;RF level (%);RF level
450000;;-110.5
450025;;-114.0
450050;;-116.0
450075;;-116.0
450100;;-116.0
450125;;-116.0
450150;;-116.0
450175;;-116.0
450200;;-116.0
450225;;-116.0
450250;;-116.0
450275;;-116.0
450300;;-116.0
450325;;-116.0
450350;;-116.0
450375;;-115.0
450400;;-116.0
450425;;-116.0
450450;;-116.0
450475;;-116.0
450500;;-116.0
450525;;-116.0
450550;;-116.0
450575;;-115.5
450600;;-116.0
etc etc... until the end of your scan.

Save this as a csv and it should import into Sennheiser's WSM no problem!
It sounds more complicated than it is. Once you know what you're doing you can make the conversion in a minute or two. It really is that straight forward. The hardest part will be learning to use wildcards in find and replace if you are not familiar with them. If you don't have a text editor that will let you use wildcards then it's a difficult proposition!
I hope this helps!

James, thank you very much for this!

Sent from my Nexus 5 using Tapatalk

[Zoe Martin]

Hi James

How did you set the wildcard on TextWrangler? What do you set it to look for, or exclude?

Thanks!
Zoe

[Mac Kerr]

Hi James

How did you set the wildcard

Please go to your profile and change the "Name" field to your real first and last name as required by the posting rules displayed in the header at the top of the section, and in the Site Rules and Suggestions in the Forum Announcements section, and on the registration page when you registered.

Mac

[Pete Erskine]

Yes! 

It's pretty simple but you need to have the right tools!

James, if you don't mind I'd like to put this on my site?

[Diogo Nunes Pereira]

Yes! 

It's pretty simple but you need to have the right tools!

Jeez... I totally missed this! Thank you very much James.

D

[keithfarmer]

Oh, Just realised I made a small error in my info above. The ScanName field in the header will need to be populated otherwise it will fail to load into WSM.

Hi James

I too am interested in the search strings to use in TextWrangler in order to only remove the decimal point from the Frequency

Thanks

Keith

[James Kazeze]

Hi James

How did you set the wildcard on TextWrangler? What do you set it to look for, or exclude?

Thanks!
Zoe

Hi Zoe, Sorry I've not been back here in a little while! However, if it's still of use to you, I do two Grep find and replace searches in Textwrangler.
The first is:
Find "(...)\.(...)" and replace with "\1\2" Without the speech marks.
Generally in a Grep search in Textwrangler, a "." is a wildcard for any single digit number.  the "\." tells it that I'm looking for a point/period/full stop and not a random number. so the first argument basically tells it that I want it to find two sets of three digit numbers separated by a decimal point. the "\1\2" in the replace field means I want it to replace all the instances it fins in the search with the two sets of three digit numbers. "\1" being hte first set of three digit numbers it found, and "\2" being the second. this effectively just removes the decimal points from the frequencies! Using the replace all option does them all in one fell swoop.

The second is:
Find "," and replace with ";;" Again, without the speech marks.
This isn't actually a Grep search, but it doesn't matter if it's still in Grep search mode. it won't affect the result. This just replaces all the commas with two sets of semi-colons.

I hope that helps!

[James Kazeze]

James, if you don't mind I'd like to put this on my site?

Hi Peter, Sure, feel free. This info is here to help people use the data as they need to. It's best shared!

[James Kazeze]

Jeez... I totally missed this! Thank you very much James.

D

Not a problem at all!

[Diogo Nunes Pereira]

It's pretty simple but you need to have the right tools!
It's easiest if you use a text editor that allows you to use wildcards in the find and replace search. I am using a program called textwrangler which is free in the apple app store for mac.

Hi Zoe, Sorry I've not been back here in a little while! However, if it's still of use to you, I do two Grep find and replace searches in Textwrangler.
The first is:
Find "(...)\.(...)" and replace with "\1\2" Without the speech marks.

As an alternative to TextWrangler for us RF Explorer and Windows users: In Notepad++ this same procedure (and wildcards) worked just fine.

Most times I'm a heavy Shure user but finally have a production that has me dealing with WSM again... Feels like so many things are done so much better in WWB6.

Though note that you'll need to change XXXXXX to your scan's starting (lowest) frequency, YYYYYY to your scan's end (highest) frequency and ZZ to the size of frequency step between values in KHz. My scans all use 25KHz steps so I don't know if it will work with any other size step as WSM itself uses 25KHz steps for it's scans.
It's also important to note the RFUnit value. I have it set to dBm as that's what I get from my RF explorer. WSM defaults to dB with it's scans. If your scans give you RF level in dB change the RFUnit to dB instead.

Can confirm that WSM loaded fine one of my scan files with a 125kHz step.

[ProSoundWeb Community]