|
[Data] section
|
|
| · | Almost all commands that refers to the [Data] section must be put inside a Data.Loop..EndLoop statement.
|
| · | All commands in a Data.Loop..EndLoop statement are executed once for each row in the [Data] section.
|
| · | Commands can access the data in the [Data] section through column variables in the command parameters.
|
| · | One row = one set of parameters.
|
| · | Delimiter = BatchSettings.Delimiter.
|
| · | One column is always used by SetupBatcher for data markers, column number set by BatchSettings.MarkerCol.
|
| · | It is not possible to use comments in the [Data] section.
|
| Import data manually
|
|
|
| · | Load a text file - click file > open section > data.
|
| · | Paste data from the clipboard into a column - copy one column (in Excel), enter SetupBatcher, click data > paste column from clipboard, choose destination column.
|
| · | Paste and replace the entire data section - click edit > paste section > data.
|
| · | Get data from SetupExplorer - use the SetupExplorer filter functions to select accounts and click export to export to SetupBatcher.
|
| Example - use SetupExplorer to get SamAccount names and display names by group membership
|
|
|
| · | Enter SetupExplorer
|
| · | Enter a server name, click explore
|
| · | Click the "group membership" tab, click explore
|
| · | Click on a group name in the column headings to filter accounts by group membership
|
| · | Click the "export" button, click "export to" / "SetupBatcher [Data] section"
|
| · | Enter "2,1" in the "Accounts / Columns" text box
|
| · | UnCheck the "Groups / Export" check box
|
| · | Check "Export to / SetupBatcher [Data] section", click "Ok"
|
|
|
| Import data automatically in a script
|
|
|
| · | Load a text file - Data.Load - Data.Save to save
|
| · | Load a number of text files - $GetDataFiles
|
| · | Get files from a FTP or email server - $GetDataFiles
|
| · | Get data from Active directory - Data.Get.AD, Data.Get.AD.Find
|
| · | Get data from Linux directory - Data.Get.LD.Find
|
| · | Get data from Novell directory - Data.Get.ND, Data.Get.ND.Find
|
| Manually
|
|
|
| · | Click the data menu and choose function.
|
|
|
| Automatically from a script
|
|
|
| · | Check length and that valid characters are used - Data.Column.Check
|
| · | Check for duplicates - Data.Column.DupeCheck
|
| · | Create unique AD user names - Data.Column.DupeCheck
|
| · | Fill a column with identical values - Data.Column.Fill
|
| · | Replace text in a column - Data.Column.ReplaceText
|
| · | Generate passwords - Data.Passwords.Generate
|
| · | Create unique SamAccount user names - Data.Usernames.Generate
|
| · | Write data - Data.Write
|
| · | Print - Data.PrintRow
|
| · | Preview [Data] section before script starts - Data.Show
|