Pre-loading values for drop down

Imported from Yahoo
1

Thanks all. I’m trialing the Excluded Competitors method in my pro-forma. Most of my lists only need a few entries so not too many competitors to exclude.

And remembering to use New Like instead of New. Thanks Jon

I’ve been using Sailwave for too many years (since 2005) and usually in a hurry that I tend to stick to the earlier ways and forget to try the newer features. But I did successfully export all my .blw to XML last autumn and import to a SQL Server database to refresh my SSIS data import skills and do some handicap analysis.

2

Hi Pat,

  I am interested in the last bit of this message, importing into

an SQL data using XML export. Please could you let me know more?

  I have started looking at this  but using either a SQLite or

MySQL/MariaDB database. SQLite has the adavantage it is readily
moveable across different computing platforms.

Look forward to hearing from you.

Kind regards,

Huw

···

On 22/05/2019 06:41,
[sailwave] wrote:

patmjones@btinternet.com

          Thanks all. I'm trialing the Excluded Competitors method

in my pro-forma. Most of my lists only need a few entries
so not too many competitors to exclude.

          And remembering to use New Like instead of New. Thanks Jon

          I've been using Sailwave for too many years (since 2005)

and usually in a hurry that I tend to stick to the earlier
ways and forget to try the newer features. But I did
successfully export all my .blw to XML last autumn and
import to a SQL Server database to refresh my SSIS data
import skills and do some handicap analysis.


Avast logo

This email has been checked for viruses by Avast antivirus software.

www.avast.com

3

I save my blw files as XML (From the File menu in Sailwave) then import them to a SQL Server database using SQL Server Integration Services (aka Visual Studio Data Tools, SSIS or DTS). I use these because they are tools I use professionally and I can save the SSIS package program and use it repeatedly as new sailwave blw files become available.
There are free developer versions of both SQL Server and the Visual Studio Data Tools available from Microsoft and they run happily on a decent spec windows pc or laptop. It does not have to be a SQL Server database since SSIS can read or write via various connectors, including ODBC so SQLite and MySQL are both possible sources or destinations.

Once the data is in the database there’s a whole new world of analysis tools and reporting available!

4

Hi Pat,

  Very interesting, would you be willing to share what you have

done and if so document what is needed to replicate what you do.

  FYI - I am in the slow process of updating a Sailwave User Guide

written for Los Alamitos YC by Mark Townsend and what you have
described could be part of and advanced use section.

Kind regards,

Huw

···

On 11/08/2019 08:19,
[sailwave] wrote:

patmjones@btinternet.com

          I save my blw files as XML (From the File menu in

Sailwave) then import them to a SQL Server database using
SQL Server Integration Services (aka Visual Studio Data
Tools, SSIS or DTS). I use these because they are tools I
use professionally and I can save the SSIS package program
and use it repeatedly as new sailwave blw files become
available.
There are free developer versions of both SQL Server and
the Visual Studio Data Tools available from Microsoft and
they run happily on a decent spec windows pc or laptop. It
does not have to be a SQL Server database since SSIS can
read or write via various connectors, including ODBC so
SQLite and MySQL are both possible sources or
destinations.

          Once the data is in the database there's a whole new

world of analysis tools and reporting available!


Virus-free. www.avast.com