2007/05/28

Creating Database


        To manage AD accounts Using PHP5+Mysql5
        How to let the good idea work in practice?
        First,Export users list from exchange server 2003  into a txt file easily and modify its data just a little,so that microsoft excel can read and transfer it,then,open a blank excel file,click menu "file",select "open",search for that txt file and select it to open,modify it and save  as a csv type file. as someone knows,database has a function that allowed importing some kinds of file into a table, one kind of them is csv.At this monment,i think you have known how to do.
        Second,export member list of group including distribution group and security group,you have no any idea exporting member list unless using commant line looks like DOS mode,the data file you have exported need to modify too,at last,import the fixed file into one table of your database.there are always some kind of relationship between users list and members list.
        Basic data has been builded,Final,apply your skill of database to do it.you will find a way to realize.
 

No comments: