Wouldn't cygwin be a bit of overkill for what I want to do?
On 07-28-2014 4:48 PM, Daniel Klein wrote:
Another option would be to install cygwin and use the unix-like 'cp'
command.
Dan
On Mon, Jul 28, 2014 at 5:18 PM, Charlie Noah <[email protected]
<mailto:[email protected]>> wrote:
Tony, you and Simon have given me an idea. Since I'll be doing
this again from time to time, it's probably worth the effort to
build an EXECUTE.DOS.CMD utility, which would prefix a DOS command
with char(255): k and make it do as OS execute. Then I could
structure a paragraph line like
EXECUTE.DOS.CMD copy "e:\TinyBearMarketing\GOLDCREST\Images\Purple
Martin Decoys & Starling Excluder Doors\PME2.jpg"
e:\TinyBearMarketing\GOLDCREST\Images\Export
substituting each image name. I think this might be easier than
going the short-directory name route, although that's a trick I'll
need to remember. Never know when it will come in handy.
There are about 16,000 image files, and I was planning to do them
about 1000 at a time. While they're in the destination folder I am
going to resize them, and I'm not sure what 16,000 files at once
would do to the resizer program - or a paragraph or batch file,
either, for that matter. It might be an interesting experiment.
Thanks,
Charlie
On 07-28-2014 3:34 PM, Tony Gravagno wrote:
I dunno if jBase is the same as D3 in this regard but when using
the DBMS Copy verb I think the data is pulled into the DBMS first
before it's written back to the OS. That's going to be Very slow.
It would be better to use the DBMS to script command-line
operations. You can write a large script and execute it all once.
You can do an Execute "!Copy..." of individual files. Or you can
create a huge OS command and then do a single Execute.
And I could be completely off... :)
As to paths with spaces in them, I wrote a utility a while back
which retrieves the short-directory name using the Windows DIR
command. Then I used that in my commands to eliminate grief from
spaces. I don't think that's necessary here but if you need to do
that it's possible.
HTH
T
On Monday, July 28, 2014 1:18 PM, Charlie Noah wrote:
I have several thousand image files I want to copy from various
Windows folders (a couple hundred) to one Windows folder. My plan
was to cheat and build a paragraph to copy the image files. The
problem comes when the source folder name has spaces in it. It
seems COPY doesn't like them, and truncates the file name
(actually the folder name) at the first space.
Example:
COPY "e:\TinyBearMarketing\GOLDCREST\Images\Purple Martin Decoys
& Starling Excluder Doors\" PME2.jpg
results in:
** Error [ 201 ] **
Unable to open file "e:\TinyBearMarketing\GOLDCREST\Images\Purple
I've tried with and without quotes, so that isn't it. Has anyone
found a way to overcome this, or a better way to do it? The
reason I'm using COPY (well, actually COPYTO, a one-line COPY
frontend) because I can build the COPY statements in a list
driven JQL report.
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
<mailto:[email protected]>
To unsubscribe, send email to [email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the
Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
<mailto:[email protected]>
To unsubscribe, send email to [email protected]
<mailto:[email protected]>
For more options, visit this group at
http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google
Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at
http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google
Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
