[UK-CONTEST] Excel to Cabrillo (text) file - help pse?

[Cooper, Stewart]

In the past I have found this the quickest/easiest route too. I do feel that there is a gap in the market for a fast and dirty utility that takes text format log files of ANY kind and can spit out an ADIF, Cabrillo file or even RSGB format for VHF contest entries. The old DOS Turbolog had a great import facility which worked well in a similar way. I'd write it myself if I had the time!

Stewart

-----Original Message-----
From: uk-contest-bounces at contesting.com
[mailto:uk-contest-bounces at contesting.com]On Behalf Of Gavin Taylor
GM0GAV
Sent: 01 March 2005 14:43
To: UK Contest Reflector
Subject: Re: [UK-CONTEST] Excel to Cabrillo (text) file - help pse?


Hi Nigel,

I did a similar thing some time ago to help somebody get started with
Dxbase. It started out in a nasty G4TYF log format.

I used excel to manipupate it into the correct format, then exported to a
csv file. From there used Asc2ADIF http://kh2d.net/software/asc2adif.cfm to
convert it to an adif. That will then go straight into TQSL for upload.

If you run into problems send me a sample log and I will take a look.

73 Gavin
GM0GAV

----- Original Message -----
From: "Don Field" <g3xtt at lineone.net>
To: "UK Contest Reflector" <uk-contest at contesting.com>
Sent: Tuesday, March 01, 2005 1:50 PM
Subject: Re: [UK-CONTEST] Excel to Cabrillo (text) file - help pse?


> Trivial Nigel - Paste-special (unformatted text) into Ultraedit or
> equivalent, and you can then manipulate the columns to your heart's
content.
> I do it all the time when people send Excel logs for the IOTA contest.
>
> 73 Don G3XTT
>
> ----- Original Message -----
> From: "Nigel G3TXF" <nigel at G3TXF.com>
> To: "Chris Tran ZL1CT" <zl1ct at gm7v.com>
> Cc: "UK Contest Reflector" <uk-contest at contesting.com>
> Sent: Tuesday, March 01, 2005 10:18 AM
> Subject: [UK-CONTEST] Excel to Cabrillo (text) file - help pse?
>
>
> > Hullo Chris,
> >
> > Could you (or anyone else on the UK Contest Reflector) pse help me to
> export
> > an Excel file into a "Cabrillo compatible text-file"?
> >
> > I have been trying to do this with Word's Mail-Merge, but Mail-Merge
gives
> > you separate file for each line entry, and what I need is all the
entries
> > from the log in one flat text file.
> >
> > I realise that this is easy enough for those that know how - but I
don't!
> >
> > I have all my DX-Trip Logs in Access and now want to up-load them to
LoTW.
> > Exporting from Access in Excel is no problem, but getting from Excel
into
> a
> > Cabrillo-style flat text file is where I need help!
> >
> > 73 - Nigel G3TXF
> >
> > ----- Original Message -----
> > From: "Chris Tran ZL1CT" <zl1ct at gm7v.com>
> > To: "Tom Wylie" <t.wylie at ntlworld.com>; <uk-contest at contesting.com>
> > Sent: Tuesday, March 01, 2005 4:52 AM
> > Subject: Re: [UK-CONTEST] Easy question
> >
> >
> > > Hi Tom
> > >
> > > I have not actually done this, but one procedure would be :-
> > > 1. Export the Excel spreadsheet data to a Cabrillo compatible
text-file
> > > 2. Use WT4I tools to check this file, then save as a Cabrillo log-file
> > > 3. Import the Cabrillo log-file into logging software (Writelog cannot
> > > import Cabrillo)
> > > 4. Export as a .adi file
> > >
> > > There must be an easier way to do this..... ?
> > >
> > > 73
> > > Chris
> > > ZL1CT
> > >
> > > ----- Original Message -----
> > > From: "Tom Wylie" <t.wylie at ntlworld.com>
> > > To: <uk-contest at contesting.com>
> > > Sent: Tuesday, March 01, 2005 10:56 AM
> > > Subject: [UK-CONTEST] Easy question
> > >
> > >
> > >> How can I convert from an Excel file to an ADIF?
> > >>
> > >> tom
> > >> gm4fdm
> > >>
> > >> _______________________________________________
> > >> UK-Contest mailing list
> > >> UK-Contest at contesting.com
> > >> http://lists.contesting.com/mailman/listinfo/uk-contest
> > >
> > > _______________________________________________
> > > UK-Contest mailing list
> > > UK-Contest at contesting.com
> > > http://lists.contesting.com/mailman/listinfo/uk-contest
> > >
> > >
> >
> >
> > _______________________________________________
> > UK-Contest mailing list
> > UK-Contest at contesting.com
> > http://lists.contesting.com/mailman/listinfo/uk-contest
> >
>
>
> _______________________________________________
> UK-Contest mailing list
> UK-Contest at contesting.com
> http://lists.contesting.com/mailman/listinfo/uk-contest
>
> --
> This email has been verified as Virus free
> Virus Protection and more available at http://www.plus.net

_______________________________________________
UK-Contest mailing list
UK-Contest at contesting.com
http://lists.contesting.com/mailman/listinfo/uk-contest

Scanned by IFB SafeMail http://www.ifb.net for spam/UCE and virus content.
IFB Spam-Score:** (2.55)


----------------------------------------------------------------
   
Offshore Design Ltd
   
www.odl.co.uk
   
This email is for the sole use of the intended recipient(s) and may contain confidential
and privileged information. You should not disclose its contents to any other person. Any
unauthorised review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please notify the sender immediately.