Archive: bulk

If you create a bash script for a long running process then you may decide its much better, or even essential, that this script is run using screen. Screen is a utility that allows you to run things in a detachable terminal on the server, so you are not reliant on your own machine maintaining [...]

If you need to update a large number of rows on a single table then your first reaction may be to write a loop that updates one row at a time. Of course if the table is large then this can result in a very large number of SQL queries. Taking a bit of inspiration [...]

If you need to change the character set and collation for all columns and tables on an entire database then check out this little PHP script. It's currently Zend Framework based, though only for the database adapter - you could easily modify this to suit your own database connection. PLAIN TEXT PHP: <?php /* collationChange [...]

If you need to do a bulk find and replace operation on a load of files within a particular folder structure, for example when refactoring some of your code, then instead of trying to use your IDE you could give this little app a try. It's called Regexxer: http://regexxer.sourceforge.net/ And is in the Ubuntu repositories [...]

Currently working on a project that requires some fairly complex integration between Magento and Mail Chimp. I'm really impressed with Mail Chimp so far - the API is really well documented and a pleasure to work on. A breath of fresh air compared to most API's that I have worked on before. It's amazing what [...]

I have recently been working on shoehorning a large amount of data into a Google Adwords account for a client. Looking at setting up unique ads for around 50k products (targeting in stock products only so this is just a slice of the full catalogue size). I have managed to figure my way around the [...]