Parsing Excel Files in Rails

Parsing Excel Files in Rails

I’m doing a project where I need to import a spreadsheet, parse it, and then insert the data into the database.  Now my first concern for finding a gem was that it could support more than one format of spreadsheet file.  My second concern was that I wanted to be able to easily iterate over sheets, rows, and columns.  My third and last concern was if it’s still being actively developed.  While doing research for reading spreadsheet files I found 2 primary candidates.

The first candidate is the Spreadsheet gem.  This was the first gem I tried and could easily iterate over sheets, rows, and columns.  It was also still being actively developed.  But the primary disadvantage is that it will only work with .xls files.  Here is an example of how to use this spreadsheet gem to iterate over sheets and rows.

Read more

The Power of WordPress Themes and Templates

The Power of WordPress Themes and Templates

WordPress is a popular CMS that is both free and relatively painless to setup.  Since you’ll want to get the most out of this system, we will discuss developing a simple template page.

Depending on the purpose of your site, you might want to develop a WordPress theme of your own. For this example we only need a simple template, so just follow the example of creating a child theme at WordPress.

Read more

9 Marketing Tips for Web Development Firms

9 Marketing Tips for Web Development Firms

Figuring out how to market your web development firm can be difficult. It’s a puzzle I’ve pondered for quite some time now; but I have good news that I would like to share with you! First of all, you aren’t alone. And secondly, here’s a list of 9 marketing tips that will boost your web development firm to the next level.

Read more

How Effective is Blogging in Generating Traffic? We have results!

How Effective is Blogging in Generating Traffic? We have results!

A few weeks ago I wrote about the Effectiveness of Blogging in Generating Traffic. That blog article underlined the results of a couple surveys that talked about the importance of blogging in improving the SEO, as well as marketing benchmarks taken from more than 7,000 businesses which included results from a Facebook and Twitter strategy.

At that time, we were getting started with our own blog (and social media) here at Synaptian, so we did not have first hand data like we do now. It has been 2 months since we first started blogging and we have some good results to share with you.

Read more