Mass Operations

The Export feature will export all the data to a .csv file (Figure 3.6). The Mass operations option permit an import of a .csv file (Figure 3.7). You can edit a .csv file in a spreadsheet application, choosing the ; to split the columns. The fields are:

Mandatory fields:

actionmachine: Options available:
- I: To insert a machine in IPBrick;
- U: To update machine information in IPBrick;
- D: To delete a machine in IPBrick;
machinetype: Options available:
- 1: For Workstation;
- 3: For Workstation + Softphone;
- 14: For Linux Workstation;
- 15: For Linux Workstation + Softphone;
- 16: For Printer;
- 2: For IP Phone;
- 7: For Linux Terminal;
- 4: For Windows Terminal.
name: Machine single name;
ip: Machine IP. The format is xxx.xxx.xxx.xxx;
mac: Machine NIC MAC address. The format is xx:xx:xx:xx:xx:xx;
password: Password to use if a SIP phone is selected. Example: 123;

Other fields:

computernumber: Machine LDAP ID;
groupnumber: Machine group number if associated to some group;
rdpsrvaddress: Remote server IP if a terminal is selected;
rdpsrvdomain: Remote server domain if a Windows terminal is selected.

Example of a .cvs file content for mass operations import option:

"actionmachine";"machinetype";"name";"ip";"mac";"password"
"I";"1";"wrk01";"192.168.69.100";"00:E0:98:9C:49:03";""
"I";"1";"wrk02";"192.168.69.101";"00:E0:98:4D:23:12";""
"I";"1";"wrk03";"192.168.69.102";"00:E0:98:9B:45:04";""
"I";"3";"softphone01";"192.168.69.102";"00:E0:98:9B:45:04";"1234"

! Attention:

The computer name has to be an alphanumerical name. Exceptions are the characters _ and -;
The computer name shouldn't have spaces nor diacritical marks on characters neither punctuation. Its maximum size should be 15 characters;
Is is not allowed to register neither machine with the same name nor machine whose names are identical with a registered user log in;
For a registration of a Windows station, the name as to be always in small letters and if necessary change the Computer name to small letters, too.

**Figure 3.6:** Machine Management - Export

**Figure 3.7:** Machine Management - Mass Operations

iPortalMais