Importing CSV-results

Imported from Yahoo
1

sw2.01build7

Hi,

when importing raceresults from a CSV-file Sailwave does not recognize mapped fields eg importing series from R1, R2...

/Anders

2

Hi Anders

         I use CSV Results import all the time without any problem, can you send us a sample csv file?

cheers
Tony

···

At 21:22 05/08/2009, Anders Landenstad wrote:

sw2.01build7

Hi,

when importing raceresults from a CSV-file Sailwave does not recognize mapped fields eg importing series from R1, R2...

/Anders

3

Hi Tony,

It´s not a big deal for me but we had this in an earlier version and
MrC fixed it. Competitorimport is OK but not results

//Anders

···

--- In sailwave@yahoogroups.com, Tony Tucker <tony@...> wrote:

Hi Anders

         I use CSV Results import all the time without any problem,
can you send us a sample csv file?

cheers
Tony

At 21:22 05/08/2009, Anders Landenstad wrote:
>
>
>sw2.01build7
>
>Hi,
>
>when importing raceresults from a CSV-file Sailwave does not
>recognize mapped fields eg importing series from R1, R2...
>
>/Anders
>
>

4

Her are some files: But “I see the light” that fixes it… . the guess button.

But it does not remember the field for the next race.

/Anders

···

----- Original Message -----

From:
Tony Tucker

To: sailwave@yahoogroups.com

Sent: Wednesday, August 05, 2009 10:32 PM

Subject: Re: [sailwave] Importing CSV-results

Hi Anders

I use CSV Results import all the time without any problem,
can you send us a sample csv file?

cheers
Tony

At 21:22 05/08/2009, Anders Landenstad wrote:

sw2.01build7

Hi,

when importing raceresults from a CSV-file Sailwave does not
recognize mapped fields eg importing series from R1, R2…

/Anders

5

Hi Anders

         Yes, you always need to hit Guess to get all the fields lined up.

cheers
Tony

···

At 21:48 05/08/2009, Anders Landenstad \(juniorsegling.se\) wrote:

[Attachment(s) from Anders Landenstad (juniorsegling.se) included below]

Her are some files: But "I see the light" that fixes it.... . the guess button.

But it does not remember the field for the next race.

/Anders
----- Original Message -----
From: <mailto:tony@tonytucker.com>Tony Tucker
To: <mailto:sailwave@yahoogroups.com>sailwave@yahoogroups.com
Sent: Wednesday, August 05, 2009 10:32 PM
Subject: Re: [sailwave] Importing CSV-results

Hi Anders

I use CSV Results import all the time without any problem,
can you send us a sample csv file?

cheers
Tony

At 21:22 05/08/2009, Anders Landenstad wrote:
>
>sw2.01build7
>
>Hi,
>
>when importing raceresults from a CSV-file Sailwave does not
>recognize mapped fields eg importing series from R1, R2...
>
>/Anders
>

6

its very close to being sorted out so its slicker

  • i.e. not need for guess button and remembers.

it should remember now - it must be broken - or perhaps it only
remembers non-standard mappings.

cj

Tony Tucker wrote:

···

mailto:tony@tonytucker.commailto:sailwave@yahoogroups.comsailwave@yahoogroups.comhttp://www.yachtsandyachting.com/http://www.sailing.org/http://www.sailwave.com/http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdfsailwave-digest@yahoogroups.comsailwave-unsubscribe@yahoogroups.comhttp://groups.yahoo.com/group/sailwave/http://groups.yahoo.com/group/sailwave/joinmailto:sailwave-digest@yahoogroups.commailto:sailwave-fullfeatured@yahoogroups.comsailwave-unsubscribe@yahoogroups.comhttp://docs.yahoo.com/info/terms/

7

Hi Colin

         While you're on the import any chance of getting another couple of issues sorted?

         1) If the competitor is new, the PY is not set, even if the class in the csv file is contained within the ratings file.

         2) If the competitor is in Sailwave, but has not sailed before you need to include him manually for their result to count.

many thanks
Tony

···

At 13:32 19/08/2009, Colin Jenkins wrote:

its very close to being sorted out so its slicker - i.e. not need for guess button and remembers.

it should remember now - it must be broken - or perhaps it only remembers non-standard mappings.

cj

Tony Tucker wrote:

Hi Anders

         Yes, you always need to hit Guess to get all the fields lined up.

cheers
Tony

At 21:48 05/08/2009, Anders Landenstad \(juniorsegling.se\) wrote:

[Attachment(s) from Anders Landenstad (juniorsegling.se) included below]

