The BTM - 2013 Professional and Automatic Scoring Editions provide a new feature to allow bowler information to be imported form an Excel or .CSV file. The program will support most Excel files up to files created by Excel 2007. Users with newer versions of Excel should save the information in .CSV format for importing into BTM - 2013. Please see the HELP file included in the program for additional information. |
Upon selecting this option, the user will be prompted to locate and open the file containing the information to be imported. By default, BTM - 2013 will show Excel files created by Excel 2003 and older. For Workbooks created in Excel 2007, use the drop down list for Files of type to select 'New Excel'. For CSV files, use 'Text/Comma'. Upon
selecting the file to be imported, the Import Wizard will open to step through
the import process.
Each type of file
will be imported differently
MS
Excel
The Fields section provides the various data which can be imported into BTM - 2013. To the right are the columns and rows from the MS Excel spreadsheet which was opened. The first step is to match the Fields to the data in the Excel spreadsheet:
1. Select
the field to be imported.
2. Click
the Green Plus Sign (+). The and another screen will appear
3. Type the Column letter which contains the data for the Field to be populated. If the data fields in the Excel spreadsheet go down, the Range Type can be changed to Row, then indicate the Row that contains the data.
4. Set the Start and Finish Rows as appropriate. Typically, these will not need to be changed. However, this option allows for the first row to be skipped if there are column headings that do not need to be imported. In addition, multiple ranges can be configured for the same field, so if there are rows in the middle of the spreadsheet that should be omitted, these rows can be skipped.
5. Select the next Field to be configured and repeat Steps 2-4 above. When finished defining the fields to be imported, click Next or Execute. It is recommended to click the Execute button as the next screens are designed for advanced users.
6. The next screen allow for changes to be made with regards to how the data is imported for each field configured. These settings are designed for Advanced users and should not be changed unless absolutely necessary. Click Next or Execute to continue.
7. The
final screen of the Import data wizard provides some Commit options, additional option to limit the number of records imported and error logging options. The Advanced TAB provides options to change the Import Mode.
Designate whether the records should be imported as new records or update
existing records. For the latter, identify the Key Columns such that the
correct records can be updated.
8. Clicking
Execute will open another screen:
This screen offers one final opportunity to filter the records. The options are under Selection Criteria are self-explanatory. Once the selections have been made, click the Import Selected option.
MS 2007 Excel
The Fields section provides the various data which can be imported into BTM - 2013. To the right are the columns and rows from the MS Excel spreadsheet which was opened. The first step is to match the Fields to the data in the Excel spreadsheet:
1. Select
the field to be imported.
2. Click
the column from the Worksheet and that column will immediately be assigned to
the selected field. If the incorrect column is selected, simply click the
correct column
3. Select the next Field to be configured and repeat. When finished defining the fields to be imported, click Next or Execute. It is recommended to click the Execute button as the next screens are designed for advanced users.
4. The next screen allow for changes to be made with regards to how the data is imported for each field configured. These settings are designed for Advanced users and should not be changed unless absolutely necessary. Click Next or Execute to continue.
5. The
final screen of the Import data wizard provides some Commit options, additional option to limit the number of records imported and error logging options. The Advanced TAB provides options to change the Import Mode.
Designate whether the records should be imported as new records or update
existing records. For the latter, identify the Key Columns such that the
correct records can be updated.
6. Clicking
Execute will open another screen:
This screen offers one final opportunity to filter the records. The options are under Selection Criteria are self-explanatory. Once the selections have been made, click the Import Selected option.
CSV
A CSV (Comma Separated Variable) file is simply a comma-delimited text file, typically created from an Excel Worksheet. However, BTM - 2013 supports delimited text files that utilize separators other than a comma, such as TAB or Space delimited files. Use the Drop Down list next to Comma to select the separator: Selecting this option will open another screen: The Fields section provides the various data which can be imported into BTM - 2013. To the right are the columns and rows from the MS Excel spreadsheet which was opened. The first step is to match the Fields to the data in the Excel spreadsheet: 1. If the delimited text file includes a header line or two, do not import this data by entering the number in the Skip line(s) field. 2. Select the field to be imported. 3. Click the column from the Worksheet and that column will immediately be assigned to the selected field. If the incorrect column is selected, simply click the correct column. Alternatively, the drop down list for Col Number can be used to select the column for the field 4. Select the next Field to be configured and repeat. When finished defining the fields to be imported, click Next or Execute. It is recommended to click the Execute button as the next screens are designed for advanced users. 5. The next screen allow for changes to be made with regards to how the data is imported for each field configured. These settings are designed for Advanced users and should not be changed unless absolutely necessary. Click Next or Execute to continue. 6. The final screen of the Import data wizard provides some Commit options, additional option to limit the number of records imported and error logging options. The Advanced TAB provides options to change the Import Mode. Designate whether the records should be imported as new records or update existing records. For the latter, identify the Key Columns such that the correct records can be updated. 7. Clicking Execute will open another screen:
This screen offers one final opportunity to filter the records. The options are under Selection Criteria are self-explanatory. Once the selections have been made, click the Import Selected option. |