DASLr Manual - MEC

yompmulligrubsInternet and Web Development

Oct 31, 2013 (3 years and 5 months ago)

410 views




© 2005 MCOECN

DASLr
-
1

of
17

Revised
11/1/13

v1.61




DASLr













© 2005 MCOECN

DASLr
-
2

of
17

Revised
11/1/13

v1.61


DASLr

Overview


DASLr is a collection of views that make DASL data easily available to ITCs and
users. DASL
r

can be used with an ODBC compliant application



i.e. Excel
,
Access, Filemaker Pro
,
SQL Server 2005

Reporting Services
, Safari,
Active
Reports
,
etc.


to create custom reports using DASL data.

. Please note that
these are examples only


any ODBC compli
ant application can be used with
DASLr
.









































© 2005 MCOECN

DASLr
-
3

of
17

Revised
11/1/13

v1.61

Understanding DASLr

A Microsoft SQL Server ODBC connection connects the user’s computer to the

DASLr database which contains security tables, and the DASLr views listed

below. The

DASLr views reference tables i
n a copy of the production DASL
database.



ViewNa
m
e

ViewNa
m
e

Ab
s
ence
T
y
p
e
s

Stu
d
en
t
E
m
i
s
A
s
s
e
s
s
m
ent

Co
m
m
uni
t
ySe
r
vi
c
e

Stu
d
en
t
E
m
i
s
F
D

C
ou
r
s
eMa
s
t
e
r

Stu
d
en
t
E
m
i
s
F
N

C
ou
r
s
es

Stu
d
en
t
E
m
i
s
FNGr
aduate

D
A
S
L
Us
e
r
s

Stu
d
en
t
E
m
i
s
F
S

D
i
s
t
r
i
c
ts

Stu
d
en
t
E
m
i
s
G
i
f
t
edEx

Ho
m
eroo
m
s

Stu
d
en
t
E
m
i
s
Spe
c
i
a
l
E
d

Lo
c
k
e
rs

Stu
d
ent
F
ees

Ma
r
k
s

Stu
d
ent
G
p
a
H
i
st
o
r
y

O
P
T

Stu
d
ent
Gr
o
w
th

Pe
r
i
od
A
b
s
en
ce
St
u
de
n
t

Stu
d
ent
H
e
a
lt
h
Log

R
epo
r
t
ing
T
e
r
m
s

Stu
d
ent
H
o
m
e
r
oo
m
s

S
c
ho
o
l

Stu
d
entI
m
m
un
i
za
t
i
on

S
c
ho
o
lC
a
l
e
nda
r

Stu
d
en
t
Ma
r
k
s
All

S
c
ho
o
l
F
ee
s

Stu
d
en
t
Me
d
i
c
al

S
c
ho
o
l
M
a
r
k
C
o
m
m
entStan
d
a
r
d

Stu
d
en
t
Me
m
be
rs
hip

S
c
ho
o
ls

Stu
d
en
t
Mi
s
c

S
t
a
f
f

Stu
d
ent
N
otes

Stu
d
en
t
Ab
se
n
c
e
S
u
m
m
a
r
y

Stu
d
ent
O
n
l
i
n
e
S
c
h
e
dA
cc
o
u
n
t
s

Stu
d
en
t
A
l
e
rt

Stu
d
en
t
Pe
r
i
o
d
Ab
s
e
n
c
e

Stu
d
en
t
A
P
E
x
a
m

Stu
d
en
t
P
r
e
s
c
r
ip
t
ion

Stu
d
en
t
A
s
s
e
s
s
m
en
t

Stu
d
en
t
P
r
o
f
i
l
e
F
u
l
l

Stu
d
en
t
B
u
i
l
di
n
gP
r
og
r
e
s
s
i
o
n

Stu
d
ent
R
e
q
ue
s
t_
n
y

Stu
d
ent
C
on
t
a
c
t
s

Stu
d
en
t
SA
T
2E
x
am

Stu
d
ent
C
ou
r
s
e
H
i
s
to
r
y

Stu
d
en
t
S
c
h
e
du
l
e

Stu
d
ent
C
ou
r
s
e
M
a
r
k
s

Stu
d
en
t
S
p
e
c
i
a
l
E
d

Stu
d
ent
C
ou
r
s
eR
e
q
u
e
st
s

Stu
d
en
t
S
S
ID

Stu
d
ent
C
ou
r
s
e
s
A
ss
i
g
ne
d

Stu
d
ent
T
r
an
s
po
r
ta
t
i
o
n

