ProSoundWeb Community

Please login or register.

Login with username, password and session length
Advanced search  

Pages: 1 2 [All]   Go Down

Author Topic: RF Explorer .csv formatting for WSM  (Read 9581 times)

Diogo Nunes Pereira

  • Full Member
  • ***
  • Offline Offline
  • Posts: 171
  • Barcelona, sometimes...
RF Explorer .csv formatting for WSM
« on: October 22, 2015, 05:45:53 pm »

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
Logged
Diogo Nunes Pereira
elraval@gmail.com
--------------------------
"I envy not those who own charriots, horses or land. I envy only those who drink water from every spring." - Popular Song from Portugal

Pete Erskine

  • Moderator
  • Hero Member
  • *****
  • Offline Offline
  • Posts: 1393
    • Best Audio
Re: RF Explorer .csv formatting for WSM
« Reply #1 on: October 22, 2015, 06:39:52 pm »

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/
Logged
Pete Erskine
917-750-1134
www.bestaudio.com
peter@bestaudio.com

Diogo Nunes Pereira

  • Full Member
  • ***
  • Offline Offline
  • Posts: 171
  • Barcelona, sometimes...
Re: RF Explorer .csv formatting for WSM
« Reply #2 on: October 23, 2015, 12:40:38 pm »

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
Logged
Diogo Nunes Pereira
elraval@gmail.com
--------------------------
"I envy not those who own charriots, horses or land. I envy only those who drink water from every spring." - Popular Song from Portugal

James Kazeze

  • Newbie
  • *
  • Offline Offline
  • Posts: 5
Re: RF Explorer .csv formatting for WSM
« Reply #3 on: December 19, 2015, 09:43:28 pm »

Yes!  :D

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!
Logged

James Kazeze

  • Newbie
  • *
  • Offline Offline
  • Posts: 5
Re: RF Explorer .csv formatting for WSM
« Reply #4 on: December 20, 2015, 03:10:02 pm »

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.
Logged

Jason Glass

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 781
    • CleanWirelessAudio.com
Re: RF Explorer .csv formatting for WSM
« Reply #5 on: December 21, 2015, 12:04:43 am »

Yes!  :D

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

  • Newbie
  • *
  • Offline Offline
  • Posts: 1
Re: RF Explorer .csv formatting for WSM
« Reply #6 on: April 18, 2016, 11:14:48 am »

Hi James

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

Thanks!
Zoe
Logged

Mac Kerr

  • Old enough to know better
  • Administrator
  • Hero Member
  • *****
  • Offline Offline
  • Posts: 6870
  • Audio Plumber
Posting Rules
« Reply #7 on: April 18, 2016, 11:29:52 am »

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
Logged

Pete Erskine

  • Moderator
  • Hero Member
  • *****
  • Offline Offline
  • Posts: 1393
    • Best Audio
Re: RF Explorer .csv formatting for WSM
« Reply #8 on: April 18, 2016, 01:33:37 pm »

Yes!  :D

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?
Logged
Pete Erskine
917-750-1134
www.bestaudio.com
peter@bestaudio.com

Diogo Nunes Pereira

  • Full Member
  • ***
  • Offline Offline
  • Posts: 171
  • Barcelona, sometimes...
Re: RF Explorer .csv formatting for WSM
« Reply #9 on: May 02, 2016, 05:56:27 pm »

Yes!  :D

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

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

D
Logged
Diogo Nunes Pereira
elraval@gmail.com
--------------------------
"I envy not those who own charriots, horses or land. I envy only those who drink water from every spring." - Popular Song from Portugal

keithfarmer

  • Newbie
  • *
  • Offline Offline
  • Posts: 2
    • The Audio Alliance
Re: RF Explorer .csv formatting for WSM
« Reply #10 on: May 06, 2016, 05:43:32 am »

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

  • Newbie
  • *
  • Offline Offline
  • Posts: 5
Re: RF Explorer .csv formatting for WSM
« Reply #11 on: May 17, 2016, 06:38:24 pm »

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!
Logged

James Kazeze

  • Newbie
  • *
  • Offline Offline
  • Posts: 5
Re: RF Explorer .csv formatting for WSM
« Reply #12 on: May 17, 2016, 06:40:10 pm »

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!
Logged

James Kazeze

  • Newbie
  • *
  • Offline Offline
  • Posts: 5
Re: RF Explorer .csv formatting for WSM
« Reply #13 on: May 17, 2016, 06:40:40 pm »

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

D

Not a problem at all!
Logged

Diogo Nunes Pereira

  • Full Member
  • ***
  • Offline Offline
  • Posts: 171
  • Barcelona, sometimes...
Re: RF Explorer .csv formatting for WSM
« Reply #14 on: September 26, 2016, 07:51:50 pm »

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.
Logged
Diogo Nunes Pereira
elraval@gmail.com
--------------------------
"I envy not those who own charriots, horses or land. I envy only those who drink water from every spring." - Popular Song from Portugal

ProSoundWeb Community

Re: RF Explorer .csv formatting for WSM
« Reply #14 on: September 26, 2016, 07:51:50 pm »


Pages: 1 2 [All]   Go Up
 



Page created in 0.03 seconds with 23 queries.