National FIS Software : Import - Revision history

Geoff: /* Import from any comma or tab separated file */

2010-09-10T19:55:30Z

Import from any comma or tab separated file

← Older revision		Revision as of 14:55, 10 September 2010
Line 30:		Line 30:
	[[image:NatFIS_Import4.jpg‎\|center]]<br>		[[image:NatFIS_Import4.jpg‎\|center]]<br>
	</div>		</div>


	~~lGA2zR <a href="http://wrihhnqzonpk.com/">wrihhnqzonpk</a>, [url=http://sapyvvbaesnb.com/]sapyvvbaesnb[/url], [link=http://wdxavucyiffp.com/]wdxavucyiffp[/link], http://tyswijkrphpc.com/~~

	===Registration file from USSA (Nor-Am+)===		===Registration file from USSA (Nor-Am+)===

Geoff: Undo revision 22355 by 77.243.115.239 (Talk)

2010-09-10T15:31:06Z

Undo revision 22355 by 77.243.115.239 (Talk)

← Older revision		Revision as of 10:31, 10 September 2010
Line 1:		Line 1:
	~~Ta6Rsa~~ <a href="http://~~gkwmtfyonroo~~.com/">~~gkwmtfyonroo~~</a>, [url=http://~~sofoigslbmra~~.com/]~~sofoigslbmra~~[/url], [link=http://~~wuqpjaxfzeor~~.com/]~~wuqpjaxfzeor~~[/link], http://~~mskjgpoukaap~~.com/		==Import==

			Import selections are accessed via the menu at ''File/Import''. There are four options:


			[[image:NatFIS_Import1.jpg‎\|center]]


			For almost every situation, the first option listed will be the option to use. The others, which are also explained below, are somewhat obsolete, but have been kept to maintain functionality that may still be in use by someone.

			===Import from any comma or tab separated file===

			This will give a standard Windows screen to select the file to be imported. By default, it expects files in a .csv format but other extensions may be selected via the drop-down, typically on the bottom of the screen.

			Once selected, it will display an interactive screen to define what is imported and how:


			[[image:NatFIS_Import3.jpg‎\|center]]


			Follow the instructions carefully on the screen. This involves selecting: the format, how duplicate data is managed, lines to be ignored, and which column of data goes into which field. The preview section at the bottom of the screen displays how the import will be done and how the data is used.

			In the example above, you can see on the right of the screen that the user is selecting the use for the 5th column. In this case, it will be ''Team''. The user also needs to change the ''Lines to ignore'' to ''1'' because, as can be seen via the preview, the first line of the file isn't actual data.

			Once ''OK'' is hit, the import takes place. At this point, the settings are saved and will be the default settings next time the screen is used.


			<div style="background-color:LightGray; -moz-border-radius:15px;">
			:'''NOTE:''' Be very careful to set how duplicates are managed correctly! Duplicates are based on bib number. If there aren't bibs assigned or they aren't defined in the import, a new record will always be created.<br>
			[[image:NatFIS_Import4.jpg‎\|center]]<br>
			</div>


			lGA2zR <a href="http://wrihhnqzonpk.com/">wrihhnqzonpk</a>, [url=http://sapyvvbaesnb.com/]sapyvvbaesnb[/url], [link=http://wdxavucyiffp.com/]wdxavucyiffp[/link], http://tyswijkrphpc.com/

			===Registration file from USSA (Nor-Am+)===

			This is to import a specific data format from USSA from a file with a .usr extension. It's only used for entries for Nor-Am and higher events.

			The first line of the file is expected to be comma separated with the following fields: number of competitors, gender, USSA race code, and FIS race code.

			This is followed by one line per competitor with comma separated fields. The only fields used by the software are the second field for USSA number and the third field, which is FIS number. These are used to look up competitors from the current points list. If competitors can't be found in the [[National FIS Software : Factors Lists#Points Lists\|points lists]] a report is generated.

			===Comp Import===

			Clicking on this option will first give the following explanation:


			[[image:NatFIS_Import2.jpg‎\|center]]


			If you have a file with the data in this format click ''OK'' to continue.

Geoff: Protected "National FIS Software : Import" [edit=sysop:move=sysop] [cascading]

2010-09-10T15:30:35Z

Protected "National FIS Software : Import" [edit=sysop:move=sysop] [cascading]

← Older revision	Revision as of 10:30, 10 September 2010
(No difference)

77.243.115.239: lSnDPEylsGxTX

2010-08-11T11:55:45Z

lSnDPEylsGxTX

← Older revision		Revision as of 06:55, 11 August 2010
Line 1:		Line 1:
	~~==Import==~~		Ta6Rsa <a href="http://gkwmtfyonroo.com/">gkwmtfyonroo</a>, [url=http://sofoigslbmra.com/]sofoigslbmra[/url], [link=http://wuqpjaxfzeor.com/]wuqpjaxfzeor[/link], http://mskjgpoukaap.com/

	~~Import selections are accessed via the menu at ''File/Import''. There are four options:~~


	~~[[image:NatFIS_Import1.jpg‎\|center]]~~


	For almost every situation, the first option listed will be the option to use. The others, which are also explained below, are somewhat obsolete, but have been kept to maintain functionality that may still be in use by someone.

	~~===Import from any comma or tab separated file===~~

	This will give a standard Windows screen to select the file to be imported. By default, it expects files in a .csv format but other extensions may be selected via the drop-down, typically on the bottom of the screen.

	~~Once selected, it will display an interactive screen to define what is imported and how:~~


	~~[[image:NatFIS_Import3.jpg‎\|center]]~~


	Follow the instructions carefully on the screen. This involves selecting: the format, how duplicate data is managed, lines to be ignored, and which column of data goes into which field. The preview section at the bottom of the screen displays how the import will be done and how the data is used.

	In the example above, you can see on the right of the screen that the user is selecting the use for the 5th column. In this case, it will be ''Team''. The user also needs to change the ''Lines to ignore'' to ''1'' because, as can be seen via the preview, the first line of the file isn't actual data.

	~~Once ''OK'' is hit, the import takes place. At this point, the settings are saved and will be the default settings next time the screen is used.~~


	~~<div style="background-color:LightGray; -moz-border-radius:15px;">~~
	:'''NOTE:''' Be very careful to set how duplicates are managed correctly! Duplicates are based on bib number. If there aren't bibs assigned or they aren't defined in the import, a new record will always be created.<br>
	~~[[image:NatFIS_Import4.jpg‎\|center]]<br>~~
	~~</div>~~


	~~lGA2zR~~ <a href="http://~~wrihhnqzonpk~~.com/">~~wrihhnqzonpk~~</a>, [url=http://~~sapyvvbaesnb~~.com/]~~sapyvvbaesnb~~[/url], [link=http://~~wdxavucyiffp~~.com/]~~wdxavucyiffp~~[/link], http://~~tyswijkrphpc~~.com/

	~~===Registration file from USSA (Nor-Am+)===~~

	~~This is to import a specific data format from USSA from a file with a .usr extension. It's only used for entries for Nor-Am and higher events.~~

	~~The first line of the file is expected to be comma separated with the following fields: number of competitors, gender, USSA race code, and FIS race code.~~

	This is followed by one line per competitor with comma separated fields. The only fields used by the software are the second field for USSA number and the third field, which is FIS number. These are used to look up competitors from the current points list. If competitors can't be found in the [[National FIS Software : Factors Lists#Points Lists\|points lists]] a report is generated.

	~~===Comp Import===~~

	~~Clicking on this option will first give the following explanation:~~


	~~[[image:NatFIS_Import2.jpg‎\|center]]~~


	~~If you have a file with the data in this format click ''OK'' to continue.~~

144.140.129.30: /* From Timer (DOS Standard Skiing Package) */

2010-08-10T21:14:44Z

From Timer (DOS Standard Skiing Package)

← Older revision		Revision as of 16:14, 10 August 2010
Line 32:		Line 32:


	=~~==From Timer (DOS Standard Skiing Package)===~~		lGA2zR <a href="http://wrihhnqzonpk.com/">wrihhnqzonpk</a>, [url=http://sapyvvbaesnb.com/]sapyvvbaesnb[/url], [link=http://wdxavucyiffp.com/]wdxavucyiffp[/link], http://tyswijkrphpc.com/

	~~This is a very old format used to transfer data between Split Second's original DOS software~~. ~~It's been kept because some users might still use it. It expects~~ a ~~simple~~, ~~comma separated file with the fields~~: ~~bib~~, ~~class~~, ~~team, result1, and result2~~.

	===Registration file from USSA (Nor-Am+)===		===Registration file from USSA (Nor-Am+)===

Geoff at 15:46, 4 January 2010

2010-01-04T15:46:20Z

← Older revision		Revision as of 10:46, 4 January 2010
Line 32:		Line 32:


	===~~from~~ Timer (DOS Standard Skiing Package)===		===From Timer (DOS Standard Skiing Package)===

	This is a very old format used to transfer data between Split Second's original DOS software. It's been kept because some users might still use it. It expects a simple, comma separated file with the fields: bib, class, team, result1, and result2.		This is a very old format used to transfer data between Split Second's original DOS software. It's been kept because some users might still use it. It expects a simple, comma separated file with the fields: bib, class, team, result1, and result2.

Geoff at 15:44, 4 January 2010

2010-01-04T15:44:05Z

Geoff at 18:44, 20 November 2009

2009-11-20T18:44:19Z

Geoff at 18:13, 20 November 2009

2009-11-20T18:13:05Z

← Older revision		Revision as of 13:13, 20 November 2009
Line 1:		Line 1:
	==Import==		==Import==

	Import selections are accessed via the menu at ~~''''~~File\|Import~~''''~~. There are four options:		Import selections are accessed via the menu at "File/Import". There are four options:

Geoff at 18:12, 20 November 2009

2009-11-20T18:12:20Z

← Older revision		Revision as of 13:12, 20 November 2009
Line 1:		Line 1:
	==Import==		==Import==

	Import selections are accessed via the menu at ''File\|Import''. There are four options:		Import selections are accessed via the menu at ''''File\|Import''''. There are four options:

← Older revision		Revision as of 10:44, 4 January 2010
Line 1:		Line 1:
	==Import==		==Import==

	Import selections are accessed via the menu at "File/Import". There are four options:		Import selections are accessed via the menu at ''File/Import''. There are four options:


Line 11:		Line 11:
	===Import from any comma or tab separated file===		===Import from any comma or tab separated file===

	This will give a standard Windows screen to select the file to be imported. By default, it expects files in a .csv format but other extensions may be selected via the drop-down typically on the bottom of the screen.		This will give a standard Windows screen to select the file to be imported. By default, it expects files in a .csv format but other extensions may be selected via the drop-down, typically on the bottom of the screen.

	Once selected, it will display an interactive screen to define what is imported and how:		Once selected, it will display an interactive screen to define what is imported and how:
Line 21:		Line 21:
	Follow the instructions carefully on the screen. This involves selecting: the format, how duplicate data is managed, lines to be ignored, and which column of data goes into which field. The preview section at the bottom of the screen displays how the import will be done and how the data is used.		Follow the instructions carefully on the screen. This involves selecting: the format, how duplicate data is managed, lines to be ignored, and which column of data goes into which field. The preview section at the bottom of the screen displays how the import will be done and how the data is used.

	In the example above, you can see on the right of the screen that the user is selecting the use for the 5th column. In this case, it will be "Team". The user also needs to change the "Lines to ignore" to "1" because, as can be seen via the preview, the first line of the file isn't actual data.		In the example above, you can see on the right of the screen that the user is selecting the use for the 5th column. In this case, it will be ''Team''. The user also needs to change the ''Lines to ignore'' to ''1'' because, as can be seen via the preview, the first line of the file isn't actual data.

	Once "OK" is hit the import takes place. At this point the settings are saved and will be the default settings next time the screen is used.		Once ''OK'' is hit, the import takes place. At this point, the settings are saved and will be the default settings next time the screen is used.


Line 34:		Line 34:
	===from Timer (DOS Standard Skiing Package)===		===from Timer (DOS Standard Skiing Package)===

	This is a very old format used to transfer data between Split Second's original DOS software. It's been kept because some users might still use it. It expects a simple comma separated file with the fields: bib, class, team, result1, result2.		This is a very old format used to transfer data between Split Second's original DOS software. It's been kept because some users might still use it. It expects a simple, comma separated file with the fields: bib, class, team, result1, and result2.

	===Registration file from USSA (Nor-Am+)===		===Registration file from USSA (Nor-Am+)===
Line 40:		Line 40:
	This is to import a specific data format from USSA from a file with a .usr extension. It's only used for entries for Nor-Am and higher events.		This is to import a specific data format from USSA from a file with a .usr extension. It's only used for entries for Nor-Am and higher events.

	The first line of the file is expected to be comma separated with the following fields: number of competitors, gender, USSA race code, FIS race code.		The first line of the file is expected to be comma separated with the following fields: number of competitors, gender, USSA race code, and FIS race code.

	This is followed by one line per competitor with comma separated fields. The only fields used by the software are the ~~seconnd~~ field for USSA number and the third field which is FIS number. These are used to look up competitors from the current points list. If competitors can't be found in the [[National FIS Software : Factors Lists#Points Lists\|points lists]] a report is generated.		This is followed by one line per competitor with comma separated fields. The only fields used by the software are the second field for USSA number and the third field, which is FIS number. These are used to look up competitors from the current points list. If competitors can't be found in the [[National FIS Software : Factors Lists#Points Lists\|points lists]] a report is generated.

	===Comp Import===		===Comp Import===
Line 52:		Line 52:


	If you have a file with the data in this format click OK to continue.		If you have a file with the data in this format click ''OK'' to continue.

← Older revision		Revision as of 13:44, 20 November 2009
Line 7:		Line 7:


	For almost ~~all situations~~ the first option listed will be the ~~one~~ to use. The others, which are also explained below, are somewhat obsolete but have been kept ~~rather than remove~~ functionality that may still be in use by someone.		For almost every situation, the first option listed will be the option to use. The others, which are also explained below, are somewhat obsolete, but have been kept to maintain functionality that may still be in use by someone.

	===Import from any comma or tab separated file===		===Import from any comma or tab separated file===

	This will give a standard Windows screen to select the file to be imported. By default it expects files in a .csv format but other extensions may be selected via the drop-down typically on the bottom of the screen.		This will give a standard Windows screen to select the file to be imported. By default, it expects files in a .csv format but other extensions may be selected via the drop-down typically on the bottom of the screen.

	Once selected it will display an interactive screen to define what is imported and how:		Once selected, it will display an interactive screen to define what is imported and how:


Line 19:		Line 19:


	Follow the instructions carefully on the screen. This involves: ~~selecting~~ the format, how duplicate data is managed, lines to be ignored, and ~~selecting~~ which column of data goes into which field. The preview section at the bottom of the screen displays how the import will be done and how the data is used.		Follow the instructions carefully on the screen. This involves selecting: the format, how duplicate data is managed, lines to be ignored, and which column of data goes into which field. The preview section at the bottom of the screen displays how the import will be done and how the data is used.

	In the example above you can see on the right of the screen the user is selecting the use for the 5th column. In this case it will be "Team". The user also needs to change the "Lines to ignore" to "1" because, as can be seen via the preview, the first line of the file isn't actual data.		In the example above, you can see on the right of the screen that the user is selecting the use for the 5th column. In this case, it will be "Team". The user also needs to change the "Lines to ignore" to "1" because, as can be seen via the preview, the first line of the file isn't actual data.

	Once "OK" is hit the import takes place. At this point the settings are saved and will be the default settings next time the screen is used.		Once "OK" is hit the import takes place. At this point the settings are saved and will be the default settings next time the screen is used.
Line 27:		Line 27:

	<div style="background-color:LightGray; -moz-border-radius:15px;">		<div style="background-color:LightGray; -moz-border-radius:15px;">
	:'''NOTE:''' Be very careful to set how duplicates are managed correctly! Duplicates are based on bib number. If there aren't bibs assigned or they aren't defined in the import a new record will always be created.<br>		:'''NOTE:''' Be very careful to set how duplicates are managed correctly! Duplicates are based on bib number. If there aren't bibs assigned or they aren't defined in the import, a new record will always be created.<br>
	[[image:NatFIS_Import4.jpg‎\|center]]<br>		[[image:NatFIS_Import4.jpg‎\|center]]<br>
	</div>		</div>
Line 42:		Line 42:
	The first line of the file is expected to be comma separated with the following fields: number of competitors, gender, USSA race code, FIS race code.		The first line of the file is expected to be comma separated with the following fields: number of competitors, gender, USSA race code, FIS race code.

	This is followed by one line per competitor with comma separated fields. The only fields used by the software are the ~~2nd~~ field for USSA number, and the ~~3rd~~ field which is FIS number. These are used to look up competitors from the current points list. If competitors can't be found in the [[National FIS Software : Factors Lists#Points Lists\|points lists]] a report is generated.		This is followed by one line per competitor with comma separated fields. The only fields used by the software are the seconnd field for USSA number and the third field which is FIS number. These are used to look up competitors from the current points list. If competitors can't be found in the [[National FIS Software : Factors Lists#Points Lists\|points lists]] a report is generated.

	===Comp Import===		===Comp Import===