Hi Mark,

It's Win7. I had no idea Robocopy even existed. Since it's command line driven, I can automate building a paragraph to drive it. I'll certainly check it and richcopy out.

Learn something new every day... I consider any day I don't either learn something new or catch hell about something a total waste. SWMBO makes sure very few of my days are wasted. :-)

Thanks!
Charlie

On 07-28-2014 5:37 PM, Mark Hogden wrote:

If this is SERVER 2003 or above or windows 7 or above then ROBOCOPY would be my choice.

http://technet.microsoft.com/en-us/magazine/ee851678.aspx

There's also a richcopy(which I have not tried) that is multi-threaded and supports command line options.

*From:*[email protected] [mailto:[email protected]] *On Behalf Of *Charlie Noah
*Sent:* Monday, July 28, 2014 3:10 PM
*To:* [email protected]
*Subject:* Re: Apparent COPY Limitation

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

Reply via email to