Drupal Integration With Amazon S3 File System

BACKGROUND

PepsiCo is a global food and beverage company with a product portfolio that includes 22 international brands generating over a $1 billion each in annual retail sales.

They were looking to store media images in Amazon S3 (Simple Storage Service). In order to achieve the above requirements, Mpire Solutions suggested to create an internal portal that provides a functionality to upload media files to the S3 file system while providing limited and restricted Amazon S3 accesses to their employees.

CHALLENGE

Since the client was looking for a digital asset management functionality, our team decided to conduct a deep audit to identify the main objectives and basic requirements before we proposed anything to the client. After a thorough examination of the scenario, we proposed Drupal CMS to the client as it was the best fit as per the requirements.           

The first challenge we faced was to make the connectivity between Drupal and the Amazon S3 file system. The second major challenge was the access control mechanism between Amazon S3 file system and users. After implementing the access control functionality, every user should have only accessed their own media in the portal.

The third challenge was to create the tag-based functionality associated with each media entity. Our ACQUIA certified Drupal team of developers decided to use the Drupal taxonomies to achieve the tag-based functionality.

REQUIREMENTS

  • Amazon S3 back-end file system integration – To make connectivity between Amazon s3 file system and Drupal.
  • Access control mechanism – To make easy access for the users who have already accessed the platform before.
  • Media assets uploading to Amazon S3 & Tag-based functionality  – To control and manage file uploading mechanism.

SOLUTION

First, our Drupal developers used the contributed modules to build the connectivity between Amazon S3 and Drupal and then we created the taxonomy terms specifically for tag-based functionality.

After achieving the above, we created two user roles in Drupal. One role has the functionality to create a tag, associate file assets with tags, and manage the functionality to make a brief association between files assets and tags. The second role has only access to upload file assets to the Amazon S3 file system.

We also created the custom module which contains the functionality to upload file assets to a specific folder in the Amazon S3 file system. This module also contains the permissions functionality for both of the user roles which restricts the users to its own permissions.

RESULTS

  • We managed to make a significant integration between the Amazon S3 file system and Drupal.
  • We successfully created two different user roles in Drupal with specific accesses assigned to each.
  • A custom module was created to upload the required files in the Amazon S3 file system.
  • Taxonomy terms were created for tag-based functionalities.

BENEFITS

  • The portal now provides the functionality to make some effective integrations between Drupal and Amazon S3 file systems.
  • The portal has a flexible, robust, and user-friendly interface.
  • The client is only providing access to the portal to their employees without providing them Amazon credentials.
Read More

QuickBooks Integration with Drupal and Workflow Automation

Background

 

The management of the IYNAUS wanted to update their official website as per current community standards. They had two operational portals – a management portal, and an assessment portal.

They were using the Management portal to accomplish all internal functions and to store critical data. On the other hand, all assessment activities for students and teachers were being handled using the Assessment portal. The management sought to upgrade the portals and website by adding new features and addressing additional issues.

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

The client required feature enhancements, bug fixing, and updating the website according to the community standards. However, there were also a couple of external portals connected with the website and it was quite a challenge to keep things unchanged among the workflow of both external portals while making changes to the website.

Another challenge was to convert their manual functions into automated mechanisms. We consistently made an effort of understanding their workflows to suggest the most apt solution.

Requirements

  • Security Update – To implement multiple security update patches.
  • Website Upgrade – To make the website up-to-date as per the community standards.
  • Workflow Automation– To automate the entire manual order workflow.
  • QuickBooks Integration – To integrate accounts-related data and send it to QuickBooks from Drupal.
  • Website Redesign – To add latest features throughout the website for better customer experience.

Solution

Since there were two external portals connected with the website, we had to be extremely vigilant while working on the procedures. A team of ACQUIA certified Drupal developers at Mpire Solutions conducted an in-depth audit to come up with the most suitable solution.

