case study

Data Migration from .NET to WordPress for Online Content Publisher

The Client

The client is an online content publisher who publishes thousands of articles on mental health topics on his company website. He brings onboard editors and writers who upload research papers, case reports, and journals on depression, addiction, bipolar disorders, schizophrenia, etc., on this website. By publishing dozens of articles monthly, the client aims to bring medical students and psychiatrists to the newest insights around these areas.

Industry

Healthcare

Tech Stack

WooCommerce, jQuery, Restrict Content Pro, Stripe, MySQL, Amazon RDS, Amazon EC2

The Challenges

Before contacting Capital Numbers, the client used to run this website on the .NET framework. However, he soon found that the .NET setup was not offering him the SEO benefits. Unhappy with poor site traffic, the client wanted to migrate all data from the existing .NET framework to WordPress.

He was aiming to make provisions for:

  • On-page/off-page SEO activities
  • Metadata work
  • Hyperlinking
  • Tags and titles
  • Article listings
  • Image optimizations
  • Ad placements
  • Page redesigns, etc.

In addition, the client also wanted to make the website content more accessible to those who are color blind or low on vision. He was looking for a way to add good contrast ratios to website fonts and colors so that even the visually challenged could consume content without trouble.

the challenges

Moreover, the existing website had multiple URLs, and ‘mini’ directories merged. So, the client wanted to add a Single Sign-On (SSO) authentication. An SSO would help all users access every independent URL with a single set of credentials.

The volume of work was enormous. So, the client wanted a tech partner who could do the heavy lifting and handle the associated challenges well. Looking at Capital Numbers’ past work, the client sought our help to achieve the goals.

Solutions We Offered

At the onset of the project we clearly defined all the milestones, deliverables and timelines.

Our expert engineers started by analyzing the .NET environment’s source code before planning the migration work. But, while assessing the existing source code, we found that the datasets had vast character-set problems.

