Re: Copying files from sub folders under source directories into sub folders with same names as source directory sub folders in destination directories without overwriting already existing files of same name.

[Satish ML]

On Wednesday, May 21, 2014 6:59:40 AM UTC+5:30, Rustom Mody wrote:
> On Tuesday, May 20, 2014 9:35:10 PM UTC+5:30, Jagadeesh N. Malakannavar 
> wrote: > Hi Satish, > > Can you please send python part in plain text format? 
> Python code here is > > difficult to read. It would be helpful to read 
> https://wiki.python.org/moin/GoogleGroupsPython#Posting_from_Google_Groups 
> Note particularly the 2 standard expectations: - Dont top post - Dont use 
> excessively long (> 70 chars) lines

Hi,

Here is the code.


xls file looks as follows:
a.c     C:\Desktop\salingeg\src\code\a.c        C:\Desktop\salingeg\dest\code
hello.txt       C:\Desktop\salingeg\src\txt\hello.txt   
C:\Desktop\salingeg\dest\txt
integration.doc C:\Desktop\salingeg\src\doc\integration.doc     
C:\Desktop\salingeg\dest\doc
UG.doc  C:\Desktop\salingeg\src\doc\UG.doc      C:\Desktop\salingeg\dest\doc
Applications.xml        C:\Desktop\salingeg\src\xml\Applications.xml    
C:\Desktop\salingeg\dest\xml
Platforms.xml   C:\Desktop\salingeg\src\xml\Platforms.xml       
C:\Desktop\salingeg\dest\xml
avc.alias       C:\Desktop\salingeg\src\cnx\alias\avc.alias     
C:\Desktop\salingeg\dest\cnx\alias
cats.alias      C:\Desktop\salingeg\src\cnx\alias\cats.alias    
C:\Desktop\salingeg\dest\cnx\alias
avc.init        C:\Desktop\salingeg\src\cnx\init\avc.init       
C:\Desktop\salingeg\dest\cnx\init
cats.init       C:\Desktop\salingeg\src\cnx\init\cats.init      
C:\Desktop\salingeg\dest\cnx\init
                
                
PYTHON SCRIPT:

import xlrd, sys, os, shutil

file_location = "C:\Users\salingeg\Desktop\input.xls"
workbook = xlrd.open_workbook(file_location)
sheet = workbook.sheet_by_index(0)
sheet.cell_value(0, 0)
for row in range(sheet.nrows):
        source = []
        source.append(sheet.cell_value(row, 1))
        destination = []
        destination.append(sheet.cell_value(row, 2))
        files = []
        files.append(sheet.cell_value(row, 0))
        for f in files:
                for s in source:
                        for d in destination:
                                print f
                                print s
                                print d
                                if (os.path.exists("d\\f")):
                                        print ('File exists')
                                else:
                                        shutil.copy(s, d)
                
I am getting the following error:

a.c
C:\Desktop\salingeg\src\code\a.c
C:\Desktop\salingeg\dest\code
Traceback (most recent call last):
  File "C:\Users\salingeg\Desktop\excel_1.py", line 24, in <module>
    shutil.copy(s, d)
  File "C:\Program Files (x86)\python26\lib\shutil.py", line 84, in copy
    copyfile(src, dst)
  File "C:\Program Files (x86)\python26\lib\shutil.py", line 50, in copyfile
    with open(src, 'rb') as fsrc:
IOError: [Errno 2] No such file or directory: 
u'C:\\Desktop\\salingeg\\src\\code\\a.c'


-- 
https://mail.python.org/mailman/listinfo/python-list