Clever software solutions to everyday challenges
Last week I told a client he could send me a file in excel and I could import that into the mysql database directly. When I got the file I learned that it wasn’t quite that easy. I had planned to just save it as tab delimited text or CSV, but there was a “description” …
Continue reading “How to Convert Excel Spreadsheets to SQL Statements”
originally posted at http://www.goodfeelingplace.com/how-to-add-special-shipping-by-product-in-zen-cart I am in the process of migrating a static site (peacemonger.org) to a database driven site “powered by” zen cart. One of the features requested was the ability to add special shipping charges for odd shaped items, like posters. After doing some research I discovered a page with instructions at http://tutorials.zen-cart.com/index.php?article=190, …
Continue reading “How to add special shipping by product in Zen Cart”
originally posted at http://www.goodfeelingplace.com/how-to-import-and-export-large-datasets-in-mysql I’ve seen many questions around the importing and exporting of large tables and/or databases in mysql, so I’d like to share how I’ve learned to manage those processes. Using phpmyadmin for these tasks is not suitable because web servers are not designed for running large scripts or uploading/downloading large files. You …
Continue reading “How to import and export large datasets in mysql”
originally posted at http://www.goodfeelingplace.com/free-mdb-file-to-mysql-conversion This week I created a pretty useful tool I’d like to share. I was given an MS Access file (.mdb) and I needed a way to transfer the structure and the data into a MySQL database. I don’t have MS Access and I have no plans to purchase it, so I …