Monthly Archives: July 2013

Integrating BitBucket with PivotalTracker

Posted on by
8

Problem

You would like to integrate your BitBucket git repository with your Pivotal Tracker issue tracker.

Solution

After creating your bitbucket git repository and pivotal tracker project, do the following.

  • Go to your Pivotal Tracker – Profile and copy your API Token
  • Go to your Bitbucket repository and click on the Administration link (top right corner)
  • From the Repository Details menu on the left select Services
  • From the Service drop down list select Pivotal Tracker
  • Add the Pivotal Tracker API Token that you copied earlier and save

You can now use commits that have a square bracker [#111111] with the pivotal issue ticket and update pivotal when making a commit

Exporting query results from MySQL

Posted on by
Reply

Problem

You would like to export some query results from MySQL into a format that can be imported in LibreOffice, OpenOffice or Excel.

Solution

Try first with the default export options, as by doing a google search, there are a lot of different options for specifying field delimeters, lines terminated, etc.
So by not specifying any additional options the export is a tab delimited, linefeed-terminated file which should work in most of the programs.
So in order to do that you would need a folder in the MySQL server that should have write access. Usually /tmp should do. Then you can build your query and at the end add the INTO OUTFILE ‘/path’, like:

SELECT one,max(two) max_two,min(three) min_three 
FROM table 
WHERE one=1 
GROUP BY one 
INTO OUTFILE '/tmp/my_query.csv';

You can use any file ending but usually by specifying .csv the program that you will try to open will understand it.