Client: New England & New York Real Estate Journal
Domain: http://nerej.com & http://nyrej.com
NEREJ and NYREJ is a commercial real estate news publication. The largest in New England and one of the largest in New York. Originally they were on a custom developed platform built in Zend. I was able to reverse engineer what they did and implement new changes and a redesign many years ago. A few years later they decided to move to WordPress. They kept the old websites up and I assisted in setting up 301 redirects and the new WordPress sites on a subdomain effectively merging the two. WordPress is great for small websites and blogs but not so well for large websites. It didn't work out for them and they gave me a call. My brain instantly started working and I thought of all the content they have all the way back to 2005. We were gonna get ALL of it until the day they go live.
So I needed to rip the story table from the Zend and WordPress sites and write a custom script to import them into the new sites database so it could be done on the fly. I chose XML for this task as it is easily ripped from PHPMYADMIN and WordPress. I custom wrote all the import scripts for each platform in raw basic PHP. This required not just importing but cleaning all the XML as well. This was great for the Zend website but WordPress XML is terrible. This meant I needed to fix encoding, convert shortcodes and any variation of them, and change image links and any variation of them. After what felt like a ridiculous amount of time I was done with the story table. When all was said and done between NEREJ and NYREJ I imported and cleaned a total of 72,278 stories using my scripts. Wow!!!
It wasn't limited to just stories though. They have a custom built directory, professional profiles, advertising platform, PayPal integration for subscriptions, founders message (blog), and other various pages. All of this needed to be integrated into the new website with administration pages to manage them all. All the imports were done with custom written import scripts using XML and PHP. The administration was written in CakePHP and Bootstrap 3. PayPal was integrated using the REST API (https://github.com/paypal/PayPal-PHP-SDK).
Finally they wanted to take down the subdomain but have the links foward you to the new website. This required reverse engineering WordPress permalinks. For some reason I found out WordPress throws everything into the wp_posts table. I'd never do this but there must have been a reason to this. I just find it messy and this probably the reason WordPress doesn't work so well for large websites. MySQL can only handle so much on a large database table. Anyways I was able to pull the slug from the wp_posts table. Then I took my scripts slug script and integrated it so it will look to the wp_posts table for the slug and when it finds it's match it will forward it to the new url with the new slug. Instant WordPress to new site fordwarding software.
Overall this was the most challenging project I have ever done. Building a news website is one thing. Converting 2 existing platforms into one, cleaning all the data, forwarding any existing links to the new sites, for not one but two websites, is a whole different story. I mean 72,278 stories is a ridiculous amount of data entry! I don't think I want to see another WordPress XML file for a VERY long time after this.