1 / 25

Office of Education Technology (OET)

Office of Education Technology (OET). Active Directory Bulk Import. Saturday March 11, 2006 /8:30 – 10:30 AM. Before you proceed…. Some slides contain notes that are viewable from the Notes Page layout Select View  Notes Page from the menu toolbar to view additional notes. STI Export.

taber
Download Presentation

Office of Education Technology (OET)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Office of Education Technology (OET) Active Directory Bulk Import Saturday March 11, 2006 /8:30 – 10:30 AM

  2. Before you proceed… • Some slides contain notes that are viewable from the Notes Page layout • Select View  Notes Page from the menu toolbar to view additional notes

  3. STI Export • Open District Workstation and logon • Select Utilities, Export, Export Manager • Select New and type the name of the export (AD_Export) and click OK • In the Export File Name box, type AD_Export.txt • Change the export path to the location where you want the exported information to be placed (e:\ad_export)

  4. STI Export • Select Edit Query • On the Query Builder Design page, select qryStudent Demographics from the left pane and drag it to the right pane • Select the checkboxes for the following: • First_Name • Last_Name • Grade_Level • School_Number

  5. STI Export • Click on the disk icon at the top of the page to save the query • Name the query (All Students Export) • For the category, select General • For the description, type “This query is used to export students….) • Click OK

  6. STI Export • Click the traffic light at the top of the page to run the test the query • If the results are what you expected, click the Red X to close the Query Builder page • On the Export Builder page, select your query from the Query dropdown list and click OK • Click Save

  7. STI Export • On the Export Specifications page, you should see the AD_Export object in the list • Select it and click Start • Once the export is complete, a dialogue box will appear. Click OK • You can exit the District Workstation by clicking on the X in the upper right hand corner of each screen

  8. STI Export • Go to the newly created e:\ad_export folder and share it to DIST Support Admins • Go to your AD management workstation and retrieve the exported file (place it near the root of a drive letter for ease of use such as c:\ad_exports\ad_export.txt)

  9. STI Export

  10. Change text to columns

  11. Left, Concatenate, Find and Replace • Use Left to create user name • Use the concatenate function to create user names

  12. Find and Replace • Click to highlight the column containing the grade level • Click on Edit, then Find • Click on the Replace tab and click on the options button • Be sure to check the Match entire cell contents box • In the Find text box, enter a grade level. In the replace with text box enter the graduation year. • Click Replace All • You will need to do the same process to replace school numbers with School Names if you prefer.

  13. What we have at this point • Your file should look similar to the example below. You have a column containing first names, last names, graduation year, school name, and the columns used to create a user name.

  14. Before adding anything else… • Be sure that your spreadsheet looks like below:

  15. Add Canonical Name • MORE CONCATENATE! • CN=username,OU=High,OU=Students,DC=District,DC=KETSDS,DC=NET

  16. Finish manipulating file • Add dsadd user to the first column • Highlight the entire worksheet, select Format then cells. Choose text and click OK • Add –fn in the column before the first name • Add –ln in the column before the last name • Add –desc in the column before the graduation year

  17. Highlight and Paste • Highlight only the text that you want to import. (be sure that the “work” cells that were used to configure the username are not included) • Copy the contents and open a new spreadsheet. • Right click in cell A1 and click Paste Special • Bullet Values and click OK

  18. Save!!! • Click on File and Save As • Change the Save as type to Text (Tab-delimited) file, name your file and click SAVE • You will be prompted with a couple of windows…click OK and YES

  19. Open File using Notepad

  20. Remove Tabs • Highlight the space between dsadd user and the “CN…” on the first row • Press Ctrl+C or select edit,copy • Select Edit, then replace • In the Find What text box, press Ctrl+v or select edit, paste • In the Replace with text box, press the space bar one time and click Replace All.

  21. Save as a Batch File • The tabs have been removed from your text file and it is ready to go. Click on File, click the Save as Type: and change to All Files. Rename your file to filename.bat and click Save.

  22. Run your import • From an Administrative workstation that has Windows Server 2003 support tools installed, double click on the file to run it. If you would like to monitor the progress of the file, run it from a command prompt rather than double clicking on it.

  23. View Success • Open Active Directory Users and Computers to view your newly created accounts

  24. Additional Items • DSAdd user has many options that can be manipulated • DSMod uses similar command functions and can be used for existing users

More Related