Import Data

Imported from Yahoo
1

I am trying to import race results from an excel spreadsheet, saved as a
.csv file
The positions have been entered in the spreadsheet under a 'pos' column &
other codes under a seperate 'code' column
The positions import OK but the codes (DNF, DSQ etc) come over with a small
square after the code which causes a problem with Sailwave not recognising
the code.

Ralph Tingle

[Non-text portions of this message have been removed]

2

Ralph:
I have had a similar problem, if you look at your .csv file in
notepad, I think you will see that there is no comma at the end of
the line. Try adding an extra column in your spreadsheet labelled
Ignore. You will now be able to import the file and Sailwave will
ignore the last column labelled Ignore.

Yours
John Crawley

I am trying to import race results from an excel spreadsheet, saved

as a

.csv file
The positions have been entered in the spreadsheet under a 'pos'

column &

other codes under a seperate 'code' column
The positions import OK but the codes (DNF, DSQ etc) come over with

a small

square after the code which causes a problem with Sailwave not

recognising

···

--- In sailwave@yahoogroups.com, "Ralph Tingle" <rat@a...> wrote:

the code.

Ralph Tingle

[Non-text portions of this message have been removed]

3

Hi John/Ralph

The 1.58 beta has this fixed.

"Fix leaving binary chars in fields when importing from CSV files."

CJ

···

-----Original Message-----
From: jcc2jcc [mailto:johncrawley@sympatico.ca]
Sent: 16 August 2004 19:16
To: sailwave@yahoogroups.com
Subject: [sailwave] Re: Import Data

Ralph:
I have had a similar problem, if you look at your .csv file in
notepad, I think you will see that there is no comma at the end of
the line. Try adding an extra column in your spreadsheet labelled
Ignore. You will now be able to import the file and Sailwave will
ignore the last column labelled Ignore.

Yours
John Crawley

--- In sailwave@yahoogroups.com, "Ralph Tingle" <rat@a...> wrote:
> I am trying to import race results from an excel spreadsheet, saved
as a
> .csv file
> The positions have been entered in the spreadsheet under a 'pos'
column &
> other codes under a seperate 'code' column
> The positions import OK but the codes (DNF, DSQ etc) come over with
a small
> square after the code which causes a problem with Sailwave not
recognising
> the code.
>
> Ralph Tingle
>
>
> [Non-text portions of this message have been removed]

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!-
http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com
Yahoo! Groups Links

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004

4

Thanks guys
The wierd thing about this problem is that when I reloaded Sailwave & the
file later in the day, the 'square' character had disappeared!!!
This also happened once when loading up rating files - the update did not
appear until I shut down & re-loaded Sailwave.

Is this ME or just one of those things??

Regards
Ralph

···

-----Original Message-----
From: Colin Jenkins [mailto:colin@sailwave.com]
Sent: 16 August 2004 20:55
To: sailwave@yahoogroups.com
Subject: RE: [sailwave] Re: Import Data

Hi John/Ralph

The 1.58 beta has this fixed.

"Fix leaving binary chars in fields when importing from CSV files."

CJ

-----Original Message-----
From: jcc2jcc [mailto:johncrawley@sympatico.ca]
Sent: 16 August 2004 19:16
To: sailwave@yahoogroups.com
Subject: [sailwave] Re: Import Data

Ralph:
I have had a similar problem, if you look at your .csv file in
notepad, I think you will see that there is no comma at the end of
the line. Try adding an extra column in your spreadsheet labelled
Ignore. You will now be able to import the file and Sailwave will
ignore the last column labelled Ignore.

Yours
John Crawley

--- In sailwave@yahoogroups.com, "Ralph Tingle" <rat@a...> wrote:
> I am trying to import race results from an excel spreadsheet, saved
as a
> .csv file
> The positions have been entered in the spreadsheet under a 'pos'
column &
> other codes under a seperate 'code' column
> The positions import OK but the codes (DNF, DSQ etc) come over with
a small
> square after the code which causes a problem with Sailwave not
recognising
> the code.
>
> Ralph Tingle
>
>
> [Non-text portions of this message have been removed]

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!-
http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com
Yahoo! Groups Links

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004

-!- http://www.fastmail.fm/ -!- http://www.spampal.org/ -!-
http://www.sailwave.com/ -!-

Convert to daily digest of emails send blank email to:
sailwave-digest@yahoogroups.com
Yahoo! Groups Links