Bridging the gap in data management

My company has A LOT of data and spreadsheets. These spreadsheets are like master spreadsheets shared between different departments and I needed to bridge the gap between the spreadsheets and the data on WordPress. WP Data Tables provided me THE EXACT SOLUTION I NEEDED to bridge that gap. If all the spreadsheets are stored somewhere (like google drive), I can share those spreadsheets with the entire company and also sync them to various websites that we manage. Those with edit permissions on the spreadsheets are very few, so I usually don’t have to worry about any data being messed up. I also cache my version on the website. That way, if someone does make a mistake on the spreadsheet, the website isn’t affected. Those with edit permissions to the spreadsheet have been taught how to login to WP and navigate to WP Data Tables and refresh the data.

Dedicating another person or resource to manually manage the data from these spreadsheets within WordPress was unrealistic and unattainable. The data didn’t exist in an API form either. WP Data Tables was quite literally my saving grace to all the data management and enhancements I’ve made in my company’s various websites this year.

As a result of having all this massive influx of data easily managed and added to the website with WP Data Tables, I have had to increase the PHP memory limit on my WordPress installation. I’m also massively abusing the limits of their single cell shortcode in my custom application. Anyone who thinks their website is slow because of WP Data Tables… it’s not the plugin itself per se. It’s simply that your website is more robust and consumes more resources than a basic WordPress website. As a result, you need to adjust your server accordingly to handle the extra resource hogs.

• This topic was modified 1 year, 3 months ago by cchphealthplan.