Monthly Archives: October 2014

CSV to SQL Converter

Microsoft excel can’t seem to export csv with double quotes anymore =_=, can’t import csv directly using phpmyadmin. Found this really site that helps to make the conversion from csv to mysql statements. http://www.convertcsv.com/csv-to-sql.htm

Posted in database | Tagged , | Comments Off on CSV to SQL Converter

mysql: Change character encoding for database and tables

http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8 Use the ALTER DATABASE and ALTER TABLE commands. ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; If not possible, Export structure and data with phpmyadmin Custom – display all … Continue reading

Posted in database | Tagged , | Comments Off on mysql: Change character encoding for database and tables

Excel: Delete blank rows quickly, change numbers to text

Source: http://www.theexceladdict.com/_t/t031008.htm Change number to text Format Cells > Number > Custom > 0 Suppose you receive a list of data that contains blank rows that you want to remove without affecting the order of the list. This technique will … Continue reading

Posted in Excel | Tagged | Comments Off on Excel: Delete blank rows quickly, change numbers to text

Prestaship 1.3 Force default currency for checkout

Source: http://www.prestashop.com/forums/topic/9473-module-force-currency/ Note: Error in amount shown in store owner email but is correct in customer email. Use with caution. in init.php before: $currency = Tools::setCurrency(); add: $cookie->id_currency = intval(Configuration::get(‘PS_CURRENCY_FRONT_DEFAULT’)); in admin/tabs/AdminCurrencies.php after: ‘PS_CURRENCY_DEFAULT’ => array(‘title’ => $this->l(‘Default currency:’), ‘desc’ … Continue reading

Posted in ecommerce | Tagged , | Comments Off on Prestaship 1.3 Force default currency for checkout