Before beginning with the actual task, we made sure to accurately understand the workflows of the application and consciously decided to first upgrade the Drupal Core without confusing the functionality of the website.

Furthermore, we managed to convert their manual functions into completely automated mechanisms. Previously, they used to manually enter the details of orders in QuickBooks (leading accounting software). However, with the implementation and extension of contributed and API modules, we managed to integrate QuickBooks with Drupal.

Results

  • The Drupal Core was upgraded successfully as per the requirements of the client.
  • The official website of the client was upgraded while exceeding the required standards with advance modification of functions.
  • QuickBooks was integrated with Drupal Core. Drupal now automatically sends order related information to QuickBooks thus eliminating the manual process.
  • All the bugs were fixed and website features were updated and enhanced.
  • The client was fully satisfied with the project delivery as we successfully managed to meet the targets within the given timeframe.

Benefits

  • The automation and integration of the workflow greatly helped save effort and time.
  • The additional and new features of the website majorly contributed towards attracting new customers.
  • Improved CMS of the website.
Read More

Performance Optimization and Functionality Enhancements With Drupal 7

Background

 

The client was a professional Sales enablement and Sales readiness provider that helped businesses and organizations with numerous expert sales enablement programs. The main issue was that while the client already had a Drupal-based official website, they heavily relied on third party agencies to run multiple projects.

The client decided to consolidate all their operations under an in-house team to make the maximum use of their skills and experience and to expand their service portfolio. In order to do so, they had to convey this information to the target audience and existing clients.

Their official website was the most effective platform and source of information to share this update about the expanded service offering. They approached Mpire Solutions to upgrade and modify their website to make it more user-friendly and dynamic using the most reliable technologies while also training their in-house team at the same time.

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

Since the client was looking to update their website in terms of enhanced functionality perspective, our team had to conduct a comprehensive audit of their existing website to dig out flaws and gaps before suggesting a solution. The main challenge was to deliver the desired solution within the limited timeline provided by the client.

We had to face certain limitations throughout the process of web design, as we were asked to keep some elements of the design unchanged. Furthermore, there was no previous history or information available about the website to help us understand existing issues. Therefore, we designated a professional team of certified developers to look into the details of the client’s website in order to understand and find its flaws.

Requirements

  • Website Updates – Update the website in order to make it more user-centric for critical digital marketing objectives.
  • Website Enhancement – Enhance overall features of the website to let the targeted audience know about updates in service portfolio.
  • Website Redesign – To redesign specific pages of the website for a better user interface.
  • Website Coding Modifications – To fix bugs and other issues on resource center pages.
  • Website Security – To secure clients’ information and other critical data of the website and implement Drupal security patches.
  • A/B Testing – To analyze random behavior of the visitors / users.

Solution

Once our expert Drupal team found the inefficiencies within the website and understood the requirements of the client, we made significant changes in the design and functions of the same.

There were two main changes required – one was redesigning the blog page and the other was homepage revamp. These were quite challenging while keeping all other factors in consideration. The homepage revamp required complete redesign and functionality changes to improve the overall user experience.

The website’s load time optimization was yet another flaw. We decided to start updating the website with the best practices of minified CSS, JS, advanced aggregation, and image optimization to decrease the loading time of the website. It all worked as per strategy as the loading time of the website improved significantly.

Results

  • The entire website was updated and modified with the help of Drupal 7 technology.
  • The website’s loading time was enhanced.
  • The website’s functions were modified as per the requirements of the client.
  • The necessary web pages were redesigned to optimize the landing pages
  • The website’s security was strengthened with the help of authentic tools.
  • The client was 100% satisfied as we managed to update, modify, and optimize the website within a narrow timeline.

Benefits

  • The website’s load time has improved to Grade ‘A’ from Grade ‘B’.
  • The website’s user experience has been improvised to a huge extent.
  • The newly optimized website has helped attract maximum organic traffic to the website.
  • The website has become much more flexible and functional at the backend for content editors.
Read More