Lottery Numbers Import Wizard

Top  Previous  Next

When you start to work with lottery software one of the most important thing is establishing a database of current lottery numbers.

We will use term 'lottery numbers' instead of 'drawings'. Drawings is appropriate term in US for example but in translation to other languages it may be misunderstood for drawing something on the paper with a pen.

 

Although the software has Update Lottery Numbers Online feature where you can download numbers from many games, but in case when you need to import numbers manually

this wizard help you do that.

 
Very often this is a time consuming task. Visual Lottery Analyser provides this wizard so you do not have to type the drawing numbers manually.

You can import drawings from text file or paste text from clipboard and then parse text into a lottery numbers.

After that you may continue to adding the latest numbers to database using other software features.

 

To open Lottery Numbers Import window, please go to the software main window and click the Wizard button located on the ribbon bar within Lottery Numbers group.

 

importnumberswizard1

 

Each of pages has a comment shown on the top of wizard with explanation how to proceed with current step.

 

Previous and Next buttons moves between pages. You can always go back and forth to change some of import options

 

You can exit from wizard at any time by clicking on Cancel buttons.

 

Step 1 - Game Type


On this wizard page are listed all your games.

Select a game to which you want to import the numbers into.

 

Step 2 - Select the source of your numbers


Here you can choose the source of your numbers, where from you want to get them. You can choose to import numbers from:

 
Text file
It may be any text file that contains your number in any format
Clipboard
It may be any text from Clipboard that contains your number in any format
Internet web page
It may be any web page that contains your number in any format. The web page will be download into software and the web page text will be parsed.
 

Step 3 - Import data


The action you are going to take depends on your choice made in step 2.

If you have selected to import numbers from text file then you will need to click on the Open button to choose your text file from disk and load into wizard text box.
If you have selected to import numbers from Clipboard then you will need to click on the Paste button to paste the text into a wizard text box.
If you have selected to import numbers from Web page then you will need enter Internet Web address into a address bar and then click the Open button to load a page into a wizard text box.
After you have completed one of these steps click on the Next button to proceed.

 

Step 4 - Prepare and Clean Text


To have a text successfully parsed into a lottery numbers that could be imported into a drawings database the text should be in the following format

1,2,3,4,5 ^ Date
where the numbers are separated by comma and the drawings date is separated from numbers by ^ character
to enter a ^ character if necessary you can use Shift+6 keys on your keyboard

No date is required, you can add dates later using Lottery Numbers Manager

 

If you have your numbers shown in the required format like 1,2,3,4,5 ^ Date then you can skip this step.
If not, then you must parse the text using our text parser.
It may sound complicated but actually the text parser described below is so powerful that you can do almost anything with the text.

In most cases it will be enough to click once on the Parse Text Into Numbers button to have the text correctly parsed.
We have actually used this tool to import lottery numbers from a variety of web pages and text files and parse that text into numbers to use with our lottery numbers database located on our server.

The text parser automatically finding a date and numbers within a text so you do NOT have to edit a text manually at all!

 
Here are the details of text parser's options
Many of the options are for the advanced use only, you do not need to change and use all of them all the time.

 

Numbers & Data Group


 

importnumberswizard2
 
Numbers Position

This option is mandatory to set!

Please select whether the latest lottery numbers are on the top or on the bottom of your text file.
You must select the option correctly to have the lottery numbers entered into a software database in correct order!
Usually that latest numbers are on the top of the text.

 

Data Is In Range
This option is for optional and advanced use only!

Set here whether you need to use only a portion of a text.
When we imported numbers from web pages or text files provided by lottery sites then many times happened that the text was formatted like that:
1 2 3 4 5 Date and then variety information like Prizes and Jackpots.
Normally the text parser would fail because it could take the other numbers into account. Using this option you can set only the range of text where the real numbers are.
To do so check the Use Range check mark to tell the parser that it should take a part of text only.

Enter into two numbers boxes a data range like for example:

Text is

1 2 3 4 5 03/03/2010 Jackpot $10000

You need enter into a first box number 1 as the numbers starts form first position in line and then enter into a second box 22, as this is the position within text line where the date ends.

This option will be rather rarely used but is provided for convenience if necessary, There are also other options you can use instead of this one to achieve similar task

 

Minimum Length
This option is for optional use only!

This options tells the parser what is minimum length of text or text in line to take it for processing.

 

Lines 2X
This option is for optional use only!

This options tells the parser how to parse numbers for games when numbers are put into 2 lines of text.
Usually you will have numbers like 0 2 8 etc in one line, but it may happed that you will  will have like
1 4 5 6 7 8 9 10 11 12 13 14 15

5 7 9 etc
To avoid parsing error check this option. It may be the case with Keno games.

 

Exclude lines with
This option is for optional use only!

This options tells the parser to exclude all lines in text during parsing that  include a word entered into a text box.
There are also other options you can use instead of this one to achieve similar task

 

Parse Text Into Numbers

Click this button to start parsing text

After parsing review the numbers whether they are parsed correctly or not, if they are OK then click the Next button to proceed.

 

Replace Text Group


Here is a set of methods that lets you replace a text. The tool is intended to use when a text needs to be further modified before parsing into numbers.

 

replaceedit

 

Method

Choose replacing method, how the text will be processed.
Process line by line
This is default option!
When replacing text the tool will process a text line by line and apply all replacing options to each line

 
Process whole text

