Mass Operations

The Export feature will let you save all data to a .csv file (Figure 3.8). The Mass operations option enables you to import of a .csv file (Figure 3.9). You can edit a .csv file in a spreadsheet application, choosing ; to split the columns.

Mandatory fields:

• action: Options available:
  • I: To insert a machine in IPBrick;
  • U: To update machine information in IPBrick;
  • D: To delete a machine in IPBrick;
  • N: No change is done to the line.
• 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;

Other fields:

• mac: Machine NIC MAC address. The format is xx:xx:xx:xx:xx:xx;
• password: Password to use if a SIP phone is selected. e.g.: 123;
• 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;
• callerid;
• voip_nat;
• voip_disallow;
• voip_allow;
• voip_dtmfmode;
• voip_subscribecontext;
• voip_pickupgroup;
• voip_callgroup;
• voip_canreinvite;
• voip_insecure;
• voip_athuser;
• voip_fromuser;
• voip_fromdomain;
• voip_mailbox;
• voip_quality;
• voip_call_limit;
• phonedescription;
• idphonetemplate;
• printerdescription;
• printerlocation;
• printerport.

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

    action;computernumber;machinetype;name;groupnumber;ip;mac;password
    I;;1;wrk03;;172.29.1.52;00:E0:98:9B:45:06;
    I;;1;wrk04;;172.29.1.54;00:E0:98:9B:45:04;
    I;;3;softphone04;;172.29.1.57;00:E0:98:9B:45:54;1234

! Attention !:

• The computer's name has to be alphanumerical. The exception is the character 'hyphen' -;
• The computer's name shouldn't contain spaces nor diacritical marks on characters neither punctuation. Its maximum length should be 15 characters;
• It is not allowed to register neither machines with the same name nor machines 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.8: Machine Management - Export

Figure 3.9: Machine Management - Mass Operations