Export CSV to file

Imported from Yahoo
1

Hi Colin and Jon,
the speed of (good and useful!) beta versions is unbelievable. Please,
permit me a wish.

The export of the summery table to the clipboard is a very valuable
feature of Sailwave. To save the CSV-stucture as a file a spread sheet
must be opened, paste from clipboard selected, and all columns must be
set to text format in the import dialogue before closing this window.
Then the results can be saved in file. No manual editing of the
CSV-stucture is necessary.

We need this export for uploading the results to the webserver by file
transfer (not ftp!) from a form. A PHP-postprocessor is started
automatically on the webserver by this type of data upload.

This could be simplified drastically if:

- a button "Export to file" is added in the export dialogue

- a "Save as" dialogue is opend

- the default directory is the same as the opened *.blw file

- the default file name is the same as the *.blw file but has an
extension like ".txt"

- do not allow the extension ".blw" to protect the data file(s)

The JSON-structure is too complex to be extracted to our simple needs.

Dierk

2

Hi Dierk,

If you could send me a sample of the output you would like to jon@sailwave.com. I’ll see what I can do. It might be more flexible if I give you a standalone program that will convert the .blw file to a csv file of the format you require.

I already have one that does it for the competitors but not for the race results. This might work better for you because you could have an ini file which specified which columns and format things get printed in.

Lets have a look at what would be you minimum spec to be useful and what would be your ideal and I’ll see what I can do.

Regards

Jon

···

On 10 December 2012 23:19, heppi33 heppi33@yahoo.com wrote:

Hi Colin and Jon,
the speed of (good and useful!) beta versions is unbelievable. Please,
permit me a wish.

The export of the summery table to the clipboard is a very valuable
feature of Sailwave. To save the CSV-stucture as a file a spread sheet
must be opened, paste from clipboard selected, and all columns must be
set to text format in the import dialogue before closing this window.
Then the results can be saved in file. No manual editing of the
CSV-stucture is necessary.

We need this export for uploading the results to the webserver by file
transfer (not ftp!) from a form. A PHP-postprocessor is started
automatically on the webserver by this type of data upload.

This could be simplified drastically if:

  • a button “Export to file” is added in the export dialogue

  • a “Save as” dialogue is opend

  • the default directory is the same as the opened *.blw file

  • the default file name is the same as the *.blw file but has an
    extension like “.txt”

  • do not allow the extension “.blw” to protect the data file(s)

The JSON-structure is too complex to be extracted to our simple needs.

Dierk

–
Jon Eskdale
07976 709777

Skype “eskdale”

3

Hi Jon,
many thanks for Your quick answer and offer.

The stucture and contents of the export are perfect for our application.
I want to avoid invoking an additional program and its handling for our
less experienced scorers. It would be nice to add an option to select
the semicolon as field separator (our standard) directly.

To copy the uploaded file to a write protected directory a PHP-script is
required (has admin rights). It takes only a few additional lines of
code validating and converting the content to our internal
CSV-structure.

Most of our pages (www.wfg-baldeneysee.org) are created dynamically by
PHP. If You are interested go to the regatta table "Regattatabelle". In
the third row You will find the 2.4 mR class and "(show English Info
Page)". On the info page the entry list (competitors) and the results
list can be selected (and other informations).

I have done my first tests of layouts on printing results using HTML5
and Javascript to format the pages for our requirements. The new feature
of setting the class names of styles (columns) is a great help (e.g.
selecting tags by getElementsByClassName()). I can send a PDF printout
to You (and all files used). Only Firefox is a usable browser for
printing.

Dierk

Hi Dierk,

If you could send me a sample of the output you would like to
jon@... I'll see what I can do. It might be more flexible if I
give you a standalone program that will convert the .blw file to a csv

file

of the format you require.

I already have one that does it for the competitors but not for the

race

results. This might work better for you because you could have an ini

file

which specified which columns and format things get printed in.

Lets have a look at what would be you minimum spec to be useful and

what

would be your ideal and I'll see what I can do.

Regards

Jon

> **
>
>
> Hi Colin and Jon,
> the speed of (good and useful!) beta versions is unbelievable.

