Jim, thank you.
I used your WRITE from the R> approach, using COPY instead of MOVE.
Before I did, I set the source and target paths into variables:
set vsource text = null
set vtarget text = null
set vsource = 'd:\0-source\'
set vtarget = 'd:\0-target\'
After writing the REM line, the statement:
('COPY' & .vsource + (ctxt(file_sn)) +
+ '*.*' & .vtarget + file_set + '\')=50 +
from file_ident
... produced the line-by-line batch file by serial number.
Launched from R>.
Files copied at rate of @1,000/min. Saved me at least a day of marking
and moving.
I'd never once thought of setting up a batch file from within R:Base.
The '=50' is new to me. Nice add to the tool bag.
Thanks very much!
Bruce
> -------- Original Message --------
> Subject: [RBASE-L] - Re: Data File Relocation Routine
> From: James Bentley <[email protected]>
> Date: Wed, March 07, 2012 10:01 am
> To: [email protected] (RBASE-L Mailing List)
>
>
> Bruce,
>
> -- TO MOVE FILES IN THE FORM OF xxxxx.filename.ext
> -- create a batch file to accomplish this
> -- at the R> enter the following commands or better stil create a RMD file
> -- This assumes that the RBase working directory is where the common
> -- files are located and that the "a,b,c,d" directories are sub-directories
> -- of the common directory. If not use full path to "a,b,c,d" directories
> SET HEADINGS OFF
> OUTPUT MVFILES.BAT
> WRITE 'REM Batch file created',.#DATE,'at',.#TIME
> SELECT ('MOVE' & file_sn + '*.*' & file_set+'\')=50
> OUTPUT SCREEN
> -- This should write a series of 'MOVE 10001*.* a\
> -- if file_sn is INTEGER substitute (CTXT(file_sn)) in above
> -- if you are extra cautious use COPY instead of MOVE in above
>
> -- You might want to enter RBEDIT MVFILES.BAT at R> to verify file
> -- after this open a WINDOWS command prompt and enter
> -- MVFILES.BAT
>
> -- Alternatively you could try LAUNCH MVFILES.BAT at R>
>
>
>
> Jim Bentley
> American Celiac Society
> [email protected]
> tel: 1-504-737-3293
>
>
> >________________________________
> > From: Jason Kramer <[email protected]>
> >To: RBASE-L Mailing List <[email protected]>
> >Sent: Wednesday, March 7, 2012 10:27 AM
> >Subject: [RBASE-L] - Re: Data File Relocation Routine
> >
> >
> >Bruce,
> > If I understand correctly, you have a table that looks like
> this:
> >file_sn file_set
> >10001 a
> >10002 a
> >10003 b
> >10004 c
> >
> > A single directory with all files in it, and directories named
> a,b,c,d that you want to copy (or move) the files into, and an Excel
> file with the same information? Is that correct?
> >
> Thanks,
> >
> Jason
> >
> >Jason Kramer
> University Archives and Records Management
> 002 Pearson Hall
> (302) 831 - 3127 (voice)
> (302) 831 - 6903 (fax)
> >On 3/7/2012 11:20 AM, Bruce Chitiea wrote:
> >All: RBASE 91_64
> 9.1.5.20214
> have PluginPowerPak 91_64
> Windows 7 GOAL
> Distribute classed sets of data files from a common folder to their
> respective set folders. BACKGROUND For a client with severe data-file
> duplication and
> file-content-identification issues ranging across several thousand
> files, I've: - created a backup working set of those files - pre-pended a
> 5-digit serial number to each file-copy into the format: xxxxx.filename.ext -
> aggregated all files into a common folder
> - successfully parsed the folder's file list into text fields: xxxxx filename
> ext filesize datestamp - processed these in Excel to identify duplication and
> content-meaning,
> and to class files into four sets: [ a b c d ] - successfully Gateway'd the
> file serial number and file set identifier
> into a two-column R:Base table: file_sn [ 10001,10002...2nnnn ] file_set [ a
> b c d ] - created four empty file folders, each reserved for one file class
> NEED I'm thinking the 'file_sn' and 'file_set' values are sufficient input to
> a process that 'walks' the common file list and performs the
> distribution. I have no such routine and I'm SO FAR behind the 8-ball on
> this job ... What's the best way to handle this? MTIA Bruce Chitiea
> SafeSectors, Inc.
> >
> >
