Prepare a CSV file for mapping your candidates

Organize information about potential business services (candidates) in your organization and save it in a CSV file.

Before you begin

Role required: sm_admin

About this task

Warning: If you import planned services using the Service Map Planner module, use the CSV file format described in Import planned business services from the CSV file.

Procedure

  1. Create an .xlsx file.
  2. Define entry point attributes for service candidates in the .xlsx file. Customers use these entry points to access services. For example, they use http://www.google.com:8080 to access the Google page.
    Warning: Do not confuse column order in the .xlsx file. Entering attributes in wrong columns causes mapping errors.
    Column Description
    A Enter a unique name of the planned business service. For example, NY Public Library or Google.
    Warning: Service Mapping imports only business services with unique names.

    If there is more than one entry with the same name in CSV files you use, the latest imported record overwrites the previous ones.

    B (Optional) If you know the URL that serves as the entry point to your business service, enter it in this column. For example, enter https://www.nypl.org/ or www.google.com:8080.
    Warning: If you define the URL, you do not have to define the IP address, port, FQDN, and protocol. Service Mapping parses the URL to extract the IP address, port, and FQDN.

    If there is no URL that serves as the entry point, define other parameters in columns C, and E.

    C (Optional) The IP address of the entry point in the IPv4 format. Enter this parameter only if you did not enter the URL in column B.
    D (Optional) The port of the entry point. For example, 8080 for the Google page. Enter this parameter only if you did not enter URL in column B.

    If you did not enter either URL or the port, Service Mapping uses port 80 for the http protocol and port 443 for the https protocol.

    E (Optional) The FQDN of the service entry point, for example,www.google.com for Google. Enter this parameter only if you did not enter the URL in column B.
  3. Save the file in a drive that you can access during the import with the .csv extension.

What to do next

Map multiple business services from a CSV file