Trace exports from Mac or Windows Clients

[jerm!]

Hello all,

I am using (and loving) my RF Explorer to supplement a more a more expensive TTi hand held unit for RF Coordinating. I use these tools in conjunction with Professional Wireless Systems IAS software. IAS allows me to import a trace from my TTi, as a CSV file and visually work around it wil my RF candidate frequencies. Here is a screen shot:

The imported TTi trace is in the bottom window. It appears as though the RF-Explorer windows client allows for the export of traces as a CSV file, however, the IAS software does not know what to do with this CSV file. Is it just a matter of formatting ? Is this something that can be updated in the RF-Explorer client? I have attached a trace file from the TTi unit for those curious.

Thanks!

Jeremy Goldstein

je...@jermg.com

[Ariel Rocholl]

Jerm,

This is a common request and I am working to offer it soon.

Background:

Unfortunately there is no such a thing as a "standard CSV" format defined anywhere (e.g. http://en.wikipedia.org/wiki/Comma-separated_values for reference). In fact, a CSV file may not even be separated by comma but by other delimiters, such as Tabulator.

The current version of the RF Explorer Windows Client generates a powerful, cumulative complex CSV containing all the data captured in the session, not a single data instance as the IAS software requires. You can easily convert the current format to the one you want (or any other) using a Perl, Python or even Excel scripting. However, as this is of common use, I am including the support of the IAS format in the RF Explorer Windows Client natively, so there is no need to perform any external conversion.

Best regards,
Ariel Rocholl

[Retiredbum]

Outstanding! 

 

At big companies, you'd have to do a market study to determine how many upgrades you would sell, then do an ROI on the investment required to design the new capabilities.  Then, if it passes the analysis, it would have to be prioritized against the other good ideas.  Then to the annual planning process…2 years later…

 

Looking forward to the update!

 

Thanks again,

 

--Alan

 

[jerm!]

Agreed! Thanks for the quick response Ariel!

Hi Lisa!! Miss ya on the BlackBerry shows!! Hope all is well!

-jerm!

On Monday, October 1, 2012 10:53:32 PM UTC-4, Lisa Woodward wrote:

I too am looking forward to this in the next update. Thank you so much. - Lisa

[Retiredbum]

On Sunday, September 30, 2012 10:41:29 AM UTC-7, Ariel Rocholl wrote:

Jerm,

This is a common request and I am working to offer it soon.

Background:

Unfortunately there is no such a thing as a "standard CSV" format defined anywhere (e.g. http://en.wikipedia.org/wiki/Comma-separated_values for reference). In fact, a CSV file may not even be separated by comma but by other delimiters, such as Tabulator.

The current version of the RF Explorer Windows Client generates a powerful, cumulative complex CSV containing all the data captured in the session, not a single data instance as the IAS software requires. You can easily convert the current format to the one you want (or any other) using a Perl, Python or even Excel scripting. However, as this is of common use, I am including the support of the IAS format in the RF Explorer Windows Client natively, so there is no need to perform any external conversion.

Best regards,
Ariel Rocholl

 

 

Ariel,

 

I've never imported CSV into the IAS software (I've only used the FCC database linkage IAS provides) so I don't know anything about it.  I'm just starting to the RF Explorer for scouting open frequencies for wireless mic applications.  So far, I like scanning 30MHz at a time.  (Lectrocsonics frequency blocks are 25.5 MHz wide.)

 

My question relates to how I will be able to get data over a wide bandwidth (say US TV channels 14-51, which equates to 470-698 MHz) from RF Explorer to IAS?  Since the maximum RF Explorer scan width is 100 MHz, the transfer would have to be in blocks assuming IAS can support that.  Or will you be able to combine narrower band scans into one CSV file?

 

Thanks, Alan

[Ariel Rocholl]

All,

The simpler CSV format required by IAS and other 3rd party software is available in the new RF Explorer for Windows v1.09.04 - please check the download area. An example of the file you can get now is listed below:

845.000,-79.32
845.089,-79.64
845.179,-77.41
845.268,-77.82
845.357,-76.50
845.446,-78.00
845.536,-78.09
845.625,-77.09
845.714,-78.41
845.804,-80.82
845.893,-103.27
845.982,-105.59
846.071,-104.18
846.161,-101.05
....

Alan,

I am not really familiar with what IAS software is capable for in terms of loading multiple CSV files to cover different frequency ranges. However, as the file is simple enough, you can easily generate files for the different (consecutive) frequency areas you need, and easily join them together from the command line as per below example. It is not ideal, but easy enough as a workaround in the meantime we work to extend the frequency span available for RF Explorer, which I expect to be dramatically larger before end of year.

• Say you saved three files, each one using the same span (100MHz) and consecutive so the file1.csv is 150-250MHz, file2.csv is 250-350Mhz, and file3.csv is 350-450MHz and you have these 3 files generated in c:\mytests\ folder)
• Type the following commands in a command line window in order to get a combined file_all.csv with these three frequency areas "glued" together in a single file:

cd /d c:\mytests

copy file1.csv+file2.csv+file3.csv /A file_all.csv

Best,

Ariel

[Ariel Rocholl]

Lisa,

This should work now with the new version. Let me know otherwise.

Best,
Ariel

On Tue, Oct 2, 2012 at 4:53 AM, Lisa Woodward <lisawoo...@gmail.com> wrote:

I too am looking forward to this in the next update. Thank you so much. - Lisa

On Sunday, September 30, 2012 11:36:03 PM UTC-7, Retiredbum wrote:

--
 
 
 

--
Ariel Rocholl
http://www.rf-explorer.com

[Dirk-Willem van Gulik]

On 4 Oct 2012, at 11:00, Ariel Rocholl wrote:

> This should work now with the new version. Let me know otherwise.

It also works in the mac version - unfortunately that one is currently still stuck in apple-review (as we access hardware - it is taking a few months now for Apple to work through their 'sandbox is mandatory' issues.

If people are stuck on this - let me know and I'll do a self-compiled/non-apple approved version (or you can build form source).

Dw

[Ariel Rocholl]

Yes, it is sad the improvements you did are still waiting in the Apple's review queue...

In the meantime, perhaps a DMG distributable could help Mac users to get the latest greatest improvements you did, I can upload it to the RF Explorer official download area if you want to, let me know.

Ariel

Dw

--

[jerm!]

Ariel, 

I can confirm this Single Signal CSV feature works as it should. IAS had no problem displaying the data.

Thanks so much making this happen so quickly!!

[Ariel Rocholl]

Excellent, thanks for the feedback.

[Lisa Woodward]

I can confirm that Shure Workbench 6.5 also was able to import the "Single Signal CSV" file. Thank you so much! - Lisa

[Ariel Rocholl]

I am glad it worked as expected, thanks for the update.

--
 
 
 

[Lisa Woodward]

Make sure your RF explorer has got the latest firmware. I have experienced an issue where the RF explorer appeared to have the latest firmware but the file would not import into WB 6.5. I re-updated the firmware and it fixed the issue.

Hope this helps - Lisa

On Sunday, November 25, 2012 12:27:36 PM UTC-8, Michał Kacunel wrote:

Is there any special way of importing the CSV file into WWB6.5? When I tried opening the Single Signal CVS file WWB tells me that the file is either corrupt or the wrong format. I would appreciate if anyone could shine some light on this.

Thanks!

[Ariel Rocholl]

Hi Jens,

I would assume that has to do with your "local / regional settings" in Windows. Can you check to see if your configuration in Windows uses "." for decimal separator? If it doesn't but uses ",", then the OS will create a wrong CSV format. Optionally, you may use the configuration option within the RF Explorer for Windows tool, to select a different separator (such as a TAB) but check if WWB supports CSV with TABs rather than commas.

On Tuesday, March 19, 2013 4:25:37 AM UTC+1, Jens Bacher wrote:

Hi

When using comma as a default decimal seperator in windows, RF explorer will output CSV data with 3 commas in each line, which Shure WWB will not read. Could this be fixed?

Jens Bacher