Please,

> permit me a wish.
>
> The export of the summery table to the clipboard is a very valuable
> feature of Sailwave. To save the CSV-stucture as a file a spread

sheet

> must be opened, paste from clipboard selected, and all columns must

be

> set to text format in the import dialogue before closing this

window.

> Then the results can be saved in file. No manual editing of the
> CSV-stucture is necessary.
>
> We need this export for uploading the results to the webserver by

file

> transfer (not ftp!) from a form. A PHP-postprocessor is started
> automatically on the webserver by this type of data upload.
>
> This could be simplified drastically if:
>
> - a button "Export to file" is added in the export dialogue
>
> - a "Save as" dialogue is opend
>
> - the default directory is the same as the opened *.blw file
>
> - the default file name is the same as the *.blw file but has an
> extension like ".txt"
>
> - do not allow the extension ".blw" to protect the data file(s)
>
> The JSON-structure is too complex to be extracted to our simple

needs.

···

--- In sailwave@yahoogroups.com, Jon Eskdale <jon@...> wrote:

On 10 December 2012 23:19, heppi33 heppi33@... wrote:
>
> Dierk
>
>
>

--
Jon Eskdale
07976 709777
Skype "eskdale"

4

Hi Dierk,

You have confused me a bit now. I don’t understand how clicking a single icon on the desktop would be difficult for a scorer. Especially as this could be batch file that initiated the upload to your server.

Although from what I understand of your requirement wouldn’t the Plugin that sends the results to Sailracer do the job for you if it went to your server instead of Sailracer? This is the results in a csv format.

Jon

···

On 11 December 2012 21:27, heppi33 heppi33@yahoo.com wrote:

Hi Jon,
many thanks for Your quick answer and offer.

The stucture and contents of the export are perfect for our application.
I want to avoid invoking an additional program and its handling for our
less experienced scorers. It would be nice to add an option to select
the semicolon as field separator (our standard) directly.

To copy the uploaded file to a write protected directory a PHP-script is
required (has admin rights). It takes only a few additional lines of
code validating and converting the content to our internal
CSV-structure.

Most of our pages (www.wfg-baldeneysee.org) are created dynamically by
PHP. If You are interested go to the regatta table “Regattatabelle”. In
the third row You will find the 2.4 mR class and “(show English Info
Page)”. On the info page the entry list (competitors) and the results
list can be selected (and other informations).

I have done my first tests of layouts on printing results using HTML5
and Javascript to format the pages for our requirements. The new feature
of setting the class names of styles (columns) is a great help (e.g.
selecting tags by getElementsByClassName()). I can send a PDF printout
to You (and all files used). Only Firefox is a usable browser for
printing.

Dierk

— In sailwave@yahoogroups.com, Jon Eskdale <jon@…> wrote:

Hi Dierk,

If you could send me a sample of the output you would like to

jon@… I’ll see what I can do. It might be more flexible if I

give you a standalone program that will convert the .blw file to a csv

file

of the format you require.

I already have one that does it for the competitors but not for the

race

results. This might work better for you because you could have an ini

file

which specified which columns and format things get printed in.

Lets have a look at what would be you minimum spec to be useful and

what

would be your ideal and I’ll see what I can do.

Regards

Jon

On 10 December 2012 23:19, heppi33 heppi33@… wrote:

**

Hi Colin and Jon,

the speed of (good and useful!) beta versions is unbelievable.

Please,

permit me a wish.

The export of the summery table to the clipboard is a very valuable

feature of Sailwave. To save the CSV-stucture as a file a spread

sheet

must be opened, paste from clipboard selected, and all columns must

be

set to text format in the import dialogue before closing this

window.

Then the results can be saved in file. No manual editing of the

CSV-stucture is necessary.

We need this export for uploading the results to the webserver by

file

transfer (not ftp!) from a form. A PHP-postprocessor is started

automatically on the webserver by this type of data upload.

This could be simplified drastically if:

  • a button “Export to file” is added in the export dialogue
  • a “Save as” dialogue is opend
  • the default directory is the same as the opened *.blw file
  • the default file name is the same as the *.blw file but has an

