Bulk Import Deployment Plan Activities

LATE APRIL: Manage Deployment Plans through the API.

The Bulk Import Deployment Plan Activities feature allows users to upload Deployment Plan Activities from Excel (.xlsx) files.

Access Bulk Import user permission is required.

1. Source tab

1a. Download the Excel import template file

Download the import template so you can start adding the data to be imported.

To download the import template:

  1. Go to Deployment > Manager.
  2. Click to open a Deployment Plan in Draft or Approved mode.
  3. Click the Activities tab.
  4. Click Bulk Import.

    NOT Bulk Update.The Bulk Import button is at the bottom of the pop up beside Export to XLSX.
  5. Click the template file link to download the Excel template file.

     The template will contain a column for every field, including Deployment Plan Activity Custom Fields.

 

1b. Prepare the Excel template file

Add your Deployment Plan Activity data to the Excel template file.

To prepare your Excel files:

  • Use the correct formats:
    • Supported date formats are:
      • DD/MM/YYYY (22/03/2019)
      • DD/M/YYYY (22/3/2019)
      • D/M/YYYY (9/03/2019)
      • MM/DD/YYYY (03/22/2019)
      • M/DD/YYYY (3/22/2019)
      • M/D/YYYY (03/9/2019)
      • YYYY/MM/DD (2019/03/09)
    • Supported date and time formats are:
      • DD/MM/YYYY HH:MM AM or PM (22/03/2019 09:00 PM)
      • DD/MM/YYYY HH:MM (22/03/2019 21:00)
      • MM/DD/YYYY HH:MM AM or PM (03/22/2019 09:00 PM)
      • MM/DD/YYYY HH:MM (03/22/2019 21:00)
        If seconds are present, they will be truncated.
    • Supported time formats are:
      • HH:MM AM or PM (09:00 PM)
      • HH:MM (21:00)
        If seconds are present, they will be truncated.
  • Fill in mandatory core fields.
  • Fill in mandatory custom fields.

Deployment Plan Activity records with bad formatting, missing data, or other errors will be handled by:

  • Mandatory core and custom fields:  Being skipped at import and an error being logged.
  • Non-mandatory custom fields: Being imported without that data and a warning being logged.

 

1c. Upload the Excel file

To upload your Excel files to Plutora:

  1. Go to Deployment > Manager.
  2. Click to open the Deployment Plan, which must be in Draft or Approved mode.
    Activities cannot be imported into Deployment Plans which are in Execution or Completed modes.
  3. Click the Activities tab.
  4. Click Bulk Import.

    NOT Bulk Update.The Bulk Import button is at the bottom of the pop up beside Export to XLSX.
  5. Select the file to upload by:
    • Dragging and dropping the file into Drop your file here.

      Or:
    • Click Browse Local Computer, select the file, and click Open.
      The maximum Excel file size that can be uploaded is 25 MB.
  6. Click Next.

 

2. Mapping tab

Once your Excel file has uploaded, you must map each column of your data to a field in Plutora.

2a. Which mapping method should I use?

Auto Mapping

Auto Mapping saves time by automatically matching column headings with Plutora’s field names.

The Excel template file should map perfectly if the column headings are unedited and no Deployment Plan Activity Custom Fields have been added since the template was downloaded.

Manual Mapping

Manually map your data when:

  • You only want to import mandatory fields, not custom fields.
  • Your Excel file column heading cells do not match Plutora’s fields.

 

2b. Map data

To map your data:

  1. To select:
    1. Auto Mapping:
      1. Click Auto Mapping.

        • All columns should highlight to show that they have been mapped.
        • A warning pop up will show if any required or non-required field has not been mapped:
          • The import will not proceed if any required fields have not been mapped.
          • Close the pop up, then click Back, and upload an edited Excel file.
        • Remove Auto Mapping by clicking Clear Mappings.
      2. Click Next.
    2. Manual Mapping:
      1. Click a cell.
        A map value pop up opens with the column value. For example, Column G.
      2. Click the map value pop up.
        The Copy Values pop up opens.
      3. Click the Select a field drop-down menu and select a field name where the column data should be copied.

        • Field names are in alphabetical order, mandatory fields first.
        • Fields with a red asterisk are mandatory and must be mapped for the upload to proceed.
        • Once a field is selected, the pop up closes.
      4. Continue matching columns to fields until all mandatory fields and as many other values as necessary are mapped.
      5. To remove manual mappings, click Clear Mappings.
      6. When you have finished manual mapping, click Next.

 

 

3. Validation & Confirmation tab

After clicking Next, the Validation & Confirmation tab will open and the data will be validated.

Then the Confirmation message will open.

Click View Details under the Validation & Confirmation panel to see more information about the import:

  • Errors (such as incorrect formatting) in mandatory fields will result in the record being skipped.
  • Errors in non-mandatory fields will result in the record being imported with warnings.

Under the Confirmation panel, the numbers may not add up to the total number of records, as the same record can be skipped and have warnings at the same time.

Click Next to import the Excel file.

 

4. Processing tab

The file import processes, showing the percentage completed.

 

5. Summary tab

The Summary tab opens with an overview of the data imported and the error messages.

Click View detailed log to see the full list of records successfully created without warnings, the records created with a warning (for example, a missing value for a non-mandatory field), and records skipped and not created due to errors.

You have now bulk imported the data in your Excel file. Click Close.

 

Back to the top arrow

Be the first to find out about new features. Subscribe to the Release Notes email. Subscribe Now

Was this article helpful?

0 found this helpful.