Services

Services are service plans when they are bound to a customer. An example would be that Jon Doe has a 400mbps service. This service is a service plan that is bound to Jon Doe. This is the same as a subscription in other systems.

Service CSV Format

Below is the format of the CSV file that you will need to import services into Nucleo. Feel free to download the template.

Download CSV Template

Columns

  • Name
    ID
    Type
    int | string
    Description

    ID of the service in your current system. In subsequent imports, Nucleo will bind imported data to this ID for any resource that references this service.

  • Name
    Customer ID
    Type
    int | string
    Description

    ID of the customer in your current system.

  • Name
    Service Plan ID
    Type
    int | string
    Description

    ID of the service plan in your current system.

  • Name
    Site ID
    Type
    int | string
    Description

    ID of the site the service plan is on in the current system.

  • Name
    Status
    Type
    string
    Description

    Status of the service. The possible values are active, in-active, or schedule-for-install

  • Name
    Failure Reason
    Type
    string
    Description

    The reason the service failed to activate. The possible values are line-of-sight, customer-wiring, service-not-possible.

  • Name
    SLA Status
    Type
    string
    Description

    The service level agreement of the contract. Possible values are sla and non-sla.

  • Name
    Price
    Type
    decimal
    Description

    The price of the service billed at the interval the customer is subscribed to.

  • Name
    Billing Interval
    Type
    number
    Description

    The interval which the customer is billed for their service. The possible values are monthly, three-months, six-months, one-year, or two-years.

  • Name
    Billing Interval Day
    Type
    number
    Description

    The day of the month the customer is billed for their service. The possible values are 1 through 31.

  • Name
    Tax Exempt
    Type
    boolean
    Description

    Flag on whether the service is tax exempt or not. 0 for taxable, 1 for tax exempt.

  • Name
    Traffic Shaping Type
    Type
    string
    Description

    The way the traffic for the service is shaped. The possible values are dynamic or static. Leave empty if not shaping.

  • Name
    Shaping Rules
    Type
    string
    Description

    Any shaping rules for the service. This could be IP addresses or subnets. Leave empty if not shaping.

  • Name
    Suspended Date
    Type
    date
    Description

    The date the service wass suspended. Leave empty if not suspended.

  • Name
    Last Period Billed Start Date
    Type
    date
    Description

    The start date the last day the service was billed from your previous system. This will kick off the billing process in the new system.

  • Name
    Last Period Billed End Date
    Type
    date
    Description

    The end date the last day the service was billed from your previous system.

  • Name
    Last Period Type
    Type
    string
    Description

    The last period which the service was billed for your previous system.