Export the organizational structure in HR to Visio

In HR, the personnel organizational structure is usually presented in the form of Treeview, which gives people the feeling that they are not intuitive, have no image, and have less capacity. Besides name and cascade relationships, there is no other information. If you can export it to the Visio model, that would be great. Take office2013 as an example.

2. Use the Visio Wizard to export the organizational structure:
   

    

    

    

   Create an excelfile, department.xls, which contains the organizational structure information and is saved to c: \ department.xls.

    

    

   Name: name of the current organization displayed on the model Diagram

   Affiliated to: cascade links are generated based on this attribute and must be unique in the system.

   Name: select the auxiliary information of the organization name, such as the Organization Code.

    

   Select the attribute to be displayed in the model. You can select meaningful fields here.

    

   Select the shape field in the model. (I don't know what it is)

    

   Here you can select an image of the organizational structure diagram. No image is shown in this example.

    

   For a large organizational structure, you can select paging. This is not required here.

    

   You can modify the existing page.

    

   The generated organizational structure is displayed by page.

3. Generate

   In Visio, in addition to Wizard export, a command line tool orgwiz is also provided to export the Visio diagram through the command line.

   Orgwiz.exe is usually located in the installation directory and can be searched in the installation directory. My installation directory is found in D: \ Program Files \ Microsoft Office \ office15, this command has many complex parameters.Http://office.microsoft.com/zh-cn/assistance/HA010774642052.aspx.
   

   FirstCMDToOrgwiz.exeIn the Directory
   

   Copy the following command and press Enter:

   Orgwiz.exe/filename = c: \ department.xls/name-field = strdepartmentcode/manager-field = lngdepartmentparentid/UNIQUEID-FIELD = lng1_mentid/pages = B 10 pagename ="Business Group, BA 10 pagename = "BBusiness Group, D 10 pagename = "CDepartment stores"/Display-fields = strdepartmentname, strdepartmentcode, strsuperintendname
   

   DemoDownload