Procedure for Download of File Merge Utility (in case file is split) and Merging Split Quarterly Consolidated TDS/TCS statement
A. Procedure for Download of File Merging Utility
1) Download “File Merge Utility” from TIN website (www.tin-nsdl.com ) under the option “TAN Registration” in download section. FMU can be downloaded at the desired location for example desktop (see Fig 1.1 below).
2) JRE (Java Run-time Environment) [versions: SUN JRE: 1.4.2_02 or 1.4.2_03 or 1.4.2_04 or IBM JRE: 220.127.116.11] should be installed on the computer where the e-TDS/TCS FVU is being installed.
3) JRE is freely downloadable from http://java.sun.com or http://www.ibm.com/developerworks/java/jdk or
You may ask your computer vendor (hardware) to install the same for you.
4) For installing the File Merge Utility double click on the exe (File_Merger_Utility.exe) file downloaded from the TIN website.
5) On double clicking, a window will be displayed for extracting the contents of the exe file. Default location for extracting the files will be C drive (see Fig 1.2 below).
6) The files can also be extracted in any other location (other than C drive). In that case, define the appropriate path by clicking the ‘Browse’ button where the files are to be extracted.
7) For extracting the contents of the file click “Unzip” button. On clicking the “Unzip” button, two files as below (see Fig 1.3 and 1.4 below) will be extracted at the default path (C:\File_MERGE_UTILITY) or the desired location as the case may be:
8) To open the File Merge Utility, double click on the file “FMU.bat” available in the folder where FMU has been installed. On double click of the file, window as below will open (Fig 1.5 below).
2. Procedure for merging the split quarterly consolidated TDs/TCS statement.
1) Copy all the split files in the single folder at the desired location.
2) Open the “File Merge utility” by double clicking the file “FMU.bat”.
3) Click on “Browse” button of “Input file path” and provide path or navigate to path of the folder where all split files are copied (see Fig 1.6 below). Example: files are copied at D drive and the folder name is TDS_TCS_statement.
4) On navigating to the folder where all the split files are copied, only one file i.e., the first file will be visible (see Fig 1.5 above). Example MUMA00001A_200809_Q4_26Q.zip1.
5) Select the visible file and click on button “Open” (see fig 1.5 above). Example: files are copied at path D:\TDS_TCS_statement and the input file name is MUMA00001A_200809_Q4.zip1.
6) Click on “Browse” button of “Output file path” and provide path or navigate to path of the folder where merged consolidated TDS/TCS file is to be created (see Fig 1.7 below). Example: the output file path is D:\TDS_TCS_Statement.
7) On selecting the location for saving the merged file, click on “Save” button (see Fig 1.6 above).
8) Click on “Merge files” button available on the File Merge Utility window.
9) On successful merging of split files message “File merged successfully at xxxxxxxxxxx (desired location)” will be provided (see Fig 1.8 below)and a merged file in compressed form will be created at the output path. Example the output file path is D:\TDS_TCS_Statement and the file name is MUMA00001A_200809_Q4_26Q.zip
10) Merged file created is password protected.
11) For extracting the contents of the merged file follow the procedure as provided in the mail received for consolidated statement.
12) In case of any assistance contact TIN call centre at 020-27218080.