You lost your leading zeros of your varchars importing/exporting your data. You have this example data in your table storagebins: area = L, row = 1, rack = 2, shelf = 3 and it is supposed to look like this area = L, row = 001, rack = 02, shelf = 03 Use this SQL [...]
Author Archive
November 7, 2011 by marco · Leave a Comment
Filed under: Snippets, mySQL
Social Tagging: mySQL • script
Filed under: Snippets, mySQL
Social Tagging: mySQL • script
November 1, 2011 by marco · Leave a Comment
Filed under: Snippets, VBA, mySQL
Social Tagging: development • mySQL • script
Filed under: Snippets, VBA, mySQL
Social Tagging: development • mySQL • script
I used this hacked Excel-Macro to convert all dates in a selected range from a manual data import using Excel to generate all required INSERTs for our MySql database from 03.08.2011 16:51:01 to 2011-08-03 16:51:01 In case you wonder, where you can find your Visual-Basic editor and execute your VBA-code… follow these instructions. Here is [...]
June 11, 2011 by marco · Leave a Comment
Filed under: Running, Sports
Social Tagging: efficiency • running • technique
Filed under: Running, Sports
Social Tagging: efficiency • running • technique
I hope you geeks out there do any sports regularly despite the common prejudices. I do and I am getting a lot in return. Moving your body in a skilled way running, cycling, swimming, playing whatever is a form of intelligence, gives you new energy for your work, clears your mind and sometimes even delivers [...]
February 8, 2011 by marco · Comments Off
Filed under: Linux, Serverstuff, Tools
Social Tagging: development • Linux • php • Serverstuff • Tools
Filed under: Linux, Serverstuff, Tools
Social Tagging: development • Linux • php • Serverstuff • Tools
In order to prevent email delivery during development and log all email messages that would have been delivered, you can actually do a simple trick: Replace the file /usr/sbin/sendmail (on Ubuntu, use ‘locate sendmail’ to find it if it lies elsewhere) with this little shell-script, or rather make a _bak of the original and save [...]
November 2, 2010 by marco · Comments Off
Filed under: Links, Read-Write-Web, Snippets, Tools
Social Tagging: api • Tools
Filed under: Links, Read-Write-Web, Snippets, Tools
Social Tagging: api • Tools
If you are looking for a simple way to display lines like a roundtrip on a map, Google’s Static Maps API might be for you. Documentation and examples: http://code.google.com/intl/en-US/apis/maps/documentation/staticmaps/ Limits: – There is a query limit of 1000 unique (different) image requests per viewer per day. – URLs are restricted to 2048 characters. Here are [...]
October 19, 2010 by marco · Comments Off
Filed under: Linux, Snippets, Tools
Social Tagging: Linux • php • script • Tools
Filed under: Linux, Snippets, Tools
Social Tagging: Linux • php • script • Tools
If you have to deal with very old PHP4 legacy code containing every syntax crime you may know from the early years, how would you handle it? Give it to your junior people to fix it manually? I like to have at least some handy helpers for the first rough corrections. I found sed to [...]
September 30, 2010 by marco · Comments Off
Filed under: Linux, Productivity
Social Tagging: commandline • Linux • subversion
Filed under: Linux, Productivity
Social Tagging: commandline • Linux • subversion
Set ignore to all files of a directory with subversion: $ cd cache $ svn propset svn:ignore ‘*’ . $ svn ci . -m ‘Ignore set on cache dir.’ Show changed files between two revisions, overview $ svn diff -r 300:HEAD –summarize Show changed files between two revisions, for each revision: $ svn log -v [...]
June 24, 2010 by marco · Comments Off
Filed under: Mac, Snippets, Tutorials
Social Tagging: commandline • Serverstuff • Tools
Filed under: Mac, Snippets, Tutorials
Social Tagging: commandline • Serverstuff • Tools
This is a receipe how I save stuff to S3 from my Mac: 1.) Signup with S3: http://aws.amazon.com/s3/ (check pricing!). This will give you access to the AWS Management Console. 2.) Create a Bucket: This can be done via the AWS Management console. If you are not familiar with the concept of ‘buckets’ check-out the [...]
May 27, 2010 by marco · Comments Off
Filed under: Entrepreneurship
Social Tagging: culture • Inspiration
Filed under: Entrepreneurship
Social Tagging: culture • Inspiration
I recently came across an interesting table comparing typical mindsets of freelancers to those of entrepreneurs, which I immedately printed out and sticked to my refrigerator as a reminder. Since we currently have startup conditions too in our company, I know that it takes a lot of discipline to make adjustments to a mindset that [...]
I have recently been playing with the new MODx (‘Revolution’) and I must say, I love the concept and it’s flexibility. Just to make things easier for folks starting out with MODx or who migrate from MODx Evolution here are some recommended links. General: Download MODx Revolution: As of 06.04.2010 there is MODx Revolution 2.0.0-rc-1 available. MODx [...]
Just in case somebody has a similar problem… Coming mainly from MySql I had to deal with some MsSql/SQL Server specialties. Consider the following working SQL for MsSql: SELECT AK.AK_TEXT, BU.BUDGET_BEREICH ,TY.AKTIONSTYP_TEXT ,AK.AK_STARTDATUM ,AK.AK_ENDEDATUM FROM AKTIONEN AS AK WITH (nolock) LEFT JOIN BUDGET_TRAEGER AS BU ON AK.AK_BUDGET_NUMMER=BU.BUDGET_NUMMER LEFT JOIN AKTIONSTYP AS TY ON AK.AK_TYP=TY.AKTIONSTYP_TYP LEFT [...]
February 28, 2010 by marco · Comments Off
Filed under: Productivity, Software development
Social Tagging: agile • development
Filed under: Productivity, Software development
Social Tagging: agile • development
Since feedback is a form of communication, excessive feedback will have the effect like an explosion in communication paths and will eventually produce more noise than signal. Any feedback loop in the system must help facilitate the management of change and efficiently adapt requirements along the the way. If this is not the case for [...]
January 22, 2010 by marco · Comments Off
Filed under: Books, Software development
Social Tagging: agile • culture • development • Inspiration
Filed under: Books, Software development
Social Tagging: agile • culture • development • Inspiration
I have just received a new book: “Apprenticeship Patterns“: Skimming through the first pages I noticed the words in the 3rd column extending from the points in the 2nd column and thought, ‘Hmm, I have heard about these 2nd column points’… The following table popped up in my mind, which I would like to share [...]
January 18, 2010 by marco · Comments Off
Filed under: Problems, Snippets
Social Tagging: mySQL • php • script
Filed under: Problems, Snippets
Social Tagging: mySQL • php • script
We have just had the case of having ftp access to a site on a shared hosting LAMP webspace but needed also the database and mainly the database scheme to setup our own development-system for the app. This is actually very straight forward using the following snippet uploaded and executed on the webserver: <?php exec( ’mysqldump [...]
Recursively remove all .svn directories from a working copy: find . -name .svn -exec rm -rf {} \; Recursively remove all ._xyz-files (OSX meta file info) from your WebDav-Drive, set via hourly cron: find /var/data/ -name “._*” -exec rm {} \; Do not forget to set your path ;). Check for syntax-errors (lint) in all [...]
November 10, 2009 by marco · Comments Off
Filed under: Snippets, Software development, Tools, Tutorials
Social Tagging: commandline • script • subversion • Tools
Filed under: Snippets, Software development, Tools, Tutorials
Social Tagging: commandline • script • subversion • Tools
This is just a link to a very good tutorial on how to make your own SVN post-commit hook using a PHP script. It sends the following information via email: Committer name Commit message List of files edited Diff of changes made http://techchorus.net/writing-php-script-send-svn-commit-changeset-email-notification
October 29, 2009 by marco · Comments Off
Filed under: Softskills, Software development
Social Tagging: agile • development • team
Filed under: Softskills, Software development
Social Tagging: agile • development • team
I recently played the ballpoint game for the first time and was impressed… … how clearly it demonstrates the different phases of a team going through the ‘storming, norming and performing’-phases for everyone – even for management spectators. … how the iteration-rhythm helps to keep focus and increase the team performance to a very high and predictable level. … how easy it [...]
October 29, 2009 by marco · Comments Off
Filed under: Software development, Videos
Social Tagging: development • video
Filed under: Software development, Videos
Social Tagging: development • video
It is not brand new but still a very interesting talk: Robert Lefkowitz on open source software development methodologies with lots of nice anecdotes. Watch the 21min video: http://oscon.blip.tv/file/1108217/ Or listen to the audio: http://itc.conversationsnetwork.org/shows/detail3995.html
September 21, 2009 by marco · Comments Off
Filed under: Snippets, Tools
Social Tagging: commandline • php
Filed under: Snippets, Tools
Social Tagging: commandline • php
I just hacked together the following quick and dirty PHP-script to use the tidy-extension from the command line. Maybe somebody else needs something like this somewhere. Check the comment for details: <?php // // (a) Save this as tidy.php // (b) Call it from commandline like this: $ php tidy.php trashed.html > tidy.html // to [...]
Since one of my coolest (private) projects www.lsis.com somewhat lacks the expected amount of traffic, I would like to emphasize the core feature in this blobpost – just to make you aware of it or encourage you to tell your friends or have ideas to apply the concept to other areas. In short LSIS – [...]
RSS