Combining daily csv's to form a single monthly csv CDR

Before starting the procedures below, make sure you have logged into the FTP site and downloaded the daily CDR zip files and have them in a folder on your computer desktop named CDR.

Windows how to:  (Attached to this article is a document containing screenshots)

First we must unzip the files.
This can be accomplished two ways.
1. Unzip each zip file individually and place it in the same folder.
     or
2. If you would like to unzip them all at once, read below.

Download G7zip by clicking here: http://www.7-zip.org/download.html (NOTE: download the correct version for your operating system)
Install the software. (You only have to do this once.)

Once this is software is installed:
Click on the folder containing your zip files. 
Select ALL the zip files and right click on any one of them and select --> G-7zip --> Extract Here
This will unzip all of the zip files and you should now see both the .zip and .csv files in this folder.

Second we must join them together into one file.
Click start then click run and type CMD and hit enter. This will open a command prompt window.
From within the command window, navigate to the folder containing the .csv files by typing:  

cd Desktop/CDR  (As long as you have placed the zip files in a folder named CDR on your Desktop this command should work.)

Next type:  
dir  (This should list all of the csv's in the directory and you should see the files that you download.)

Next: To join them into one file type the following command:

copy *.csv fullmonth.csv  (Then hit Enter.)

Type dir again and you should now see a file called fullmonth.csv

Now you can open your new fullmonth.csv in Excel.  You will then need to sort and remove the extra column headers because there will be column headers for every day that you joined into the fullmonth.csv file.

LInux / Mac how to:
Open Terminal or shell, browse to the directory that contains the ZIP files and type the following commands (copy and paste if you wish).

First we must unzip the files.
unzip "*.zip"
Second we must join them together into one file.
cat *.csv > fullmonth.csv

Now you can open your new fullmonth.csv in Excel.  You will then need to sort and remove the extra column headers because there will be column headers for every day that you joined into the fullmonth.csv file.