Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!rt.uk.eu.org!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Date: Tue, 20 May 2014 21:35:10 +0530 (IST)
From: Jagadeesh Malakannavar <mnjagadeesh@gmail.com>
To: Satish ML <satishmlwizpro@gmail.com>
Subject: 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.
In-Reply-To: <45b38d71-bf27-4d8e-b912-1093bbb38dcb@googlegroups.com>
References: <e672c890-a0d2-4bf5-bd94-9fdf70b0d1d2@googlegroups.com> <mailman.10123.1400482872.18130.python-list@python.org> <8ff7483f-cec3-4cc8-bedf-68da09571350@googlegroups.com> <89887b39-3988-45cf-9a26-02f3eeef9f22@googlegroups.com> <934ba77e-6794-4d41-a3f3-ca0e370c4afb@googlegroups.com> <575e4180-b222-4e8f-a378-f39a51c3c085@googlegroups.com> <45b38d71-bf27-4d8e-b912-1093bbb38dcb@googlegroups.com>
User-Agent: Alpine 2.11 (LRH 23 2013-08-11)
MIME-Version: 1.0
Content-Type: MULTIPART/MIXED; BOUNDARY="8323328-427932426-1400601935=:22217"
Cc: python-list@python.org
Precedence: list
Reply-To: Jagadeesh Malakannavar <mnjagadeesh@gmail.com>
Newsgroups: comp.lang.python
Message-ID: <mailman.10157.1400602844.18130.python-list@python.org>
Lines: 45
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:71811

  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

--8323328-427932426-1400601935=:22217
Content-Type: TEXT/PLAIN; charset=US-ASCII
Content-Transfer-Encoding: QUOTED-PRINTABLE

Hi Satish,

Can you please send python part in plain text format? Python code here is=
=20
difficult to read.

Thanks

On Tue, 20 May 2014, Satish ML wrote:

| On Tuesday, May 20, 2014 5:54:47 PM UTC+5:30, Satish ML wrote:
| > On Tuesday, May 20, 2014 5:51:19 PM UTC+5:30, Satish ML wrote: > On Tue=
sday, May 20, 2014 11:27:01 AM UTC+5:30, Rustom Mody wrote: > On Monday, Ma=
y 19, 2014 2:32:36 PM UTC+5:30, Satish ML wrote: > On Monday, May 19, 2014 =
12:31:05 PM UTC+5:30, Chris Angelico wrote: > > On Mon, May 19, 2014 at 4:5=
3 PM, wrote: > Could you kindly help? Sure. Either start writing code and t=
hen post when you have problems, or investigate some shell commands (xcopy =
in Windows, cp in Linux, maybe scp) that can probably do the whole job. Or =
pay someone to do the job for you. ChrisA > Hi ChrisAngelico, > Consider th=
at source and destination directories are given in a .xls(excel) file. > Th=
is is the code > import xlrd, sys, subprocess > file_location =3D "C:\Users=
\salingeg\Desktop\input.xls" > workbook =3D xlrd.open_workbook(file_locatio=
n) > sheet =3D workbook.sheet_by_index(0) > sheet.cell_value(0, 0) > for ro=
w in range(sheet.nrows): > values =3D [] > values.append(sheet.cell_value(r=
ow, 1)) > destination =3D [] > dest
|  ination.append(sheet.cell_value(row, 2)) > for s in values: > for d in d=
estination: > If I am using cp or xcopy command, it will copy all files fro=
m s to d. > shutil.copy(s, d) can't be used here because it overwrites file=
s in d. Kindly help. have u tried using https://docs.python.org/2/library/o=
s.path.html#os.path.exists ? I have tried it. But how does it help? We won'=
t be able to make out whether source file is present in destination directo=
ry. If we can do that, like if (source file exists in destination directory=
) print "exists" continue else shutil.copy(s, d)
|=20
| Here we don't have the option of manually giving the file path. It has to=
 be read from .xls file (i.e. from the two lists in code)
|=20
--8323328-427932426-1400601935=:22217--