You can use the `--since` and `--pretty` option of `git log`, for instance:

    git log --since=&quot;last month&quot; --pretty=format:&#39;%h,%an,%ar,%s&#39; &gt; log.csv


Refer to the PRETTY FORMATS section of the [Git log man page](https://git-scm.com/docs/git-log#_pretty_formats) for more options.

This command creates a formatted CSV containing hash,user,date/time,description,files changed,insertions,deletions

    git log --pretty=format:&#39;&quot;%h&quot;,&quot;%an&quot;,&quot;%aD&quot;,&quot;%s&quot;,&#39; --shortstat --no-merges | paste - - - &gt; log.csv

To add, if you want to apply date range, add --after or --before in this format &quot;yyyy-mM-d&quot;

    git log --before=&quot;2016-12-1&quot; --pretty=format:&#39;&quot;%h&quot;,&quot;%an&quot;,&quot;%ae&quot;,&quot;%aD&quot;,&quot;%s&quot;,&#39; --shortstat --no-merges | paste - - - &gt; log.csv

With `String.Format()` it is possible to format for example `DateTime` objects in many different ways. Every time I am looking for a desired format I need to search around on Internet. Almost always I find an example I can use. For example:

    String.Format(&quot;{0:MM/dd/yyyy}&quot;, DateTime.Now);          // &quot;09/05/2012&quot;

But I don&#39;t have any clue how it works and which classes support these &#39;magic&#39; additional strings.  

So my questions are:

 1. How does `String.Format` map the additional information `MM/dd/yyyy` to a string result?
 2. Do all Microsoft objects support this feature?  
    Is this documented somewhere?
 3. Is it possible to do something like this:  
    `String.Format(&quot;{0:MyCustomFormat}&quot;, new MyOwnClass())`

String.Format - how it works and how to implement custom formatstrings

I have a `Transfer` class, simplified it looks like this:

	public class Transfer
	{
		public virtual IFileConnection source { get; set; }
		public virtual IFileConnection destination { get; set; }

		public virtual void GetFile(IFileConnection connection, 
			string remoteFilename, string localFilename)
		{
			connection.Get(remoteFilename, localFilename);
		}

		public virtual void PutFile(IFileConnection connection, 
			string localFilename, string remoteFilename)
		{
			connection.Get(remoteFilename, localFilename);
		}

		public virtual void TransferFiles(string sourceName, string destName)
		{
			source = internalConfig.GetFileConnection(&quot;source&quot;);
			destination = internalConfig.GetFileConnection(&quot;destination&quot;);
			var tempName = Path.GetTempFileName();
			GetFile(source, sourceName, tempName);
			PutFile(destination, tempName, destName);
		}
	}

The simplified version of the `IFileConnection` interface looks like this:

	public interface IFileConnection
	{
		void Get(string remoteFileName, string localFileName);
		void Put(string localFileName, string remoteFileName);
	}

The real class is supposed to handle a `System.IO.IOException` that is thrown when the `IFileConnection` concrete classes loses connectivity with the remote, sending out emails and what not.

I would like to use Moq to create a `Transfer` class, and use it as my concrete `Transfer` class in all properties and methods, except when the `GetFile` method is invoked - then I want it to throw a `System.IO.IOException` and make sure the `Transfer` class handles it properly.

Am I using the right tool for the job?  Am I going about this the right way?  And how would I write the setup for that unit test for `NUnit`?


Mocking a method to throw an exception (moq), but otherwise act like the mocked object?

Is there a way to generate a git commit log for the last month, and export it as a CSV file? I&#39;m looking for something I can run from the command line, or a 3rd party app. I&#39;d like the following columns: author, date of commit, subject, file edited and hash.

How do I generate a git commit log for the last month, and export it as CSV?

<p>Is there a way to generate a git commit log for the last month, and export it as a CSV file? I'm looking for something I can run from the command line, or a 3rd party app. I'd like the following columns: author, date of commit, subject, file edited and hash.</p>


Is there a file or menu that will let me change the settings on how to deal with line endings?

I read there are 3 options:

1. **Checkout Windows-style, commit Unix-style**
  
 Git will convert LF to CRLF when checking out text files. When
 committing text files, CRLF will be converted to LF. For
 cross-platform projects, this is the recommended setting on Windows
 (&quot;core.autocrlf&quot; is set to &quot;true&quot;)

2. **Checkout as-is, commit Unix-style**
  
 Git will not perform any conversion when checking out text files.
 When committing text files, CRLF will be converted to LF. For
 cross-platform projects this is the recommended setting on Unix
 (&quot;core.autocrlf&quot; is set to &quot;input&quot;).

3. **Checkout as-is, commit as-is**
  
 Git will not perform any conversions when checking out or committing
 text files. Choosing this option is not recommended for cross-platform
 projects (&quot;core.autocrlf&quot; is set to &quot;false&quot;)

How to change line-ending settings

Is there a way to exclude certain paths/directories/files when searching a git repository using `git grep`? Something similar to the `--exclude` option in the normal `grep` command?

I need to use `git grep` because using `grep` directly runs too slowly on large git repositories. 

How to exclude certain directories/files from git grep search

I have a parameterized Jenkins job which requires the input of a specific Git branch in a specific Git repo.  Currently this parameter is a string parameter.

Is there any way to make this parameter a choice parameter and dynamically fill the drop down list with the Git branches?  I don&#39;t want to require someone to maintain this choice parameter by manually configuring the drop down every time a new branch is created.

Dynamically Fill Jenkins Choice Parameter With Git Branches In a Specified Repo

What would actually happen if I had a hash collision while using git?

E.g. I manage to commit two files with the same sha1 checksum,
would git notice it or corrupt one of the files?

Could git be improved to live with that, or would I have to change to a new hash algorithm?

(Please do not deflect this question by discussing how unlikely that is - Thanks)

Hash collision in git

I love git submodules.  Also, I hate git submodules.  What I love about them is how it enables to you to cleanly compartmentalize dependencies etc.  I get the point of having them point to a specific commit on a repo, I do.  But in my case, I&#39;m building a library that will be used in another project, so I want to keep it in that seperate repo.

However, the annoyance comes when I&#39;m working on a daily basis on this library and I constantly have to switch back to the app using my library to commit the pointer update.

So, is it possible to have a git submodule just always be on the head of the repo it&#39;s pointing at while I&#39;m constantly updating and adding to this library?


Force Git submodules to always stay current

I am writing a Java app to export data from Oracle to csv file

Unfortunately the content of data may quite tricky. Still comma is the deliminator, but some data on a row could be like this:

    | ID    |   FN    |   LN   |  AGE   |  COMMENT                   |
    |----------------------------------------------------------------|
    | 123   |  John   |  Smith |   39   | I said &quot;Hey, I am 5&#39;10&quot;.&quot;  |
    |----------------------------------------------------------------|

so this is one of the string on the `comment` column:

&gt;I said &quot;Hey, I am 5&#39;10&quot;.&quot;

No kidding, I need to show above comment without compromise in excel or open office from a CSV file generated by Java, and of course cannot mess up other regular escaping situation(i.e. regular double quotes, and regular comma within a tuple). I know regular expression is powerful but how can we achieve the goal with such complicated situation?


How to escape comma and double quote at same time for CSV file?

I&#39;m looking for a way to convert xlsx files to csv files on Linux.

I do not want to use PHP/Perl or anything like that since I&#39;m looking at processing several millions of lines, so I need something quick. I found a program on the Ubuntu repos called xls2csv but it will only convert xls (Office 2003) files (which I&#39;m currently using) but I need support for the newer Excel files.

Any ideas?

Convert xlsx to csv in Linux with command line

I have a table like this

    Value   String
    -------------------
    1       Cleo, Smith

I want to separate the comma delimited string into two columns

    Value  Name Surname
    -------------------
    1      Cleo   Smith

I need only two fixed extra columns 


How to split a comma-separated value to columns

I&#39;m using the pandas library to read in some CSV data.  In my data, certain columns contain strings.  The string `&quot;nan&quot;` is a possible value, as is an empty string.  I managed to get pandas to read &quot;nan&quot; as a string, but I can&#39;t figure out how to get it not to read an empty value as NaN.  Here&#39;s sample data and output

	One,Two,Three
	a,1,one
	b,2,two
	,3,three
	d,4,nan
	e,5,five
	nan,6,
	g,7,seven

    &gt;&gt;&gt; pandas.read_csv(&#39;test.csv&#39;, na_values={&#39;One&#39;: [], &quot;Three&quot;: []})
        One  Two  Three
    0    a    1    one
    1    b    2    two
    2  NaN    3  three
    3    d    4    nan
    4    e    5   five
    5  nan    6    NaN
    6    g    7  seven

It correctly reads &quot;nan&quot; as the string &quot;nan&#39;, but still reads the empty cells as NaN.  I tried passing in `str` in the `converters` argument to read_csv (with `converters={&#39;One&#39;: str})`), but it still reads the empty cells as NaN.

I realize I can fill the values after reading, with fillna, but is there really no way to tell pandas that an empty cell in a particular CSV column should be read as an empty string instead of NaN?

Get pandas.read_csv to read empty values as empty string instead of nan

How do i simply write out a file including real tabs inside? `tab` means real `tab` which is **not the spaces**. How to write the `tab` or what is the character for real `tab`?

For example here:

    $chunk = &quot;a,b,c&quot;;
    file_put_contents(&quot;chunk.csv&quot;,$chunk);

What character should i use to get `tabs` instead of `Commas (,)` there?&lt;br&gt;
In the output file, there should be real `tabs` between the seperated words.

- Real Tabs means, **a true wide space we get when we press the `&lt;tab&gt;` key** in a text-editor.

PHP to write Tab Characters inside a file?

I have a remote repo in which I want to commit certain files (the compiled files to deploy them on a cloud computing platform), but I don&#39;t want to deploy them on github...

is there some way to have to different .gitignore files, one for each remote?

git: have different .gitignore file for each remote

I have generated SSH keys for a new server installation according to the procedure outlined [here](http://help.github.com/mac-set-up-git/). However, when I copy the contents of `id_rsa.pub` to my keys list on GitHub, I get the error message &quot;Key is invalid. Ensure you&#39;ve copied the file correctly.&quot; 

The generated key _is_ valid, and I am copying it exactly as is (all in one line with no whitespace at the beginning/end).

Anybody have an idea what could be going on?

&quot;Key is invalid&quot; message on GitHub

I&#39;m new to Jenkins and git too. I created a remote repository at `github.com` and made a local copy of it.  
Then I want to link it through Jenkins. I installed needed plugins for git integration, but I don&#39;t know what my local Repository URL is to set it when configuring the new project. Could someone help me where to find it?

Jenkins linking to my local git repository

I created a local repository of my Visual Studio 2010 solution folder using Git GUI on my dev machine. I then created a remote repository in my GitHub account. Now, I am looking for how to push my local repository to the remote repository.

In SVN I can just commit using TortoiseSVN and changes are pushed to the remote repository. I don&#39;t see any tool like that available for Git. 

How do I push my local repo to my remote repo on GitHub?

Pushing from local repository to GitHub hosted remote

I am looking for a python library for the Github APIv3 suitable for me.

I found one library [(python-github3)][1] mentioned in the [GH API docs][2]. After playing around with it in ipython for an hour or two, I found it really unintuitive to explore/work with. I looked some more, and found there&#39;s quite a number of people at least attempting to write such a library. The more promising-looking (at a glance) are [PyGithub][3] and [another python-github3][4], which apparently is different from the first one.

*Before I spend the next days consecutively trying out library after library, I wanted to ask the SO community if there is an accepted, definitive, obvious choice for that library?*

What I didn&#39;t like about the first library was the (to me) unintuitive way to get at data - some things you get as attributes, some you get as return value of a method, that return value is some complicated object which has to be paged and iterated through, etc. 

In that regard, PyGithub looks more attractive at first glance - clearly drill down through an object hierarchy, and then arrive at the attribute containing what you want:

`for repo in g.get_user().get_repos():
    print repo.name`

So, any pearls of wisdom to share? I know I don&#39;t have skills enough to quickly judge library quality, which is why I&#39;m turning to the SO community.

*edit: fwiw, I ended up using **PyGithub**. It works well, and the author is really receptive for feedback and bug reports. :-)*

  [1]: https://github.com/copitux/python-github3
  [2]: http://developer.github.com/v3/libraries/
  [3]: https://github.com/jacquev6/PyGithub
  [4]: https://github.com/ChristopherMacGown/python-github3

Content Type	Original Author	Original Content on Stackoverflow
Question	Justin Jackson	View Question on Stackoverflow
Solution 1 - Git	Simon	View Answer on Stackoverflow
Solution 2 - Git	A.Badger	View Answer on Stackoverflow
Solution 3 - Git	Marvin Glenn Lacuna	View Answer on Stackoverflow

How do I generate a git commit log for the last month, and export it as CSV?

Git Problem Overview

Git Solutions

Solution 1 - Git

Solution 2 - Git

Solution 3 - Git

Mocking a method to throw an exception (moq), but otherwise act like the mocked object?

String.Format - how it works and how to implement custom formatstrings

Attributions