LinQ2 P-Series Excel File Integration Channel and Test Cases

LinQ2 P-Series Excel File Integration Channel and Test Cases

1. Introduction

This interface allows sending requests to LinQ2 through Excel file either “.xls” or “.xslx” formats. Linq2 application will read this file from already defined source directory .In case of successful processing this file will be move to destination directory. Otherwise it will move in to error directory. User can find error and description from log monitoring section.Select the organization by clicking on the required organization list displayed in the left. The selected organization will be highlighted in red color. To edit the organization details click on the Organization ID.

 

2. Configuration

Authorized user can configure Excel File request parameter setting from configuration >LinQ2 resources > File - Show List > LinQ2 page. Form this page authorized user can define source, destination, error and pending folder path.  

Ref: - Screen 1 – LinQ2 File backend management_1.

Ref: - Screen 2 – LinQ2 File backend management_2.

Ref: - Screen 3 – LinQ2 Define files backend parameters

 

 Screen 1 – LinQ2 File backend management_1

 

 

 

 Screen 2 – LinQ2 File backend management_2

 

 

Screen 3 – LinQ2 Define file backend parameters

 

 

3. Monitoring and Control

Excel File handler service is available in services list. Authorized user can login in to LinQ2 system and can monitor the current status of Excel File handler service and recent errors and warning from status monitor section. User can also start and stop the Excel file handler service from this section.

Ref: - Screen 4 – LinQ2 Excel File handler Service Status Monitoring and Control

 

 Screen 4 – LinQ2 Excel File handler Service Status Monitoring and Control

 

 

4. Constraints

  1. The file name should contain an underscore “_”.
  2. The first column format should be number without and decimal places.
  3. The very first cell of the Excel sheet must contain the message to be sent.
  4. The message may contain any number of parameters in the format ${param_name}. These parameter values must be listed starting from the second column after the mobile that is in the first column.
  5. Each parameter in the message should match the value in the corresponding column in the same order.

 

5. Excel File Test Cases:

For excel file upload and sample excel sheet, refer the following screens.

Ref: - Screen 5 – LinQ2 Excel File handler when source directory is selected as “Excel File”

Ref: - Screen 6 – LinQ2 Excel File handler sample excel file with parameters

 

 

Screen 5 – LinQ2 Excel File handler when source directory is selected as “Excel File”

 

 

 

Screen 6 – LinQ2 Excel File handler sample excel file with parameters

 

 

5.2.1 Excel File with parameters

Interface

Excel File Service

Pre-conditions

 

  • Validate file name (ending with .xls or xlsx and having an underscore “_” in the file name. 
  • Putting files in Source folder.
  • Validate file format 
    • The messages should in the first sheet of the excel file.
    • The message in the first line (first row and first column) 
    • Each mobile number in the first column starting from the second row
    • The message contains the parameter place holders in the format ${param_name} and the values are provided in the each row starting from the second column in order.

 

Request

Example:

    File name:         Test_.xlsx

   File content:

                                Dear ${name} your account will expired after 6 days

                                   566123431                   Muhammad

                                   566123432                Rayan

                                   566123433                Iqbal

                        

 

 

Expected Result

 

  • File will be moved to destination folder.
  • Three message in file should be picked by linQ2 system
  • If there are any errors then:
  • The file should be moved to error folder
  • No message picked.

       

 

 

 

 

Actual Result

 

 

 

 

  

5.2.2 Excel File without any parameters 

Interface

Excel File Service

Pre-conditions

 

  • Validate file name (ending with .xls or xlsx and having an underscore “_” in the file name. 
  • Putting files in Source folder.
  • Validate file format 
    • The message in the first line (first row and first column). 
    • The messages should in the first sheet of the excel file. 

Each mobile number in the first column starting from the second row

Request

Example:

    File name:         Test_.xlsx

   File content:

                                Dear customer your account will expired after 6 days

                                566123431 

                                566123432 

                                566123433 

                                                        

 

Expected Result

 

  • File will be moved to destination folder.
  • Three message in file should be picked by linQ2 system
  • If there are any errors then:
  • The file should be moved to error folder
  • No message picked.

       

 

 

 

 

Actual Result

 

 

 

 

 

 

 

 

5.2.3 Excel File Test One Message 

  

Interface

Excel File Service

Pre-conditions

 

  • Validate file name (ending with .xls or xlsx and having an underscore “_” in the file name. 
  • Putting files in Source folder.
  • Validate file format 
    • The message in the first line (first row and first column) 
    • The messages should in the first sheet of the excel file.
    • Each mobile number in the first column starting from the second row
    • If the message contains parameter place holders in the format ${param_name} then the values are provided in the each row starting from the second column in order.

 

Request

Example:

    File name:         Test_.xlsx

   File content:

                                Dear ${name} your account will expired after 6 days

                                   566123431                   Muhammad

                                   566123432                Rayan

                                   566123433                Iqbal

 

Expected Result

 

  • File will be moved to destination folder.
  • Only the first message in file should be picked by linQ2 system and sent to the mobile number of the user that uploaded the file for testing. 
  • If there are any errors then:
  • The file should be moved to error folder
  • No message picked.

          

 

 

 

 

Actual Result

 

 

 

 


© 2024 Cerebra All Copyrights Reserved

    • Related Articles

    • LinQ2 P-Series Xml File Integration Channel

      XML File Integration 1.1 Introduction This interface allows sending requests to LinQ2 through xml file saved in UTF 8 format. Linq2 application will read this file from already defined source directory. In case of successful processing this file will ...

    • LinQ2 P-Series Voice Integration Channel v1.0

      Voice Integration Introduction Now Linq2 P Series supports automated voice calling feature through standard SIP providers e.g. FreePBX. Linq2 P Series is integrated with SIP Providers by using the following approach/steps. Configure SIP account ...

    • LinQ2 P-Series Push Notifications Integration Channel v1.1

      Push Notification Integration 1.1 Introduction Linq2 is integrated with Push Providers (PushWoosh/OneSignal/Google FCM) by using following approach. Push notification can be requested in the XML or Rest request by MQ or WebService integration ...

    • LinQ2 P-Series Database Integration Channel

      Data base Integration 1.1 Introduction LinQ2 application has a database monitor component to pull messages from database other then linQ2 database. LinQ2 database monitor can pull message information from the database table and send it to appropriate ...

    • LinQ2 P-Series XML Structure Description v 2.0

      This document explains LinQ2's XML structure, which uses ar XML File Channel Element Type Max. Len Rep Allowed Values Mandatory Description Evnt_Id Text 10 1 N/A Y Unique Event Identifier. Evnt_Source Text 10 1 ‘OMS’, ‘CRM’ Y Event source. Put here a ...