[WT-support] Getting data out of Win-Test

[Christian Janssen]

Hi Bob,

thanks for your feedback. 

I already know about creating CSV files out of WT. The plan is more to
have an automatic tool to do this job. and using the writelog command
with more than 100k QSOs takes a while. 

I learned that the broadcast feature is not very reliable. It may be
better to directly read the WT4 file to get the QSO data. Or is the
wtclublog tool also working with the sync feature of WT?

73s Chris



--- Ursprüngliche Nachricht --- 
Datum: 20.07.2012 10:42
Von: "Bob Wilson, N6TV" <n6tv at arrl.net>
An: support at win-test.com, "Christian Jannssen, DL1MGB"
<chris at dl1mgb.com>
Betreff: Re: [WT-support] Getting data out of Win-Test
 
> The entire log, plus calculated data such as country prefix,
continent,
> beam heading, distance to each QSO, etc. may be exported to a
> comma-delimited (.csv) file for easy import into spreadsheets or SQL
> databases. 
> 
> See  http://docs.win-test.com/wiki/Creating#Text_and_CSV_Files
> 
> Just type WRITELOG [Enter] in the Win-Test logging window and select
csv
> file.  Click the [Options...] button and select the fields to export. 
> 
> 73,
> Bob, N6TV
> 
> On Fri, Jul 20, 2012 at 12:41 AM, YANN - F1NGP <f1ngp at ref-union.org>
wrote:
> 
> > Hello Chris ,
> >
> > During PJ4C we use this tool:
> > http://www.plcg.org/wtclublog/
> >
> > Maybe you could ask to Pete G4CLA if the MYSQL server adress
(originaly
> > CLUBLOG server) could be changed ?
> >
> > 73 de YANN - F1NGP
> >
> >
> > On Fri, 20 Jul 2012 09:28:29 +0200, chris at dl1mgb.com (Christian
> > Janssen) wrote:
> > > Hi,
> > >
> > > does there exist already a solution to extract QSO data out of
Win-Test
> > > and to put the data into another database like MySQL or Access?
The plan
> > > is to extract QSO data (date, time, callsign, band, mode,
operator) and
> > > to use it in other programms for onlinelog, statistics,... Yes I
know
> > > there is Clublog... 
> > >
> > > So what I am asking is a possibility to get the data from Win-Test
and
> > > to put it into another database for further processing. 
> > >
> > > Hw?
> > >
> > > 73s Chris DL1MGB
> > >
> > >
> > >
> > > _______________________________________________
> > > Support mailing list
> > > support at win-test.com
> > > http://lists.f5mzn.org/cgi-bin/mailman/listinfo/support
> >
> > _______________________________________________
> > Support mailing list
> > support at win-test.com
> > http://lists.f5mzn.org/cgi-bin/mailman/listinfo/support
> >
>