Data file format in example
Top  Previous  Next


·Clear text, one account / row, comma delimited data  
·Delimiter can be changed to TAB, semicolon or colon by changing BatchSettings.Delimiter  
·Any data can be read from any column by changing %col% variables in the script  

#
Column
Type*
Description
1
AccountName
D
NT / Windows 2000 user name
2
FullName
D

3
EmailAddress
D
Not used in example
4
Password
D

5
Domain
D
Not used in example
6
PIN
D
Personal ID Number, format: YYMMDD-XXXX (birth date and control code)
7
AccountType
D
S=student, T=teacher, used for group membership / permissions
8
Unit
D
School or School district   
9
Class
D
Used for group membership and on Windows 2000 OU.
10
OldUnit
C
Set when a student moves to a new school-> move files to new server, tell administrator that files should be deleted
11
OldClass
C
Set when class changes-> change group and OU membership
12
AccountActive
C
Used to temporarily inactivate an account. "active" = set account disabled to no, "Inactive" = set account disabled to yes
13
AccountDeleted
C
"delete" = set expiration date to 2000-01-01 -> no longer possible to log on, administrator then deletes accounts manually (safety measure)
14
AccountNew
C
"new" = create new account

*) D = Data field, C = Control field

Data file example - five new accounts, type=S(students), school="HOJDEN", class="6a" and "6b"

10000,Ann-Britt Svensson,ann.britt.svensson@utb.kommun.se,kl34ur,DOMAIN001,830434-4386,S,HOJDEN,6a,,,active,notdel,new
10001,Lisa Holgersson,lisa.holgersson@utb.kommun.se,oxefjfkw,DOMAIN001,840512-4323,S,HOJDEN,6a,,,active,notdel,new
10002,Karl Evert Nyberg,karl.evert.nyberg@utb.kommun.se,fk39ds,DOMAIN001,830918-8590,S,HOJDEN,6b,,,active,notdel,new
10003,Stefan Jonson,stefan.jonson@utb.kommun.se,cmow92,DOMAIN001,840220-4812,S,HOJDEN,6b,,,active,notdel,new
10004,Sirpa Lehtosalo,sirpa.lehtosalo@utb.kommun.se,gjqm23,DOMAIN001,840602-3206,S,HOJDEN,6b,,,active,notdel,new

Data file example - move account 10001 from class 6a to 6b, inactivate account 10003, mark account 10004 for deletion

10001,Lisa Holgersson,lisa.holgersson@utb.kommun.se,oxefjfkw,DOMAIN001,840512-4323,S,HOJDEN,6b,,6a,active,notdel,
10003,Stefan Jonson,stefan.jonson@utb.kommun.se,cmow92,DOMAIN001,840220-4812,S,HOJDEN,6b,,,inactive,notdel,
10004,Sirpa Lehtosalo,sirpa.lehtosalo@utb.kommun.se,gjqm23,DOMAIN001,840602-3206,S,HOJDEN,6b,,,active,delete,

Data file example - same as above move example but with only the needed data (works equally well)

10001,,,,,,,HOJDEN,6b,,6a,active,notdel,
10003,,,,,,,HOJDEN,6b,,,inactive,notdel,
10004,,,,,,,HOJDEN,6b,,,active,delete,