extension like “.txt”

  • do not allow the extension “.blw” to protect the data file(s)

The JSON-structure is too complex to be extracted to our simple

needs.

Dierk

–

Jon Eskdale

07976 709777

Skype “eskdale”

–
Jon Eskdale
07976 709777

Skype “eskdale”

5

Hi Jon,
please excuse my bad explanations.

To use a similar upload like the Sailracer plugin (I did not look at it
till now) is a great idea! Give me some days to test it.

To the semicolon:
In the dialogue window "Export to clipbord as plain text" Sailwave
offers the direct choice of the separators "Tab", "Space", and "Comma"
by options. The semicolon must be entered manually in the field "Other
string". To remember the scorer to select our standard separator the
additional option "Semicolon" would be helpful.

I hope I explained it better now.

Dierk

Hi Dierk,

You have confused me a bit now. I don't understand how clicking a

single

icon on the desktop would be difficult for a scorer. Especially as

this

could be batch file that initiated the upload to your server.

Although from what I understand of your requirement wouldn't the

Plugin

that sends the results to Sailracer do the job for you if it went to

your

server instead of Sailracer? This is the results in a csv format.

Jon

> **
>
>
> Hi Jon,
> many thanks for Your quick answer and offer.
>
> The stucture and contents of the export are perfect for our

application.

> I want to avoid invoking an additional program and its handling for

our

> less experienced scorers. It would be nice to add an option to

select

> the semicolon as field separator (our standard) directly.
>
> To copy the uploaded file to a write protected directory a

PHP-script is

> required (has admin rights). It takes only a few additional lines of
> code validating and converting the content to our internal
> CSV-structure.
>
> Most of our pages (www.wfg-baldeneysee.org) are created dynamically

by

> PHP. If You are interested go to the regatta table "Regattatabelle".

In

> the third row You will find the 2.4 mR class and "(show English Info
> Page)". On the info page the entry list (competitors) and the

results

> list can be selected (and other informations).
>
> I have done my first tests of layouts on printing results using

HTML5

> and Javascript to format the pages for our requirements. The new

feature

> of setting the class names of styles (columns) is a great help (e.g.
> selecting tags by getElementsByClassName()). I can send a PDF

printout

> to You (and all files used). Only Firefox is a usable browser for
> printing.
>
> Dierk
>
>
> >
> > Hi Dierk,
> >
> > If you could send me a sample of the output you would like to
> > jon@ I'll see what I can do. It might be more flexible if I
>
> > give you a standalone program that will convert the .blw file to a

csv

> file
> > of the format you require.
> >
> > I already have one that does it for the competitors but not for

the

> race
> > results. This might work better for you because you could have an

ini

> file
> > which specified which columns and format things get printed in.
> >
> > Lets have a look at what would be you minimum spec to be useful

and

> what
> > would be your ideal and I'll see what I can do.
> >
> > Regards
> >
> > Jon
> >
> >
> >
> > > **
>
> > >
> > >
> > > Hi Colin and Jon,
> > > the speed of (good and useful!) beta versions is unbelievable.
> Please,
> > > permit me a wish.
> > >
> > > The export of the summery table to the clipboard is a very

valuable

> > > feature of Sailwave. To save the CSV-stucture as a file a spread
> sheet
> > > must be opened, paste from clipboard selected, and all columns

must

> be
> > > set to text format in the import dialogue before closing this
> window.
> > > Then the results can be saved in file. No manual editing of the
> > > CSV-stucture is necessary.
> > >
> > > We need this export for uploading the results to the webserver

by

···

--- In sailwave@yahoogroups.com, Jon Eskdale <jon@...> wrote:

