[MAGENTO] Magento Database Optimization and log cleaning Functionality

Smart Tricks

Magento is heavy on web servers because of its vast and secured modular structure. An eCommerce system must have powerful tracking system which can track customer activities and orders and other relevant data tracking and Magento have all this functional and storing every information in MySQL different database tables in form of logs. Magento have around 10 logs tables which needs to be optimized periodically.

10 Log tables are:
log_customer
log_visitor
log_visitor_info
log_url
log_url_info
log_quote
report_viewed_product_index
report_compared_product_index
report_event
catalog_compare_item

To Magento database log cleaning and optimizing through admin panel step by step:

STEP 1: Login in to admin Panel.
STEP 2: Go to system->configurations.
STEp 3: Go to left side tab “system”(Under advanced).
STEP 4: GO to right content Log Cleaning.
STEP 5: Enable it.
STEP 6: Donot forget to give email id(For notification of any fault during log cleaning process).

Its an automated optimizations.
If you want to do…

View original post 26 more words

Advertisements

Create custom fields in magento like textarea, multi select box, File dialog, date, dependent text fields in system.xml file magento admin panel.

jmsoni

<config>
<tabs>
<exportcustomerdetails translate=”label”>
<label>Export Customer Details</label>
<sort_order>250</sort_order>
</exportcustomerdetails>
</tabs>
<sections>
<exportcustomers translate=”label” module=”exportcustomers”>
<label>Export Customer Details Setting</label>
<tab>exportcustomerdetails</tab>
<frontend_type>text</frontend_type>
<sort_order>300</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>

<groups>
<enableexportcustomers translate=”label”>
<label>Export Customer Details </label>
<frontend_type>text</frontend_type>
<sort_order>300</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
<!–<fields>
<multiple_dropdown translate=”label comment”>
<label>Select Fields </label>
<comment>Select fields which you want to export</comment>
<frontend_type>multiselect</frontend_type>
<source_model>ExportCustomerDetails_ExportCustomers_Model_Customerfields</source_model>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
</multiple_dropdown>
</fields>–>
<comment><![CDATA[This is a <strong>global comment</strong> about my <em>configuration</em>.<br />You can specify <u>custom html</u> tags. <a href=”http://www.bubblecode.net/en” target=”_blank”>Click here for example!</a>]]></comment>
<fields>
<text_field translate=”label comment”>
<label>Text Field</label>
<comment>Text field with store view scope.</comment>
<frontend_type>text</frontend_type>
<sort_order>10</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</text_field>
<textarea translate=”label comment”>
<label>Textarea</label>
<comment>Textarea with store view scope.</comment>
<frontend_type>textarea</frontend_type>
<sort_order>20</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</textarea>
<!–<dropdown translate=”label comment”>
<label>Dropdown</label>
<comment>Dropdown with global scope.</comment>
<frontend_type>select</frontend_type>
<source_model>jr_customconfigexample/system_config_source_dropdown_values</source_model>
<sort_order>30</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
</dropdown>–>
<multiple_dropdown translate=”label comment”>
<label>Select Fields </label>
<comment>Select fields which you want to export</comment>
<frontend_type>multiselect</frontend_type>
<source_model>ExportCustomerDetails_ExportCustomers_Model_Customerfields</source_model>
<sort_order>40</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>0</show_in_website>
<show_in_store>0</show_in_store>
</multiple_dropdown>
<file translate=”label comment”>
<label>File</label>

View original post 96 more words

Google lists 127 of the best Android apps in the world, and you need to try them all

BGR

If you were gifted a new Android device last week for Christmas and you’re having trouble figuring out where to begin, today is your lucky day. In fact, even if you’re a seasoned Android veteran, today is still your lucky day because Google has gone through the hundreds of thousands of apps in its Google Play app store and cherry picked the cream of the crop. The result is a list of 127 Android apps that Google has deemed to be “must-have” apps, and old and new Android users alike should check them all out.

The best part, by the way, is that they’re almost all completely free.

View original post 208 more words

The Enormous Implications Of Facebook Indexing 1 Trillion Of Our Posts

Gmail Now Even More Inaccessible In China

About Magento 2.0 developer documentation

Alan Kent's Blog

With Magento 2 dev beta we also launch documentation in GitHub. Here is a bit more info for those interested.

Hi everybody, this is Bradburn Young with a guest post. Thanks to Alan for lending me his space to talk to you here.

I lead a team of technical writers here at Magento. We publish Magento 2.0 developer documentation, and I’m writing the community of Magento developers to let you know that we’d like to hear from you. We rely sincerely on the understanding and experience of our developer community to help us shape documents that make your work easier to do. I’m going to tell you about a step we’ve taken to make it simpler for you to talk directly to us.

For the Developer Beta release, we’ve moved our documentation from the old public wiki to a new location and platform, http://devdocs.magento.com. Below are some basic questions and…

View original post 526 more words

how to send email to customer programmatically in magento?

jmsoni

<?php
$templateId = 11;

// Set sender information
$senderName = Mage::getStoreConfig(‘trans_email/ident_support/name’);
$senderEmail = Mage::getStoreConfig(‘trans_email/ident_support/email’);
$sender = array(‘name’ => $senderName,
’email’ => $senderEmail);

// Set recepient information
$recepientEmail = $email;
$recepientPassword = $randomString;

// Get Store ID
$store = Mage::app()->getStore()->getId();

// Set variables that can be used in email template
$vars = array(‘customer’ => $recepientEmail,
‘cust’ => $recepientPassword);

$translate = Mage::getSingleton(‘core/translate’);

// Send Transactional Email
try{
Mage::getModel(‘core/email_template’)->sendTransactional($templateId, $sender, $recepientEmail, $recepientPassword, $vars, $storeId);
}
catch(Exception $e){
print_r($e);
}
?>

View original post