Her are some files: But "I see the light" that fixes it.... . the
guess button.

But it does not remember the field for the next race.

/Anders
----- Original Message -----
From: <mailto:tony@tonytucker.com>Tony Tucker
To: <mailto:sailwave@yahoogroups.com>sailwave@yahoogroups.com
Sent: Wednesday, August 05, 2009 10:32 PM
Subject: Re: [sailwave] Importing CSV-results

Hi Anders

I use CSV Results import all the time without any problem,
can you send us a sample csv file?

cheers
Tony

At 21:22 05/08/2009, Anders Landenstad wrote:

sw2.01build7

Hi,

when importing raceresults from a CSV-file Sailwave does not
recognize mapped fields eg importing series from R1, R2...

/Anders

------------------------------------

-!- <http://www.yachtsandyachting.com/>http://www.yachtsandyachting.com/ -!- http://www.sailing.org/ -!- <http://www.sailwave.com/>http://www.sailwave.com/ -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from <http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf>http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf ~ Convert to daily digest of emails send blank email to <mailto:sailwave-digest@yahoogroups.com>sailwave-digest@yahoogroups.com ~ To unsubscribe from the SUG please send blank email to <mailto:sailwave-unsubscribe@yahoogroups.com>sailwave-unsubscribe@yahoogroups.com Yahoo! Groups Links

    (Yahoo! ID required)

    mailto:sailwave-fullfeatured@yahoogroups.com

8

Any chance you can fix the import so we can import competitors and aliases of competitors?

···

From: Tony Tucker

Sent: Wednesday, August 19, 2009 5:36 AM

To: sailwave@yahoogroups.com

Subject: Re: [sailwave] Importing CSV-results

Hi Colin

While you’re on the import any chance of getting another
couple of issues sorted?

  1. If the competitor is new, the PY is not set, even if the
    class in the csv file is contained within the ratings file.

  2. If the competitor is in Sailwave, but has not sailed
    before you need to include him manually for their result to count.

many thanks
Tony

At 13:32 19/08/2009, Colin Jenkins wrote:

its very close to being sorted out so its slicker - i.e. not need
for guess button and remembers.

it should remember now - it must be broken - or perhaps it only
remembers non-standard mappings.

cj

Tony Tucker wrote:

Hi Anders

Yes, you always need to hit Guess to get all the fields lined up.

cheers
Tony

At 21:48 05/08/2009, Anders Landenstad (juniorsegling.se) wrote:

[Attachment(s) from Anders Landenstad (juniorsegling.se) included below]

Her are some files: But “I see the light” that fixes it… . the
guess button.

But it does not remember the field for the next race.

/Anders
----- Original Message -----
From: mailto:tony@tonytucker.comTony Tucker
To: mailto:sailwave@yahoogroups.comsailwave@yahoogroups.com
Sent: Wednesday, August 05, 2009 10:32 PM
Subject: Re: [sailwave] Importing CSV-results

Hi Anders

I use CSV Results import all the time without any problem,
can you send us a sample csv file?

cheers
Tony

At 21:22 05/08/2009, Anders Landenstad wrote:

sw2.01build7

Hi,

when importing raceresults from a CSV-file Sailwave does not
recognize mapped fields eg importing series from R1, R2…

/Anders

-!-
<http://www.yachtsandyachting.com/>http://www.yachtsandyachting.com/

-!- http://www.sailing.org/ -!-
<http://www.sailwave.com/>http://www.sailwave.com/ -!- On-Line
Sailwave help…http://sailwave.com/help/HTML
~ Mark Thompson’s

Sailwave User Manual is available from
<http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf>http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf

~ Convert to daily digest of emails send blank email to
mailto:sailwave-digest@yahoogroups.comsailwave-digest@yahoogroups.com

~ To unsubscribe from the SUG please send blank email to
mailto:sailwave-unsubscribe@yahoogroups.comsailwave-unsubscribe@yahoogroups.com

Yahoo! Groups Links

(Yahoo! ID required)

mailto:sailwave-fullfeatured@yahoogroups.com

9

hi mark, importing aliases is tricky (i think) -
can you think of a syntax to do it… perhaps i’m missing the
obvious…

cj

S. Mark Townsend wrote:

···

www.avg.com

10

gh tony

1) If the competitor is new, the PY is not set, even if the class in the csv file is contained within the ratings file.

hmmm, given that sailwave only saves one rating at a time i’m not sure
it’s a bug - you can get around it by ticking the box on the rating tab
that says words tot he effct of ‘always update raings before scoring’

2) If the competitor is in Sailwave, but has not sailed before you need to include him manually for their result to count.

