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]> 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] > 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. > > > -- > -- > 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. > -- -- 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.