On 11 December 2012 21:27, heppi33 heppi33@... wrote:
> --- In sailwave@yahoogroups.com, Jon Eskdale jon@ wrote:
> > On 10 December 2012 23:19, heppi33 heppi33@ wrote:
> file
> > > transfer (not ftp!) from a form. A PHP-postprocessor is started
> > > automatically on the webserver by this type of data upload.
> > >
> > > This could be simplified drastically if:
> > >
> > > - a button "Export to file" is added in the export dialogue
> > >
> > > - a "Save as" dialogue is opend
> > >
> > > - the default directory is the same as the opened *.blw file
> > >
> > > - the default file name is the same as the *.blw file but has an
> > > extension like ".txt"
> > >
> > > - do not allow the extension ".blw" to protect the data file(s)
> > >
> > > The JSON-structure is too complex to be extracted to our simple
> needs.
> > >
> > > Dierk
> > >
> > >
> > >
> >
> >
> >
> > --
> > Jon Eskdale
> > 07976 709777
> > Skype "eskdale"
> >
>
>
>

--
Jon Eskdale
07976 709777
Skype "eskdale"

6

Hallo Dierk,

if You entered the semicolon in the field "other string" (or in German "Benutzer definiert") and You marked "other string" Saliwave will use this as default. So other users must not be remembered what separator to use ...

Christof

···

--- In sailwave@yahoogroups.com, "heppi33" <heppi33@...> wrote:

Hi Jon,
please excuse my bad explanations.

To use a similar upload like the Sailracer plugin (I did not look at it
till now) is a great idea! Give me some days to test it.

To the semicolon:
In the dialogue window "Export to clipbord as plain text" Sailwave
offers the direct choice of the separators "Tab", "Space", and "Comma"
by options. The semicolon must be entered manually in the field "Other
string". To remember the scorer to select our standard separator the
additional option "Semicolon" would be helpful.

I hope I explained it better now.

Dierk

--- In sailwave@yahoogroups.com, Jon Eskdale <jon@> wrote:
>
> Hi Dierk,
>
> You have confused me a bit now. I don't understand how clicking a
single
> icon on the desktop would be difficult for a scorer. Especially as
this
> could be batch file that initiated the upload to your server.
>
> Although from what I understand of your requirement wouldn't the
Plugin
> that sends the results to Sailracer do the job for you if it went to
your
> server instead of Sailracer? This is the results in a csv format.
>
> Jon
>
>
> On 11 December 2012 21:27, heppi33 heppi33@ wrote:
>
> > **
> >
> >
> > Hi Jon,
> > many thanks for Your quick answer and offer.
> >
> > The stucture and contents of the export are perfect for our
application.
> > I want to avoid invoking an additional program and its handling for
our
> > less experienced scorers. It would be nice to add an option to
select
> > the semicolon as field separator (our standard) directly.
> >
> > To copy the uploaded file to a write protected directory a
PHP-script is
> > required (has admin rights). It takes only a few additional lines of
> > code validating and converting the content to our internal
> > CSV-structure.
> >
> > Most of our pages (www.wfg-baldeneysee.org) are created dynamically
by
> > PHP. If You are interested go to the regatta table "Regattatabelle".
In
> > the third row You will find the 2.4 mR class and "(show English Info
> > Page)". On the info page the entry list (competitors) and the
results
> > list can be selected (and other informations).
> >
> > I have done my first tests of layouts on printing results using
HTML5
> > and Javascript to format the pages for our requirements. The new
feature
> > of setting the class names of styles (columns) is a great help (e.g.
> > selecting tags by getElementsByClassName()). I can send a PDF
printout
> > to You (and all files used). Only Firefox is a usable browser for
> > printing.
> >
> > Dierk
> >
> >
> > --- In sailwave@yahoogroups.com, Jon Eskdale jon@ wrote:
> > >
> > > Hi Dierk,
> > >
> > > If you could send me a sample of the output you would like to
> > > jon@ I'll see what I can do. It might be more flexible if I
> >
> > > give you a standalone program that will convert the .blw file to a
csv
> > file
> > > of the format you require.
> > >
> > > I already have one that does it for the competitors but not for
the
> > race
> > > results. This might work better for you because you could have an
ini
> > file
> > > which specified which columns and format things get printed in.
> > >
> > > Lets have a look at what would be you minimum spec to be useful
and
> > what
> > > would be your ideal and I'll see what I can do.
> > >
> > > Regards
> > >
> > > Jon
> > >
> > >
> > > On 10 December 2012 23:19, heppi33 heppi33@ wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > Hi Colin and Jon,
> > > > the speed of (good and useful!) beta versions is unbelievable.
> > Please,
> > > > permit me a wish.
> > > >
> > > > The export of the summery table to the clipboard is a very
valuable
> > > > feature of Sailwave. To save the CSV-stucture as a file a spread
> > sheet
> > > > must be opened, paste from clipboard selected, and all columns
must
> > be
> > > > set to text format in the import dialogue before closing this
> > window.
> > > > Then the results can be saved in file. No manual editing of the
> > > > CSV-stucture is necessary.
> > > >
> > > > We need this export for uploading the results to the webserver
by
> > file
> > > > transfer (not ftp!) from a form. A PHP-postprocessor is started
> > > > automatically on the webserver by this type of data upload.
> > > >
> > > > This could be simplified drastically if:
> > > >
> > > > - a button "Export to file" is added in the export dialogue
> > > >
> > > > - a "Save as" dialogue is opend
> > > >
> > > > - the default directory is the same as the opened *.blw file
> > > >
> > > > - the default file name is the same as the *.blw file but has an
> > > > extension like ".txt"
> > > >
> > > > - do not allow the extension ".blw" to protect the data file(s)
> > > >
> > > > The JSON-structure is too complex to be extracted to our simple
> > needs.
> > > >
> > > > Dierk
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > Jon Eskdale
> > > 07976 709777
> > > Skype "eskdale"
> > >
> >
> >
> >
>
>
>
> --
> Jon Eskdale
> 07976 709777
> Skype "eskdale"
>

