Using Excel to Update SQL Data

The other day a co-worker was trying to figure out how to help a client update a lot of individual fields in a SQL table.  He did not want to grant them direct access to the entire backend of the SQL server table but he also did not want to have to spend a lot of time “developing” code to do this update.  This was a one-time update and using SSIS to create a package seemed like overkill.  He also wanted to have control over which fields got update.  He was trying to find an easy way of doing this.  His client also has some experience using spreadsheets.  I told him of a way to accomplish these requirements while at the same time giving his client the ability to “mass update” fields as needed. Learn More

Tags: , , , , , , , | Posted under MSSQL, Programming/Coding | Leave a comment

Working with the Dolphin 7.1 Admin Menu

Hello and welcome! In today’s blog I’ll show you how to change the Dolphin 7.1 admin menu. The admin menu is the menu bar that appears on the left side of the screen when logged into the admin area.

To access the admin menu builder, simply log into your Dolphin admin and select “Admin Builder” under the “Builders” sub-menu on the left. Learn More

Tags: , , , , , | Posted under BoonEX Dolphin | Leave a comment

Configuring Site Meta Keywords in Joomla 2.5

Meta keywords are a list of keywords used to indicate what your web page is about. These are important so that web crawlers can properly index your Joomla site. In this article I will give you a step guide on how to configure site meta keywords in Joomla 2.5

1. Login as an administrator to Joomla.

2. Go to menu “Site -> Global Configuration”: Learn More

Tags: , , , , , , , , , | Posted under Joomla | Leave a comment