Development of a Subscription-based Interview Management Portal

Our challenge was to lift-and-shift data from the existing PHP format to WP while ensuring a few critical aspects like:

• Data safety
• Data integrity
• Minimum disruptions

We already had success stories where we moved data from old setups to new environments. But, the problem in this project was that the client provided us with huge Excel files from which we had to import data. The files had multiple custom fields. We had to rely on well-thought-out business logic to take care of the migration work so that every custom field in the old setup gets reflected in the new host as is.

• Data structure: Firstly, we checked the data labels/categories in the old setup and looked for inconsistencies (if any).
• Technical elements: Secondly, we brainstormed the PHP code that would help us migrate existing data to the new setup.

Since we had past experiences migrating large data sets to new environments, we could carry out the above pre-migration assessments well.

Next, we began setting up the WordPress framework as the new backend structure. We uploaded the Excel files in this new structure and started the import work with the help of custom PHP code. The custom coding scripts helped us parse Excel data and insert them into MySQL tables flawlessly. Our pool of certified PHP professionals, well-versed in custom coding, was quick enough to implement the business logic needed to move data files smoothly. We consistently checked for security flaws during the migration work and even took periodic backups to restore data if anything went wrong.

Once done with the migration work, we focused on creating extra features on WordPress to customize this interview management portal. For example, we integrated assessment lists, interview lists, transaction lists, customer lists, coupon lists, etc.

Since we were developing this software for recruiters to purchase, we needed a robust payment gateway solution. So, we chose Stripe because this payment solution accepts all popular debit and credit cards. Moreover, Stripe is secure and doesn't store card details.