Software And Drupal Integration For Automated Workflow

INTRODUCTION

SCALA is a multinational organization providing secure network deployment. It offers wide ranging software, hardware, services and support for companies that are looking to transform their physical space – retail stores, financial institutions, restaurants, and transportation hubs with a wide array of technology including artificial intelligence, virtual reality, digital signs, mobile sensors and computer vision technology.

Before reaching out to Mpire Solutions, the team at SCALA used to manually add new content to their website. They were looking for an automated process through which they can add content to their website without any manual effort. After a complete analysis of their requirements, our team of developers decided to address them through a customized solution.

CHALLENGE

The biggest challenge we faced during development of the customized solution was the directory structure of the zip file generated by the software. The directory structure had the .htm file in a specific folder and these files contained the HTML of the content. Also, some folders contained CSS, JS files, and images. The folder locations of CSS, JS, and images changed each time the client exported the content from software. This process caused to show the broken display of the webpage to the visitors.

Our development team suggested a custom module and a programmatically created page on which only the administrator can import the zip file exported from the software that client used for documentation purposes.

REQUIREMENTS

  • Features Enhancement – To significantly create, add, implement, and integrate new features to the client’s website.
  • Automated Workflow – To reduce the client’s manual efforts in day to day operations.
  • Software Data Integration – To effectively integrate the software exported data with Drupal CMS.

SOLUTION

Once our certified Drupal team analyzed the client’s requirements, they started working on making the custom module on the local setup. In that specific custom module, we created a programmatic page that contained the file upload functionality to ease the entire process of uploading. The website administrator can now upload the zip file and then the back-end code can automatically find all the .htm, .CSS, .JS, and image files to store all these assets in the respective Drupal storage.

The HTML content from the .htm file was included in the content section for a specific content type and then adjusted for all images paths as per Drupal’s standards. After importing all the content to Drupal, the code removes the zip file from the Drupal storage folder so that the System storage can have free space available all the time.

In the complete workflow, the website’s load optimization was yet another main target. Our team of Drupal developers noticed each and every detail of the website so that the custom module’s functionality cannot affect the website’s performance.

RESULTS

  • The manual effort made by the client on a daily basis was diminished with the development of a custom Drupal module.
  • New features were added throughout the website to ease the client’s day-to-day operations.
  • Proper software data with Drupal integration not only saves time but also provides the right and desired results.
  • Enhanced and customized Drupal standards.

BENEFITS

  • The configuration of the custom module proved to be flexible and functional for the SCALA team.
  • A thorough software integration now allows the software to automatically export data in Drupal.
  • The client now enjoys the automated workflow without making any manual efforts.
Read More

Bibliography Function Integration into Drupal 8

Introduction

Our client’s main focus is improving the safety and quality standards of America’s healthcare system by investing in research and collecting useful knowledge, data, and tools for healthcare professionals and policymakers. They made the decision to upgrade their Content Management System (CMS) from Drupal 7 to Drupal 8 to capitalize on the superior capabilities and features of the latter.

They hired our services to develop the Bibliography functionality for the ‘Literature Collection’ section – the most essential component of their website. Unlike Drupal 7, the Bibliography contributed module for Drupal 8 is not yet available. Therefore, we chose to use the Bibcite module to develop the Bibliography function.

Challenge

Our task was to develop the ‘Literature Collection’ page on their website while we had access to their latest design along with 5300 references in the RIS format.

However, we found several bugs in the Bibcite module for Drupal 8 which we needed to fix by creating a patch as per the requirements of the client. The main challenge was that the Bibcite module neither supported the mapping of the custom fields nor the term reference fields via RIS import.

Another challenge was implementing their custom design which required two different layouts for the main search page and the search results page, using the same Drupal Views core module.

Solution

First, we launched a patch for the Bibcite module to support custom fields mapping. In this patch, we modified the ‘modules/bibcite_entity/src/Form/MappingForm.php file to get all the fields using the ‘getReferenceFieldOptions()’ function and then, configured the filter to return only the custom or desired fields.