Stu
d
ent
D
ai
l
yAb
s
e
n
c
e

Stu
d
ent
T
r
an
s
po
r
ta
t
i
o
n_
n
y

Stu
d
ent
D
e
m
og
r
aphi
c

Stu
d
en
t
Vi
s
ion

Stu
d
ent
D
i
sc
i
p
l
i
n
e

U
s
e
r
I
m
pe
rs
onations




© 2005 MCOECN

DASLr
-
4

of
17

Revised
11/1/13

v1.61


Conn
ecting to DASLr via ODBC


Before you can use DASLr with any ODBC compliant tool, you will need to set up
ODBC connectivity to

DASLr. Below are the steps to create this ODBC
Connection.




Go to C
ontrol Panel


Administrative Tools


Data Sources (ODBC)

o

OR

If running Windows 7 64 bit connect

from path

(see last page
oif uncertain)
:


Go to

-

C:
\
Windows
\
SysWOW64
\
odbcad32.exe.




Click

on the System DSN tab in the
ODBC Data Source Administrator

dialog box







Click Add button





© 2005 MCOECN

DASLr
-
5

of
17

Revised
11/1/13

v1.61






Choose SQL Server as the driver for your data source




Click Finish








Name


Enter the name of your DASLr database




Description


Enter
a

description of your DASLr database




Server


Choose the server that your DASLr database resides on

[MEC
DASLr server:
64.113.176.79
]




Click Next





© 2005 MCOECN

DASLr
-
6

of
17

Revised
11/1/13

v1.61







Choose “With SQL Server authentication using a login ID and password
entered by the user.




Enter Login
ID and Password
[Provided by MEC]




Click Client Configuration







U
ncheck

'Dynamically determine port', leaving the Port number

1433.




Click Next




© 2005 MCOECN

DASLr
-
7

of
17

Revised
11/1/13

v1.61






Click Next






Click Finish





© 2005 MCOECN

DASLr
-
8

of
17

Revised
11/1/13

v1.61





Click Test Data Source






Click OK



You are now ready to use DASLr
with any ODBC compliant application.





© 2005 MCOECN

DASLr
-
9

of
17

Revised
11/1/13

v1.61







© 2005 MCOECN

DASLr
-
10

of
17

Revised
11/1/13

v1.61

DASLr Authorized Account Application


A

DASLr Authorized Account Application form follows.




© 2005 MCOECN

DASLr
-
11

of
17

Revised
11/1/13

v1.61


DASLr Authorized Account Application


First and Last Name:






Position:


School District:



Supervisors Name:


Phone number:


School Building:


Building IRN:


Phone number:


Type of Request:
Check one box




New Account




Update




Deletion



Renewal


If Renewal, Username:










Required Signatures

This form will not be processed without the appropriate
signatures


Applicant: Date:


Superintendent:


Date:





Grant this account access to all views for the entire district


Note: If you do
not

check the box above, please indicate the access desired for this
account
:





-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

MEC

Staff Use Only
-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-


Request Received: _______________




Request Completed: _______________


Account Name: __________________




Staff Completing Request: ___________





© 2005 MCOECN

DASLr
-
12

of
17

Revised
11/1/13

v1.61


Microsoft Access using ODBC
Connectivity


To connect to DASLr from Microsoft Access via ODB
C, do the following….




Create a new blank database in Microsoft Access



File


Get External Data


Link T
ables



Choose “Files of type” = ODBC Databases

























On the Machine Data Source tab of the Select Data Source dialog box,
click on the Data Source Name of the database you want to connect to.




Click OK





© 2005 MCOECN

DASLr
-
13

of
17

Revised
11/1/13

v1.61






Enter p
assword and Click OK






You will be asked to Link the tables in MS Access


click
OK thru the
tables.














© 2005 MCOECN

DASLr
-
14

of
17

Revised
11/1/13

v1.61

Microsoft Excel using ODBC
Connectivity



To connect to DASLr from Microsoft Excel via ODBC, do the
following….





Data


Import External Data


New Database Query






Choose Data Source


Datbases tab


click on DASLr database




Click OK






Enter Login ID and Password




Click OK





© 2005 MCOECN

DASLr
-
15

of
17

Revised
11/1/13

v1.61





Choose table






Click Next





© 2005 MCOECN

DASLr
-
16

of
17

Revised
11/1/13

v1.61





Click Next






Click Next





© 2005 MCOECN

DASLr
-
17

of
17

Revised
11/1/13

v1.61





Click
Finish



How to determine if you are running Windows 7 with 64
-
bit OS
-