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 13089 times)

Diogo Nunes Pereira

  • Full Member
  • ***
  • Offline Offline
  • Posts: 211
  • 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
[email protected]
--------------------------
"I envy not those who own charriots, horses or land. I envy only those who drink water from every fountain." - Popular Song from Portugal

Pete Erskine

  • Moderator
  • Hero Member
  • *****
  • Offline Offline
  • Posts: 1457
    • 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
[email protected]

Diogo Nunes Pereira

  • Full Member
  • ***
  • Offline Offline
  • Posts: 211
  • 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
[email protected]
--------------------------
"I envy not those who own charriots, horses or land. I envy only those who drink water from every fountain." - 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: 918
    • 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: 7562
  • 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: 1457
    • 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
[email protected]

Diogo Nunes Pereira

  • Full Member
  • ***
  • Offline Offline
  • Posts: 211
  • 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
[email protected]
--------------------------
"I envy not those who own charriots, horses or land. I envy only those who drink water from every fountain." - Popular Song from Portugal

ProSoundWeb Community

Re: RF Explorer .csv formatting for WSM
« Reply #9 on: May 02, 2016, 05:56:27 PM »


Pages: [1] 2  All   Go Up
 



Site Hosted By Ashdown Technologies, Inc.

Page created in 0.041 seconds with 25 queries.