For instance, the ISO-based character-set issues in the .NET setup abnormally displayed special characters (e.g., $,%, #, %, etc.) between sentences. It was highly frustrating for the users. So, in place of ISO encoding, we implemented the UTF-8 encoding method to render all characters correctly without letting any special characters pop up.

It took immense brainstorming to properly remove all character-set problems from around 3500+ articles using the UTF-8 encoding method. Although we used custom scripts to automate the encoding work, we depended on six data entry specialists to manually take care of a few tasks.

Once done with the data migration and encoding work, we took care of areas like the Home page, site structures, mega menus, admin areas, etc. Adding the WooCommerce plugin helped us take care of these.

solutions

Next, we used the Restrict Content Pro plugin to control who can and cannot view certain content. We integrated it to restrict action hooks and search filters and lock away exclusive content from unpaid users.

As for the frontend, we fine-tuned everything using jQuery, HTML, and CSS codes. Here, we strictly adhered to WCAG 2 guidelines to make content readable to all, even those with visual disabilities.

As per the project’s needs, we added four dashboards for guests, editors, students, and the super admin. While creating the login dashboards, we also worked on Single Sign-On (SSO) to help users sign in with just a single set of usernames and passwords to access all product features. We did a lot of customization around the SSO to ease content accessibility. We added Stripe, as well, to help paid subscribers make recurring payments safely.

Because the website was data-heavy, we agreed to power up the storage using the MySQL database solution. We also used Amazon’s RDS to protect and encrypt data with private keys.

Once done with everything, we deployed the new solution on Amazon’s EC2, as it’s a highly reliable network for hosting data-heavy websites optimally.

Results

In only six months, Capital Numbers completed the project. In around three months, we completed the data migration and UI work. We spent about two months on SSO work and around a month on issue-fixing. The results have benefited the client, who now maintains his new WordPress website at a lower cost.

Here’s more on the successes that the client congratulated us for:

Result Bullet
.NET to WordPress (WP) Migration

We moved bulk data sets from the .NET install to WordPress without any data loss.

Result Bullet
20K+ Web Page Transfers

We transferred over 20K web pages that included hundreds of content pieces, such as:

  • Journals
  • Archives
  • Weekly Posts
  • Research Papers
  • Case Reports
  • Product Reviews
  • Feature Articles
  • Insightful Videos
Result Bullet
Video Imports from XML Files

We imported many of these videos from massive XML files to their destination databases on WordPress.

Result Bullet
UTF-8 Character Encoding

We eliminated all invalid characters using the UTF-8 encoding method.

Result Bullet
WooCommerce Plugin Implementation

Our WordPress experts used the scalable WooCommerce plugin to optimize the site for hundreds of content uploads.

Results
Result Bullet
Mega Menu Implementation

We created the mega menu with several dropdowns that reveal lower-level pages of the site at a glanc.

Result Bullet
WCAG 2 Web Development Guidelines

Because we followed WCAG 2 guidelines, the web content and fonts are consumable for low-vision users.

Result Bullet
SEO Plugin Implementation

Our SEO plugin implementations now help the client add relevant meta tags, titles, descriptions, breadcrumbs, etc., to improve the search ranks.

Result Bullet
Sticky Ads

We made provisions for sticky ads that stay fixed on the right side of the pages, even as users scroll down or up.

Result Bullet
Four Admin Dashboards

Guests, editors, students, and the super admin can quickly log in to their respective dashboards to manage and view content across the site.

Result Bullet
SSO Implementation

Thanks to our SSO implementation, all users can access merged URLs and premium links without re-authenticating themselves every time.

Result Bullet
4 Project Milestones

Capital Numbers’ expert engineers did all these implementations and integrations in four pre-planned milestones.

Result Bullet
90% Reduction in Maintenance Costs

Our efforts and hard work have led us to redevelop an SEO-friendly WordPress site with 90% lesser maintenance costs.

Result Bullet
Higher SEO Value

Driving good SEO traffic, the site is a highly customizable one and ready for unlimited scaling.

Result Bullet
End-to-end Data Migration Work

Benefitting from the results, the client spoke highly of us on Clutch and lauded us for assessing and migrating 20K+ web pages between two installs without damaging a single data source or business logic.

Let’s Discuss Your Requirements

Confidentiality & Same Day Response Guaranteed!

Send Your Query
Download

Download this case study in PDF

Tittle Star

300+ Glowing Customer Reviews

97 out of 100 Clients Have Given Us a Five Star Rating on Google & Clutch

  • Google 5 Star Customer Rating
  • One Ranked
  • Clutch Champion 2024
  • G2 - Business Software Review
  • GoodFirms
quote icon

"They're very willing to assemble the team that we ask for if we have certain preferences."

James BurkeCapital Numbers 5/ 5
quote icon

"I am glad I found Capital Numbers and I credit them for a lot of the success I have had."

George LevyCapital Numbers 5/ 5
quote icon

"They are always willing to help, even after the project was supposed to have ended ."

Charles Douglas-OsbornCapital Numbers 5/ 5
quote icon

"Capital Numbers was easy to work with, and they were always available."

P. AtturCapital Numbers 5/ 5
quote icon

"It is impressive how easy it was to work with them."

Jose RodriguezCapital Numbers 5/ 5
quote icon

"Their fast response was impressive."

Jorge QuinteroCapital Numbers 5/ 5
quote icon

"They were quick and efficient and their work was very good."

Bob NorbergCapital Numbers 5/ 5
quote icon

"They respond so quickly to thoughts and always try to do the best they can."

Marcello RongioneCapital Numbers 5/ 5
Join Our Success Stories

Get Custom Solutions, Recommendations, Resumes, or, Estimates. Confidentiality & Same Day Response Guaranteed!

Fill Out the Form and We Will Contact You.

    Select Files From Your  or   or 
    • Checkmark Icon 100% Confidential
    • Checkmark Icon We Sign NDA

    What’s Next?

    Our Consultants Will Reply Back to You Within 8 Hours or Less

    Expert Guidance You Can Trust. No Pitch, Just Expert Solutions.
    +25 More Awards in Past Decade

    Frequently Asked Questions

    Based on the information provided about Capital Numbers, here arefive frequently asked questions (FAQs) and their answers

    We offer a wide range of services, including:

    • Digital Engineering: Custom software development, enterprise systems, automation tools.
    • Web Development: Dynamic websites, e-commerce platforms, CMS solutions.
    • Mobile App Development: iOS & Android apps, cross-platform solutions, app maintenance.
    • QA (Quality Assurance): Automated and manual testing for error-free software.
    • Cloud Engineering: Cloud migration, cloud infrastructure management.
    • Data Engineering & Analytics: Data integration, data warehousing, data visualization, predictive analytics.
    • AI/ML/GenAI: AI-driven analytics, machine learning solutions, generative AI applications.
    • UI/UX Design: User interface design, prototyping & wireframing.
    • Emerging Tech: AR/VR development, blockchain development.

    We offer two distinct engagement models:

    • Project-Based Development: Tailored solutions for defined goals, ideal for short-term projects.
    • Dedicated Development Teams: Seamless integration, scalable solutions for long-term partnerships.

    We have clients in various countries, including:

    • USA
    • UK
    • Canada
    • Australia
    • Ireland
    • Switzerland
    • Saudi Arabia
    • Indonesia
    • UAE
    • Israel
    • Italy

    We have received numerous awards, including:

    1. Clutch Top 1000 B2B Companies
    2. Financial Times High-Growth Companies
    3. The Economic Times India's Growth Champions
    4. Dun & Bradstreet Leading SMEs of India
    5. Manifest Global Awards
    6. Clutch Global Leaders
    7. Clutch Champion Awards
    8. GoodFirms: Trusted Choice Awards
    9. GoodFirms: Best Company to Work With

    We were founded in 2012.

    We are ISO 9001 and ISO 27001 certified, demonstrating quality and data security standards.

    We create dynamic websites, e-commerce platforms, and manage content with user-friendly solutions.

    We develop iOS & Android apps, cross-platform solutions, and provide ongoing maintenance.

    We offer data integration, warehousing, visualization, and predictive analytics for data-driven decisions.

    We offer AI-driven analytics, machine learning solutions, and generative AI applications for various needs.

    Innovation, quality, client satisfaction, integrity, and teamwork are core values that guide our operations.

    We aim to become a global leader in digital solutions, continuously innovating and empowering businesses with cutting-edge technology.

    Click to Expand
    cookie close

    This website collects cookies to deliver a better user experience. Read Cookie and Privacy Policy