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

Shopify Application Development & Integration For Customized Payment Module

Background

 

Rosy.com is a private digital family organizer and app that helps preserve personal, family, and business memories. They organize and digitize photographs, videos, documents, stories, and other types of media so that users can create beautiful storytelling and personal sharing using the digital family organizer and app.

Since the client already had a fully functional Shopify website, they were looking for a customized payment module to manage the complete subscription process using the Shopify application. With the help of the customized app, the client was looking to add value to the customer experience so that users can claim multiple discounts on a single subscription.

Furthermore, they required an efficiently running application to assist the active and non-active users. In addition to the customized Shopify application, they also wanted a proper and smooth integration to achieve their objectives. 

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

Already built-in limitations of Shopify were the key challenges we faced when developing a customized Shopify App. The basic limitation for the client was that users subscribing to their platform can only apply one discount voucher at a time for a single subscription. The experienced Shopify developers’ team at Mpire Solutions had to find and implement the best-customized solution to overcome this limitation efficiently.

Another key challenge related to the custom Shopify App was to link/integrate it with the Recharge App for a customized payment module. It further included the following challenges;

  1. To check and verify who is subscribing to the platform.
  2. Type of discounts users can avail or claim on a specific subscription (Half-Yearly or Yearly subscription).
  3. The renewal or cancellation of the subscription with specific timelines.
  4. Expiry terms and conditions of the subscriptions.
  5. The timeline of the subscription should define the nature and number of discounts a user can claim.
  6. To implement and manage the subscription process throughout the website.
  7. To implement the complete payment module with Recharge APIs integration.

Requirements

Customized Shopify Application Development – To manage the subscription process including discounts and coupons throughout the payment module.

Solution

The client already had a fully operational Shopify website, so we developed the entire customized Shopify application from scratch using the required technologies.

Since the client was looking forward to managing their discount mechanism and verifying who is subscribing to their platform, we integrated the customized Shopify App with Recharge APIs to meet the custom requirements for the client. The Shopify application was entirely customized and was integrated into their existing Shopify store. Even after facing so many limitations, we managed to implement the functionalities efficiently.

Furthermore, we implemented an automatic recurring email management system for the client using PHP technology. This was specifically for the ease of users, for example, if a registered user is inactive for more than a month, the email management system will automatically generate an email with some discount to attract them again.

Results

  • A fully functional customized Shopify application was developed for the client and integrated with their existing Shopify website.
  • The integration between the Shopify application with Recharge APIs enabled the smooth payment process for the client.
  • With the help of our customized Shopify Application solution, the client’s registered users can now purchase their subscriptions, and in return, the client provides them with a variety of features and discounts.

Benefits

  • The client has a fully efficient system now in the form of a Shopify website integrated with a Shopify application.
  • The users of Rosy.com can easily apply for multiple discounts even for a single subscription.
  • The client now has a proper backend mechanism through which they can create new discounts as per the requirements.
Read More

Custom WordPress Plugin Development and Implementation

Background

 

SirsiDynix is a well-known flexible co-workspace provider for start-ups, businesses, and organizations. They were facing issues over the reservation process of their workspaces i.e.,  conference rooms, coworking spaces, event spaces, desk spaces, shared offices, meeting rooms, breakout spaces, and etc.

The dimension of their service was massive as they were operating in a number of countries offering customized workspace solutions across various cities. They approached us to develop, implement, and manage a solution to tackle the challenges effectively.

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

Before reaching out to us, they had no digital solution or tool (except for a WordPress website) to tackle the ever-growing high-tech issues. However, with a continuous business expansion over the years, they had to deal with a lot of complexities throughout the reservation process of workspaces.

The key challenge was to create a plugin from the ground up and to show availability of the workspaces. We had to develop and modify the plugin in such a way that it can handle the demand of workspaces with different frequencies while specifying ranges of availability at the same time.

Requirements

  • Upgrade of Reservation Process – To upgrade the reservation process while making the availabilities visible and up-to-date for the customers.
  • Visibility of Available Workspaces – To assist users in determining the availability of essential workspaces over the course of days, weeks, months, and years.
  • Customized & Optimized Mechanism  – To make sure that the developed plugin can help manage all the business needs during the reservation process while considering different frequencies and recurrence challenges.

