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 jBASE@googlegroups.com
To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
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 jbase+unsubscr...@googlegroups.com
<mailto:jbase+unsubscr...@googlegroups.com>.
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 jBASE@googlegroups.com
To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
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 jbase+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
