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

Attention: 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.
    Attention:

    Service Mapping imports only business services with unique names.

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

    B (Optional) The URL, for example, https://www.nypl.org/ or www.google.com:8080.

    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 you define the IP address, FQDN, and port, Service Mapping does not use the URL.

    C (Optional) The IP address of the entry point in the IPv4 format.

    If the URL contains credentials, Service Mapping uses only the part of the URL without credentials. For example, if the URL is http://user:password@example.com, the actual URL that Service Mapping uses is http://example.com.

    If the URL contains additional parameters with special symbols, like comma, remove them.
    D (Optional) The port of the entry point. For example, 8080 for the Google page.

    If left blank, 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, http://www.google.com for Google.
  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