Solution

To start with, our WordPress developers performed extensive analysis of the specifications before recommending the development of a custom WordPress Plugin that can address all reservation issues from the beginning. Before taking any further action, our initial responsibility was to fully comprehend all of the client’s requirements.

We were able to effectively develop a user-friendly and customized WordPress Plugin with the best implementation and practices of WordPress development that tackles all the reservation issues efficiently. The users could easily search through the workspace availabilities and even recurrence frequencies for booking their desired workspaces.

Following are some of the customizations that we successfully managed to implement throughout the event calendar;

  • Add/Remove Events.
  • Edit Events.
  • Update Events.
  • Recurring Events.
  • Upgrade in display design.
  • Events with different frequencies.
  • Provisions in the workspace, such as multimedia / projectors, sound system, stationery, whiteboard, seating arrangements, refreshments, etc.

Results

  • The WordPress Plugin was successfully developed and implemented.
  • Dynamic customization of the plugin.
  • The users can now easily find the slots for reservations with different ranges and frequencies throughout the event calendar.
  • The client’s expectations were met in terms of objectives within set timelines.

Benefits

  • The upgrade helped SirsiDynix to achieve maximum operational efficiency.
  • It also helped them expand their business with the availability of more specific data about the bookings pattern and as per the demands of the target audience.
  • The entire project was delivered in a cost-effective manner with an enhanced user experience.
  • The client credited this upgrade for an overall turnaround of their business operations and multifold revenue increase.
Read More

Development of Integrated Leaderboard, Event Calendar, Email Management System, and Reward Redemption Process

Background

Blue Studios is providing online learning opportunities to students starting from preschool to 12th grade with the help of online learning classes and many other skill based courses of various categories through webinars, videos, and live classes.

Before reaching out to Mpire Solutions, they were not aware of the concept of a leaderboard. Morever, no mechanism existed to rank the users based on projects, assignments, and quizzes for a specific subject and / or other categories. Instead, they were using a grading system based on marks without any conceptualization of leaderboard rankings.

To begin with, they required a complete mechanism of an event calendar where the users can easily book online projects based on availabilities and offers. We had to select the most appropriate technology to develop an efficient, user-friendly, and integrated event calendar.

Furthermore, with live classes and other online learning activities that can help the users earn rewards, they wanted us to create a mechanism of reward redemption using the right technologies and integration with third parties and within the platform, so that registered users can easily redeem their gifts without any delays.

The last thing they required was a customized and integrated email management system to deal with the auto-generated email throughout the registration process.

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 main task was to create a leaderboard from scratch while integrating all other functions that are related to assignments and the grading system. Since Blue Studios were already using different third-party integrated platforms (Klayvio, Userpilot, & Typeform), our team had to face a lot of limitation throughout the process of development.

Another main challenge was to initiate the custom codes due to no direct access. Our team of experienced and certified developers spent extensive time on the project to find and implement the best possible solution in order to meet the requirements. The client provided us with a specific design and we had to suggest the most efficient technologies for different platforms of the website to get the desired results.

The reward redemption process was yet another challenge for our team. We had to use the right third-party integration platform to develop a well-structured and smooth reward redemption process for the registered users that were ranking in the leaderboard. Other than that, the client required a proper email management system for the new users so that when they register on the platform, they can get the confirmation email right away. 

Requirements

  • Integrated Leaderboard Development – To create, implement, and integrate a leaderboard for a proper ranking system based on different online activities.
  • Event Calendar Development – To manage the live activities and to book for available projects.
  • Features Enhancement – To enhance existing features in order to effectively integrate with the leaderboard.
  • Integrated Gift/Reward Redemption Process – To redeem the gifts based on grades & ranking, on the leaderboard.
  • Email Management System –  To generate and send auto-generated emails through third-party integration throughout the registration process.

Solution

Since the basic design was provided by the client, our experienced and certified team of developers came up with the right mix of technologies (ASP.NET, HTML, CSS, JavaScript, and Uscreen) to perform both tasks.

