ServiceNow Case Studies

  1. 1. Importing CSV file which is not in standard tabular format

    What was the problem?

    ServiceNow need standard tabular formatted CSV files to import the data in Service Now tables. We have CSV files that are not in standard format. Like, first some rows contains the sentences and then table data started. While importing such type of file in service now, it searches for first header row and it fails to insert the table data.

    What is the solution?

    We have skipped the standard transformation Map via Scheduled Data Import. We have used Scheduled Script to read the actual file and imported the data via script in the Service Now tables.

    What are the benefit?

    The data file in CSV format and having tabular data wherever in the file. Script reads it and imports the data correctly. Also, we have supported comma as well as tab delimitation. So the expected results reflects in the reports.

    If anyone facing the same issue, please reach us. We are open to support. Reach us at www.fideltech.com

  2. 2. Importing multiple data file (XLS/CSV) in Service Now Tables

    What was the problem?

    • In ServiceNow, when multiple files attached to the Data Source and Scheduled Data Import executed the first attached file data is imported in the targeted table.
    • Other files are not considered while doing the data transform.
    • We have more than files coming from email and need to import in the tables.

    What is the solution?

    • In this case what we have done is, we have used the Parent Data Source and the number of child Data Sources that can actually hold the single attachment.
    • Here, we have written as Scheduled Script that actually gets the attachments from Parent Data Source and attaches corresponding attachments to the Child Data Sources.
    • Then, each Data Source have their Scheduled Import Set to import the data in the Service Now targeted tables.

    What are the benefits?

    Client has more than a file in email attachment and corresponding data is imported in the tables, so as to correct reports values are populated from the tables.

    If anyone facing the same issue, please reach us. We are open to support.

  3. 3. All Reports need to be printed into a PDF document.

    What was the problem?

    This is a data archival process for every month. The users need

    • A Graphical User Interface (GUI) to select report or reports that they want to print into a PDF document, give PDF document a name, and selected report or reports should be printed into a PDF document file with given name and store at particular location on server or available to download to those users.
    • Report scheduling in which admin user creates a schedule for different users by selecting certain number of section and reports. After the schedule ran, it should send an email to the respective users.

    What is the solution?

    To print ServiceNow reports in the PDF, there are few ways inbuilt in ServiceNow such as

    • Exporting a table record, list of records, and report into PDF.
    • The ServiceNow also has a web kit version of Home Page or Dashboard printing into PDF functionality available.
    • For developers, there is implementation of iText classes in ServiceNow, which can be used for custom PDF export process other that what is already given by ServiceNow developers.
    Many other developers, who have, similar, requirements for printing such reports, passed on all of the options ServiceNow provides inbuilt. The reason behind that is those options is not sufficient and appropriate in few cases. The ServiceNow would print any report into a PDF that we required, but if there is array of reports to print in order, that is not possible to print with ServiceNow into a PDF. Other than this example, ServiceNow does not print custom reports created using UI Page Widgets, external libraries, etc. The Dashboard Export web kit plugin can help us to export reports on any homepage or dashboard, but it is not working when that dashboard has interactive filters. It gives an error that says, “Failed to export, please try again.” Along with this, UI pages and custom reports are not on homepages or dashboards so printing those reports would need different solution. In iText implemented by ServiceNow, few people get some success while creating PDFs, but matching color, aligning contents, placing images and media gets problematic and may be because of it, Possibly, few people skipped using the iText and went looking for third party solutions.

    What are the benefits?

    Now client just schedule report publishing section wise and its subscriber user wise. It generates PDF automatically with latest data and delivers to respective stakeholders on their time. Client don't need to do manual work.

    If anyone facing the same issue, please reach us. We are open to support.

  4. 4. Exporting Zip file.

    What was the problem?

    Some reports data is inputted to ServiceNow in ZIP files which contains files other than Excel and CSV to generate report.
    The files in ZIP are image files and client wants that files to be extracted from the ZIP and display to user in the UI of ServiceNow.

    What is the solution?

    ServiceNow does not have inbuilt solution for extracting files other than Excel and CSV.
    It provides some script to extract files from the ZIP, but it also does not work for files other than Excel and CSV. So we have implemented and java program on MID server and extracted data from the MID server. Whenever email with ZIP attachment received in ServiceNow mailbox, it processed and sent to MID server to extract the files. MID server program extracts the ZIP file and send back to ServiceNow. We use this images in UI page to display reports.

    What are the benefits?

    Client can see his reports in the ServiceNow when it was not possible to send data from 3rd party software in Excel or CSV zip but in image files.

    If anyone facing the same issue, please reach us. We are open to support.