7

Hi Jon,
the upload like the Sailracer plugin works without any problems with my
own template and is really simple to use!

Using "html.textQ" only shows the second part of the publish dialogue
window but there is no output into the textarea. On the basis of this
window I propose the following:

- delete the two greyed out fields "Style" and "Effects"

- in the "Destination" field only "default browser", "save to file", and
"installed application" (important to select an alternative browser, can
be the same as in the publish dialogue) are needed.

- delete the buttons "MS Word" and "MS Excel" (I see no usage)

- add options to select the separator (important)

- add option to select the column names set by the user (like Sailracer
plugin) or the internal names (important, like the export to clipboard).

- perhaps some users (having no knowledge how to edit the html template)
need an input field to type in the webserver page address which is
inserted into the template by e.g. "html.address".

- a selection of columns (like the export to clipboard) is not necessary
(the visible columns are copied).

- there is no need to output the CSV-structure twice (as by
"html.sailracerwiz()" and "html.textQ"). The textarea tag in the
template can be formatted to give a good overview of data to be
uploaded.

I'm convinced that a lot of users need such a simple to use feature to
upload results as CSV-structure.

Dierk

8

Hi Dierk,

Just to let you know I've read your post and will consider your suggestions in more detail once I've got the new cruiser handicap system in place. In the meantime if you have something very simple that needs changing let me know

Jon

···

--- In sailwave@yahoogroups.com, "heppi33" <heppi33@...> wrote:

Hi Jon,
the upload like the Sailracer plugin works without any problems with my
own template and is really simple to use!

Using "html.textQ" only shows the second part of the publish dialogue
window but there is no output into the textarea. On the basis of this
window I propose the following:

- delete the two greyed out fields "Style" and "Effects"

- in the "Destination" field only "default browser", "save to file", and
"installed application" (important to select an alternative browser, can
be the same as in the publish dialogue) are needed.

- delete the buttons "MS Word" and "MS Excel" (I see no usage)

- add options to select the separator (important)

- add option to select the column names set by the user (like Sailracer
plugin) or the internal names (important, like the export to clipboard).

- perhaps some users (having no knowledge how to edit the html template)
need an input field to type in the webserver page address which is
inserted into the template by e.g. "html.address".

- a selection of columns (like the export to clipboard) is not necessary
(the visible columns are copied).

- there is no need to output the CSV-structure twice (as by
"html.sailracerwiz()" and "html.textQ"). The textarea tag in the
template can be formatted to give a good overview of data to be
uploaded.

I'm convinced that a lot of users need such a simple to use feature to
upload results as CSV-structure.

Dierk