CSV import from Travelplus for Repeaters

Control and memory management software for Icom transceivers
kd0bow
Posts: 1
Joined: Thu 24. Jan 2008, 00:24

CSV import from Travelplus for Repeaters

Unread post by kd0bow »

1st i want to thank you for the Nicest program i have seen for the IC-7000...
its a pleasure to use... once the comport is setup and working correctly its easy to use.

i am Stateside (in the USA) and use the ARRL program called Travelplus for Repeaters 2007-2008
its a great program that finds repeaters etc .. i use it for when i go on vacation.
it creates CSV files to import..

only issue .. it doesnt import correctly (causes the program to drop back out to windows XP)

how do i proceed to get this imported..
User avatar
DL2RUM
Administrator
Posts: 2770
Joined: Mon 27. Aug 2007, 13:36
Location: JO40DF

Re: CSV import from Travelplus for Repeaters

Unread post by DL2RUM »

I don't know this program and RUMtrol supports only one .csv protocol.

Code: Select all

Memory number  (A1-A99, B1-B99,....,1-99,1A, 1B, 2A, 2B,...., Call1, Call2)
Channel name  (0 to 9 ASCII chars)  (Would = "BLANK")
Frequency in Khz  (xxxxxx.xxx )
Mode  (AM,FM,LSB etc.)
Filter (1,2,3 )
RX SUB Freq (or off or NULL string)
TX SUB Freq (or off or NULL string)
DTCS type (NN,NR,RN,RR or NULL string)
DTCS code (023 to 754 or NULL string)
DUPLEX (DUP+ or DUP- or NULL string)
SCAN (ON or OFF or Null string)
Splitt  (ON or OFF or Null string)
Split Frequency in Khz  (xxxxxx.xxx )
Split Mode  (AM,FM,LSB etc.)
Split Filter (1,2,3 )
Split RX SUB Freq (or off or NULL string)
Split TX SUB Freq (or off or NULL string)
Split DTCS type (NN,NR,RN,RR or NULL string)
Split DTCS code (023 to 754 or NULL string)
You have to convert your file into this format. Make sure you have at least the first 12 fields included.

Then it should be looks like this:

Code: Select all

A1,"W6PW SF",145350,"FM",1,"OFF",114.8,,,"DUP-","ON","OFF"
A2,"KF6CLH",145410,"FM",3,,"OFF","NR",51,"Off","ON","On",145250,FM,2,"OFF",Off,RR,73,
B4,"KF6CLH",145410,"FM",3,,"OFF","NN",051,"DUP-","ON","OFF"
B3,"SR",145470,"FM",2,,88.5,,,"DUP-","OFF","OFF"
C4,"Oakland",145490,"FM",2,Off,131.8,,,"DUP-","OFF","OFF"
C5,"I3545",146115,"FM",1,,88.5,,,"DUP-","OFF","OFF"
D6,"Mdiablo",146205,"FM",1,,100,,,"DUP-","OFF","OFF"
D7,"SONOMA",146625,"FM",1,,88.5,,,"DUP-","ON","OFF"
E8,"SanRamon",146655,"FM",1,,107.2,,,"DUP-","OFF","OFF"
E9,"Vacaville",146670,"FM",1,,127.3,,,"DUP-","ON","OFF"
10,"Orinda",146715,"FM",1,,107.2,,,"DUP-","OFF","OFF"
11,"San Jose",146730,"FM",1,,100,,,"DUP-","OFF","OFF"
12,"SONOMA",146775,"FM",1,,88.5,,,"DUP-","OFF","OFF"
13,"Vacaville",146790,"FM",1,,123,,,"DUP-","OFF","OFF"
14,"NAPADAN",146820,"FM",1,,88.5,,,"DUP-","ON","OFF"
15,"W6BUR",146835,"FM",1,,85.4,,,"DUP-","ON","OFF"
16,"Annapolis",146880,"CW",1,,88.5,,,"off","ON","OFF"
17,"ACS SR",146910,"RTTY-R",1,,88.5,,,,"OFF","OFF"
18,"Novato",146940,"FM",1,,110.9,,,"DUP-","OFF","OFF"
19,"SR",146955,"FM",1,,88.5,,,"DUP-","OFF","OFF"
20,"NAPAJEFF",146970,"FM",1,,103.5,,,"DUP-","OFF","OFF"
Call1,"SR2",146985,"FM",1,,88.5,,,"DUP-","OFF","OFF"
Call2,"WB6NDJ",447000,"FM",1,,77,,,"DUP-","OFF","OFF"
1A,"PETALUMA",147060,"FM",1,,88.5,,,"DUP-","OFF","OFF"
1B,"KI6B",147105,"FM",1,,88.5,,,"DUP-","OFF","OFF"
25,"SR4",147120,"FM",1,,88.5,,,"DUP-","OFF","OFF"
26,"VE6MUF",147180,"FM",1,,162.2,,,"DUP-","OFF","OFF"
27,"SEBASTOPL",147195,"FM",1,,88.5,,,"DUP-","ON","OFF"
28,"Vacaville",147210,"FM",1,,136.5,,,"DUP-","OFF","OFF"
29,"Concord",147270,"FM",1,,100,,,"DUP+","OFF","OFF"
30,"WA6OXR SF",147315,"FM",1,,103.5,,,"DUP+","OFF","OFF"
31,"LARK-LMR",147360,"FM",1,,100,,,"DUP+","OFF","OFF"
32,"STHELENA",147445,"FM",1,,151.4,,,"DUP+","ON","OFF"
33,"I7650",441675,"FM",1,,123,,,"DUP+","OFF","OFF"
34,"I8410",441800,"FM",1,,100,,,"DUP+","OFF","OFF"
35,"W6AEX",7368.5,"FM",1,,77,,,"DUP+","OFF","OFF"
36,"W6SON",14070.095,"FM",1,,88.5,,,"DUP+","OFF","OFF"
37,"W6TI",145350,"FM",1,,110.9,,,"DUP+","OFF","OFF"
38,"EUREKA",145410,"FM",1,,107.2,,,"DUP+","OFF","OFF"
39,"I3351",145470,"FM",1,,100,,,"DUP+","OFF","OFF"
40,"W6CO",145490,"FM",1,,151.4,,,"DUP+","OFF","OFF"
41,"NOONTIME",146115,"USB",1,,"OFF",,,,"OFF","OFF"
43,"3905 PSK",146205,"USB",1,,"OFF",,,,"OFF","OFF"
44,"80m DX",3505.5,"CW",1,,"OFF",,,,"OFF","OFF"
73 and best dx de Tom, DL2RUM
ve6lx
Posts: 1
Joined: Tue 6. Jan 2009, 17:23

