Convert Open Office Spreadsheet Number formatted as text

Convert Open office Sheet cell is formatted as text. To re-enter all the data as number:-
1. Highlight all of the cells and use Format -> Cells to change the cell format to an appropriate number format.
2. With all of the cells still selected, go to the menu Edit -> Find & Replace
3. In the Search For box enter .* (period asterisk)
4. In the Replace with box enter &
5. Select More Options and check Current Selection Only and Regular Expressions
6. Click Replace All

Magento – Rename Admin login page

Step 1 – Change Path

Find the file local.xml – it is usually located in the app/etc/ directory under your Magento installation.

Locate the following code segment:-

  1. <admin>
  2.   <routers>
  3.     <adminhtml>
  4.       <args>
  5.         <frontName><![CDATA[admin]]></frontName>
  6.       </args>
  7.     </adminhtml>
  8.   </routers>
  9. </admin>

Now, replace admin with your new admin URL. This should be something personal which is hard to guess, use only letters or numbers – no special characters, then save the file


Step 2 – Refresh Cache

In SSH/ Terminal, navigate to /var/ cache in the Magento install directory. Run:-

rm -rf *

Step 3 – Visit the new URL in your web Browser

Magento install error – Exception printing is disabled

Here is a known error which can occur when installing Magento:

There has been an error processing your request
Exception printing is disabled by default for security reasons.
Error log record number: XXXXXXXXXXXXXXX

Here is the solution:

  1. Navigate to the “errors” folder.
  2. Change local.xml.sample to local.xml
  3. You should now see a new list of crazy errors all over the Magento page – this is okay.
  4. Open magento/lib/Zend/Cache/Backend/File.php and look for:
    protected $_options = array(
    ‘cache_dir’ => ‘null’,
  5. Change it to:
    protected $_options = array(
    ‘cache_dir’ => ‘tmp/’,
  6. Save it.
  7. Now the final step is to go create a tmp folder in the root Magento folder.
  8. That’s it.