Fixed: Issues with importing Talk Groups from RR CSV Download

[w2lie]

I've noticed tonight that I am having issues importing a Radio Reference CSV Dump into the Group call section of the G-Series PPS.

It looks like a heading has changed on the export, at least on the systems I am importing tonight for a customer's profile.


The issue is that the second column is called "HEX". On earlier dumps of the CSV's, the second column was called "SUBFLEET".

My workaround at this time is to open each CSV file and change the heading of the second column. This fixes the import issue.

 

[jpolich7]

Tried the edit to subfleet but PPS still not accepting talk group csv files.

 

[w2lie]

Can you post a link to the system in the database you are having issues with? I would like to see how it looks when I export it to a CSV file and also try to import it into my copy of PPS.

 

[w2lie]

I see from your other thread it was the Phoenix RWC system.

I modified the header to "Subfleet" as per my initial post and it worked fine for me.

 

[Webodisk]

It seems affect to all imports, I tried NC VIPER yesterday got same error, edited CSV header from HEX to subfleet worked perfectly

 

[rivardj]

That second column should never have been labeled as Subfleet, not aplicable to P25 systems. Changing it to Hex and populating it with the correct data makes sense.

I discovered the change a few days ago when I tried to up date my Excel Workbook that I use to create files in the proper format for DSDPlus and OP25. It took me about an hour to update my Workbook to accept the new file format.

 

[LEH]

That second column should never have been labeled as Subfleet, not aplicable to P25 systems. Changing it to Hex and populating it with the correct data makes sense.

I discovered the change a few days ago when I tried to up date my Excel Workbook that I use to create files in the proper format for DSDPlus and OP25. It took me about an hour to update my Workbook to accept the new file format.

So are you saying you got your TG file to import with 'Hex'? I messed around with two TG files last night, one with 'hex' values after the decimal and the other without any values after the 'decimal' field. If the header row had 'hex' in either case, it would not import.

I won't argue that 'subfleet' makes no sense, but that is the accepted format. Hopefully a fix to allow both may come forth (making 'hex' the preferred, but allowing older files with 'subfleet' to also still work).

 

[jpolich7]

As fmulder13 pointed out elsewhere, the problem persists. As I posted above, the fixes suggested do not work for Phoenix RWC and according to other posts the fixes do not work for them either. Appears to be a bug in the RR data files or the Unication PPS import utility.

 

[w2lie]

I was able to import the Phoenix RWC system if I modified it.
I also imported the California East Bay Regional Communications System, The North Carolina VIPER system, Wake Systems, and Durham Systems, as well as local systems in NY.

So far any system I needed to import for customers has been successful.

What if you take the systems you couldn't import and change the headers to match what can import?
What happens if you remove the HEX values completely?

Can you share what systems didn't work for you? I'd like to see if I can get them to import.

 

[jpolich7]

PPS V0.3.17 Beta4 will not import Phoenix RWC talkgroups. Error message is same as others report for other systems in other locations: data format wrong. Editing HEX and other suggestions do not help, as mentioned a couple weeks ago. Also, files posted by others that they reported as working will not import. There is a new flaw in the RR files for Phoenix RWC and some/all other systems or in the PPS software or both.

 

[rivardj]

LEH,

I muddied the waters with my comment. My situation has nothing to do with Unication hardware or associated software. I have an Excel Workbook that I created to generate files from Radio Reference csv files that are compatible with DSD+ and OP25 systems. I had the same sort of issue as the Unication software has when the change was made to the source files from Radio Reference. I was just acknowledging the issue.

Sorry for the confusion.

 

[KevinC]

PPS V0.3.17 Beta4 will not import Phoenix RWC talkgroups. Error message is same as others report for other systems in other locations: data format wrong. Editing HEX and other suggestions do not help, as mentioned a couple weeks ago. Also, files posted by others that they reported as working will not import. There is a new flaw in the RR files for Phoenix RWC and some/all other systems or in the PPS software or both.

I just tried with the beta on RWC and it worked after I made the header change.

 

[fmulder13]

I was able to import talk groups from Minnesota's statewide ARMER system, after using Excel to modify the "Hex" label to "Subfleet." Using Apple Numbers failed. Marking the same line "SubFleet," and "subfleet" also failed. It had to be "Subfleet" to work for me.

 

[RFBURNS2]

Thanks all for the fix. Changing the header to “Subfleet“ worked for me. I use google sheets. DL file from RR. Right click file and open in notepad. Remove hex replace with Subfleet.

 

[Uni1]

This has been fixed and will be in our V1.3 PPS.

 

[junkycosmos]

hi Uni1 and all
Will v1.3 PPS ve available on Downloads- G4/G5 P25 Voice Pager | unicationusa site?
Just checked today and it still shows v0.3.14.15 released 07/2019
or do we download v1.3 PPS from somewhere else? Thx

 

[w9zro]

OK can someone modify a csv file for me i have tried everything and it still wont work its for the Lake county Indiana trunked system would really like to import the talkgroup list Lake County Public Safety Trunking System, Countywide, Indiana - Scanner Frequencies PLEASE my pps is V0.3.17beta04 it just will not work for me

 

[Webodisk]

Try this

 

[w9zro]

omg thanks soo much owe you a cold one that's for sure

 

[W4BLR]

OK Guys. Changing the header worked as far as importing the file...but...it will not import the ID tags ,HEX or otherwise. I will have to type in all the the ID's. What gives?