Software utilities

Today I created a workbook in Excel 2007. After working on it, i closed the file pressing the small red X at the top of the docuemnt. Everything was ok. But after that I tried closing Excel, and guess what… it didn’t! Also, besides remaining open, all the menu items and buttons where grayed out! The only one which wasn’t was the send –> Bluetooth menu! So I went to the add-in menu and disabled the option, and that’s it, noew everything works fine! Remember that to disable the option you have to opne Excel as an Administrator. I cannot do this in the start menu as I can do for almost every pogram, so i had to go to the program files foider (or, if you have win64, program files(x86)), then microsoft office, then office 12, and there right-click on excel.exe and choose run as administrator. After doing this, click the windows logo on the top left, choose excel options, then add-ins, the on the drop down list choose COM add ins, and there finally you can disable the bluetooth add-in in Excel 2007!

Enjoy!

Hi all! I’ve been away for a while, working on Zen Cart! Now I’m back and I want to share with you some tips and tricks on this software! First of all, Zen Cart is a great open source E-commerce software, written in PHP. This is very good and under development, there are many mods and a support forum full of people willing to help, I strongly suggest you to give it a try! One of its problems is that it is a bit hard to find a way to patch it or modify the appearance or functionality of the software. For example, for ease of use, I wanted to show in the admin product and category listings the weight of the product, to check if I entered it correctly without having to open all the products edit page. There isn’t an option to do this in zen cart, so I had to patch the file category_product_listing.php in admin\includes\modules.

First, around line 77, before: <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_CATEGORIES_SORT_ORDER; ?></td>, add this:

<td class="dataTableHeadingContent" align="right">Width</td>

Note that you could replace Width with whatever you want in the column heading, maybe also a constant specified in some file.

At line 171, before this line: <td class="dataTableContent" align="right"><?php echo $categories->fields['sort_order']; ?></td>, add this line

<td class="dataTableContent" align="right">-</td>

 

At line 249 and 269 add at the end of the SQL list of fields to extract

, p.products_weight

(pay attention to the starting comma!). Then at line 347, before this line: <td class="dataTableContent" align="right"><?php echo $products->fields['products_sort_order']; ?></td>, add this line

<td class="dataTableContent" align="right"><?php echo $products->fields['products_weight']; ?></td>

There is no need to say that before appliyng this you should backup everything and that I don’t assume any liability for the use of this patch! Let me know if it works!

I had a website about Umbria (a region of Italy). It ranked well for tourism-related keywords and had a good number of daily visits. Suddently, visit dropped to 1/10, and they continued to drop. Of course, I mean visits from Google. After some searching and talks with friends, I tought it could be a megamenu penalization. This penalization usually happens when you have large menus shared by all the website pages. I tried to remove the menu, making it different for different cities in the reagion, and after a cuople of days the visits went back (almost) to their original status. Did you ever have a similar penalization?

I was looking for a way to solve the problme of the repeater Control in ASP.NET, which does not offer a functionality like the Empty Data Template of the GridView control or other controls. A solution would be to inherit the Repeater control and create an EmptyTemplate element, as in this post. After some searches I fount this interesting post. The author uses the HeaderTemplate and checks the DataItem count, if it is 0 it shows some text (in the example, it shows a tabel row, but you could easuly do the same with a div or span), otherwise it is hidden. Just what I was looking for! This is the code to use:

<asp:Repeater ID=”repeater” runat=”server”

DataSourceID=”mydatasource” >

<HeaderTemplate>
<span id=”span1″ runat=”server” visible=’<%# ((ICollection)repeater.DataSource).Count == 0 ? true : false %>’>
No data found.
</span>
</HeaderTemplate>

Here repeater is the Id of the Repeater Control.

It happened to me that using Lytebox (http://www.dolem.com/lytebox/) the frame closed immediately as soon as you clicked on the link the first time. If you clicked again it worked. It happened under Firefox. After some googling, I found out that if you remove all the javascript in the linked file, it works fine. Try this solution and good luck!