- This topic has 3 replies, 2 voices, and was last updated 7 years, 10 months ago by
.
- Posts
I recently purchased an SA44B to use for frequency coordination of RF microphones and In Ear systems in a live sound environment. I am exporting CSV files from spike to import into coordination software. I have no problem importing my CSV files into Shure’s Wireless Workbench but I am unable to import them into Professional Wireless IAS. When I try to import to IAS I am prompted with a message that says that “The data format of this file could not be determined.”
When viewing my CSV files with a document viewer they appear as follows:
400.014251, -100.0442
400.042823, -100.0231
400.071394, -100.7527
400.099966, -100.3621
400.128537, -99.6406
400.157108, -99.4818
400.185680, -100.1065
400.214251, -100.9081
400.242823, -100.3853
400.271394, -100.5615
400.299966, -99.8299
400.328537, -99.0408
400.357108, -98.9290
400.385680, -99.6852
400.414251, -101.2290
400.442823, -100.7002
400.471394, -100.8887I am also currently able to import CSV files from a different brand scanner with no problems. The CSV file from that scanner appear as follows:
Model Type: PSA2702,
File Version Number…: X02-02,
Trace Type: Live,
Start Frequency: 0470.0000 MHz,
Stop Frequency: 0698.0000 MHz,
RBW: 280kHz,
Auto RBW: Off,
Video Filter: On,
Prefs Trace CSV: Absolute,
Reference Level: -20dBm,
Fixed Offset: Off,-010.0dB,
Graticule Scale: 10dB/div,
Graticule Shift: 00,
0470.0000,-087.7
0470.8440,-087.3
0471.6890,-087.5
0472.5330,-087.1
0473.3780,-086.9
0474.2220,-087.4
0475.0670,-086.7
0475.9110,-076.6
0476.7560,-052.2
0477.6000,-054.2
0478.4440,-055.1
0479.2890,-055.2
0480.1330,-055.1Thinking that maybe it was just a matter of significant figures I edited my original CSV file to appear as follow with no success:
470.0142, -100.4
470.0428, -100.3
470.0713, -100.5
470.0990, -99.6
470.1285, -98.8
470.1571, -99.3
470.1856, -100.8
470.2142, -101.7
470.2428, -101.6
470.2713, -101.7
470.2990, -100.4
470.3281, -99.2
470.3571, -99.4
470.3854, -100.5
470.4245, -101.4
470.4428, -100.7
470.4718, -100.8
470.4990, -100.2Anyone have any ideas on how I can get IAS to recognize my .CSV files?
Thanks!
AlexHi Charles,
Sorry for the late response. I was hoping another IAS user would chime in with their experience. Does the IAS software have a user manual or anything else that would describe the file format it expects? If you can find this, I could probably help determine what would need to be done to make it work.
The file that you said works has several configuration settings included, is it possible the IAS software expects one/some of these?
Regards,
AndrewHi Charles,
If simply re-saving the file fixed the issue, I’m going to guess that the line endings is what is resolved it. Our software probably saves newlines with ‘\n’ and excel will replace them with ‘\r\n’. After looking at the files, the resaved version also removed the spaces between the values on each line, maybe that?
Glad you found a solution,
Regards,
Andrew
You must be logged in to reply to this topic.