Page 1 of 1

CSV import from Travelplus for Repeaters

Posted: Thu 24. Jan 2008, 01:04
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..

Re: CSV import from Travelplus for Repeaters

Posted: Thu 24. Jan 2008, 16:19
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"

Re: CSV import from Travelplus for Repeaters

Posted: Thu 8. Jan 2009, 15:35
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

Re: CSV import from Travelplus for Repeaters

Posted: Thu 8. Jan 2009, 15:56
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