Adding column data to an existing Sailwave data set.

Imported from Yahoo
1

Is there a way to import additional data to an existing Sailwave data set?

e.g. I have an existing Sailwave file and I would like to import the club names of the competitors by using the sail number as the key.

The ascii file would like like this:

SailNo, Club

1234, WSC

3345,RCYS

Cheers,

Peter

2

Hi,

···

I would export to CSV and open that in your favourite spreadsheet app. Use a LOOKUP on sail number in the spreadsheet to fill in the club. Then re-export as CSV from the spreadsheet and import the series back in to Sailwave.

Ian

On 22 Mar 2017, at 2:27 am, Peter van Muyden pvanmuyden@gmail.com [sailwave] sailwave@yahoogroups.com wrote:

Is there a way to import additional data to an existing Sailwave data set?

e.g. I have an existing Sailwave file and I would like to import the club names of the competitors by using the sail number as the key.

The ascii file would like like this:

SailNo, Club

1234, WSC

3345,RCYS

Cheers,

Peter

3

Hi Ian,

That works fine for non race data or if the race data didn’t contain any “scoring codes”. I was hoping for an import option that would match on the sail numbers.

Peter

···

On Tue, Mar 21, 2017 at 11:47 PM, Ian Bullock ian_bullock@me.com [sailwave] sailwave@yahoogroups.com wrote:

Hi,

I would export to CSV and open that in your favourite spreadsheet app. Use a LOOKUP on sail number in the spreadsheet to fill in the club. Then re-export as CSV from the spreadsheet and import the series back in to Sailwave.

Ian

On 22 Mar 2017, at 2:27 am, Peter van Muyden pvanmuyden@gmail.com [sailwave] sailwave@yahoogroups.com wrote:

Is there a way to import additional data to an existing Sailwave data set?

e.g. I have an existing Sailwave file and I would like to import the club names of the competitors by using the sail number as the key.

The ascii file would like like this:

SailNo, Club

1234, WSC

3345,RCYS

Cheers,

Peter

4

Hi Peter,

Might have to speak to Jon, nicely :wink:

  You could try using merge in another Sailwave series . Firstly

create a new series with all the competitor information you
need/want including Club; you could create this from a CSV file
with competitor data. Then merge in the series you already have.

Kind regards,

Huw

···

On 22/03/2017 18:24, Peter van Muyden
[sailwave] wrote:

pvanmuyden@gmail.com

Hi Ian,

            That works fine for  non race data or if the race

data didn’t contain any “scoring codes”. I was hoping
for an import option that would match on the sail
numbers.

Peter

            On Tue, Mar 21, 2017 at 11:47 PM,

Ian Bullock ian_bullock@me.com
[sailwave] sailwave@yahoogroups.com
wrote:

Hi,

                        I

would export to CSV and open that in your
favourite spreadsheet app. Use a LOOKUP on
sail number in the spreadsheet to fill in
the club. Then re-export as CSV from the
spreadsheet and import the series back in to
Sailwave.

Ian

                            On 22 Mar 2017, at 2:27 am, Peter van

Muyden pvanmuyden@gmail.com
[sailwave] <sailwave@yahoogroups.com >
wrote:

                                  Is there a way to

import additional data to an
existing Sailwave data set?

                                    e.g. I have an existing

Sailwave file and I would like
to import the club names of the
competitors by using the sail
number as the key.

                                    The ascii file would like

like this:

SailNo, Club

1234, WSC

3345,RCYS

Cheers,

Peter


Virus-free. www.avast.com

5

I think Huw is on the right lines. What I’d do is:

Export the current series to CSV, stuff it in a spreadsheet and add the extra column(s) of data.

Export the spreadsheet as CSV and use it to create a new series.

Then merge the two series and you should be good to go.

I haven’t tried this, but I shouldn’t be surprised if it went a lot more easily in one direction than the other.

I reckon the first thing I’d try would be make a copy of the original series and wipe all results and entrants from the copy, which would retain all the non competiitor specific data to save you retyping that.

Then I’d import alll the competitors and details from the spreadsheet CSV to get all the data columns I wanted.

Finally I’d merge in the original series to get all the race results.

Jim C