Importing Data Files


Data in a variety of configurations from other programs including Excel can be imported into League Manager. You may have just a first and last name, name plus a numeric ID, name and ID with scores, etc. that you can import. The file you import must be a text (ASCII) file. Most software programs and services have a way to output your data in a text file delimited by a comma, space, tab or semicolon.


When importing, if you already have names in the League Manager league into which you are importing, the program will first attempt to match people by looking for a matching player ID number. If a number is not available, then the program will attempt a match with the first and last name (Jim and James or Dick and Richard may be the same person to us humans, but to the computer it is not a match even with the same last name).


If you are importing the data into an empty league, then no matching is necessary (except if you are importing scores in which case the first and last names must match for all scores by an individual player).


If the data you are importing is from an online registration form created using GolfSoftware's Website Builder registration feature, please see Import Registration Information.


Importing


  1. Select "Import Data to League..." from the League menu.

  2. The Import window will open on Tab 1. Import to... Whatever league is open in League Manager is where the data will be imported to. If you see the incorrect league named on this tab, hit the Cancel button and open the correct league.



  3. Click Next to move to Tab 2. File to Import.



  4. Click on the Find ASCII delimited file to import button (above image) and you will see a new window like the one below (from Windows XP).



  5. Select the file you want to import from the "Get file to import window" (above) and click on Open button.



  6. Check to see if your data has a header line or lines above the data (the above has none) and make sure the number in the Start import at row box is correct. If you have one line of headers (last name, first name, gender, etc.), enter "2" in this box. If your data starts at the third line in your file, enter "3" in this box.

  7. Click the Next button to go to Tab 3. Type of file.



  8. When you arrive at Tab 3. Type of file, your data may not show itself in rows and columns as above. You must select the correct delimiter by clicking and placing the dot next to the applicable delimiter (see below). Your data should be in rows and columns as in the image below.



  9. In some cases you may see the text in columns surrounded by single or double quotation marks. If that is the case, click on the Text qualifier box and change to the text qualifier which is visible in your data. For instance, if you see the double quotation marks surrounding the last name - "Taylor" - then change the Text qualifier box to the double quotation marks.

  10. Click on the Next button to advance to Tab 4. Fields to import to.



  11. You must "map" or tell League Manager on Tab 4 which columns of data you wish to import and where (what "field") to put the data. All columns, like column 1 above, will have "None" for the field name. If that is a field you want to import - League Manager will not import data identified as "None" - select the proper identifying name from the drop down menu for that column (field) of data. Once all of the fields you want to import are properly identified and all of the fields you do not want to import have "None" as the column header, then you may click on the Finish button.

  12. When the importing is complete, you will see something like the below image.



  13. You will note in the background how many records were updated, added and transferred. Click on the OK button. League Manager will close and you must restart League Manager.