We started the leaderboard development using ASP.NET for backend & HTML/CSS/JavaScript for frontend development. Since we used customized technology throughout the development process, there were no limitations or barriers throughout the coding process.

We managed to get 3rd party integrations with various platforms to achieve the desired results with the leaderboard. We suggested and implemented a variety of technologies for the admin panel and registration process of the website to make them more optimized and user-friendly.

After successfully developing an integrated leaderboard, we moved towards creating an effective event calendar for the users to book the live events easily. We used Uscreen technology to create an event calendar that shows the availability of the live events.

Furthermore, the implementation of the integrated gift redemption process greatly helped the registered users on the leaderboard in redeeming their gifts based on total points, projects submitted, and quizzes.

To address the need of a proper email management system, we implemented third-party integration with Klayvio technology, so that newly registered users can get an instant auto-generated email for confirmation.

Results

  • We managed to successfully create a customized and integrated leaderboard for the client with the implementation of ASP.NET, HTML, CSS, and JavaScript technology.
  • Registered users can now see their rankings through the leaderboard.
  • An event calendar was developed with the best practices of Uscreen technology.
  • A proper reward redemption was developed using third-party integration.
  • An integrated and customized email management system was implemented to send instant emails to newly registered users.
  • All the features that were mandatory for successful customization and integration were enhanced.
  • The management of Blue Studios was fully satisfied as we managed to custom deliver the project as per their exact requirement.

Benefits

  • The integrated leaderboard encourages the registered users to perform above par and to get the motivation to see themselves ranking on top of the leaderboard.
  • The event calendar helps the users to register for various live classes throughout the week/month.
  • The reward redemption system allows the registered users to easily redeem their gifts based on ranking, grades, assignments submitted, and, quizzes.
  • The integrated email management system makes the entire registration process more flexible and significant.
Read More

Customized Extension Development for Chrome and Safari

Background

OneProximity is a well-known platform to generate and secure login information (ID & Password) for its registered customers. Previously, they only had a mobile app through which customers could manage & secure their login credentials for various platforms regardless of any nature.

The key reason why OneProximity reached out to us was to enhance the functionalities of this app by making it available to the customers via desktops, laptops and personal computers using customized extensions for Chrome and Safari.  

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

Before approaching Mpire Solutions, they only had a mob app as a password manager and were facing challenges in updating the registered credentials manually. The main challenge was to develop extensions for two platforms (Chrome and Safari) from scratch and with the same functionalities so that customers can also use the proximity app on their desktops and personal computers as well.

The primary challenge was not just to develop the extensions, but to ensure that the customization integrates with an existing app smoothly. Our team of developers conducted an extensive audit of the application before suggesting a way forward. A technical and security challenge was about encrypting the passwords within the existing app. The deep understanding of OneProximity application enabled us to move towards the solution while keeping all other important factors under consideration.

Requirements

  • Customized Extension Development for Chrome – To make the app solutions available to customers using Google Chrome.
  • Customized Extension Development for Safari – To make the app solutions available to the customers using Safari.
  • Implementation, Support, & Monitoring – To implement and monitor the overall performance of the extension.

Solution

After an extensive audit of the existing application, our team of expert developers developed customized extensions for Chrome and Safari by following the best practices of Coordinator & JavaScript throughout the process.

The core function of the extension was not to save the login information on Chrome and Safari but to retrieve the stored credentials from the existed app for registered users.

The existing application was based on Lambda functions which were not proving effective in getting the desired results. To come up with a significant solution, we developed a middleware to perform the task which helped us in developing reliable extensions for Chrome and Safari.

Results

  • The custom Chrome and Safari extensions were successfully developed and implemented.
  • Customers can now experience the features of the app across all devices.
  • The custom developed extensions were now able to retrieve login IDs and password details from the app.
  • To excess the extensions the registered users have to provide some basic information based on mobile numbers and ID numbers as allocated by the app.
  • The extensions can retrieve the credentials for all platforms regardless of their nature.
  • The extensions would only work along with the app. Customers have to register on the app to use the extensions.
  • The team of OneProximity was fully satisfied with the results along with our efficient and timely services as we managed to complete the project within the provided timeframe.

