Hi Jon,
I have a PHRF event coming up this weekend, and the OA is going to
give me a CSV file to load the SW file as usual.
I have also been handed a Sailwave file with ORC triple number
ratings loaded, since the event would like to use ORC for qualifying
boats as well as standard PHRF. I will alias the ORC division
boats.
Is there a handy way to combine these two files, so I don't have to
re-enter all the ORC ratings? If I could get the ORC data out, I
could attach it to the spreadsheet maybe. Or possibly dump the ORC
ratings in to a proper rating file and have access to it that way?
All suggestions gratefully received.
Thanks,
jrc
···
–
John R Culter NRO CAN
Vancouver Canada
+1 604 742-8832
Hi John,
If I am understanding the problem correctly, it sounds like a data manipulation question rather than a Sailwave question so here goes:
- Export the ORC Sailwave file as CSV
- Import both the ORC CSV and the Entry CSV into separate tables or sheets in your spreadsheet of choice
- Add an ORC column to the entry table and use a VLOOKUP command to lookup the relevant line from the ORC table
- Export the new entry table as CSV and import in to SW as usual
I hope that helps
Ian
···
–
John R Culter NRO CAN
Vancouver Canada
+1 604 742-8832
Ian,
My File menu doesn't show an export option. There is "Export series
summary to Windows Clipboard" but everything else seems to relate to
imports.
What am I missing? Maybe it's somewhere else? Using current
download.
Thanks,
jrc
···
On 2019-06-04 11:57 PM, Ian Bullock
[sailwave] wrote:
ian_bullock@me.com
Hi John,
If I am understanding the problem correctly, it
sounds like a data manipulation question rather than a Sailwave
question so here goes:
- Export the ORC Sailwave file as CSV
-
Import both the ORC CSV and the Entry CSV into
separate tables or sheets in your spreadsheet of choice
-
Add an ORC column to the entry table and use a
VLOOKUP command to lookup the relevant line from the ORC
table
-
Export the new entry table as CSV and import in
to SW as usual
I hope that helps
Ian
On 5 Jun 2019, at 01:27, John Culter jrculter@medi.net [sailwave]
<sailwave@yahoogroups.com >
wrote:
Hi Jon,
I have a PHRF event coming up this weekend, and
the OA is going to give me a CSV file to load the
SW file as usual.
I have also been handed a Sailwave file with ORC
triple number ratings loaded, since the event
would like to use ORC for qualifying boats as well
as standard PHRF. I will alias the ORC division
boats.
Is there a handy way to combine these two files,
so I don’t have to re-enter all the ORC ratings?
If I could get the ORC data out, I could attach it
to the spreadsheet maybe. Or possibly dump the
ORC ratings in to a proper rating file and have
access to it that way?
All suggestions gratefully received.
Thanks,
jrc
–
–
John R Culter NRO CAN
Vancouver Canada
+1 604 742-8832
John R Culter
Treasurer -- University Hill Congregation
+1 604 742-8832
Hi John,
Apologies, I was going from memory of the UI but you are absolutely correct, the way to get the data fro Sailwave to a spreadsheet is via the clipboard, not a CSV file.
Just use export “Export series summary to Windows Clipboard”, then select a single cell at the top left in the spreadsheet and paste the data.
Ian
···
On 6 Jun 2019, at 12:13 am, John Culter jrculter@medi.net [sailwave] sailwave@yahoogroups.com wrote:
Ian,
My File menu doesn't show an export option. There is "Export series
summary to Windows Clipboard" but everything else seems to relate to
imports.
What am I missing? Maybe it's somewhere else? Using current
download.
Thanks,
jrc
On 2019-06-04 11:57 PM, Ian Bullock
ian_bullock@me.com [sailwave] wrote:
Hi John,
If I am understanding the problem correctly, it
sounds like a data manipulation question rather than a Sailwave
question so here goes:
- Export the ORC Sailwave file as CSV
-
Import both the ORC CSV and the Entry CSV into
separate tables or sheets in your spreadsheet of choice
-
Add an ORC column to the entry table and use a
VLOOKUP command to lookup the relevant line from the ORC
table
-
Export the new entry table as CSV and import in
to SW as usual
I hope that helps
Ian
On 5 Jun 2019, at 01:27, John Culter jrculter@medi.net [sailwave]
<sailwave@yahoogroups.com >
wrote:
Hi Jon,
I have a PHRF event coming up this weekend, and
the OA is going to give me a CSV file to load the
SW file as usual.
I have also been handed a Sailwave file with ORC
triple number ratings loaded, since the event
would like to use ORC for qualifying boats as well
as standard PHRF. I will alias the ORC division
boats.
Is there a handy way to combine these two files,
so I don’t have to re-enter all the ORC ratings?
If I could get the ORC data out, I could attach it
to the spreadsheet maybe. Or possibly dump the
ORC ratings in to a proper rating file and have
access to it that way?
All suggestions gratefully received.
Thanks,
jrc
–
<jrc110.jpg>
John R Culter NRO CAN
Vancouver Canada
+1 604 742-8832
–
<jrc110.jpg>
John R Culter
Treasurer -- University Hill Congregation
+1 604 742-8832
Perfect. Should have experimented a bit. It’s all there, including
the ORC windrats. Excellent. Very helpful.
Thanks, Ian.
jrc
···
On 2019-06-05 09:52 PM, Ian Bullock
[sailwave] wrote:
ian_bullock@me.com
Hi John,
Apologies, I was going from memory of the UI but you are
absolutely correct, the way to get the data fro Sailwave to a
spreadsheet is via the clipboard, not a CSV file.
Just use export “Export series summary to Windows Clipboard”, then
select a single cell at the top left in the spreadsheet and
paste the data.
Ian
On 6 Jun 2019, at 12:13 am, John Culter jrculter@medi.net
[sailwave] <sailwave@yahoogroups.com >
wrote:
Ian,
My File menu doesn't show an export option. There is
“Export series summary to Windows Clipboard” but
everything else seems to relate to imports.
What am I missing? Maybe it's somewhere else? Using
current download.
Thanks,
jrc
–
On 2019-06-04 11:57 PM, Ian
Bullock [sailwave] wrote:
ian_bullock@me.com
Hi John,
If I am understanding the problem
correctly, it sounds like a data manipulation question
rather than a Sailwave question so here goes:
- Export the ORC Sailwave file as CSV
-
Import both the ORC CSV and the Entry
CSV into separate tables or sheets in your
spreadsheet of choice
-
Add an ORC column to the entry table
and use a VLOOKUP command to lookup the relevant
line from the ORC table
-
Export the new entry table as CSV and
import in to SW as usual
I hope that helps
Ian
On 5 Jun 2019, at 01:27, John Culter
jrculter@medi.net
[sailwave] <sailwave@yahoogroups.com >
wrote:
Hi
Jon,
I have a PHRF event coming up this
weekend, and the OA is going to give me
a CSV file to load the SW file as usual.
I have also been handed a Sailwave file
with ORC triple number ratings loaded,
since the event would like to use ORC
for qualifying boats as well as standard
PHRF. I will alias the ORC division
boats.
Is there a handy way to combine these
two files, so I don’t have to re-enter
all the ORC ratings? If I could get the
ORC data out, I could attach it to the
spreadsheet maybe. Or possibly dump the
ORC ratings in to a proper rating file
and have access to it that way?
All suggestions gratefully received.
Thanks,
jrc
–
<jrc110.jpg>
** John
R Culter NRO CAN**
Vancouver Canada
+1 604 742-8832
–
<jrc110.jpg>
John R Culter
Treasurer -- University Hill Congregation
+1 604 742-8832
John R Culter
Treasurer -- University Hill Congregation
+1 604 742-8832