Heather Mello

Here is an example on how I extracted email address from a mail log file: $subject = "1 Aug 5 13:26:20 269701-web1 postfix/smtp[20033]: E730B10582C3: to=, relay=gmail-smtp-in.l.google.com[74.125.91.27]:25, delay=1.4, delays=0.02/0.01/0.13/1.3, dsn=2.0.0, status=sent (250 2.0.0 OK 1312568780 fp10si6690298qab.63) 1 Aug 5 13:30:49 269701-web1 postfix/smtp[20753]: F06EF10582C3: to= , relay=mx4.hotmail.com[65.55.92.136]:25, delay=0.28, delays=0.02/0/0.1/0.15, dsn=2.0.0, status=sent (250 <20110805183048.F06EF10582C3@269701-web1.www.bloom.com> Queued mail for delivery) 1 Aug 5 13:34:13 269701-web1 postfix/smtp[20822]: 5121410582C3: to=, relay=mx1.labcorp.iphmx.com[68.232.129.161]:25, delay=0.91, delays=0.01/0/0.42/0.47, dsn=2.0.0, status=sent (250 ok: Message 21101182 accepted) 1 Aug 5 13:34:14 269701-web1 postfix/smtp[20822]: 75C8610582C3: to=, relay=mx2.labcorp.iphmx.com[68.232.129.150]:25, delay=1, delays=0.02/0/0.49/0.54, dsn=2.0.0, status=sent (250 ok: Message 22975937 accepted) 1 Aug 5 13:44:53 269701-web1 postfix/smtp[21625]: 84B5B10582C3: to=, relay=gmail-smtp-in.l.google.com[74.125.91.27]:25, delay=1.7, delays=0.01/0/0.27/1.4, dsn=2.0.0, status=sent (250 2.0.0 OK 1312569893 ef1si6693357qab.35) ";

function extract_emails_from($string){
  preg_match_all("/[\._a-zA-Z0-9-]+@[\._a-zA-Z0-9-]+/i", $string, $matches);
  return $matches[0];
}

Make sure you cd into the folder you want to delete all the contents $rm -rf * ( hit enter ) That should remove any contents in that folder you are currently in

// sort an object by key

