ucantblamem

Oh boy… The amount of times we get sent an excel spreadsheet to import into a MySQL database is just ridiculous… Thankfully, phpMyAdmin makes this task pretty easy. We just have to check the integrity of the file and match up the fields correctly, but what really gets me is that people think spreadsheets are a great way to store data???

Sure, for small amounts of simple data it is super-handy, especially when you need to do calculations on certain figures. But, we mostly get things like mailing lists sent to us with, in some cases, thousands of rows of data. NOT COOL!

Neopoleon puts it beautifully in a whitty, satirical little cartoon on his blog.

Since SM2 started selling commercial components for Joomla! the biggest feature request we’ve had (and we get a pile of them everday) is for a way to import spreadsheet data into Joomla! SO… I’ve just barely started to build an import/export component for Joomla, which will hopefully make this task as easy as pie. There are a lot of hurdles I’m going to have jump to get this to be easy for people, like inserting data across multiple tables and detecting which tables are for which component, but the goal is to be rid of the dreaded excel spreadsheet!

This entry was posted on Tuesday, December 5th, 2006 at 8:51 pm and is filed under General, Programming, Work. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.