Import Winning Numbers Wizard

Menu: Winning Numbers Import Wizard

In this step you assign field names to table's column, i.e. you specify the content of each column, e.g. drawn number, bonus number, the year of draw etc. You can select field names from the combo boxes in table's header.

Example: Let's assume you wish to import the following data into the Expert Lotto 6/49 lottery:

Winning Numbers for 2nd draw Wednesday       Jackpot  
44 2004 1 2 3 4 5 6 7 13445000 USD
45 2004 11 12 13 14 15 16 17 none  
46 2004 21 22 23 24 25 26 27 21780440 USD

That means we want to import winning numbers for the 2nd draw made on Wednesday. So we'll select the following field names in table's header:

1. column - Week
2. column - Year
3. column - Number
4. column - Number
5. column - Number
6. column - Number
7. column - Number
8. column - Number
9. column - Bonus
11. column - <ignore>
12. column - <ignore>

The first two columns will be imported as the draw date, columns 3 to 8 will be treated as winning numbers and column 9 will be the bonus number. The wizard will ignore the rest of table's columns.
The demo lottery Expert Lotto 6/49 draws two sets of winning numbers twice a week. Therefore the field names in table's header include also Draw Day and Draw. However the lines in our text do not contain these fields. This is quite common when lottery web sites publish winning results separately for each draw days and/or draw names. In such cases the wizard will prompt you for default values for the missing fields. Entered values will be used for all lines of imported text.
In the example above the wizard will prompt you for draw selection and then for draw day selection. If you select "2nd draw" and "Wednesday" then the imported winning numbers will look like this:
44. week 2004, 2nd draw Wednesday, 1,2,3,4,5,6 - 7
45. week 2004, 2nd draw Wednesday, 11,12,13,14,15,16 - 17
46. week 2004, 2nd draw Wednesday, 21,22,23,24,25,26 - 27

The imported text must contain at least:

You can select default values for the rest of the draw date fields. The defaults will be then used for all lines of imported text.

At the bottom of the window you can select the regional settings to be used for draw date conversions. This option is especially useful if the imported text contains the names of months and/or days instead of their numbers (e.g. June instead of 6) and the text is in a different language then the default one of your operating system.

Hint: Double-click any table cell to edit its content.

 

Use the Next button to continue with wizard's next step, you can return to wizard's previous step by using the Previous button.