Abzetdin Adamov's IT Blog

IT is about doing more with less!

Archive for June, 2010

Google Apps for Education – Upload many users at once

Posted by Abzetdin Adamov on June 24, 2010

Generally it’s problematical to prepare CSV format file with data to upload many users at once to GMail server for Google Apps. Here I’ll try to share a slight experience on how to do this…
  1. Select users information from appropriate database/table (see more details below)
    1. username
    2. first name
    3. last name
    4. password (how to generate automatically)
  2. Export data to Excel
  3. Delete the First colunm order number
  4. Save as Unicode Text or
  5. Open and Save as UTF-8 with BOA and .CSV extention
  6. Replace all Tab characters with Comma
  7. Upload File to Google
How to generate passwords? Keep in mind that the minimal length of password in Google is 6 symbols…


select t.username as "username",
t.first_name as "first name",
t.last_name as "last name",
round(p.str) as "password"
from table t, (select dbms_random.value(100000, 999999) str from dual) p
where .... -- if it's necessary

--dbms_random.string('L', 6) you can use this function instead of .value if you would like to generate character password

Advertisements

Posted in Administration and System Design | Leave a Comment »

Science, Education and Information Technology Festival in Sumgayit

Posted by Abzetdin Adamov on June 23, 2010

Presentation on Qafqaz University Administrative Information System

22 and 23 June 2010 a two-day Science, Education and Information Technology Festival began in the district on Tuesday aimed at building information-oriented society. Festival organized jointly with Sumgayit City Municipality, Ministry of Education, Ministry of Communication and Information Technologies, Qafqaz University and several IT Companies including Microsoft, HP, Azedunet, Nursoft, …

The programmes include colorful rally, computer training, web-design and programming competitions, motivational campaign, discussion meeting and cultural function in cooperation with Qafqaz University.

The speakers in their speeches said there is no alternative to e-education and information technology to face the challenges of 21st century and to build digital Azerbaijan.  CIO and Head of Computer Engineering Department at Qafqaz University Dr. Abzetdin Adamov talked on successfull implementation of Administrative Management System and Student Information System and how these projects support faculty and students needs in information and how it contribute the institution’s academic mission — the goals of teaching, learning, and research. A large number of heads of academic institutions, chairmen and members of school managing committee and social workers including the journalists took part in the workshop.

Posted in Information System Design, University Management System | Leave a Comment »

Towards Good Governance Through The Implementation of Electronic University Management System: Qafqaz University’s Experience

Posted by Abzetdin Adamov on June 10, 2010

Qafqaz University - Administrative Information System

Qafqaz University - Management Information System

Over the past few years, there has been increasing attention on how Information Technology (IT) supports good governance in Higher Education Institutions (HEI). It’s obvious that communications and information technology provides increasing opportunities to improve institutional effectiveness and efficiency. The use of technology is driving significant changes in the way educational institutions meet their goals and objectives. With the rapid pace of technological change and increased competition, good governance of HEI with the help of University Management System (UMS) presents significant challenges.
Parallel with general issues on the usage of IT in HEI governance, this paper provides brief information about Qafqaz University’s experience in this field and the vision of the university on the way to securing good governance, which is built on the following four main principles:

  1. increasing transparency and accountability;
  2. facilitating information access, and increasing functionality of pervasive information system;
  3. facilitating decision-making process;
  4. enhancing the efficient delivery of services to staff and students.

As it is well known from IT history, innovative technologies can start out as relatively small issues and suddenly become vitally important, requiring immediate solutions. In the same way, small IT initiative which had limited purposes has become the infrastructure with a strong strategic value and a great asset to achieve institutional strategic goals.

Posted in Good Governance through IT, Information System Design, University Management System | Leave a Comment »