Topics Map > Campus Services > PASS
Topics Map > Campus Services > Business Analysis and Reporting

BI - Convert Student IDs

Directions on how to convert swipe card information in BI.

Business Intelligence (OBIEE) has the capability of captivating data from student ID cards to provide you with information about students (name, campus email, residence hall, major, etc.).  To do this, please follow these steps: Log into Business Intelligence (OBIEE)
  1. Select Swipe Card Data from Dashboard menu
  2. Click the down arrow on Campus ID prompt and select More/Search
  3. Select the pencil for edit mode (upper right corner of dialog box) and copy & paste card IDs in the Edit box
  4. Click OK twice, then click Apply

You can now view, print or export your report.

Option  to Convert the IDs in Excel 2013:

Use the Text to Columns Command

This method works best if the data is arranged in a single column. The following example assumes that the data is in column A and starts in row 1 ($A$1). To use this example, follow these steps:

1. Select one column of cells that contain the text.
1

2. On the Data menu or ribbon, click Text to Columns.
2

3. Under Original data type, click Delimited, and click Next.
3

4. Under Delimiters, click to select the Tab check box, and click Next.
4 OR 5

5. Under Column data format, click General.
6

6. If needed: Click Advanced and make any appropriate settings for the Decimal separator and Thousands separator. Click OK.

7. Click Finish.

8. You will get the following pop-up. Select OK.
7

9. Your numbers may be too large for the column and appear as below; double-click to expand the column
8

10. Right-click to format cells as numbers (if they show up as percentages).
9

You now have your 16 digit number which can be copied and pasted into the analysis.
10

To do this, please follow these steps: Log into Business Intelligence (OBIEE)
1.    Select Swipe Card Data from Dashboard menu
2.    Click the down arrow on Campus ID prompt and select More/Search
3.    Select the pencil for edit mode (upper right corner of dialog box) and copy & paste card IDs in the Edit box
4.    Click OK twice, then click Apply
You can now view, print or export your report.


 NOTE: The formatting will still show text but the type has changed to number so formulas will recognize it as a number.

**The 16 digit number may show up as a %.  To change this, select the entire column, right click and select format cells.  You will then change the number format to number with 0 decimals.

Microsoft link with complete instructions for converting numbers stored as text:

https://support.office.com/en-us/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885


If you have questions, please contact the ITS Help Desk at 608.342.1400 or helpdesk@uwplatt.edu.  You may also visit the Help Desk on the first floor of the Karrmann Library.




Keywords:Student Id, Swipe Card, OBIEE, BI, business intelligence, Excel   Doc ID:43892
Owner:Amy C.Group:UW Platteville
Created:2014-10-09 09:59 CDTUpdated:2017-01-03 17:14 CDT
Sites:UW Platteville
Feedback:  0   0