Mastiff Inc.

Tutorials
Useful Info
We will frequently update this section with “real-life-work-related” tips and tricks ranging from Excel to PowerPoint to shortcut keys to HTML to PHP and a bunch of everyday tasks.

Stay tuned...

If you have an Excel file that has columns A and B. Both have data that may or may not exist in other column and you are only interested in the data of column A that do not exist in B. Use the following formula (put the following formula in C1 and copy down).

=IF(ISNA(VLOOKUP(A1,$B$1:$B$65535,1,FALSE)),"Not in B","")

Translates to: if the value in A isn't in B the cell in column C will say "Not in B"

Source: StackOverflow

  1. Open the file
  2. Click CTRL + F
  3. Select "Current document" in "Find in" (You can also select the folder if you have multiple files)
  4. Search in "Source code"
  5. Tick "Use regular expression"
  6. Type "[\r\n]{2,}" (without quotes) in "Find"
  7. Type "\n" (without quotes) in "Replace"
  8. Press "Replace All"

Source: user nico_swd at forums.digitalpoint.com

Stop right click and choose Select All... Save yourself a second by using the following short cut keys. (This is for you Bart)

Ctrl + A Select all
Ctrl + C Copys the highlighted text or item.
Ctrl + V Paste whatever you just copied from Ctrl + C
Ctrl + Z Undo
Ctrl + Y Redo
Ctrl + F Opens the Find function in any program including your browser
Ctrl + H Opens the Find & Replace function in most editor type programs
Ctrl + P Opens the Print function in any program including your browser
Ctrl + S Saves the document
Ctrl + Shift + S Dreamweaver Shortcut > Saves As
Alt + Tab
Alt + Esc
Window Logo Icon Key + Tab
Alows you to switch between programs
Shift + F7 Opens the Spell Check function in most editor type programs

Step 1: Go to app/design/default/your_template/template/catalog/navigation

If you do not see a left.phtml in the folder, create one with the following content:

<?php $_helper = Mage::helper('catalog/category') ?>
<?php $_categories = Mage::getModel('catalog/category')->getCategories(34) ?>
<?php $currentCategory = Mage::registry('current_category') ?>
<?php if (count($_categories) > 0): ?>

<div id="menu">
<ul>
<?php foreach ($_categories as $_category): ?>
<?php echo $this->drawItem($_category) ?>
<?php endforeach ?>
</ul>
</div>
<?php endif; ?>

NOTE: the number 34 is the ID of your category that you want to start your menu called from. For example, you may want to leverage Magento's internal Top Menu drop-down function but you need to put all your menu items under another menu item called Categories. If you pull out the menu without the number, the first menu item you will see is Categories. You may not want that. So by specifying the first id of the menu you want to start to call from will eliminate such issue.


Step 2: Go to app/design/default/your_template/template/catalog/layout

Open catalog.xml file

Ctrl+F for:

<reference name="left">

There will be 3 instances

After you find it, copy and paste the following code below "<reference name="left">"

<block type="catalog/layer_view" name="catalog.leftnav" after="currency" template="catalog/layer/view.phtml"/>

Step 3: Upload them back to the server. And the rest you can do with CSS styling.

If you need to redirect your website from none www address to www address, copy and paste the following code into your .htaccess file.

RewriteEngine On RewriteCond %{HTTP_HOST} !^www\. RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]

Use at your own risk


Alternatively if you want to do the reverse, use the following:

RewriteEngine On RewriteCond %{HTTP_HOST} !^my-domain\.com$ [NC] RewriteRule ^(.*)$ http://my-domain.com/$1 [R=301,L]

Use at your own risk

Above information is from: http://dense13.com/blog/2008/02/27/redirecting-non-www-to-www-with-htaccess/

  1. Open up Microsoft Excel.
  2. Paste your entire list into Column A.
  3. Sort the entire column alphabetically (A > Z). <-- This is very important.
  4. Click on and highlight Column B.
  5. With Column B highlighted (press the gray B button above the column to highlight the entire column), enter the following into the “formula” box in Excel.
    =IF(TRIM(A1)=TRIM(A2),"",TRIM(A1))
  6. After the formula is filled in, and with the entire Column B still selected, go to the menu in Excel, and choose: Edit > Fill > Down.
  7. This will fill Column B with a new, updated list, with all duplicates removed.
  8. Now, you’ll want to copy that column into a new spreadsheet. “Copy & Paste” won’t work…

    You could...

    • Select Column B, and choose Edit > Copy.
    • Create a new spreadsheet, and select Edit > Paste Special > “Values”.
      OR
    • I personally like to Copy & Paste into Notepad than Copy & Paste from Notepad out to Excel. This will ensure you take ascii text and nothing strange will happen. Especially if you need to sort the Pasted column.

  9. Now you should have the final, updated list. You can sort it now, and remove blank lines.

Is the page BLANK? After you paste into a new sheet, blank entries from your list show up at the top, so if you have a very large list, you might have a lot of blank lines near the top. If so, scroll down to see your list.

Above information is from http://blog.mailchimp.com/de-dupe-lists-with-an-excel-formula/ (with modifications from Wenni)

To view the headers of a message do the following:

  1. In Outlook 2010, Open an existing email.
  2. Click on the File tab.
  3. Click Info.
  4. Click the Properties button.
  5. Review the Internet Headers. (To copy: Right-click in the field and click "Select All", right-click again to select copy)

In order to view the complete message source code of newly retrieved POP messages in Outlook 2007/2010:

  1. Log onto your PC with an administrator account.
  2. Open the "Start" menu, type "regedit" into the search field and hit "Enter." The Registry Editor tool will now launch.
  3. For Outlook 2007, Navigate to the "HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\Options\Mail" directory.
    OR
  4. For Outlook 2010, HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\Options\Mail
  5. Right-click in the open space on the right side of the window and choose to create a new "DWORD Value."
  6. Create a new DWord value and enter "SaveAllMIMENotJustHeaders" as the name of the new value.
  7. Double-click on the new value, set the value as "1" and then press "OK"
  8. Close the Registry Editor and open Outlook.
  9. Right-click on the message whose source code you want to view and select "Message Options." The full source code of the message will now be viewable in the pop-up window that appears.

Above information is from http://superuser.com/questions/390806/how-can-i-view-the-entire-source-code-of-an-email-in-outlook-2010

Ever get an excel spreadsheet and you need to remove the last character of the cell?

Use this following formula:

=left(A1,Len(A1)-1)