sorry - i dont follow…

cj

···

mailto:tony@tonytucker.commailto:sailwave@yahoogroups.comsailwave@yahoogroups.comhttp://www.yachtsandyachting.com/http://www.yachtsandyachting.com/http://www.sailing.org/http://www.sailwave.com/http://www.sailwave.com/http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdfhttp://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdfmailto:sailwave-digest@yahoogroups.comsailwave-digest@yahoogroups.commailto:sailwave-unsubscribe@yahoogroups.comsailwave-unsubscribe@yahoogroups.commailto:sailwave-fullfeatured@yahoogroups.comhttp://www.yachtsandyachting.com/http://www.sailing.org/http://www.sailwave.com/http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdfsailwave-digest@yahoogroups.comsailwave-unsubscribe@yahoogroups.comhttp://groups.yahoo.com/group/sailwave/http://groups.yahoo.com/group/sailwave/joinmailto:sailwave-digest@yahoogroups.commailto:sailwave-fullfeatured@yahoogroups.comsailwave-unsubscribe@yahoogroups.comhttp://docs.yahoo.com/info/terms/www.avg.com

11

Hi Colin

         Sorry maybe I was a bit brief in my explanations.

         1) I've looked but can't find the rating tab with the Update ratings setting. :frowning: My issue is that I have a new competitor in my CSV file, and I've checked the box on the import that says "Create Competitors during import if they are not already in the series" The competitors are created, but they are not given a rating, even though their boat class is in the ratings file. Double click the competitor, click on the little blue wave next to boat class, and the correct class is already selected. Would be super nice if the rating was added automatically to the competitor on import.

         2) There's something slightly weird here. I have a series with all members in, many of whom have not sailed this series. When a result for an unsailed member is imported they go into some kind of weird state where the result is there, but rescoring does not give them a rank. Selecting "Include all sailed members" puts them in a normal state where their times count.

many thanks
Tony

···

At 09:41 20/08/2009, Colin Jenkins wrote:

gh tony

         1) If the competitor is new, the PY is not set, even if the
class in the csv file is contained within the ratings file.

hmmm, given that sailwave only saves one rating at a time i'm not sure it's a bug - you can get around it by ticking the box on the rating tab that says words tot he effct of 'always update raings before scoring'

         2) If the competitor is in Sailwave, but has not sailed
before you need to include him manually for their result to count.

sorry - i dont follow...

cj

many thanks
Tony

At 13:32 19/08/2009, Colin Jenkins wrote:

its very close to being sorted out so its slicker - i.e. not need
for guess button and remembers.

it should remember now - it must be broken - or perhaps it only
remembers non-standard mappings.

cj

Tony Tucker wrote:

Hi Anders

         Yes, you always need to hit Guess to get all the fields lined up.

cheers
Tony

At 21:48 05/08/2009, Anders Landenstad \(juniorsegling.se\) wrote:

[Attachment(s) from Anders Landenstad (juniorsegling.se) included below]

Her are some files: But "I see the light" that fixes it.... . the
guess button.

But it does not remember the field for the next race.

/Anders
----- Original Message -----
From: <mailto:tony@tonytucker.com>Tony Tucker
To: <mailto:sailwave@yahoogroups.com>sailwave@yahoogroups.com
Sent: Wednesday, August 05, 2009 10:32 PM
Subject: Re: [sailwave] Importing CSV-results

Hi Anders

I use CSV Results import all the time without any problem,
can you send us a sample csv file?

cheers
Tony

At 21:22 05/08/2009, Anders Landenstad wrote:

sw2.01build7

Hi,

when importing raceresults from a CSV-file Sailwave does not
recognize mapped fields eg importing series from R1, R2...

/Anders

------------------------------------

-!-
<http://www.yachtsandyachting.com/>http://www.yachtsandyachting.com/
-!- <http://www.sailing.org/>http://www.sailing.org/ -!-
<http://www.sailwave.com/>http://www.sailwave.com/ -!- On-Line
Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's
Sailwave User Manual is available from
<http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf>http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf

~ Convert to daily digest of emails send blank email to
<mailto:sailwave-digest@yahoogroups.com>sailwave-digest@yahoogroups.com
~ To unsubscribe from the SUG please send blank email to
<mailto:sailwave-unsubscribe@yahoogroups.com>sailwave-unsubscribe@yahoogroups.com

Yahoo! Groups Links

    (Yahoo! ID required)

<mailto:sailwave-fullfeatured@yahoogroups.com>mailto:sailwave-fullfeatured@yahoogroups.com