Benefits

  • The extensions created for Chrome and Safari allow customers to use the OneProximity platform on all mobile devices, desktops, laptops, and personal computers.
  • The main benefit of the extensions was that customers can now easily retrieve the pre-stored credentials regardless of any location or platform, no matter what device they are using.
  • The custom development of the extensions for Chrome and Safari helped OneProximity reach out to the maximum target audience.
Read More

Automation & Data Integration With Salesforce Website

Introduction

Utility Business Media, Inc. (UBM) is the utility industry’s leading publisher and producer of utility safety and leadership-focused content and education. They were looking for some experienced Salesforce development teams to help them set up, track the customer journey, and automate their routine client communication which was based on different criteria within their Salesforce website, such as automated generation of training certificates for registered candidates based on hours completed throughout the sessions. However, the training hours were dynamic and varied from applicant to applicant.

Challenge

When the client reached out to Mpire Solutions they already had a functional Salesforce website. The client used to manually enter the data of the registered applicants based on attendance and training hours in order to generate certificates for each individual.

The UBM management decided to get a customized and integrated Salesforce system that can generate certificates automatically based on hours completed by each registered applicant.

The main challenge was to work on the different conditions, limitations, and validations to automate the process of certificate generation. The client used to record the attendance of the training sessions by manually maintaining an excel sheet before uploading the same to their Salesforce system.

Another challenge was to deal with the exceptional cases throughout the data management system. For instance, an applicant is registered for a specific training session but never punched the attendance, or joined the session late leaving behind no records. We had to consider every basic possibility to create the best-fit Salesforce solution for the client.

Requirements

  • Automated Certificate Generation – To generate certificates for each individual based on attendance and hours.
  • Eligibility Criteria  –  To manage and keep track of the registered users before generating the certificate of any particular training.
  • Data Integration and Management – To streamline the entire end-to-end training process.
  • User Creation – To identify the status of whether the applicant is new or already registered with the platform.

Solution

To meet the requirements of the client, we created a customized and integrated Salesforce system. There were 4 basic conditions we worked for certificates automation;

  1. Information of the applicants.
  2. Beginning date of the event.
  3. Ending date of the event.
  4. Number of hours spent by each individual in training.

To monitor and track the presence of the registered users, we created a customized training management calendar for each applicant that tracks the total number of hours an individual has spent throughout the training sessions, before generating the certificate. We also worked on the eligibility criteria of the applicants whether they are eligible for the certificates or for a specific training session. In order to avoid human error in setting dates, we excluded backdating entries within the platform to keep things reconciled.

The Salesforce team at Mpire Solutions developed customized options for the client through which they can send the certificates to the trainees via email. However, to avoid exploitation, this customization access was only available for the admin.

There is a limitation of sending the number of emails in a single day through Salesforce. Salesforce allows you to send a maximum of 5000 emails in a single day. Sometimes UBM had to deal with more than the provided limit. This hype could be the result of discounted offers, packages, or limited offers to attract a potential audience. To deal with this challenge, we had to develop a customized batch class in Salesforce to meet the target without any limitations.

In addition to that, our Salesforce developers worked on the user’s information to check whether it’s a new applicant or already a registered applicant with the platform.

Results

  • We successfully managed to automate the certificate generation process.
  • A proper mechanism was developed to track and monitor the attendance of the registered applicants.
  • Entire data was significantly integrated with the Salesforce website to manage the training process.
  • A mechanism now can identify the status of the applicants whether they are new users or are already registered.
  • The platform now can check the eligibility criteria of the applicants.

Benefits

  • Certificate Generation Process was automated.
  • Attendance Verification Process was automated.
  • Instead of generating certificates for every individual, the client is now only a click away to send certificates to the trainees via email.
  • The client now simply has to upload the attendance to their Salesforce platform and get the desired results.
  • Trainings, Trainees, Attendance and Certificate Issue Data was significantly integrated throughout the platform.
Read More