Next, we tackled the problem of term reference field mapping. Our solution was simple: We would get the value of the specific tag from the RIS import file and match those values with the specific vocabulary available to determine if the term exists in the system or not. If it exists, then the system will return the term IDs and those term IDs will be placed as a value of term reference field.

Finally, we developed a full width design for the main search page, while the search results page was divided into 2 columns. We did this by using two different conditions in the template, based on the query string in the URL of the search results page.

Solution

Our solution has resulted in three main benefits for the client:

  • We were able to successfully develop, modify and integrate the Bibliography function or, more specifically, the ‘Literature Collection’ page into the client’s Drupal 8 website.
  • We were also able to ‘smooth out’ background processes to optimize the loading speed of the ‘Literature Collection’ page.
  • We were able to complete the project within the designated time-frame and ensure 100% client satisfaction.
Benefits
  • The development of the ‘Literature Collection’ page ensures that the visitors have full and easy access to useful and relevant information.
  • The new design of the search results page ensures that visitors can view results in a more readable manner and access relevant links.
  • The loading speed optimization of the Bibliography page ensures a seamless user experience for people who visit the website.
  • Our client was able to save their precious time and resources by outsourcing the task to our experienced developers. 
Read More

Azure Integration Services configured for EDI in Cloud

Our client is a renowned manufacturer and supplier of a wide range of healthcare products. They are registered sellers on ecommerce big boxes like Amazon and ebay where the order inflow was constantly growing every passing day, leading to an increase in the B2B trade with partners.

mpire solutions
A group of people collaborating while seated at the desk
Laptop showing customer service, retention, and profitability locations on a world map

Challenge

Being a large-scale manufacturer, the client was receiving surplus orders and meeting customer demands in a cost efficient manner was becoming a challenge for them on a daily basis. Their existing business process was not well-adjusted to handle such huge number of orders.

While the demand for their products kept growing, it also led to a sharp increase in the transactions causing the existing EDI solution cost exceed the planned budget.

This and other issues pertaining to accuracy of business transactions with their trading partners/stakeholders were eventually creating wide-range of problems on the business and client / customer side.

Requirements

  • Stability – the system needs to be steady enough to handle numerous orders.
  • Cost Efficiency – the system must be able to handle huge number of transactions with minimal cost on 3rd party EDI services.
  • Monitoring – the admin personal should have all the controls necessary to set the desired security and error handling mechanism.

Solution

To address these challenges, Azure Logic Apps has been implemented as an upgraded replacement of client’s existing EDI partner and as a cost-efficient option. The client gained more control on their frequent B2B transactions, eliminating the dependency on the existing EDI partner.

Azure offers one of the best integration solutions to its customers in the form of Azure Integration Services iPaaS solution. It is a set of cloud services for mission-critical enterprise integration. These cloud services, sometimes combined with other cloud technologies, can be used to integrate both cloud and on-premises applications.

Results

Implementing Azure Logic Apps has resulted in three main benefits:

  • The system has become robust since it is now stable enough to handle enormous amount of B2B transactions.
  • It provides the client an effective admin related control on their transactions while also ensuring accuracy.
  • The previously burgeoning cost has decreased significantly.

Benefits

  • A range of APIs exposed as Connectors reduce the integration challenges
  • Connect and Integrate data from the cloud to on-premises
  • B2B and enterprise messaging in the cloud
  • Azure Integration Services (Logic Apps and Integration Account) configured for your organization’s EDI in Cloud
  • EDI Transaction Order Sets for Purchase Order, Advanced Shipping Notice, Inventory Inquiry, and Invoice implemented.

About Azure Logic Apps

Azure Logic Apps is a cloud service which helps integrate different services by providing ready-to-use connectors, ranging from SQL Server or SAP to Azure Cognitive Services. While the underlying platform handles scale, availability, and performance, Logic Apps is especially useful for use cases and scenarios where coordinated action is needed across multiple systems and services.

Save time & money by taking EDI to the Cloud with Azure

EDI is a proven and trustworthy business message format not only for migrating existing EDI workloads to the cloud but also for enabling new B2B partnerships. Fully supported by Azure Integration Services, EDI in the cloud requires no on-premise footprint, servers or dedicated administrative staff.

Read More