------------------------------------

-!- http://www.yachtsandyachting.com/ -!- <http://www.sailing.org/>http://www.sailing.org/ -!- http://www.sailwave.com/ -!- On-Line Sailwave help...http://sailwave.com/help/HTML ~ Mark Thompson's Sailwave User Manual is available from <http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf>http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf ~ Convert to daily digest of emails send blank email to <mailto:sailwave-digest@yahoogroups.com>sailwave-digest@yahoogroups.com ~ To unsubscribe from the SUG please send blank email to <mailto:sailwave-unsubscribe@yahoogroups.com>sailwave-unsubscribe@yahoogroups.com Yahoo! Groups Links

    (Yahoo! ID required)

    mailto:sailwave-fullfeatured@yahoogroups.com

No virus found in this incoming message.
Checked by AVG - <http://www.avg.com>www.avg.com
Version: 8.5.409 / Virus Database: 270.13.61/2313 - Release Date: 08/19/09 06:03:00

12

Some thoughts.

  1. Include two new columns, competitor which would need to be unique or blank, and Alias of which would have to be equal to a previous competitor number or blank.

Competitor Alias Of

1

2 1

3

4 3

You would have to import a competitor before importing any of its aliases.

···

From: Colin Jenkins

Sent: Thursday, August 20, 2009 1:37 AM

To: sailwave@yahoogroups.com

Subject: Re: [sailwave] Importing CSV-results

hi mark, importing aliases is tricky (i think) - can you think of a syntax to do it… perhaps i’m missing the obvious…
cj

S. Mark Townsend wrote:

Any chance you can fix the import so we can import competitors and aliases of competitors?

From: Tony Tucker

Sent: Wednesday, August 19, 2009 5:36 AM

To: sailwave@yahoogroups.com

Subject: Re: [sailwave] Importing CSV-results

Hi Colin

While you’re on the import any chance of getting another
couple of issues sorted?

  1. If the competitor is new, the PY is not set, even if the
    class in the csv file is contained within the ratings file.

  2. If the competitor is in Sailwave, but has not sailed
    before you need to include him manually for their result to count.

many thanks
Tony

At 13:32 19/08/2009, Colin Jenkins wrote:

its very close to being sorted out so its slicker - i.e. not need
for guess button and remembers.

it should remember now - it must be broken - or perhaps it only
remembers non-standard mappings.

cj

Tony Tucker wrote:

Hi Anders

Yes, you always need to hit Guess to get all the fields lined up.

cheers
Tony

At 21:48 05/08/2009, Anders Landenstad (juniorsegling. se) wrote:

[Attachment( s) from Anders Landenstad (juniorsegling. se) included below]

Her are some files: But “I see the light” that fixes it… . the
guess button.

But it does not remember the field for the next race.

/Anders
----- Original Message -----
From: mailto:tony@tonytucker.comTony Tucker
To: mailto:sailwave@yahoogroups.comsailwave@yahoogroups.com
Sent: Wednesday, August 05, 2009 10:32 PM
Subject: Re: [sailwave] Importing CSV-results

Hi Anders

I use CSV Results import all the time without any problem,
can you send us a sample csv file?

cheers
Tony

At 21:22 05/08/2009, Anders Landenstad wrote:

sw2.01build7

Hi,

when importing raceresults from a CSV-file Sailwave does not
recognize mapped fields eg importing series from R1, R2…

/Anders

-!-
<http://www.yachtsandyachting.com/>http://www.yachtsandyachting.com/
-!- http://www.sailing.org/ -!-
<http://www.sailwave.com/>http://www.sailwave.com/
-!- On-Line

Sailwave help…http://sailwave.com/help/HTML ~ Mark Thompson’s
Sailwave User Manual is available from
<http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf>http://www.abyc.org/upload/Sailwave_ABYC_User_Guide.pdf

~ Convert to daily digest of emails send blank email to
mailto:sailwave-digest@yahoogroups.comsailwave-digest@yahoogroups.com
~ To unsubscribe from the SUG please send blank email to
mailto:sailwave-unsubscribe@yahoogroups.comsailwave-unsubscribe@yahoogroups.com

Yahoo! Groups Links

(Yahoo! ID required)

mailto:sailwave-fullfeatured@yahoogroups.com



---

No virus found in this incoming message.
Checked by AVG - [www.avg.com](http://www.avg.com)
Version: 8.5.409 / Virus Database: 270.13.61/2313 - Release Date: 08/19/09 06:03:00
13

that would work…

cj

S. Mark Townsend wrote:

···

www.avg.comwww.avg.com