-
Recent Posts
Recent Comments
Archives
- August 2020
- March 2020
- December 2019
- July 2019
- June 2019
- May 2019
- March 2019
- August 2018
- July 2018
- May 2018
- March 2018
- September 2017
- August 2017
- May 2017
- April 2017
- January 2017
- November 2016
- October 2016
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- November 2015
- October 2015
- September 2015
- August 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
Categories
Meta
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
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 mysql, phpmyadmin
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
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 prestashop, prestashop 1.3
Comments Off on Prestaship 1.3 Force default currency for checkout