CSV trunking p25 format

[BorisG]

I am in a country where there is no information at all from radioreference DB (outside the US)

I wanted to use the Import option on a Unication G5 device to write the CVS on my own and upload to the device

The thing I did not understand what is the correct format maybe someone can help me?

my try:

RFSS,Site,Name,Freqs
1,1(1),test,864.222

 

[lebrunmn]

Boris-
this may help--it's a discussion about the CSV headers format:

CSV import in PPS Version 03.14.10

Did I miss documentation somewhere on how to format the csv file for talkgroup information from Radio Reference to import into PPS? I'm running the latest version 03.14.10. I've tried variations of the following (which I found in another group) and all I keep getting is "The data format of...

forums.radioreference.com

Example:
Decimal,Subfleet,Alpha Tag,Mode,Description,Tag,Category
1001,,EBRCS Call 1,D,Calling,Interop,System Wide

 

[BorisG]

This is a great example of Talkgroup
But I'm looking for an example of control frequencies

 

[RaleighGuy]

Here is the format for trunking sites from the RR database, and the columns Unication looks at:

RFSS​

Site Dec​

Site Hex​

Site NAC​

Description​

County Name​

Lat​

Lon​

Range​

Frequencies​

​

​

​

Each frequency should be in a separate column.

 

[N6ML]

I am in a country where there is no information at all from radioreference DB (outside the US)

I wanted to use the Import option on a Unication G5 device to write the CVS on my own and upload to the device

The thing I did not understand what is the correct format maybe someone can help me?

Download the CSV from a US location and use it as a template.

 

[BorisG]

Can send at least one sample with details please

Here is the format for trunking sites from the RR database, and the columns Unication looks at:

RFSS​

Site Dec​

Site Hex​

Site NAC​

Description​

County Name​

Lat​

Lon​

Range​

Frequencies​

​

​

​

Each frequency should be in a separate column.

Can send at least one sample with details please

 

[BorisG]

Download the CSV from a US location and use it as a template.

I understand you need to purchase a subscription for this

 

[RaleighGuy]

Can send at least one sample with details please

I understand you need to purchase a subscription for this

Those are the headings, you should be able to fill in the blanks, as download of the information requires a premium subscription I do not feel comfortable sending the RR information.

 

[BorisG]

Believe me if there was information about my country I would be the first to pay
You can also send me old / unused information

I did not understand what lon, land, range

 

[RaleighGuy]

Lat, Lon, and range can be blank, that is the GPS (Lat/Lon) location of the site and range is distance site is rated for.

 

[BorisG]

Believe me if there was information about my country I would be the first to pay
You can also send me old / unused information

I did not understand what lon, land, range

RFSS,Site Dec,Site Hex,Site NAC,Description,County Name,Lat,Lon,Range,Frequencies
1,53,35,37D,test,not use,,,,868.57500

not working...



SITE NAC = wacn id ?
? = System ID

 

[RaleighGuy]

The WACN ID can be set to 'FFFFF' which means radio can automatically search and match a appropriate WACN ID to use. The System ID can be set to 'FFF'. You do not need to know the system RFSS (leave it as 1) and Site number may be set to FF.

 

[BorisG]

The WACN ID can be set to 'FFFFF' which means radio can automatically search and match a appropriate WACN ID to use. The System ID can be set to 'FFF'. You do need to know the system RFSS and Site number.

Frequency 868.57500
RFSS 1
Site Dec 53

Can you please give me a proper line for CVS

 

[RaleighGuy]

Frequency 868.57500
RFSS 1
Site Dec 53

Can you please give me a proper line for CVS

RFSS,Site Dec,Site Hex,Site NAC,Description,County Name,Lat,Lon,Range,Frequencies
1,053,35,FFF,test,notuse,,,,868.57500

 

[N6ML]

Can you please give me a proper line for CVS

It's CSV (comma-separated variables), not CVS.

It appears that PPS 0.3.16 Beta24 will not import trunked system CSV downloaded from RR today - I get "Input string was not in a correct format" on an unmodified downloaded file.

 

[N6ML]

So it looks like RR added some flags to the frequencies (like 'c' for "control channel"), and PPS doesn't like that. This format works:

RFSS,Site Dec,Site Hex,Site NAC,Description,County Name,Lat,Lon,Range,Frequencies
1,001,1,1F1,"ALCO Southwest Simulcast","Alameda",37.59306523267257,-122.08495782426564,13,769.293750,769.581250,769.868750,770.331250,770.768750,771.043750,771.343750,771.643750,771.943750,772.243750,772.543750,772.843750

You get prompted for the WACN ID and System ID during the import process (after selecting a properly-formatted file).

 

[BorisG]

RFSS,Site Dec,Site Hex,Site NAC,Description,County Name,Lat,Lon,Range,Frequencies
1,053,35,FFF,test,notuse,,,,868.57500

Thanks it works

 

[w2lie]

It's CSV (comma-separated variables), not CVS.

It appears that PPS 0.3.16 Beta24 will not import trunked system CSV downloaded from RR today - I get "Input string was not in a correct format" on an unmodified downloaded file.

See if this helps: Fixed: Issues with importing Talk Groups from RR CSV Download
(Fix is only for the TG import, not Site. If you have a problem with site, try looking at the headers)

 

[N6ML]

See if this helps: Fixed: Issues with importing Talk Groups from RR CSV Download
(Fix is only for the TG import, not Site. If you have a problem with site, try looking at the headers)

No, I think this looks like a new issue - RR apparently added flags like 'c' for "control channel" to the Frequencies....

RFSS,Site Dec,Site Hex,Site NAC,Description,County Name,Lat,Lon,Range,Frequencies
1,001,1,1F1,"ALCO Southwest Simulcast","Alameda",37.59306523267257,-122.08495782426564,13,769.293750,769.581250,769.868750,770.331250,770.768750,771.043750,771.343750,771.643750,771.943750c,772.243750c,772.543750c,772.843750c

Removing the 'c's makes it work again.