function sort_object_by_key( $obj, $order='' )
{
    $tmp = array();
    // deconstruct the object into an array
    foreach( $obj as $key => $val )
    {
        $tmp[$key] = '';
    }
   // sort the array
    if($order == 'DESC')
    {
        krsort( $tmp );
    }
    else
    {
        ksort( $tmp );
    }        

rsync is a software application for Unix and Windows systems which synchronizes files and directories from one location to another while minimizing data transfer using delta encoding when appropriate. An important feature of rsync not found in most similar programs/protocols is that the mirroring takes place with only one transmission in each direction. rsync can copy or display directory contents and copy files, optionally using compression and recursion. In daemon mode, rsync listens on the default TCP port of 873, serving files in the native rsync protocol or via a remote shell such as RSH or SSH. In the latter case, the rsync client executable must be installed on both the local and the remote host. I use rsync a lot specially to backup my important files between two computers, but also to keep my local slackware repository up to date. rsync is great to keep folders and files synchronized between two computers or in the same computer, you can backup all your important data to an external disk using rsync. rsync uses Copy files with rsync From local to remote computer rsync --progress --partial -avz /folder/to/copy/ user@remote.server:/remote/folder This will copy all files in /folder/to/copy/ to /remote/folder in the remote server, the folder copy itself will not be created in the remote computer, and only its contents will be copied, if you want the folder itself to also be created and then its contents copied inside the newly created copy folder, use this command. rsync --progress --partial -avz /folder/to/copy user@remote.server:/remote/folder Note the trailing slash after copy that makes the difference. The rest of options are: progress: will show the percentage of the file copied partial: tells rsync to

/var/log/maillog/ $ grep "status=sent" /var/log/maillog | grep "Aug 5" | wc -l Will return the number of emails

Create tape archives and add or extract files. Syntax tar c [ bBeEfFhiklnopPqvwX [ 0-7 ] ] [ block ] [ tarfile ] [ exclude-file ] {-I include-file | -C directory | file | file } tar r [ bBeEfFhiklnqvw [ 0-7 ] ] [ block ] {-I include-file | -C directory | file | file } tar t [ BefFhiklnqvX [ 0-7 ] ] [ tarfile ] [ exclude-file ] {-I include-file | file } ... tar u [ bBeEfFhiklnqvw [ 0-7 ] ] [ block ] [ tarfile ] file ... tar x [ BefFhiklmnopqvwX [ 0-7 ] ] [ tarfile ] [ exclude-file ] [ file ... ] c Create. Writing begins at the beginning of the tarfile, instead of at the end. r Replace. The named file s are written at the end of the tarfile. A file created with extended headers must be updated with extended headers (see E flag under Function Modifiers). A file created without extended headers cannot be modified with extended headers. t Table of Contents. The names of the specified files are listed each time they occur in the tar file. If no file argument is given, the names of all files in the tarfile are listed. With the v function modifier, additional information for the specified files is displayed. u Update. The named file s are written at the end of the tarfile if they are not already in the tar file, or if they have been modified since last written to that tarfile. An update can be rather slow. A tarfile created on a 5.x system cannot be updated on a 4.x system. A file created with extended headers must be updated with extended headers (see E flag under Function Modifiers). A file created without extended headers cannot be modified with extended headers. x Extract or restore. The named file s are extracted from the tarfile and written to the directory specified in the tarfile, relative to the current directory. Use the relative path names of files and

From command line: $ dstat -f This will show a great report in color for your system in real time.

sar - Collect, report, or save system activity information. From command line: $ sar -b This command shows the amount of traffic and you can check for spikes in traffic

You may need to sudo: From terminal: $ /etc/init.d/httpd stop $ /etc/init.d/httpd start $ /etc/init.d/httpd restart

Using terminal: $ cd /var/log/httpd/ $ tail -f access_log | grep 64.24.44.47 The -f means run continually until you hit Control - C to stop it ( the ip can be whatever your filtering the results to if your interested in an IP's traffic ) Drop the | grep and the IP if you want all traffic $ tail -f access_log

find /opt/wherever/you/want/to/search -type f -name *.jpg -ls You might have to do it a few times for different file types. Or you can just leave the "-name *.jpg" part out and it will just give you your report on ALL of your files. If you don't like full bytes you could pipe some commands together..... find /opt/wherever/you/want/to/search -type f -name *.jpg | awk '{system("ls -lh \""0"\"")}' Thanks Dave for this tidbit of information!

If you are not using Magento's email invite function because its not what you need. If you want a share link that your customers can post on a blog, or on their web site and when they click the link and sign up, they are going to be set up as an invited friend. This takes advantage of Magento's native invite functionality, but using a different way to connect. Magento has an invite email that you can use, but there are times when that is not enough. This tutorial will help you understand how I adjusted to this task. Part I - Create a .htaccess Part II - Create the module Part III - Create the observer Part IV - What your code may look like to get it on a page in Magento

How to tell if your on the home page in magento or not

Or you can try this:

$routeName = Mage::app()->getRequest()->getRouteName(); $identifier = Mage::getSingleton('cms/page')->getIdentifier(); if($routeName == 'cms' && $identifier == 'home') { echo 'You are in Homepage!'; } else { echo 'You are NOT in Homepage!'; }

Using terminal: $ grep --color=auto -Ri "page.xml" *

 --color=auto will color the findings

-R will do a recursive search

-i is case insensitive

                    

                
                    Read more                
            
                                            

                Posted in                                    Development                            
                                                    

Using Terminal: $ mail ( enter ) $ delete * ( enter ) Thats it you can type : $ h ( enter ) to verify they are all removed

Here, I will show you, how you can change your order status programmatically (with PHP coding). First, you need to load your order. If you have order id, you can load order in the following way:-

$orderId = YOUR_ORDER_ID;
$order = Mage::getModel('sales/order')
				->load($orderId);

If you have order increment id, you can load order in the following way:-

$orderIncrementId = YOUR_ORDER_INCREMENT_ID;
$order = Mage::getModel('sales/order')
				->loadByIncrementId($orderIncrementId);

Now, here is the code to change order status:-

/**
 * change order status to 'Completed'
 */
$order->setState(Mage_Sales_Model_Order::STATE_COMPLETE, true)->save();

Similarly, you can change the order status to pending, processing, canceled, closed, holded, etc.

3 Steps to create a custom observer. These instructions are to create an observer when a customer is in the process of checking out, and we are "Observing" the Save shipping piece. This was needed for a project that we are appending to the Gift Message feature for magento. We are adding some text to every order that passes through regardless if the user entered something or not. For this project I have a Website called Bloom Step 1: create the module xml In /app/etc/modules create an xml file called Bloom_Checkout.xml In this new file add the following:

<?xml version="1.0"?>

You can recover MySQL database server password with following five easy steps.

Step # 1: Stop the MySQL server process.

Step # 2: Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password.

Step # 3: Connect to mysql server as the root user.

Step # 4: Setup new mysql root account password i.e. reset mysql password.

Step # 5: Exit and restart the MySQL server. Here are commands you need to type for each step (login as the root user):

Step # 1 : Stop mysql service # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld.

Step # 2: Start to MySQL server w/o password: # mysqld_safe --skip-grant-tables & Output: [1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started

Step # 3: Connect to mysql server using mysql client: # mysql -u root Output: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>

mysql -h 10.100.10.5 -u replicationusername -p'enteryourpasswordhere'

find . -name "*.js" | xargs ls -goh | cut -b 1,13-128 You can do the same thing for css: find . -name "*.css" | xargs ls -goh | cut -b 1,13-128

// Load by name $_category = Mage::getModel('catalog/category')->loadByAttribute('name', 'Ruby Ring'); $_product = Mage::getModel('catalog/product')->loadByAttribute('name', 'emerald earring'); // Load by SKU $_product = Mage::getModel('catalog/product')->loadByAttribute('sku', 'Eram18j4'); //Load by ID (just load): $_product = Mage::getModel('catalog/product')->load($productID);

substr('abcdef', 0, 4);

I found a solution for anyone who needs it.

Because Magento has a fallback hierarchy, you can easily override the customer session class without modifying core code.

1. Locate and copy this file

and insert it into this directory structure

Example 1:

Example 2:

or

Example 3 (origional image without resize):

As a standalone component, Zend_Layout does not offer nearly as many features or as much convenience as when used with the MVC. However, it still has two chief benefits:

• Scoping of layout variables.

• Isolation of layout view script from other view scripts.

Scenario: You have created a custom module. You have entered certain data in your database. You need to show the data randomly. Solution: In MySQL the rand() function helps the select query to fetch data randomly. In Magento, you can select random rows from MySQL table using Zend_Db_Expr(‘RAND()’). You have to create a new function in your module’s collection class

(YourNamespace/YourModule/Model/Mysql4/YourModule/Collection.php)

public function setRandomOrder()
{
    $this->getSelect()->order(new Zend_Db_Expr('RAND()'));
    return $this;
}

Now, you can fetch random data from your table using the above create setRandomOrder function. The code below can be kept in the block or template (.phtml) file of your module.

$collection = Mage::getModel('yourmodule/yourmodule')

Well, I just did another install of Magento and as a Magento developer I always wanted to know roughly how many files and folders are in that. I did do some custom work to this install, so these number are slightly higher than whats in a fresh install but its rather impressive: First here is the command I ran: for t in files links directories; do echo `find . -type ${t:0:1} | wc -l` $t; done 2> /dev/null The output showed: 20384 files 0 links 5165 directories Now thats a lot of files and folders!

To get all items in remote folder

rsync -v -r --exclude-from 'exclude-sample.txt' -e ssh user@192.168.1.1:/path/to/remote/folder/ /path/to/local/computer/folder/

To only get new items from remote folder:

rsync -vru -e ssh dev@192.168.1.1:/path/to/remote/folder/ /path/to/local/computer/folder/

To show the progress of the transfer

rsync -e ssh user@192.168.1.1:/path/to/remote/file/ /path/to/local/computer/folder/ --progress

SET FOREIGN_KEY_CHECKS=0; -- reset customers TRUNCATE customer_address_entity;

TRUNCATE customer_address_entity_datetime; TRUNCATE customer_address_entity_decimal;

TRUNCATE customer_address_entity_int; TRUNCATE customer_address_entity_text;

TRUNCATE customer_address_entity_varchar; TRUNCATE customer_entity;

TRUNCATE customer_entity_datetime; TRUNCATE customer_entity_decimal;

TRUNCATE customer_entity_int; TRUNCATE customer_entity_text;

TRUNCATE customer_entity_varchar; TRUNCATE log_customer;

TRUNCATE log_visitor; TRUNCATE log_visitor_info;

ALTER TABLE customer_address_entity AUTO_INCREMENT=1;

ALTER TABLE customer_address_entity_datetime AUTO_INCREMENT=1;

ALTER TABLE customer_address_entity_decimal AUTO_INCREMENT=1;

ALTER TABLE customer_address_entity_int AUTO_INCREMENT=1;

ALTER TABLE customer_address_entity_text AUTO_INCREMENT=1;

ALTER TABLE customer_address_entity_varchar AUTO_INCREMENT=1;

ALTER TABLE customer_entity AUTO_INCREMENT=1;

Have you ever wanted to know how to put a time on the adminhtml Form.php

               $dateFormatIso = Mage::app()->getLocale()->getDateTimeFormat(
            Mage_Core_Model_Locale::FORMAT_TYPE_SHORT
        );

        $fieldset->addField('date_start', 'date', array(
            'label'        => Mage::helper('enterprise_catalogevent')->__('Start Date'),
            'name'         => 'date_start',
            'required'     => true, 
            'time' => true,
            'image'        => $this->getSkinUrl('images/grid-cal.gif'),
            'format'       => $dateFormatIso
        ));

The magic is the 'time' line. By adding , 'time' => true, it puts the time at the bottom of the calendar.

Feel free to checkout our Magento support if you would like some help with this.

$ set @@long_query_time = 5; $ SET GLOBAL long_query_time=5;

top -o cpu -O +rsize -s 5 -n 20

watch 'more mysqld-slow.log | grep Query_time | wc -l; more mysqld-slow.log | grep Query_time;' This can be helpful if your trying to debug slow queries or just capture them as they come in.

This can have many causes as your search through the internet has obviously found. My problem with this particular issue was I had my products setup properly, so it was not the fact that it was out of stock. This site almost had me excited but only to find out my product creation script already took care of it: http://zaclee.net/magento/errors-magento/stock-item-for-product-is-not-valid So, after some hard core searching, I found that I was not using the proper product object. The only way I could get my auto add to cart working was to use this $product = Mage::getModel('catalog/product')->load($product_id); I had a different product object, ( loading by the sku ) and apparently you can not use that type of object to add items to the cart. 5 hours of my life lost, hopefully to spare yours.

find . -name ".svn" -exec rm -rf {} \;

Lest say you have a need in your Magento store to have an "auto add to cart". This would be in situations where maybe you provide a free sample if they purchase a specific product, or maybe you will attach a warranyt sku to specific products automatically. However, this item your adding to the magneto cart has custom options! This can be tricky. Here is an example function I use when I run into this situation.

 
    protected function _saveCustomOption($product_id, $product, $qty)
    {
        // Load up a product that has the custom options and get the attributes, in this case we just have one custom option
       // This custom option is a text field and our end goal is to populate that with sku-product name
        $_product   = Mage::getSingleton('catalog/product')->load($product_id);
        $attrs      = $_product->getOptions();
        foreach($attrs as $attr)
        {
           // Loop through all the custom options ( once again we only have one in our scenario ) and assign the values we need        

If you have ever received a message similar to:

The host has been blocked because of too many authentication failures.

Fear not, just restart the service and you can log back in again! $ /etc/init.d/webmin stop ( hit enter ) $ /etc/init.d/webmin start ( hit enter ) Viola, service running and you can log back in again.

If you are looking at the view source of your zend framework page, and you notice that your external javascript files and your external css files are being included many times, its because you have echo in front of each line:

<?php  echo $this->headLink()->prependStylesheet($this->serverUrl().'/css/style.css'); ?>
 <?php echo $this->headLink()->prependStylesheet($this->serverUrl().'/css/colorbox.css'); ?>
 <?php echo $this->headScript()->appendFile($this->serverUrl().'/js/jquery.1.7.2.js') ?>
 <?php echo $this->headScript()->appendFile($this->serverUrl().'/js/oe.js') ?>
 <?php echo $this->headScript()->appendFile($this->serverUrl().'/js/colorbox/jquery.colorbox-min.js') ?>
 <?php echo $this->headLink()?>
 <?php echo $this->headScript()?>

The way to remove the css and  javascript files from being included many times is to do the echo on the headLink() and headScript() after you have set the files and just echo one line:

If you have Magneto 1.0.7.2 and your tired of being logged out of the admin area every few minutes, to adjust that setting: System->Configuration->Admin In the security section, change that to 86400 if you want it to be 1 day, or any value over 60. This will extend your admin time before your logged out! Life is good again!

for user in $(cut -f1 -d: /etc/passwd); do crontab -u $user -l; done

$store_id = Mage::app()->getStore()->getStoreId();

Base Directory: Mage::getBaseDir() Mage::getBaseDir(‘base’) /var/www/magento/ App: Mage::getBaseDir(‘app’) /var/www/magento/app/ Code: code Mage::getBaseDir(‘code’) /var/www/magento/app/code Design: design Mage::getBaseDir(‘design’) /var/www/magento/app/design/ Etc: etc Mage::getBaseDir(‘etc’) /var/www/magento/app/etc Lib: lib Mage::getBaseDir(‘lib’) /var/www/magento/lib Locale: locale Mage::getBaseDir(‘locale’) /var/www/magento/app/locale Media: media Mage::getBaseDir(‘media’) /var/www/magento/media/ Skin: skin Mage::getBaseDir(‘skin’) /var/www/magento/skin/ Var: var Mage::getBaseDir(‘var’) /var/www/magento/var/ Tmp: tmp Mage::getBaseDir(‘tmp’) /var/www/magento/var/tmp Cache: cache Mage::getBaseDir(‘cache’) /var/www/magento/var/cache Log: log Mage::getBaseDir(‘log’) /var/www/magento/var/log Session: session Mage::getBaseDir(‘session’) /var/www/magento/var/session Upload: upload Mage::getBaseDir(‘upload’) /var/www/magento/media/upload Export: export Mage::getBaseDir(‘export’) /var/www/magento/var/export

tar -cvfz mytarfilename.tgz /path/to/directory/to/tarball/

Magento Settings: System >> Configuration >> System > ‘Cron (Scheduled Tasks)’ tab.

• Generate schedules every: 60
• Schedule ahead for: 1
• Missed if not run within: 60
• History cleanup every: 120
• Success history lifetime: 120
• Failure history lifetime: 120

$ crontab -e 

# Execute the Magneto cron every 15 minutes
*/15 * * * * /bin/sh /path/to/magento/cron.sh 

$ yum update;

Get the NFS parts needed

$ yum install nfs-utils and yum install nfs-utils-lib;

$ yum install subversion

$ mkdir /var/nfs/

$ chmod -R 777 /var/nfs/

$ cd /var/nfs/

$ svn checkout http://wherever.yourcode.com/ /var/nfs/

$ showmount -e 192.168.1.1

This will show the available mounts from the /etc/exports

Here is the example output

Export list for 192.168.1.1:
/var/nfs 192.168.1.100,192.168.1.101

So you want to get the table name that is declared in the xml and you are not in an upgrade/install script.

If you were in an upgrade/install script you could just use: 

$tbl = $this->getTable('catalog/product');

In any other page you can use:

$tbl = Mage::getSingleton('core/resource')->getTableName('catalog/product');

If this will return: catalog_product_entity

This works with any declaration that is set in the xml!

This is all the steps and details i used to create an instance of a web server to be used for a Magento Website.

1 - Start a m3.xlarge instance

2 - Make sure its part of a security group that has Ports 80, 443 open to all 0.0.0.0/0

3 - Add a SSH port execption for your IP

4 - Assign an Elastic IP to each new instance

5 - Get the ssh details from Connect Instance in the Amazon control panel and ssh into the device(s)

6- Change the date/time of the server

Magento form validation, text validation, url validation

Read more

Posted in Development

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Real World example:

update catalog_product_entity_text set value = replace(value,'®','&reg;');

If you have a new magento installation, and you notice that the join process takes a very long time to complete, your sendmail is probably the source.

Some new servers dont have sendmail setup properly and you need to adjust a few things.

For slow email from the app, edit 3 files.
1)  /etc/resolv.conf, add search whateveryourdomainnameis.com in before the nameservers.

[root@Web1 etc]# cat /etc/resolv.conf
search winetapsocial.com
nameserver 114.243.44.83
nameserver 114.243.44.84

If you have ever needed to rewrite/overload a core magento Model.

Its actually pretty easy

Step 1: create the module instantiation file

app/etc/modules/Russellalbin_Sales.xml

<?xml version="1.0"?>
<config>
 <modules>
 <Indiebooker_Sales>
 <active>true</active>
 <codePool>local</codePool>
 </Indiebooker_Sales>
 </modules>
</config>

Here is how you can get a product reviewed by a customer in Magento

$storeId = Mage::app()->getStore()->getId();

$customer_reviews = Mage::getModel('review/review')
 ->getResourceCollection()
 ->addStoreFilter($storeId)
 ->addEntityFilter('product', $product_id)
 ->addFieldToFilter('customer_id', array('eq' =>$customer->getData('id')));

UPDATE invoice
   SET invoice_date2 = FROM_UNIXTIME(invoice_date) WHERE invoice_date > 0;

UPDATE invoice
   SET estimated_date2 = FROM_UNIXTIME(estimated_date) WHERE estimated_date > 0;

UPDATE invoice
   SET completed_date2 = FROM_UNIXTIME(completed_date) WHERE completed_date > 0;

UPDATE lawn_contract
  SET lawn_contract_date2 = FROM_UNIXTIME(lawn_contract_date) WHERE lawn_contract_date > 0;

UPDATE tree_shrub
SET estimated_date2 = FROM_UNIXTIME(estimated_date) WHERE estimated_date > 0;

UPDATE lawn_contract
SET estimated_date2 = FROM_UNIXTIME(estimated_date) WHERE estimated_date > 0;