Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

IMMS InfraLink offers an immense amount of information to Users.  Earlier in this guide we discussed ways that Users can select and shape that information to be more useful through Using Saved Views and Configuring Grid Views. Through each, the User defines which specific records are displayed in the IMMS InfraLink viewing pane. While it is useful to access these records in the application, sometimes there is reason to export those selected data records from IMMS InfraLink into an external format.  For example, a client may request monthly Case handling reports or a service manager may export weekly Timecard Summary reports for his/her team.  For purposes like these, IMMS InfraLink offers the Export All feature.

...

Identifying Data Records for Export

The IMMS InfraLink data export functionality closely integrates with standard views that present data in tabular format (e.g., All Cases, Issue Monitor, All Work Tickets, etc.) and provides an intuitive ability to export the data presented in the view. Therefore, one of the easiest ways to identify the records to be exported is to start by opening the standard view appropriate for the desired data records and use the view capabilities to select the records and the record fields to be export. Specifically, you may employ one or a combination of the following to identify and configure the records:

...

  • Loading a Saved View. Users often save a custom view configuration to meet their unique operational requirements.  Sometimes, these Saved Views will align with the data export requirements.  In that case, the export can be scheduled from that Saved View. For more information on Saved Views, see Using Saved Views.
  • Manually selecting and rearranging columns and sorting the records. Most IMMS InfraLink views provide the ability to add/remove the data columns to be displayed and to choose the order of the columns, as discussed in Configuring Grid Views
  • Applying filters to refine the records by eliminating those that do not match your filtered criteria.  For more information on filters, see Using Filters.

...

  1. Click the Export All button at the top of the view grid 
  2. Select one of the desired export file formats, CSV or MS Excel, from the drop-down menu.
  3. Upon selecting the export file type, you will next indicate when you wish to perform your data export. Select Now. 

  4. Click the Create button to perform the export immediately. 

  5. The export file will be downloaded to your default download folder. 

...


Note

When using the default

...

(i.e., "As Shown") layout the records and columns included in the export, as well as the order of the records, will match the records, columns, and

...

order displayed in the grid view. No custom formatting will be applied in the exported file. 


Gliffy Diagram
macroId230c7ce4-5a2d-482b-816c-bd0ff6eece8f
nameExport All Dropdown
pagePin1

Note

You may notice a third file type, the Import Friendly (CSV), listed in the Export All drop-down menu. This file type is intended to support bulk-data import templates when exporting records for update. This scenario is discussed below in the Exporting for Update section.

Data Export Using a Custom 

...

Template

In some IMMS InfraLink Instances, formatted data export templates are configured by the Instance Administrator, based on the needs of that organization. Export templates are located in the Export All drop-down menu. For example, as shown below, this Instance has configured two templates for Users, the "Audit Input Export Template" and the "Master Issue Tracker".  

Gliffy Diagram
macroIdb9d410fc-7ed1-4f61-bbcd-f447e308fc4b
nameCustom Export Template Selection
pagePin1
Image Removed  


To generate an export using a custom template, complete the following steps:

  1. Identify the data to be exported, as discussed earlier in this article.
  2. Click on the Export All button 
  3. Select the desired template from the Templates section of the drop-down menu. 

    Note

    Please note that the templates available for selection depend on your specific IMMS InfraLink instance configuration. Please contact your Instance Administrator or refer to the related User Guide article for information on how to configure custom export templates.


  4. Select Export All.
  5. Select Now.
  6. Click the Create button. 
  7. The export file will be loaded to your default download folder. 

...

To set a schedule for your data export, select the Schedule option. With this selection, IMMS InfraLink prompts you to provide more information about your desired export schedule. 

...

To review scheduled data exports in IMMSInfraLink:

  1. Click the Export All button at the top of the grid view. 
  2. Select Manage Scheduled Exports to open the Scheduled Exports window, which lists all Scheduled Exports created for that view.
  3. From the Scheduled Exports window, you can:
    • Filter and search Scheduled Exports
    • View details for a Scheduled Export
    • Rename a Scheduled Export
    • Modify the schedule for a Scheduled Export
    • Edit recipients of a Scheduled Export
    • Delete a Scheduled Export

Gliffy Diagram
macroId0abd08f8-6ee3-4451-a0ef-c05a42fbb4c1
displayNameScheduled Exports Window
nameScheduled Exports Window
pagePin24

Tip

A User can edit the recipients for a Scheduled Export by using the buttons above the Scheduled Exports list or via the Scheduled Export Details panel.

To add a new recipient from the Scheduled Export Details panel:

  1. Scroll to the Recipients section of the details panel.
  2. Click Add to open a window with a list of available Users. 
  3. Select the plus ("+") button to the left of the User's name to add that User to the Current Selection list. 
  4. Click Select to finish the additions. 

To delete a recipient via the Scheduled Export Details panel,

  1. Scroll to the Recipients section of the details panel.
  2. Check the box to the left of the User's name.
  3. Click the Delete button that appears above the User's name.

...

The Export All feature is also the starting point for most bulk record updates in IMMSInfraLink.

When preparing a bulk data import for the purpose of updating records in IMMSInfraLink, the User must identify the UUID, the unique record identifier in IMMSInfraLink, for each record being updated. IMMS InfraLink assigns a UUID to each new data record at the time it is created. The UUID, however, is not typically displayed in standard IMMS InfraLink views or details panels. The UUIDs can be easily obtained by exporting data for the desired records. Additionally, the data export file will provide column headers for other record attributes, which can be used in the subsequent Import data file.

...

Gliffy Diagram
macroIdbcc4484c-9fec-4d56-8005-e6ae11fbd20d
displayNameImport Friendly CSV
nameImport Friendly CSV
pagePin38