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