Re: CSV import from Travelplus for Repeaters

Unread post by ve6lx »

Tom:
I must be doing something wrong as I do not see my post.
In the cited example, you suggest 12 Fields with Field Names
the second example
A2,"KF6CLH",145410,"FM",3,,"OFF","NR",51,"Off","ON","On",145250,FM,2,"OFF",Off,RR,73,
has 19 fields and the last 7 have no filed names.
I am still trying to get my head around the program, so I would appreciate if you could also suggest field names for the last 7 fields.
Sorry if my question is so lame.
Thanks
Dave VE6LX

Thanks again for the Insanely Great Mac Program. hi hi
User avatar
DL2RUM
Administrator
Posts: 2770
Joined: Mon 27. Aug 2007, 13:36
Location: JO40DF

Re: CSV import from Travelplus for Repeaters

Unread post by DL2RUM »

Hi,
when posting, make sure you press the 'Submit' button. The 'Save' button will save the post only as a template for later use. I guess you used the wrong button.

The last 7 fields are used only, when 'Split' is selected to "ON". When split is "OFF" these fields are not required.
Following fields in this sequence are supported:

Memory number  (A1-A99, B1-B99,....,1-99,1A, 1B, 2A, 2B,...., Call1, Call2)
Channel name  (0 to 9 ASCII chars)  ( "BLANK" to clear)
Frequency in Khz  (xxxxxx.xxx )
Mode  (AM,FM,LSB etc.)
Filter (1,2,3 )
RX SUB Freq (or off or NULL string)
TX SUB Freq (or off or NULL string)
DTCS type (NN,NR,RN,RR or NULL string)
DTCS code (023 to 754 or NULL string)
DUPLEX (DUP+ or DUP- or NULL string)
SCAN (ON or OFF or Null string)
Splitt (ON or OFF or Null string)
Split Frequency in Khz  (xxxxxx.xxx )
Split Mode  (AM,FM,LSB etc.)
Split Filter (1,2,3 )
Split RX SUB Freq (or off or NULL string)
Split TX SUB Freq (or off or NULL string)
Split DTCS type (NN,NR,RN,RR or NULL string)
Split DTCS code (023 to 754 or NULL string)

I hope this helps
73 and best dx de Tom, DL2RUM
Locked