When replacing text the tool will process a whole text at once and apply all replacing options to the whole text

 
Process position range in lines, Process position range in whole text

These options lets you replace a text within a range of text only.  You can replace a range of text either in each line or whole text at once.
When you select one of these options then Range Position numeric boxes become available. Enter into these boxes start and end position of text you want to process.

 

Process between characters in lines, Process between characters in text

These options lets you replace a text within a text that is between some other words or characters in text.
When you select one of these options then Starting Word and Ending Word text boxes become available. Enter into these boxes words or characters, for example
If you have a text with line:

1 2 6 Day 1 8 9 Night
then you can use this option to process text that is between words Day and Night only. The rest of the text will not be processed.

Basically we used this option to remove the numbers between Day and Night, so in effect only numbers before word Day has left in text lines.
You can use this method for other purposes as well.

 

Process lines from start to character, Process whole text from start to character

These options lets you replace a text within a text that is between start of the each text line and the word you enter, and also replace a text within a text that is between start of text and the word you enter.
When you select one of these options then Ending Word text box become available. Enter into this box word or character, for example
If you have a text with line:

1 2 6 Day 1 8 9 Night
then you can use this option to process text that is between start of line and word Day only. The rest of the text will not be processed.

Basically we used this option to remove the numbers between start of lines and word Day, so in effect only numbers after word Day has left in text lines.
You can use this method for other purposes as well.

 

Process lines from character to end, Process whole text from character to end

These options lets you replace a text within a text that is between word you enter and end of each text line, and also replace a text within a text that is between word you enter and the end of whole text.
When you select one of these options then Starting Word text box become available. Enter into this box word or characters, for example
If you have a text with line:

1 2 6 Day 1 8 9 Night
then you can use this option to process text that is between word Day and end of the each line or whole text. The rest of the text will not be processed.

You can use this method for other purposes as well.

 

Process TAB character
Because you cannot enter a TAB character into a text box then you can use this option to process TAB character
Some of web sites provide numbers that are delimited with TAB character if necessary using this option you van for example replace  TAB with some other character like , comma for example.

 

Action

This option is mandatory to set!

Please select what kind of action will be performed when replacing a text
You can choose between Repack, which is standard action for replacing or Remove.
Remove action will remove any text processed by selected method.
This option works in conjunction with other options so you can use it to remove for example some text between other word only.

 

Find What
Enter a text, word or character you want to replace
 
Replace With
Enter here the text replacement.
It may be empty text so in the result text will be removed, similar to Remove action

Starting Word
Enter a text, word or character you want to use with the following replace or remove methods:
Process between characters in lines, Process between characters in text
Process lines from character to end, Process whole text from character to end

Add Word check mark
When checked then the word you have entered into a Starting Word text box will be included into a processed text otherwise it will not be.

Ending Word
Enter a text, word or character you want to use with the following replace or remove methods:
Process between characters in lines, Process between characters in text
Process lines from start to character, Process whole text from start to character

Add Word check mark
When checked then the word you have entered into a Ending Word text box will be included into a processed text otherwise it will not be.

 

Range Position

Use these options to set text range to process. Options became available to use with the following methods:

Process position range in lines, Process position range in whole text

Replace
Click this button to replace text


Remove lines with
This command will remove all lines from text that have a word entered into this text box.
Very often you may have a text file with lottery numbers for a day and evening.
If you want to have only numbers for a day then enter word evening to have all lines with evening word removed
To begin click on the Delete Icon on the end of the text box. Do not click the Replace button!
You can use this method for other purposes as well.

Leave lines with
This command will leave all lines from text that have a word entered into this text box and remove all others.
Very often you may have a text file with lottery numbers for a many games like
1 2 3 Lotto
1 2 3 Pick 3
1 2 3 Numbers Game

If you want to have only numbers for a Pick 3 only then enter word Pick 3 to have all lines with Pick 3 word saved and rest removed
To begin click on the OK Icon on the end of the text box. Do not click the Replace button!
You can use this method for other purposes as well.

 

Date Group


Here are few options that will help to parse text when you need to work with text dates.
 
wizarddateedit
First date is valid, Second date is valid
Very often you may have a text file with lottery numbers and they have two dates, one date is for actual drawing and the second for when drawings expire or something else.
To avoid parsing errors and confusion here you may select which date is valid.

 

Date is in range
This option is for optional and advanced use only!

Set here whether you need to use only a portion of a text to determine where the date for drawings exist.
This works in similar way like Data Is In Range method but applies to dates only.

Change Format
This tool lets you chance date format in text when necessary. You can convert between all available formats like form M/D/Y to D/M/Y etc
We use short abbreviations for those symbols and M stands for month, D for day and Y for year.

Delimiter

Here you can specify the delimiter that will be used to determine the date separator for date change format command above

 
Short date, Long date

A two small date conversion functions just for informational purposes.

Just enter or paste a date to convert between short and long date format.
 
Step 5 - Lottery Numbers Validation


This is the last step before you add numbers to software database.
Please review whether the numbers are correctly shown on the window.
 
Lottery Numbers Preview Listing

drawings_preview_list
To make any corrections you may go back to any previous wizard window by clicking on the Previous button.
 
On this wizard window there is the following option you may use:

Append when Adding

If selected then these new numbers will be appended to existing numbers in game database, otherwise the previous numbers in database will be erased and replaced with the new ones.

 

Click the Next button to add or append your numbers to software numbers database.