Manual:Import and Export Data

From Winswimwiki

Jump to: navigation, search

The objective of Importing and Exporting is to get data in and out of WinSwim

Contents

Importing

Tables

All the tables that are within the WinSwim database can be exported and imported. These tables are stored as comma delimited text files similar to what is an Microsoft Excel CSV file that Excel can import and export. But, there is a difference that is important to WinSwim. The first two lines of the imported file contain information that WinSwim uses.

Sample Text Import

This sample of the AgeGroup table you see below contains all the data in the AgeGroup sample table. If you look at the first line, this is just an informational message. The second line is more critical and contains the name of the table, "TBL=AgeGroup". It contains the name of the create table template contained within WinSwim called "DDL=AgeGroup" and the other comma delimited fields, such as, "AgeGroup","MinAge", etc... are the names of the columns in the table that match the locations of the data in the following lines. So, where you see the next line saying 0,1,8,"8 AND UNDER",0,0,2 would be AgeGroup = 0, MinAge = 1, MaxAge = 8, AgeGroupDesc = "8 AND UNDER", CTSKey = 0, MaxTotalHeats = 0 and MaxReservedHeats = 2

Import Sample

Importing Tables

YOu would go to the File > Import... menu and then in the common dialog select a .txt file. WinSwim will look at the first few lines and figure out that this is an exported table and know how to import and which table to replace from the first 2 lines we just described.

Import Tables

HYV Files

You would go to the File > Import... menu and then in the common dialog select a .hyv file. This file is the format used by Hy-tek to store events that can be shared between teams. You can use this file to import an list of events. It will replace the currently active meet events.

HYV Sample

Hy-Tek HYV Patch

Meet Manager (MM) does something non-standard for the relays, using stroke code 1 (freestyle) instead of code 6 (freestyle relay) for freestyle relays, and code 5 (individual medley) instead of code 7 (medley relay) for medley relays. MM automatically accommodate for this behavior by having Team Manager and Meet Manager internally treat a code 1 relay as code 6 and a code 5 relay as code 7, using the latter (correct) codes in the SDIF-format output files it produces (meet entries by TM and meet results by MM). WinSwim normally will import the stroke code AS-IS without modification. But, with this non-standard translation occurring, WinSwim will sense this and prompt for translation of the individual event stroke code's to the relay stroke code.

HYV Patch

SDIF Files

SDIF files stand for Standard Data Interchange Files and is the USA Swimming sanctioned format for exchanging data between software.

Here is a collection of the SDIF documents for information what the formats of the SDIF records.

That said, WinSwim will import only 4 of the SDIF transmission types. It will import the 1, 2, 10 and 20 transmission type. The USS Registration format is what you would have exported to USA Swimming and is a good format to import a members roster.

The Meet Registrations is basically entries and contains a list of the all the individual and relay entries. WinSwim when importing one of these files will automatically create the Team, Members, Events and Entries all from this file. The Meet Results is basically the same as the Meet Registrations except it has the result times and places for each event.

File/Transmission Type Codes 01 Meet Registrations
02 Meet Results
03 OVC
04 National Age Group Record
05 LSC Age Group Record
06 LSC Motivational List
07 National Records and Rankings
08 Team Selection
09 LSC Best Times
10 USS Registration
16 Top 16
20 Vendor-defined code

Meet Registrations and Results

When WinSwim imports the registrations or entries SDIF file it will automatically create the Team, Meet and the Athlete roster for all entries in the file. This file is a great file to use to create a database populated with your team from an empty database if all the swimmers are in the file.

SDIF Checker

Registered users get a free license to the SDIF Checker. This will look at the SDIF file and tell you any issues with the file compared to the standard provided by USA Swimming.

SDIF Checker

See more information at:

Exporting

Tables

To export tables within WinSwim you would go to the File > Export... and select the Tables tab. Just select the table and press the Export button. Save the file to a .txt file. See information on Importing for the format of this file. These files are in comma delimited format and can easily be imported into Microsoft Excel.

Export Tables

Meets

Exporting a Meet defaults to be exported as an SDIF formatted file. This is where you would export the Meet Registrations or the Meet Results depending on if the meet has been flagged as Completed.

Export SDIF

USA Swimming Registration

Exporting USA Registrations will create an SDIF file that can be either sent to USA Swimming or used to create a new WinSwim database and create the roster. This file will not contain all the information contained in the roster within WinSwim. You would want to use exporting a table and select Members to save a copy of the roster to a text file.

Export USA Registration
Retrieved from "http://www.winswimwiki.com/index.php?title=Manual:Import_and_Export_Data"